User: mparent-guest Date: 06/01/15 22:57:44 Modified: debian packages.config Log: # Implement backup capability (ability to go prev/next dialog) #Better mysql database creation #PostgreSQL database creation (experimental) #SQLite database creation Revision Changes Path 1.2 +156 -70 musmap/debian/packages.config CVSWEB Options: ------------------- CVSWeb: Annotate this file: http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/musmap/debian/packages.config?annotate=1.2&cvsroot= CVSWeb: View this file: http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/musmap/debian/packages.config?rev=1.2&content-type=text/x-cvsweb-markup&cvsroot= CVSWeb: Diff to previous version: http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/pkg-grass/musmap/debian/packages.config.diff?r1=1.2&r2=1.1&cvsroot= ----------------------------------- Index: packages.config =================================================================== RCS file: /cvsroot/pkg-grass/musmap/debian/packages.config,v retrieving revision 1.1 retrieving revision 1.2 diff -u -r1.1 -r1.2 --- packages.config 12 Jan 2006 20:12:31 -0000 1.1 +++ packages.config 15 Jan 2006 22:57:44 -0000 1.2 @@ -1,71 +1,159 @@ -db_input medium musmap/dbengine || true -db_go -db_get musmap/dbengine -dbengine="$RET" -if [ "$dbengine" = "mysql" ]; then - db_input medium musmap/dbhost || true - db_input medium musmap/dbuser || true - db_input medium musmap/dbpassword || true - db_input medium musmap/dbname || true - db_set musmap/dbadminuser "root" - db_input medium musmap/dbadminuser || true - db_input medium musmap/dbadminpassword || true - db_go - db_get musmap/dbhost - dbhost="$RET" - db_get musmap/dbuser - dbuser="$RET" - db_get musmap/dbpassword - dbpassword="$RET" - db_get musmap/dbname - dbname="$RET" - db_get musmap/dbadminuser - dbadminuser="$RET" - db_get musmap/dbadminpassword - dbadminpassword="$RET" - mysql --host="$dbhost" --user="$dbadminuser" --password="$dbadminpassword" --exec="CREATE DATABASE \`$dbname\`;" - mysql --host="$dbhost" --user="$dbadminuser" --password="$dbadminpassword" --exec="GRANT ALL ON \`$dbname\`.* TO '$dbuser' IDENTIFIED BY '$dbpassword';" -elif [ "$dbengine" = "postgresql" ]; then - db_input medium musmap/dbhost || true - db_input medium musmap/dbport || true - db_input medium musmap/dbuser || true - db_input medium musmap/dbpassword || true - db_input medium musmap/dbname || true - db_set musmap/dbadminuser "SYSDBA" - db_input medium musmap/dbadminuser || true - db_input medium musmap/dbadminpassword || true - db_go - db_get musmap/dbhost - dbhost="$RET" - db_get musmap/dbport - dbport="$RET" - db_get musmap/dbuser - dbuser="$RET" - db_get musmap/dbpassword - dbpassword="$RET" - db_get musmap/dbname - dbname="$RET" - db_get musmap/dbadminuser - dbadminuser="$RET" - db_get musmap/dbadminpassword - dbadminpassword="$RET" -elif [ "$dbengine" = "sqlite" ]; then - db_input medium musmap/dbfilename || true - db_go - db_get musmap/dbfilename - dbfilename="$RET" -elif [ "$dbengine" = "firebird" ]; then - db_input medium musmap/dbpath || true - db_input medium musmap/dbuser || true - db_input medium musmap/dbpassword || true +db_version 2.0 +# This conf script is capable of backing up +db_capb backup + +STEP=1 +NUMSTEPS=5 +while [ "$STEP" != 0 -a "$STEP" != $NUMSTEPS ]; do + db_reset musmap/gofirst + case "$STEP" in + 1) + db_beginblock + db_input medium musmap/dbengine || true + db_endblock + db_go + ;; + 2) + db_get musmap/dbengine + dbengine="$RET" + if [ "$dbengine" = "mysql" ]; then + db_beginblock + db_input medium musmap/dbhost || true + db_input medium musmap/dbuser || true + db_input medium musmap/dbpassword || true + db_input medium musmap/dbname || true + db_set musmap/dbadminuser "root" + db_input medium musmap/dbadminuser || true + db_input medium musmap/dbadminpassword || true + db_input medium musmap/dbcreate || true + db_endblock + elif [ "$dbengine" = "postgresql" ]; then + db_beginblock + db_input medium musmap/dbhost || true + db_input medium musmap/dbport || true + db_input medium musmap/dbuser || true + db_input medium musmap/dbpassword || true + db_input medium musmap/dbname || true + db_input medium musmap/dbcreate || true + db_endblock + elif [ "$dbengine" = "sqlite" ]; then + db_beginblock + db_input medium musmap/dbfilename || true + db_input medium musmap/dbcreate || true + db_endblock + elif [ "$dbengine" = "firebird" ]; then + db_beginblock + db_input medium musmap/dbpath || true + db_input medium musmap/dbuser || true + db_input medium musmap/dbpassword || true + db_input medium musmap/dbcreate || true + db_endblock + fi + ;; + 3) + db_get musmap/dbengine + dbengine="$RET" + if [ "$dbengine" = "mysql" ]; then + db_get musmap/dbhost + dbhost="$RET" + db_get musmap/dbuser + dbuser="$RET" + db_get musmap/dbpassword + dbpassword="$RET" + db_get musmap/dbname + dbname="$RET" + db_get musmap/dbadminuser + dbadminuser="$RET" + db_get musmap/dbadminpassword + dbadminpassword="$RET" + db_get musmap/dbcreate + dbcreate="$RET" + if test $dbcreate == true ; then + # [[Warning]] insecure method to send password + DBS=`mysql --host="$dbhost" --user="$dbadminuser" --password="$dbadminpassword" --skip-column-names --no-pager --exec="SHOW DATABASES LIKE '$dbname'"` + if test "$?" != "0"; then + db_beginblock + db_input medium musmap/dberror || true + db_input medium musmap/gofirst || true + db_endblock + else + if test "$DBS" == "" ; then + mysql --host="$dbhost" --user="$dbadminuser" --password="$dbadminpassword" --exec="CREATE DATABASE \`$dbname\`;" + mysql --host="$dbhost" --user="$dbadminuser" --password="$dbadminpassword" --exec="GRANT ALL ON \`$dbname\`.* TO '$dbuser' IDENTIFIED BY '$dbpassword';" + fi + fi + fi + elif [ "$dbengine" = "postgresql" ]; then + db_get musmap/dbhost + dbhost="$RET" + db_get musmap/dbport + dbport="$RET" + db_get musmap/dbuser + dbuser="$RET" + db_get musmap/dbpassword + dbpassword="$RET" + db_get musmap/dbname + dbname="$RET" + db_get musmap/dbcreate + dbcreate="$RET" + if test $dbcreate == true ; then + if test "dbhost" == ""; then + DBS=`su postgres "psql --port='$dbport' --list -t -A | grep '^$dbname|'"` + if test "$?" != "0"; then + db_beginblock + db_input medium musmap/dberror || true + db_input medium musmap/gofirst || true + db_endblock + else + if test "$DBS" == "" ; then + su postgres "createuser --port="$dbport" -e -A -D '$dbuser';" + su postgres "createdb --port="$dbport" -e -O '$dbuser' '$dbname';" + fi + fi + else + echo "DebConf can only create local users" + fi + fi + elif [ "$dbengine" = "sqlite" ]; then + db_get musmap/dbfilename + dbfilename="$RET" + db_get musmap/dbcreate + dbcreate="$RET" + if test $dbcreate == true ; then + mkdir -p -v `dirname "$dbfilename"` + #sqlite "$dbfilename" ";" # done by php_-sqlite + chown -R www-data:www-data `dirname "$dbfilename"` + fi + elif [ "$dbengine" = "firebird" ]; then + db_get musmap/dbpath + dbpath="$RET" + db_get musmap/dbuser + dbuser="$RET" + db_get musmap/dbpassword + dbpassword="$RET" + db_get musmap/dbcreate + dbcreate="$RET" + fi + ;; + 4) + db_input medium musmap/postinstall + ;; + esac db_go - db_get musmap/dbpath - dbpath="$RET" - db_get musmap/dbuser - dbuser="$RET" - db_get musmap/dbpassword - dbpassword="$RET" -fi + dbgo="$?" + db_get musmap/gofirst + gofirst="$RET" + if test $gofirst == true; then + STEP=1 + elif test "$dbgo" == "30"; then + STEP=$(($STEP - 1)) + else + STEP=$(($STEP + 1)) + fi +done + +db_reset musmap/dbadminpassword +db_reset musmap/dbpassword (echo "<?php" echo "/*" @@ -112,6 +200,4 @@ echo "// -------- EXTRA CONF ------------------- //" echo " Conf::Set('log_dir', '/var/log/musmap/');" echo " Conf::Set('tmp_dir', '/tmp/');" - echo "?>") > /etc/musmap/db_config.php - - db_get musmap/postinstall \ No newline at end of file + echo "?>") > /etc/musmap/db_config.php \ No newline at end of file
_______________________________________________ Pkg-grass-devel mailing list Pkg-grass-devel@lists.alioth.debian.org http://lists.alioth.debian.org/mailman/listinfo/pkg-grass-devel
