From 90dd8d668946d5ae73fd0582647e394011be5f92 Mon Sep 17 00:00:00 2001
From: nachoparker <nacho@ownyourbits.com>
Date: Sat, 29 Jul 2017 19:57:41 +0200
Subject: backup/restore: include datadir

---
 etc/nextcloudpi-config.d/nc-backup.sh  | 23 ++++++++++---
 etc/nextcloudpi-config.d/nc-restore.sh | 59 +++++++++++++++++++++++++++-------
 tests/tests.py                         |  1 +
 3 files changed, 66 insertions(+), 17 deletions(-)

diff --git a/etc/nextcloudpi-config.d/nc-backup.sh b/etc/nextcloudpi-config.d/nc-backup.sh
index 35212274..8843c7c5 100644
--- a/etc/nextcloudpi-config.d/nc-backup.sh
+++ b/etc/nextcloudpi-config.d/nc-backup.sh
@@ -16,29 +16,42 @@
 
 
 DESTDIR_=/media/USBdrive
-BASEDIR_=/var/www
+INCLUDEDATA_=no
 DESCRIPTION="Backup this NC instance to a file"
 
 DESTFILE=$DESTDIR_/nextcloud-bkp_`date +"%Y%m%d"`.tar 
 DBBACKUP=nextcloud-sqlbkp_`date +"%Y%m%d"`.bak
+BASEDIR=/var/www
 
 configure()
 {
-  cd $BASEDIR_/nextcloud
+  local DATADIR
+  DATADIR=$( cd $BASEDIR/nextcloud; sudo -u www-data php occ config:system:get datadirectory ) || {
+    echo -e "Error reading data directory. Is NextCloud running and configured?";
+    return 1;
+  }
+
+  cd $BASEDIR/nextcloud
   sudo -u www-data php occ maintenance:mode --on
 
-  cd $BASEDIR_
+  cd $BASEDIR
   echo -e "backup database..."
   mysqldump -u root --single-transaction nextcloud > $DBBACKUP
 
+  [[ "$INCLUDEDATA_" == "yes" ]] && echo -e "backup datadir... "
   echo -e "backup files..."
   mkdir -p $DESTDIR_
-  tar -cf $DESTFILE $DBBACKUP nextcloud/ && \
+  tar -cf $DESTFILE $DATAFILE $DBBACKUP nextcloud/ --exclude "nextcloud/data/*/files/*" && \
     echo -e "backup $DESTFILE generated" || \
     echo -e "error generating backup"
   rm $DBBACKUP
 
-  cd $BASEDIR_/nextcloud
+  [[ "$INCLUDEDATA_" == "yes" ]] && {
+    tar -rf $DESTFILE -C $DATADIR/.. $( basename $DATADIR ) || \
+      echo -e "error generating data backup"
+  }
+
+  cd $BASEDIR/nextcloud
   sudo -u www-data php occ maintenance:mode --off
 }
 
diff --git a/etc/nextcloudpi-config.d/nc-restore.sh b/etc/nextcloudpi-config.d/nc-restore.sh
index ec9c18c4..c99a41ad 100644
--- a/etc/nextcloudpi-config.d/nc-restore.sh
+++ b/etc/nextcloudpi-config.d/nc-restore.sh
@@ -43,16 +43,18 @@ configure()
   [ -d $BASEDIR_           ] || { echo -e "$BASEDIR_    not found"; return 1;  }
   [ -d $BASEDIR_/nextcloud ] && { echo -e "WARNING: overwriting old instance"; }
 
-  cd $BASEDIR_/nextcloud
-  sudo -u www-data php occ maintenance:mode --on
+  local TMPDIR="$( dirname $BACKUPFILE_ )/$( basename ${BACKUPFILE_}-tmp )"
+  rm -rf "$TMPDIR" && mkdir -p "$TMPDIR"
+  tar -xf "$BACKUPFILE_" -C "$TMPDIR" || return 1
+
+  ## RESTORE FILES
 
-  # RESTORE FILES
   echo -e "restore files..."
