From c773e9e407c59af01faf289e348ef8e81b94b507 Mon Sep 17 00:00:00 2001
From: Adam Chlipala <adamc@hcoop.net>
Date: Sat, 10 Feb 2007 18:43:20 +0000
Subject: [PATCH] dbtool mysql adduser working

---
 src/plugins/domtool-mysql | 10 +++++++++-
 1 file changed, 9 insertions(+), 1 deletion(-)

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."
-- 
2.20.1