From: Adam Chlipala <adamc@hcoop.net>
Date: Tue, 17 Apr 2007 03:17:08 +0000 (+0000)
Subject: Change dbtool to create user only (and assign tablespace ownership for Postgres)
X-Git-Tag: release_2010-11-19~236
X-Git-Url: https://git.hcoop.net/hcoop/domtool2.git/commitdiff_plain/53cb7cc1a416d38a26a5287478e00920f3d67b7c?hp=2464c83cc213e1e039275053456d055c2afd48cf

Change dbtool to create user only (and assign tablespace ownership for Postgres)
---

diff --git a/src/plugins/domtool-mysql b/src/plugins/domtool-mysql
index 4fad400..657ed00 100755
--- a/src/plugins/domtool-mysql
+++ b/src/plugins/domtool-mysql
@@ -2,8 +2,11 @@
 
 case $1 in
 	adduser)
-		echo MySQL user was already created during create-user.
-	;;
+		USERNAME=$2
+		PASSWORD=$3
+
+		sudo -H mysql -e "CREATE USER '$USERNAME'@'localhost' IDENTIFIED BY '$PASSWORD';"
+
 	passwd)
 		USERNAME=$2
 		PASSWORD=$3
diff --git a/src/plugins/domtool-postgres b/src/plugins/domtool-postgres
index cbc10e9..1d945d4 100755
--- a/src/plugins/domtool-postgres
+++ b/src/plugins/domtool-postgres
@@ -2,7 +2,10 @@
 
 case $1 in
 	adduser)
-		echo Postgres user was already created during create-user.
+		USERNAME=$2
+
+		sudo -u postgres psql -c "CREATE USER $USERNAME" template1
+		sudo -u postgres psql -c "ALTER TABLESPACE user_$USERNAME OWNER TO $USERNAME"
 	;;
 	createdb)
 		USERNAME=$2