create-user: Database creation fixes
[hcoop/scripts.git] / create-user-database
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 MYSQLDIR=$DBPATH/mysql
12
13 # Create postgres user and tablespace placeholder within volume
14 # FIXME: This assumes the status-quo of database accounts not being
15 # removed by destroy-user...
16 if ! test -d $PGDIR; then
17 mkdir -p $PGDIR
18 chown postgres:postgres $PGDIR
19 sudo -u postgres psql -c "CREATE TABLESPACE user_$USER OWNER postgres LOCATION '$PGDIR'" template1
20 fi
21
22 # Create mysql user and databases placeholder within volume
23 # FIXME: Same as postgres...
24 if ! test -d $MYSQLDIR; then
25 mkdir -p $MYSQLDIR
26 chown mysql:mysql $MYSQLDIR
27 fi