CentOS 7.x Upgrade owncloud to newer version or updated stack

<yambe:breadcrumb>CentOS_7.x_owncloud|Owncloud</yambe:breadcrumb>

CentOS 7.x Upgrade owncloud to newer version or updated stack

CentOS 7.x upgrade owncloud to newer version or updated stack using following steps:

1. Take database dump of older owncloud
2. Restore database dump to newer owncloud using database crendentials of new server. For this no need to start apache/owncloud interface. Only start mysqld database on new server.

   For example in case of bitnami do "./ctlscript.sh start mysql"

   For this use steps similar to:

   1. Run "/opt/owncloud-10.1.0-1/mysql/bin/mysql -u bn_owncloud -p" on bash to get mysql prompt for running further commands
   2. drop database bitnami_owncloud;
   3. create database bitnami_owncloud;
   4. use bitnami_owncloud;
   5. source <path-to-sql-dump-from-old-server>;
   6. exit
3. Ensure data folder from older owncloud is copied/moved to newer owncloud and permissions are updated

   Example steps:

   cd /opt/owncloud-10.1.0-1/apps/owncloud
   mv data data2
   mv /var/www/html/owncloud/data data
   chown -R daemon:daemon data
   ls -l #validate 770 permission on new data folder

4. cd owncloud htdocs folder

   Eg /opt/owncloud-10.1.0-1/apps/owncloud/htdocs

5. Then try to upgrade owncloud

   sudo -u daemon /opt/owncloud-10.1.0-1/php/bin/php occ maintenance:mode --on
   sudo -u daemon /opt/owncloud-10.1.0-1/php/bin/php occ upgrade

   This might show error such as

   ownCloud or one of the apps require upgrade - only a limited number of commands are available
   You may use your browser or the occ upgrade command to do the upgrade
   2019-03-13T09:01:56+00:00 Set log level to debug
   2019-03-13T09:01:56+00:00 Repair step: Upgrade app code from the marketplace
   2019-03-13T09:01:56+00:00 Repair warning: You have incompatible or missing apps enabled that could not be found or updated via the marketplace.
   2019-03-13T09:01:56+00:00 Repair warning: Please install or update the following apps manually or disable them with:
   occ app:disable activity
   occ app:disable files_pdfviewer
   occ app:disable files_texteditor
   occ app:disable gallery
   occ app:disable templateeditor
   2019-03-13T09:01:56+00:00 Repair warning: For manually updating, see https://doc.owncloud.org/server/10.1/go.php?to=admin-marketplace-apps
   2019-03-13T09:01:56+00:00 OC\RepairException: Upgrade is not possible
   2019-03-13T09:01:56+00:00 Update failed
   2019-03-13T09:01:56+00:00 Maintenance mode is kept active
   2019-03-13T09:01:56+00:00 Reset log level

6. Based on this disable apps using

   sudo -u daemon /opt/owncloud-10.1.0-1/php/bin/php occ app:disable activity
   sudo -u daemon /opt/owncloud-10.1.0-1/php/bin/php occ app:disable files_pdfviewer
   sudo -u daemon /opt/owncloud-10.1.0-1/php/bin/php occ app:disable files_texteditor
   sudo -u daemon /opt/owncloud-10.1.0-1/php/bin/php occ app:disable gallery
   sudo -u daemon /opt/owncloud-10.1.0-1/php/bin/php occ app:disable templateeditor

7. Then again try update using:

   sudo -u daemon /opt/owncloud-10.1.0-1/php/bin/php occ upgrade

   which might show error such as

   ownCloud or one of the apps require upgrade - only a limited number of commands are available
   You may use your browser or the occ upgrade command to do the upgrade
   2019-03-13T09:07:29+00:00 Set log level to debug
   2019-03-13T09:07:29+00:00 Repair step: Upgrade app code from the marketplace
   2019-03-13T09:07:29+00:00 Repair step: Repair MySQL database engine
   2019-03-13T09:07:29+00:00 Repair step: Repair MySQL collation
   2019-03-13T09:07:29+00:00 Repair info: Change collation for oc_activity ...
   2019-03-13T09:07:29+00:00 Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'ALTER TABLE `oc_activity` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;':
   
   SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
   2019-03-13T09:07:29+00:00 Update failed
   2019-03-13T09:07:29+00:00 Maintenance mode is kept active
   2019-03-13T09:07:29+00:00 Reset log level

8. To fix MySQL issues on upgrade use

   sudo -u daemon /opt/owncloud-10.1.0-1/php/bin/php occ config:system:set mysql.utf8mb4 --type boolean --value="false"

   then upgrade using

   sudo -u daemon /opt/owncloud-10.1.0-1/php/bin/php occ upgrade

   and then disable maintenance mode using:

   sudo -u daemon /opt/owncloud-10.1.0-1/php/bin/php occ maintenance:mode --off

9. Optionally create /etc/cron.daily/owncloud-maintenance.sh with

   
   #!/bin/bash
   cd /opt/owncloud-10.1.0-1/apps/owncloud/htdocs
   sudo -u daemon /opt/owncloud-10.1.0-1/php/bin/php -f cron.php

10. Set execute permissions on cron file and test it:

    chmod +x /etc/cron.daily/owncloud-maintenance.sh
    /etc/cron.daily/owncloud-maintenance.sh

11. At this point apache/owncloud frontend can be started.

    Example command ./ctlscript.sh start apache

Refer:

• https://github.com/owncloud/core/issues/27755

<yambe:breadcrumb>CentOS_7.x_owncloud|Owncloud</yambe:breadcrumb>