debian/littlebird-tc-sql.postinst
branchtesting
changeset 7 c34f5210c656
parent 5 39695f73e414
child 11 24417d8949b5
equal deleted inserted replaced
6:e9d06ed052d3 7:c34f5210c656
    18 # the debian-policy package
    18 # the debian-policy package
    19 
    19 
    20 
    20 
    21 case "$1" in
    21 case "$1" in
    22     configure)
    22     configure)
    23 	db_get mysql-server/root_password && adminpass="$RET" || true
    23 	db_get littlebird-tc/db/adminuser && adminuser="$RET" || true
    24 
    24 	db_get littlebird-tc/db/adminpass && adminpass="$RET" || true
    25 	db_get littlebird-tc/db/user && user="$RET" || true
    25 	db_get littlebird-tc/db/user && user="$RET" || true
    26 	db_get littlebird-tc/db/pass && pass="$RET" || true
    26 	db_get littlebird-tc/db/pass && pass="$RET" || true
    27 	db_get littlebird-tc/db/host && host="$RET" || true
    27 	db_get littlebird-tc/db/host && host="$RET" || true
    28 	db_get littlebird-tc/db/name && name="$RET" || true
    28 	db_get littlebird-tc/db/name && name="$RET" || true
    29 
    29 
    30 	cat <<EOF
    30 #	cat <<EOF
    31 adminpass: $adminpass
    31 #$@
    32 user: $user
    32 #adminuser/pass: $adminuser/$adminpass
    33 pass: $pass
    33 #user/pass: $user/$pass
    34 host: $host
    34 #db@host: $name@$host
    35 name: $name
    35 #EOF
       
    36 	# only init the db if there is no previous version
       
    37 	if test -z "$2" && test -n "$adminpass"; then
       
    38 
       
    39 	    if test "$host" = "localhost"; then client="localhost"
       
    40 	    else client="%"
       
    41 	    fi
       
    42 
       
    43 	    mysql -h"$host" -u"$adminuser" -p"$adminpass" <<EOF
       
    44 		CREATE DATABASE IF NOT EXISTS $name;
       
    45 		GRANT ALL ON $name.* TO '$user'@'$client' IDENTIFIED BY '$pass';
       
    46 		FLUSH PRIVILEGES;
    36 EOF
    47 EOF
    37 	
    48 	    (	set -e
       
    49 		cd /usr/share/littlebird/tc-sql
       
    50 		./install_test_iteration_2011-06.sh \
       
    51 		    "$host" "$name" \
       
    52 		    "$adminuser" "$adminpass" \
       
    53 		    "$user" "$pass"
       
    54 	    )
       
    55 	fi
    38     ;;
    56     ;;
    39 
    57 
    40     abort-upgrade|abort-remove|abort-deconfigure)
    58     abort-upgrade|abort-remove|abort-deconfigure)
    41     ;;
    59     ;;
    42 
    60