src/plugins/domtool-mysql

   1 #!/bin/bash -e
   2
   3 WHERE="'%.hcoop.net'"
   4
   5 case $1 in
   6         adduser)
   7                 USERNAME=$2
   8                 PASSWORD=$3
   9
  10                 sudo -H mysql -e "CREATE USER '$USERNAME'@$WHERE IDENTIFIED BY '$PASSWORD';"
  11         ;;
  12
  13         passwd)
  14                 USERNAME=$2
  15                 PASSWORD=$3
  16
  17                 sudo -H mysql -e "SET PASSWORD FOR '$USERNAME'@$WHERE = PASSWORD('$PASSWORD');"
  18         ;;
  19
  20         createdb)
  21                 USERNAME=$2
  22                 DBNAME_BASE=$3
  23                 DBNAME="${USERNAME}_${DBNAME_BASE}"
  24                 DIR=/srv/databases/${USERNAME:0:1}/${USERNAME:0:2}/$USERNAME/mysql
  25
  26                 if [ ! -d $DIR ]; then
  27                         echo WARNING: $DIR must already exist!
  28                 fi
  29
  30                 mkdir $DIR/$DBNAME
  31                 chown mysql:mysql $DIR/$DBNAME
  32                 chmod 770 $DIR/$DBNAME
  33                 ln -sf $DIR/$DBNAME /var/lib/mysql/$DBNAME
  34                 chmod g+rw -R $DIR/$DBNAME/
  35                 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
  36
  37                 sudo -H mysql -e "FLUSH PRIVILEGES;"
  38         ;;
  39
  40         dropdb)
  41                 USERNAME=$2
  42                 DBNAME_BASE=$3
  43                 DBNAME="${USERNAME}_${DBNAME_BASE}"
  44
  45                 sudo -H mysql -e "DROP DATABASE $DBNAME;"
  46         ;;
  47
  48         grant)
  49                 USERNAME=$2
  50                 DBNAME_BASE=$3
  51                 DBNAME="${USERNAME}_${DBNAME_BASE}"
  52
  53                 sudo -H mysql -e "GRANT CREATE,SELECT,INSERT,UPDATE,DELETE,INDEX,ALTER,CREATE VIEW,SHOW VIEW,LOCK TABLES,GRANT OPTION ON TABLE * TO '$USERNAME'@$WHERE;" $DBNAME
  54         ;;
  55
  56         *)
  57                 echo "Usage: domtool-mysql [adduser <user> <password> | passwd <user> <password> | createdb <user> <db> | dropdb <user> <db> | grant <user> <db>]"
  58         ;;
  59 esac