debian/littlebird-tc-sql.postinst
branchtesting
changeset 7 c34f5210c656
parent 5 39695f73e414
child 11 24417d8949b5
--- a/debian/littlebird-tc-sql.postinst	Wed Aug 31 14:13:15 2011 +0200
+++ b/debian/littlebird-tc-sql.postinst	Wed Aug 31 16:50:58 2011 +0200
@@ -20,21 +20,39 @@
 
 case "$1" in
     configure)
-	db_get mysql-server/root_password && adminpass="$RET" || true
-
+	db_get littlebird-tc/db/adminuser && adminuser="$RET" || true
+	db_get littlebird-tc/db/adminpass && adminpass="$RET" || true
 	db_get littlebird-tc/db/user && user="$RET" || true
 	db_get littlebird-tc/db/pass && pass="$RET" || true
 	db_get littlebird-tc/db/host && host="$RET" || true
 	db_get littlebird-tc/db/name && name="$RET" || true
 
-	cat <<EOF
-adminpass: $adminpass
-user: $user
-pass: $pass
-host: $host
-name: $name
+#	cat <<EOF
+#$@
+#adminuser/pass: $adminuser/$adminpass
+#user/pass: $user/$pass
+#db@host: $name@$host
+#EOF
+	# only init the db if there is no previous version
+	if test -z "$2" && test -n "$adminpass"; then
+
+	    if test "$host" = "localhost"; then client="localhost"
+	    else client="%"
+	    fi
+
+	    mysql -h"$host" -u"$adminuser" -p"$adminpass" <<EOF
+		CREATE DATABASE IF NOT EXISTS $name;
+		GRANT ALL ON $name.* TO '$user'@'$client' IDENTIFIED BY '$pass';
+		FLUSH PRIVILEGES;
 EOF
-	
+	    (	set -e
+		cd /usr/share/littlebird/tc-sql
+		./install_test_iteration_2011-06.sh \
+		    "$host" "$name" \
+		    "$adminuser" "$adminpass" \
+		    "$user" "$pass"
+	    )
+	fi
     ;;
 
     abort-upgrade|abort-remove|abort-deconfigure)