8 kinit
-k -t /etc
/keytabs
/root.admin.keytab root
/admin
11 if ! vos examine db.
$USERNAME >/dev
/null
2>/dev
/null
; then
12 vos create
-server afs
-partition a
-name db.
$USERNAME -maxquota 5000
13 fs mkmount
-dir /afs
/.hcoop.net
/common
/.databases
/$USERNAME -vol db.
$USERNAME -rw
14 fs setacl
-dir /afs
/hcoop.net
/common
/databases
/$USERNAME -acl databases l
15 fs setacl
-dir /afs
/hcoop.net
/common
/databases
/$USERNAME -acl system
:backup rl
18 sudo
-H mysql
-e "CREATE USER '$USERNAME'@'localhost' IDENTIFIED BY '$PASSWORD';"
24 sudo
-H mysql
-e "SET PASSWORD FOR '$USERNAME'@'localhost' = PASSWORD('$PASSWORD');"
29 DBNAME
="${USERNAME}_${DBNAME_BASE}"
30 DIR
=/afs
/hcoop.net
/common
/databases
/$USERNAME/mysql
32 kinit
-k -t /etc
/keytabs
/root.admin.keytab root
/admin
36 fs setacl
-dir $DIR -acl mysql rlid
37 fs setacl
-dir $DIR -acl databases none
38 fs setacl
-dir $DIR -acl system
:backup rl
40 chown mysql
:mysql
$DIR/$DBNAME
41 chmod 770 $DIR/$DBNAME
42 ln -sf $DIR/$DBNAME /var
/lib
/mysql
/$DBNAME
43 fs setacl
-dir $DIR/$DBNAME/ -acl mysql all
45 sudo
-H mysql
-e "GRANT CREATE,SELECT,INSERT,UPDATE,DELETE,INDEX,ALTER,CREATE VIEW,SHOW VIEW,GRANT OPTION ON TABLE * TO '$USERNAME'@'localhost';" $DBNAME
46 sudo
-H mysql
-e "FLUSH PRIVILEGES;"
49 echo "Usage: domtool-mysql [adduser <user> <password> | passwd <user> <password> | createdb <user> <table>]"