-  cd $BASEDIR_
-  rm -rf nextcloud
-  tar -xf $BACKUPFILE_ || return 1
+  rm -rf $BASEDIR_/nextcloud
+  mv "$TMPDIR"/nextcloud $BASEDIR_
+
+  ## RE-CREATE DATABASE TABLE
 
-  # RE-CREATE DATABASE TABLE
   local DBPASSWD=$( grep password /root/.my.cnf | cut -d= -f2 )
   echo -e "restore database..."
   mysql -u root -p$DBPASSWD <<EOF
@@ -64,15 +66,48 @@ CREATE USER '$DBADMIN_'@'localhost' IDENTIFIED BY '$DBPASSWD';
 GRANT ALL PRIVILEGES ON nextcloud.* TO $DBADMIN_@localhost;
 EXIT
 EOF
-  [ $? -ne 0 ] && { echo -e "error configuring nextcloud database"; return 1; }
+  [ $? -ne 0 ] && { echo -e "Error configuring nextcloud database"; return 1; }
 
-  mysql -u root -p$DBPASSWD nextcloud <  nextcloud-sqlbkp_*.bak || { echo -e "error restoring nextcloud database"; return 1; }
+  mysql -u root -p$DBPASSWD nextcloud <  "$TMPDIR"/nextcloud-sqlbkp_*.bak || { echo -e "Error restoring nextcloud database"; return 1; }
 
-  # Just in case we moved the opcache dir
-  sed -i "s|^opcache.file_cache=.*|opcache.file_cache=$BASEDIR_/nextcloud/data/.opcache|" /etc/php/7.0/mods-available/opcache.ini
+  ## RESTORE DATADIR
 
   cd $BASEDIR_/nextcloud
-  sudo -u www-data php occ maintenance:mode --off
+
+  # INCLUDEDATA=yes situation
+
+  if [[ $( ls "$TMPDIR" | wc -l ) == 2 ]]; then           
+    local DATADIR=$( grep datadirectory $BASEDIR_/nextcloud/config/config.php | awk '{ print $3 }' | grep -oP "[^']*[^']" | head -1 ) 
+    [[ "$DATADIR" == "" ]] && { echo -e "Error reading data directory"; return 1; }
+    echo -e "restore datadir to $DATADIR..."
+    rm -rf "$DATADIR"
+    mkdir -p "$( dirname "$DATADIR" )"
+    mv "$TMPDIR/$( basename "$DATADIR" )" "$DATADIR"
+    sudo -u www-data php occ maintenance:mode --off
+
+  # INCLUDEDATA=no situation
+
+  else      
+    echo -e "no datadir found in backup"
+    sed -i "s|'datadirectory' =>.*|'datadirectory' => '/var/www/nextcloud/data',|" "config/config.php"
+
+    sudo -u www-data php occ maintenance:mode --off
+    sudo -u www-data php occ files:scan --all
+
+    # cache needs to be cleaned as of NC 12
+    (
+      sleep 3
+      systemctl stop php7.0-fpm
+      systemctl stop mysqld
+      sleep 0.5
+      systemctl start php7.0-fpm
+      systemctl start mysqld
+    ) &>/dev/null &
+  fi
+  rm -r "$TMPDIR"
+
+  # Just in case we moved the opcache dir
+  sed -i "s|^opcache.file_cache=.*|opcache.file_cache=$BASEDIR_/nextcloud/data/.opcache|" /etc/php/7.0/mods-available/opcache.ini
 }
 
 install() { :; }
diff --git a/tests/tests.py b/tests/tests.py
index ebf10688..9cab4a93 100755
--- a/tests/tests.py
+++ b/tests/tests.py
@@ -111,6 +111,7 @@ class LoginNewUserTest(unittest.TestCase):
         driver.find_element_by_id("user").send_keys("test_user1")
         driver.find_element_by_id("password").send_keys("ownyourbits")
         driver.find_element_by_id("submit").click()
+        self.assertNotIn("Wrong password", driver.page_source)
 
         time.sleep(60)  # first run can be really slow on QEMU
         wait = WebDriverWait(driver, 210)
-- 
cgit v1.2.3