| | 1 | #!/bin/bash -ex |
| | 2 | |
| | 3 | # DO NOT EXECUTE DIRECTLY |
| | 4 | # This is only to be executed by create-user |
| | 5 | |
| | 6 | USER=$1 |
| | 7 | # (If it's not clear, for user fred, PATHBITS = f/fr/fred) |
| | 8 | PATHBITS=`echo $USER | head -c 1`/`echo $USER | head -c 2`/$USER |
| | 9 | DBPATH=/srv/databases/$PATHBITS |
| | 10 | PGDIR=$DBPATH/postgres |
| | 11 | PGNEWDIR="$DBPATH/postgres-9.1" |
| | 12 | MYSQLDIR=$DBPATH/mysql |
| | 13 | |
| | 14 | # Create postgres user and tablespace placeholder within volume |
| | 15 | # FIXME: This assumes the status-quo of database accounts not being |
| | 16 | # removed by destroy-user... |
| | 17 | if ! test -d $PGDIR; then |
| | 18 | # postgres 8.1 |
| | 19 | mkdir -p $PGDIR |
| | 20 | chown postgres:postgres $PGDIR |
| | 21 | sudo -u postgres psql --cluster 8.1/main -c "CREATE TABLESPACE \"user_$USER\" OWNER postgres LOCATION '$PGDIR'" template1 |
| | 22 | fi |
| | 23 | |
| | 24 | if ! test -d $PGNEWDIR; then |
| | 25 | # postgres 9.1 |
| | 26 | mkdir -p $PGNEWDIR |
| | 27 | chown postgres:postgres $PGNEWDIR |
| | 28 | sudo -u postgres psql --cluster 9.1/main -c "CREATE TABLESPACE \"user_$USER\" OWNER postgres LOCATION '$PGNEWDIR'" template1 |
| | 29 | fi |
| | 30 | |
| | 31 | # Create mysql user and databases placeholder within volume |
| | 32 | # FIXME: Same as postgres... |
| | 33 | if ! test -d $MYSQLDIR; then |
| | 34 | mkdir -p $MYSQLDIR |
| | 35 | chown mysql:mysql $MYSQLDIR |
| | 36 | fi |
HCoop / hcoop / scripts.git / blame_incremental