WIP: Resolve "Restore from legacy backup"

Closes #182

utils/backup_app.sh

 #!/bin/bash
 
-#=== Informations ===================================================================#
-#- Backup App (Piwigo, prestashop, nextcloud) database and data files
+#=== Informations ================================================================#
+#- Goal: backup App (Piwigo, prestashop, nextcloud) database and data files
 #- Author: B. Mauclaire - bm@ekimia.fr - 2019/11/11
 #- Author: M. Memeteau - mm@ekimia.fr - 2020/01/01
 #- Licence: GNU Affero General Public License v3.0
 #- Note: vm archive's name will be built with the app's name.
 #- Warning: sshpass package has to be installed.
 
-
-#--- Example of connexion parameters:
-# HOST_NAME='jaguar.ekimia.fr'
-# HOST_USER='root'
-# HOST_PORT=622
-# DB_NAME='piwigo'
-# DB_USER='piwigo'
 #-- File where host user's password is stored during script is runnung:
 PSWDFILE=".nopaswd"
 
@@ -59,7 +52,9 @@ function main_proc ()
 #--- Command for testing not asking ssh connexion password:
 function testsshnopass ()
 {
+   
    sshpass -p `cat $PSWDFILE` ssh -p $HOST_PORT ${HOST_USER}@$HOST_NAME "ls"
+   sudo apt install sshpass -y
 }
 
 
@@ -70,11 +65,12 @@ function set_app_directories ()
       piwigo)
          #-- i=photos/_data/i ; upload=photos/upload
          APP_DIR="/var/www/photos" ;
-         APP_DIRS=( "_data/i" "upload" ) ;
+         APP_DIRS=( "_data/i" "upload" "local/config" ) ;
       ;;
       prestashop)
-         APP_DIR="/var/www/html" ;
-         APP_DIRS=( "" ) ;
+         # See for 1.7 https://devdocs.prestashop.com/1.7/development/architecture/
+         APP_DIR="/var/www/" ;
+         APP_DIRS=( "shop" ) ; 
       ;;
       nextcloud)
          APP_DIR="" ;
@@ -131,14 +127,18 @@ function backup_db ()
 {
    echo ""
    echo "*** Database backup from $HOST_NAME to local file ${DB_NAME}.sql ***"
-   
-   if [ "$DB_ENGINE" == "mysql" ] || [ "$DB_ENGINE" == "mariadb" ] ; then
-      $SSHNOPASS "mysqldump '"$DB_NAME"' -u '"$DB_USER"' -p'"${DB_PWD}"'" > ${DB_NAME}.sql
-   elif [ "$DB_ENGINE" == "pgsql" ] ; then
-      # !! TO TEST !!
-      $SSHNOPASS "PGPASSWORD='"${DB_PWD}"' pg_dump --format=plain--file --create -U '"$DB_USER"' '"$DB_NAME"'" > ${DB_NAME}.sql
-      # pg_dump postgresql://username:password@127.0.0.1:5432/mydatabase 
-   fi
+
+   case $DB_ENGINE in
+      "mysql" | "mariadb")
+         $SSHNOPASS "mysqldump '"$DB_NAME"' -u '"$DB_USER"' -p'"${DB_PWD}"'" > ${DB_NAME}.sql
+         ;;
+      "pgsql")
+         #- !! TO TEST !!
+         # $SSHNOPASS "PGPASSWORD='"${DB_PWD}"' pg_dump --format=plain--file --create -U '"$DB_USER"' '"$DB_NAME"'" > ${DB_NAME}.sql
+         $SSHNOPASS "PGPASSWORD='"${DB_PWD}"' pg_dump -F p -U '"$DB_USER"' '"$DB_NAME"'" > ${DB_NAME}.sql
+         # pg_dump postgresql://username:password@127.0.0.1:5432/mydatabase 
+         ;;
+   esac
    
    echo "*** Database dump downloaded! ***"
 }