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 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