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