--- 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)