From: Adam Chlipala <adamc@hcoop.net>
Date: Sat, 10 Feb 2007 18:43:20 +0000 (+0000)
Subject: dbtool mysql adduser working
X-Git-Tag: release_2010-11-19~272
X-Git-Url: https://git.hcoop.net/hcoop/domtool2.git/commitdiff_plain/c773e9e407c59af01faf289e348ef8e81b94b507?hp=2bc5ed226e9a0cba24f9d689754e1d62bb883d86

dbtool mysql adduser working
---

diff --git a/src/plugins/domtool-mysql b/src/plugins/domtool-mysql
index 8f60e5e..fdc6bc7 100755
--- a/src/plugins/domtool-mysql
+++ b/src/plugins/domtool-mysql
@@ -2,7 +2,15 @@
 
 case $1 in
 	adduser)
-		echo "I would create MySQL user $2 with password $3."
+		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."