Commit | Line | Data |
---|---|---|
82cda9f8 CE |
1 | #!/bin/bash -ex |
2 | ||
3 | # DO NOT EXECUTE DIRECTLY | |
4 | # This is only to be executed by create-user | |
5 | ||
58df4059 CE |
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 | |
82cda9f8 CE |
9 | DBPATH=/srv/databases/$PATHBITS |
10 | PGDIR=$DBPATH/postgres | |
11 | MYSQLDIR=$DBPATH/mysql | |
12 | ||
13 | # Create postgres user and tablespace placeholder within volume | |
658c76a0 | 14 | # FIXME: This assumes the status-quo of database accounts not being |
15 | # removed by destroy-user... | |
82cda9f8 CE |
16 | if ! test -d $PGDIR; then |
17 | mkdir -p $PGDIR | |
18 | chown postgres:postgres $PGDIR | |
658c76a0 | 19 | sudo -u postgres psql -c "CREATE TABLESPACE user_$USER OWNER postgres LOCATION '$PGDIR'" template1 |
82cda9f8 CE |
20 | fi |
21 | ||
82cda9f8 | 22 | # Create mysql user and databases placeholder within volume |
658c76a0 | 23 | # FIXME: Same as postgres... |
24 | if ! test -d $MYSQLDIR; then | |
25 | mkdir -p $MYSQLDIR | |
26 | chown mysql:mysql $MYSQLDIR | |
27 | fi |