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