[clinton/scripts.git] / create-user-database

#!/bin/bash -ex

# DO NOT EXECUTE DIRECTLY
# This is only to be executed by create-user

USER=$1
# (If it's not clear, for user fred, PATHBITS = f/fr/fred)
PATHBITS=`echo $USER | head -c 1`/`echo $USER | head -c 2`/$USER
DBPATH=/srv/databases/$PATHBITS
PGDIR=$DBPATH/postgres
MYSQLDIR=$DBPATH/mysql

# Create postgres user and tablespace placeholder within volume
if ! test -d $PGDIR; then
  mkdir -p $PGDIR
  chown postgres:postgres $PGDIR
fi

sudo -u postgres psql -c "CREATE TABLESPACE user_$USER OWNER postgres LOCATION '$PGDIR'" template1

# Create mysql user and databases placeholder within volume
mkdir -p $MYSQLDIR
chown mysql:mysql $MYSQLDIR
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
	14	if ! test -d $PGDIR; then
	15	mkdir -p $PGDIR
	16	chown postgres:postgres $PGDIR
	17	fi
	18
	19	sudo -u postgres psql -c "CREATE TABLESPACE user_$USER OWNER postgres LOCATION '$PGDIR'" template1
82cda9f8 CE	20
	21	# Create mysql user and databases placeholder within volume
	22	mkdir -p $MYSQLDIR
	23	chown mysql:mysql $MYSQLDIR