src/plugins/domtool-mysql

#!/bin/sh -e

case $1 in
	adduser)
		echo MySQL user was already created during create-user.
	;;
	passwd)
		USERNAME=$2
		PASSWORD=$3

		sudo -H mysql -e "SET PASSWORD FOR '$USERNAME'@'localhost' = PASSWORD('$PASSWORD');"
	;;
	createdb)
		USERNAME=$2
		DBNAME_BASE=$3
		DBNAME="${USERNAME}_${DBNAME_BASE}"
		DIR=/afs/hcoop.net/common/databases/$USERNAME/mysql

		kinit -k -t /etc/keytabs/root.admin.keytab root/admin
		aklog

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

		mkdir $DIR/$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

		sudo -H mysql -e "GRANT CREATE,SELECT,INSERT,UPDATE,DELETE,INDEX,ALTER,CREATE VIEW,SHOW VIEW,GRANT OPTION ON TABLE * TO '$USERNAME'@'localhost';" $DBNAME
		sudo -H mysql -e "FLUSH PRIVILEGES;"
	;;
	*)
		echo "Usage: domtool-mysql [adduser <user> <password> | passwd <user> <password> | createdb <user> <table>]"
	;;
esac
Commit	Line	Data
	1	#!/bin/sh -e
	2
	3	case $1 in
	4	adduser)
	5	echo MySQL user was already created during create-user.
	6	;;
	7	passwd)
	8	USERNAME=$2
	9	PASSWORD=$3
	10
	11	sudo -H mysql -e "SET PASSWORD FOR '$USERNAME'@'localhost' = PASSWORD('$PASSWORD');"
	12	;;
	13	createdb)
	14	USERNAME=$2
	15	DBNAME_BASE=$3
	16	DBNAME="${USERNAME}_${DBNAME_BASE}"
	17	DIR=/afs/hcoop.net/common/databases/$USERNAME/mysql
	18
	19	kinit -k -t /etc/keytabs/root.admin.keytab root/admin
	20	aklog
	21
	22	if ! -d $DIR; then
	23	echo WARNING: $DIR must already exist!
	24	fi
	25
	26	mkdir $DIR/$DBNAME
	27	chown mysql:mysql $DIR/$DBNAME
	28	chmod 770 $DIR/$DBNAME
	29	ln -sf $DIR/$DBNAME /var/lib/mysql/$DBNAME
	30	fs setacl -dir $DIR/$DBNAME/ -acl system:mysql all
	31
	32	sudo -H mysql -e "GRANT CREATE,SELECT,INSERT,UPDATE,DELETE,INDEX,ALTER,CREATE VIEW,SHOW VIEW,GRANT OPTION ON TABLE * TO '$USERNAME'@'localhost';" $DBNAME
	33	sudo -H mysql -e "FLUSH PRIVILEGES;"
	34	;;
	35	*)
	36	echo "Usage: domtool-mysql [adduser <user> <password> \| passwd <user> <password> \| createdb <user> <table>]"
	37	;;
	38	esac