CentOS 7.x Upgrade owncloud to newer version or updated stack
From Notes_Wiki
<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:
- Take database dump of older owncloud
- 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:
- Run "/opt/owncloud-10.1.0-1/mysql/bin/mysql -u bn_owncloud -p" on bash to get mysql prompt for running further commands
- drop database bitnami_owncloud;
- create database bitnami_owncloud;
- use bitnami_owncloud;
- source <path-to-sql-dump-from-old-server>;
- exit
- 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
- Example steps:
- cd owncloud htdocs folder
- Eg /opt/owncloud-10.1.0-1/apps/owncloud/htdocs
- 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
- 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
- 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
- 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
- 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
- Set execute permissions on cron file and test it:
- chmod +x /etc/cron.daily/owncloud-maintenance.sh
- /etc/cron.daily/owncloud-maintenance.sh
- At this point apache/owncloud frontend can be started.
- Example command ./ctlscript.sh start apache
Refer:
<yambe:breadcrumb>CentOS_7.x_owncloud|Owncloud</yambe:breadcrumb>