[hcoop/domtool2.git] / src / plugins / domtool-mysql

#!/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
Commit	Line	Data
ae147938 AC	1	#!/bin/sh -e
	2
	3	case $1 in
	4	adduser)
c773e9e4 AC	5	USERNAME=$2
	6	PASSWORD=$3
	7	kinit -k -t /etc/keytabs/root.admin.keytab root/admin
	8	aklog
	9	vos create -server afs -partition a -name db.$USERNAME -maxquota 5000
	10	fs mkmount -dir /afs/.hcoop.net/common/.databases/$USERNAME -vol db.$USERNAME -rw
	11	fs setacl -dir /afs/hcoop.net/common/databases/$USERNAME -acl databases l
	12	fs setacl -dir /afs/hcoop.net/common/databases/$USERNAME -acl system:backup rl
	13	sudo -H mysql -e "CREATE USER '$USERNAME'@'localhost' IDENTIFIED BY '$PASSWORD'"
ae147938 AC	14	;;
	15	createdb)
	16	echo "I would create MySQL table $2_$3 for user $2."
	17	;;
	18	*)
	19	echo "Usage: domtool-mysql [adduser <user> \| createdb <user> <table>]"
	20	;;
	21	esac