Update domtool-mysql script for local filesystem tablespaces

* /afs/hcoop.net/common/databases -> /srv/databases
* ACL -> give group mysql rw permissions on all files

diff --git a/src/plugins/domtool-mysql b/src/plugins/domtool-mysql
index 49363b1..b3690ff 100755 (executable)
--- a/src/plugins/domtool-mysql
+++ b/src/plugins/domtool-mysql
@@ -21,10 +21,7 @@ case $1 in
                USERNAME=$2
                DBNAME_BASE=$3
                DBNAME="${USERNAME}_${DBNAME_BASE}"
                USERNAME=$2
                DBNAME_BASE=$3
                DBNAME="${USERNAME}_${DBNAME_BASE}"

-               DIR=/afs/hcoop.net/common/databases/${USERNAME:0:1}/${USERNAME:0:2}/$USERNAME/mysql
-
-               kinit -k -t /etc/keytabs/root.admin.keytab root/admin
-               aklog
+               DIR=/srv/databases/${USERNAME:0:1}/${USERNAME:0:2}/$USERNAME/mysql

 
                if [ ! -d $DIR ]; then
                        echo WARNING: $DIR must already exist!
 
                if [ ! -d $DIR ]; then
                        echo WARNING: $DIR must already exist!


@@ -34,7 +31,7 @@ case $1 in
                chown mysql:mysql $DIR/$DBNAME
                chmod 770 $DIR/$DBNAME
                ln -sf $DIR/$DBNAME /var/lib/mysql/$DBNAME
                chown mysql:mysql $DIR/$DBNAME
                chmod 770 $DIR/$DBNAME
                ln -sf $DIR/$DBNAME /var/lib/mysql/$DBNAME

-               fs setacl -dir $DIR/$DBNAME/ -acl system:mysql all
+               chmod g+rw -R $DIR/$DBNAME/

                sudo -H mysql -e "GRANT CREATE,CREATE TEMPORARY TABLES,SELECT,INSERT,UPDATE,DELETE,INDEX,ALTER,CREATE VIEW,SHOW VIEW,LOCK TABLES,GRANT OPTION ON TABLE * TO '$USERNAME'@$WHERE;" $DBNAME
 
                sudo -H mysql -e "FLUSH PRIVILEGES;"
                sudo -H mysql -e "GRANT CREATE,CREATE TEMPORARY TABLES,SELECT,INSERT,UPDATE,DELETE,INDEX,ALTER,CREATE VIEW,SHOW VIEW,LOCK TABLES,GRANT OPTION ON TABLE * TO '$USERNAME'@$WHERE;" $DBNAME
 
                sudo -H mysql -e "FLUSH PRIVILEGES;"