X-Git-Url: http://git.onelab.eu/?a=blobdiff_plain;f=init.d%2Fsfa;h=7c51b48896d23bd5b5fdea9d3fdc200577486326;hb=2323eb5f54f6d958352b94e16119f1bfeda8dd07;hp=6e1acb4af00ed750f34f140d1f72dde8cbaaf600;hpb=a02b0795d7ab2f6d806c45f4f3e6d19f54d2bd64;p=sfa.git

diff --git a/init.d/sfa b/init.d/sfa
index 6e1acb4a..7c51b488 100755
--- a/init.d/sfa
+++ b/init.d/sfa
@@ -63,47 +63,15 @@ function postgresql_check () {
 DATE=$(date +"%Y-%m-%d-%H-%M-%S")
 
 # Dumps the database - optional argument to specify filename suffix
-function dump_sfa_db()
-{
+function dump_sfa_db() {
     if [ -n "$1" ] ; then suffix="-$1" ; else suffix="" ; fi
-    dumpfile=/var/lib/pgsql/backups/$(date +"${SFA_DB_NAME}.${DATE}${suffix}.sql")
+    mkdir -p /usr/share/sfa/backups
+    dumpfile=/usr/share/sfa/backups/$(date +"${SFA_DB_NAME}.${DATE}${suffix}.sql")
     pg_dump -U $SFA_DB_USER $SFA_DB_NAME > $dumpfile
+    echo "Saved sfa database in $dumpfile"
     check
 }
 
-# Updates the database by applying all migration scripts in
-# /usr/share/sfa/migrations/N-up-*, where N is greater than the
-# current subversion. At least one of the migration scripts with the
-# same N must update sfa_db_version.subversion.
-function migrate_db()
-{
-    subversion=$(psql -U $SFA_DB_USER --quiet --tuples-only --no-align -c \
-	         "SELECT subversion FROM sfa_db_version LIMIT 1" \
-	         $SFA_DB_NAME 2>/dev/null || echo 0)
-    shopt -s nullglob
-    for file in /usr/share/sfa/migrations/[0-9]*-up-* ; do
-	script=$(basename $file)
-	index=${script%-up*}
-	extension=${script##*.}
-	if [ $index -gt $subversion ] ; then
-	    if [ "$extension" = "sql" ] ; then
-	        dialog " - $script (dbdumped)"
-	        dump_sfa_db "before-$script"
-		psql -U $SFA_DB_USER -f $file $SFA_DB_NAME
-	    elif [ -x $file ] ; then
-	        dialog " - $script (dbdumped)"
-	        dump_sfa_db "before-$script"
-		$file
-	    else
-	        dialog "\nWarning: migration $file not executable"
-	    fi
-	    check
-	fi
-    done
-}
-
-
-
 # Regenerate configuration files - almost verbatim from plc.init
 function reload () {
     force=$1
@@ -211,6 +179,10 @@ function db_start () {
 	    echo "host $SFA_DB_NAME $SFA_DB_USER 127.0.0.1/32 password"
 	    [ -n "$registry_ip" ] && echo "host $SFA_DB_NAME $SFA_DB_USER ${registry_ip}/32 password"
 	) >>$pghba_conf
+
+    if [ "$SFA_GENERIC_FLAVOUR" == "openstack" ] ; then
+        [ -n "$registry_ip" ] && echo "host nova nova ${registry_ip}/32 password" >> $pghba_conf
+    fi   
 	
 	# Fix ownership (sed -i changes it)
 	chown postgres:postgres $postgresql_conf $pghba_conf
@@ -257,9 +229,6 @@ function db_start () {
     if ! psql -U $SFA_DB_USER -c "" $SFA_DB_NAME >/dev/null 2>&1 ; then
 	createdb -U postgres --template=template0 --encoding=UNICODE --owner=$SFA_DB_USER $SFA_DB_NAME
 	check
-        # install db schema
-        psql -U $SFA_DB_USER -f /usr/share/sfa/sfa.sql $SFA_DB_NAME
-	check
     fi
     check
 
@@ -289,8 +258,7 @@ function start() {
     reload
 
     db_start
-
-    migrate_db
+    # migrations are now handled in the code by sfa.storage.dbschema
 
     # install peer certs
     action $"SFA installing peer certs" daemon /usr/bin/sfa-start.py -t -d $OPTIONS 
@@ -332,8 +300,11 @@ case "$1" in
 	status sfa-start.py
 	RETVAL=$?
 	;;
+    dbdump)
+	dump_sfa_db
+	;;
     *)
-	echo $"Usage: $0 {start|stop|reload|restart|condrestart|status}"
+	echo $"Usage: $0 {start|stop|reload|restart|condrestart|status|dbdump}"
 	exit 1
 	;;
 esac