dbtool mysql adduser working

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