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 (executable)
--- a/src/plugins/domtool-mysql
+++ b/src/plugins/domtool-mysql
@@ -2,8 +2,11 @@
 
 case $1 in
        adduser)
 
 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
        passwd)
                USERNAME=$2
                PASSWORD=$3

diff --git a/src/plugins/domtool-postgres b/src/plugins/domtool-postgres
index cbc10e9..1d945d4 100755 (executable)
--- a/src/plugins/domtool-postgres
+++ b/src/plugins/domtool-postgres
@@ -2,7 +2,10 @@
 
 case $1 in
        adduser)
 
 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
        ;;
        createdb)
                USERNAME=$2