src/plugins/domtool-mysql

   1 #!/bin/sh -e
   2
   3 case $1 in
   4         adduser)
   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'"
  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