ownCloud Database Migration

Starting with version 10.15.0, the ownCloud package will transition from SQLite to its original MySQL/MariaDB back-end. This update also includes optimized configurations to eliminate all warnings in the settings screen. However, the transition remains somewhat experimental and cannot yet be fully integrated into the upgrade wizard. As a result, some manual steps are required to complete the process. The good news is that this is a one-time task, and detailed step-by-step instructions for executing it via SSH are provided below:

Instructions for DSM 6 on ownCloud version 10.14.0

1. Install redis from the SynoCommunity repository
2. Enable SSH (if required) and connect to your DiskStation
3. Setup some shortcuts as follows:

oc_usr=http
oc_php=/usr/local/bin/php74
oc_occ=/var/services/web/owncloud/occ
oc_sql=/usr/local/mariadb10/bin/mysql
oc_home=/var/services/web/owncloud

4. Save your MySQL password (replacing the [...] with your value)

oc_rpwd=[your MySQL root password]

5. Set a random password for the database user

oc_upwd=$(LC_ALL=C tr -dc '[:graph:]' </dev/urandom | head -c 30; echo)

6. Enable maintenance mode

sudo -u $oc_usr $oc_php $oc_occ maintenance:mode --on

7. Remove previous Apache redirect

sudo -u $oc_usr sed -i.bak '/^RewriteEngine On$/d; /^RewriteCond %{HTTPS} off$/d; /^RewriteRule ^(.*)$ https:\/\/%{HTTP_HOST}%{REQUEST_URI} \[L,R=301\]$/d' $oc_home/.htaccess

8. Add HSTS to Apache config

sudo tee -a $oc_home/.htaccess > /dev/null <<EOF
<IfModule mod_headers.c>
Header always set Strict-Transport-Security "max-age=15552000; includeSubDomains"
</IfModule>
EOF
sudo chown $oc_usr $oc_home/.htaccess

9. Create new MySQL database

$oc_sql -u root -p$oc_rpwd -e "create database owncloud; grant all privileges on owncloud.* to 'oc_admin'@'localhost' identified by '$oc_upwd';"

10. Prepare environment for migration

sudo -u $oc_usr $oc_php $oc_occ config:system:set mysql.utf8mb4 --value=true

11. Open MariaDB 10 in DSM and enable TCP/IP connection

12. Disable maintenance mode

sudo -u $oc_usr $oc_php $oc_occ maintenance:mode --off

13. Perform database conversion (can take several minutes)

sudo -u $oc_usr $oc_php $oc_occ db:convert-type --port=3307 --password=$oc_upwd --all-apps mysql oc_admin 127.0.0.1 owncloud

14. Enable maintenance mode

sudo -u $oc_usr $oc_php $oc_occ maintenance:mode --on

15. Configure database connection

sudo -u $oc_usr $oc_php $oc_occ config:system:set dbhost --value="localhost:/run/mysqld/mysqld10.sock"

16. Open MariaDB 10 in DSM and disable TCP/IP connection

17. Backup the PHP config file with attributes preserved

sudo cp -p /usr/syno/etc/packages/WebStation/PHPSettings.json /usr/syno/etc/packages/WebStation/PHPSettings.json.bak

18. Modify the JSON file with jq

sudo jq '.["com-synocommunity-packages-owncloud"].extensions += ["pdo_mysql", "redis"]' /usr/syno/etc/packages/WebStation/PHPSettings.json > temp.json

19. Move the modified file back to the original location

sudo mv temp.json /usr/syno/etc/packages/WebStation/PHPSettings.json

20. Restore the original file's attributes (permissions, ownership, timestamps)

sudo cp --attributes-only /usr/syno/etc/packages/WebStation/PHPSettings.json.bak /usr/syno/etc/packages/WebStation/PHPSettings.json

21. Restart Apache (if it fails to restart Apache may need to be started manually)

if jq -e 'to_entries | map(select((.key | startswith("'"com-synocommunity-packages-"'")) and .key != "'"com-synocommunity-packages-owncloud"'")) | length == 0' "/usr/syno/etc/packages/WebStation/PHPSettings.json" >/dev/null; then \
sudo /usr/syno/sbin/synoservice --restart pkgctl-Apache2.4 \
else echo "Failed to restart Apache" ;\
fi

22. Configure memory caching

sudo -u $oc_usr $oc_php $oc_occ config:system:set memcache.local --value="\OC\Memcache\APCu"

23. Configure file locking

sudo -u $oc_usr $oc_php $oc_occ config:system:set memcache.locking --value="\OC\Memcache\Redis"
sudo -u $oc_usr $oc_php $oc_occ config:system:set filelocking.enabled --value true

24. Disable maintenance mode

sudo -u $oc_usr $oc_php $oc_occ maintenance:mode --off

25. Configure background jobs

sudo -u $oc_usr $oc_php $oc_occ system:cron