#!/bin/sh -e

case $1 in
	adduser)
		USERNAME=$2
		PASSWORD=$3
		kinit -k -t /etc/keytabs/root.admin.keytab root/admin
		aklog
		vos create -server afs -partition a -name db.$USERNAME -maxquota 5000
		fs mkmount -dir /afs/.hcoop.net/common/.databases/$USERNAME -vol db.$USERNAME -rw
		fs setacl -dir /afs/hcoop.net/common/databases/$USERNAME -acl databases l
		fs setacl -dir /afs/hcoop.net/common/databases/$USERNAME -acl system:backup rl
		sudo -H mysql -e "CREATE USER '$USERNAME'@'localhost' IDENTIFIED BY '$PASSWORD'"
	;;
	createdb)
		echo "I would create MySQL table $2_$3 for user $2."
	;;
	*)
		echo "Usage: domtool-mysql [adduser <user> | createdb <user> <table>]"
	;;
esac