1 files changed, 87 insertions, 0 deletions
diff --git a/etc/ncp-config.d/nc-database.sh b/etc/ncp-config.d/nc-database.sh
new file mode 100644
index 00000000..21c4ecb8
--- /dev/null
+++ b/etc/ncp-config.d/nc-database.sh
@@ -0,0 +1,87 @@
+#!/bin/bash
+
+# Data dir configuration script for NextCloudPlus
+#
+# Copyleft 2017 by Ignacio Nunez Hernanz <nacho _a_t_ ownyourbits _d_o_t_ com>
+# GPL licensed (see end of file) * Use at your own risk!
+#
+# Usage:
+# 
+#   ./installer.sh nc-database.sh <IP> (<img>)
+#
+# See installer.sh instructions for details
+#
+# More at https://ownyourbits.com/
+#
+
+DBDIR_=/media/USBdrive/ncdatabase
+DESCRIPTION="Move your database to a new location, like a USB drive"
+
+INFO="Note that non Unix filesystems such as NTFS are not supported
+because they do not provide a compatible user/permissions system
+
+You need to use a USB drive that is permanently on and is responsive 
+or the database will fail.
+
+** If it ever fails with a white page, move the database back to the SD **"
+
+is_active()
+{
+  local SRCDIR=$( grep datadir /etc/mysql/mariadb.conf.d/50-server.cnf | awk -F "= " '{ print $2 }' )
+  [[ "$SRCDIR" != "/var/lib/mysql" ]]
+}
+
+configure()
+{
+  local SRCDIR=$( grep datadir /etc/mysql/mariadb.conf.d/50-server.cnf | awk -F "= " '{ print $2 }' )
+  [ -d "$SRCDIR" ] || { echo -e "database directory $SRCDIR not found"; return 1; }
+
+  [ -d "$DBDIR_" ] && {
+    [[ $( find "$DBDIR_" -maxdepth 0 -empty | wc -l ) == 0 ]] && {
+      echo "$DBDIR_ is not empty"
+      return 1
+    }
+    rmdir "$DBDIR_" 
+  }
+
+  local BASEDIR=$( dirname "$DBDIR_" )
+  mkdir -p "$BASEDIR"
+
+  grep -q -e ext -e btrfs <( stat -fc%T "$BASEDIR" ) || { echo -e "Only ext/btrfs filesystems can hold the data directory"; return 1; }
+  
+  sudo -u mysql test -x "$BASEDIR" || { echo -e "ERROR: the user mysql does not have access permissions over $BASEDIR"; return 1; }
+
+  [[ $( stat -fc%d / ) == $( stat -fc%d "$BASEDIR" ) ]] && \
+    echo -e "INFO: moving database to another place in the same SD card\nIf you want to use an external mount, make sure it is properly set up"
+
+  cd /var/www/nextcloud
+  sudo -u www-data php occ maintenance:mode --on
+
+  echo "moving database to $DBDIR_..."
+  service mysql stop
+  mv "$SRCDIR" "$DBDIR_" && \
+    sed -i "s|^datadir.*|datadir = $DBDIR_|" /etc/mysql/mariadb.conf.d/50-server.cnf
+  service mysql start 
+
+  sudo -u www-data php occ maintenance:mode --off
+}
+
+install(){ :; }
+
+# License
+#
+# This script is free software; you can redistribute it and/or modify it
+# under the terms of the GNU General Public License as published by
+# the Free Software Foundation; either version 2 of the License, or
+# (at your option) any later version.
+#
+# This script is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+# GNU General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with this script; if not, write to the
+# Free Software Foundation, Inc., 59 Temple Place, Suite 330,
+# Boston, MA  02111-1307  USA
+