Upgrade and Migrate Owncloud Server from 10.0.7 (Ubuntu 16.04) to 10.4.1 (Ubuntu 18.04) Version

Steps to reproduce

  1. Upgrading and migrating the owncloud from 10.0.7 to 10.4.1

  2. Existing Owncloud 10.0.7 Setup
    • Operating System: Ubuntu 16.04 Server LTS
    • Web server: Apache2
    • Database: SQLITE3
    • PHP version: PHP 7.0.
    • ownCloud version: “10.0.7.2”

  3. New Owncloud 10.4.1 Setup
    • Operating System : Ubuntu 18.04 Server LTS
    • Web Server : Apache2
    • Database : Mariadb
    • PHP Version : PHP7.2
    • Owncloud Version: “10.4.1”

  4. While Upgrading from Owncloud 10.0.7 to 10.4.1 I have faced a lots of issues in Database file because in my previous Owncloud version 10.0.7 my database type is Sqlite3 and in my current version 10.4.1 the database type is MariaDB while trying to converting sqlite3 to MariaDB syntax error will throw in your MariaDB due to the SQL queries in sqlite3 has one syntax structure and for MariaDB has another syntax Structure in order to migrate the old database to new database it will be difficult now either you have to convert the queries syntax of sqlite3 to MariaDB or else you should install the same database to both of the owncloud version so I have installed Sqlite3 database in owncloud 10.4.1 to migrate the database.

  5. I have Migrated the database by copying the old owncloud.db file which is stored in /var/www/html/owncloud/data and moved to new owncloud 10.4.1 /var/www/data/owncloud/data/ by stopping the webserver and putting the owncloud in an maintenance mode.

  6. Once after I have moved my owncloud.db file I started my services of webserver and putting the owncloud maintenance mode –off and my database got imported.
    While opening in my browser login I got an error to upgrade in OCC after that I have upgraded my OCC and the error got solved my database has imported successfully and I have synced my previous Data to new Owncloud Version 10.4.1.

  7. Now my database type for owncloud is sqlite3 and i don’t want my owncloud database type in sqlite3 so I tried to convert my db type to MariaDB while trying to convert my db type in OCC it throws an error of DBAL/Exception so I have installed PHP7.2-Sqlite3 in my owncloud and I tried again to convert my database now the DB got converted to MariaDB

Expected behaviour
Owncloud should be in live with MariaDB type
Actual behaviour
Empty table set in my owncloud database
Server configuration
Operating system: Ubuntu 16.04 Server LTS
Web server: Apache2
Database: SQLITE3
PHP version: PHP 7.0.
ownCloud version: “10.0.7.2”,
Updated from an older ownCloud or fresh install: Fresh Install
Where did you install ownCloud from: owncloud.org
Signing status (ownCloud 9.0 and above):
Login as admin user into your ownCloud and access http://example.com/owncloud/index.php/settings/integrity/failed
paste the results into https: No errors have been found.
.
The content of config/config.php:
{
“system”: {
“instanceid”: “oc3lo3f6rcjd”,
“passwordsalt”: “REMOVED SENSITIVE VALUE”,
“secret”: “REMOVED SENSITIVE VALUE”,
“trusted_domains”: [
“192.168.1.11”,

    ],
    "datadirectory": "\/var\/www\/html\/owncloud\/data",
    "overwrite.cli.url": "https:\/\/192.168.1.11\/owncloud",
    "dbtype": "sqlite3",
    "version": "10.0.7.2",
    "logtimezone": "UTC",
    "installed": true,
    "mail_smtpmode": "smtp",
    "loglevel": 1
}

List of activated apps:
Enabled:

  • afterlogic: 1.1.2
  • comments: 0.3.0
  • configreport: 0.1.1
  • contacts: 1.5.4
  • customgroups: 0.3.6
  • dav: 0.3.2
  • federatedfilesharing: 0.3.1
  • federation: 0.1.0
  • files: 1.5.1
  • files_external: 0.7.1
  • files_external_ftp: 0.2.0
  • files_pdfviewer: 0.11.0
  • files_sharing: 0.10.1
  • files_trashbin: 0.9.1
  • files_versions: 1.3.0
  • files_videoplayer: 0.9.8
  • firstrunwizard: 1.1
  • gallery: 16.1.0
  • gpxpod: 2.2.2
  • groupalert: 1.0.5
  • guests: 0.5.0
  • market: 0.2.4
  • notifications: 0.3.2
  • onlyoffice: 2.2.1
  • phonetrack: 0.2.8
  • provisioning_api: 0.5.0
  • systemtags: 0.3.0
  • templateeditor: 0.3
  • twofactor_backup_codes: 0.0.4
  • updatenotification: 0.2.1
    Disabled:
  • encryption
  • external
  • theme-example
  • user_external.
    Are you using external storage, if yes which one: yes local/smb/sftp/…
    Are you using encryption: no
    Are you using an external user-backend, if yes which one: no
    Client configuration
    Browser: Apache/2.4.18 (Ubuntu)
    Operating system: ubuntu
    Logs
    Web server error log
    [Fri Jul 24 14:47:37.282560 2020] [:error] [pid 17108] [client 183.83.241.2:35737] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 14:48:08.939750 2020] [:error] [pid 17344] [client 183.83.241.2:35756] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 14:48:09.290535 2020] [:error] [pid 17344] [client 183.83.241.2:35756] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 14:48:40.918366 2020] [:error] [pid 16179] [client 183.83.241.2:35763] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 14:48:41.249415 2020] [:error] [pid 16179] [client 183.83.241.2:35763] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 14:49:12.949405 2020] [:error] [pid 17335] [client 183.83.241.2:35776] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 14:49:13.324344 2020] [:error] [pid 17335] [client 183.83.241.2:35776] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 14:49:44.932445 2020] [:error] [pid 15691] [client 183.83.241.2:35800] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 14:49:45.303921 2020] [:error] [pid 15691] [client 183.83.241.2:35800] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 14:50:16.926054 2020] [:error] [pid 16143] [client 183.83.241.2:35810] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 14:50:17.271708 2020] [:error] [pid 16143] [client 183.83.241.2:35810] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 14:50:48.928660 2020] [:error] [pid 17108] [client 183.83.241.2:35842] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 14:50:49.281363 2020] [:error] [pid 17108] [client 183.83.241.2:35842] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 14:51:20.950767 2020] [:error] [pid 17335] [client 183.83.241.2:35862] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 14:51:21.326396 2020] [:error] [pid 17335] [client 183.83.241.2:35862] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 14:51:52.927111 2020] [:error] [pid 17854] [client 183.83.241.2:35888] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 14:51:53.285428 2020] [:error] [pid 17854] [client 183.83.241.2:35888] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 14:52:24.927819 2020] [:error] [pid 17108] [client 183.83.241.2:35894] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 14:52:25.287108 2020] [:error] [pid 17108] [client 183.83.241.2:35894] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 14:52:56.922190 2020] [:error] [pid 17854] [client 183.83.241.2:35933] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 14:52:57.278308 2020] [:error] [pid 17854] [client 183.83.241.2:35933] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 14:53:28.928510 2020] [:error] [pid 17724] [client 183.83.241.2:35941] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 14:53:29.303424 2020] [:error] [pid 17724] [client 183.83.241.2:35941] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 14:54:00.931843 2020] [:error] [pid 16179] [client 183.83.241.2:35949] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 14:54:01.295086 2020] [:error] [pid 16179] [client 183.83.241.2:35949] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 14:54:32.931887 2020] [:error] [pid 17969] [client 183.83.241.2:35964] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 14:54:33.294222 2020] [:error] [pid 17969] [client 183.83.241.2:35964] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 14:55:04.921887 2020] [:error] [pid 16179] [client 183.83.241.2:35968] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 14:55:05.281185 2020] [:error] [pid 16179] [client 183.83.241.2:35968] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 14:55:36.941676 2020] [:error] [pid 18493] [client 183.83.241.2:35982] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 14:55:37.327893 2020] [:error] [pid 18493] [client 183.83.241.2:35982] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 14:56:08.920513 2020] [:error] [pid 18170] [client 183.83.241.2:35986] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 14:56:09.255521 2020] [:error] [pid 18170] [client 183.83.241.2:35986] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 14:56:40.942503 2020] [:error] [pid 18505] [client 183.83.241.2:36001] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 14:56:41.299840 2020] [:error] [pid 18505] [client 183.83.241.2:36001] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 14:57:12.931189 2020] [:error] [pid 16179] [client 183.83.241.2:36008] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 14:57:13.300122 2020] [:error] [pid 16179] [client 183.83.241.2:36008] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 14:57:44.919812 2020] [:error] [pid 16179] [client 183.83.241.2:36016] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 14:57:45.271907 2020] [:error] [pid 16179] [client 183.83.241.2:36016] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 14:58:16.930376 2020] [:error] [pid 18496] [client 183.83.241.2:36027] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 14:58:17.297699 2020] [:error] [pid 18496] [client 183.83.241.2:36027] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 14:59:03.928843 2020] [:error] [pid 18632] [client 183.83.241.2:36031] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 14:59:04.290572 2020] [:error] [pid 18632] [client 183.83.241.2:36031] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 14:59:35.929706 2020] [:error] [pid 19046] [client 183.83.241.2:36075] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 14:59:36.300010 2020] [:error] [pid 19046] [client 183.83.241.2:36075] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 14:59:52.921117 2020] [:error] [pid 18795] [client 183.83.241.2:36093] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 14:59:53.277006 2020] [:error] [pid 18795] [client 183.83.241.2:36093] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 15:00:24.937787 2020] [:error] [pid 18496] [client 183.83.241.2:36248] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 15:00:25.768534 2020] [:error] [pid 18496] [client 183.83.241.2:36248] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 15:00:57.086126 2020] [:error] [pid 19282] [client 183.83.241.2:36324] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 15:00:57.626405 2020] [:error] [pid 19282] [client 183.83.241.2:36324] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 15:01:28.931259 2020] [:error] [pid 19372] [client 183.83.241.2:36351] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 15:01:29.291836 2020] [:error] [pid 19372] [client 183.83.241.2:36351] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 15:02:00.921365 2020] [:error] [pid 19438] [client 183.83.241.2:36400] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 15:02:01.278217 2020] [:error] [pid 19438] [client 183.83.241.2:36400] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 15:02:32.966551 2020] [:error] [pid 19414] [client 183.83.241.2:36417] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 15:02:33.424591 2020] [:error] [pid 19414] [client 183.83.241.2:36417] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 15:03:19.927987 2020] [:error] [pid 19355] [client 183.83.241.2:36473] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 15:03:20.287363 2020] [:error] [pid 19355] [client 183.83.241.2:36473] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 15:03:36.957934 2020] [:error] [pid 19572] [client 183.83.241.2:36513] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 15:03:37.320787 2020] [:error] [pid 19572] [client 183.83.241.2:36513] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 15:04:08.933582 2020] [:error] [pid 19732] [client 183.83.241.2:36547] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 15:04:09.302256 2020] [:error] [pid 19732] [client 183.83.241.2:36547] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 15:04:40.923457 2020] [:error] [pid 19795] [client 183.83.241.2:36586] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 15:04:41.288261 2020] [:error] [pid 19795] [client 183.83.241.2:36586] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 15:05:12.933111 2020] [:error] [pid 19523] [client 183.83.241.2:36604] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 15:05:13.303091 2020] [:error] [pid 19523] [client 183.83.241.2:36604] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 15:05:59.977950 2020] [:error] [pid 19947] [client 183.83.241.2:36711] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 15:06:00.341410 2020] [:error] [pid 19947] [client 183.83.241.2:36711] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 15:06:31.957168 2020] [:error] [pid 19738] [client 183.83.241.2:34824] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 15:06:32.304163 2020] [:error] [pid 19738] [client 183.83.241.2:34824] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 15:06:48.939939 2020] [:error] [pid 19434] [client 183.83.241.2:34855] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 15:06:49.315171 2020] [:error] [pid 19434] [client 183.83.241.2:34855] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 15:07:20.928497 2020] [:error] [pid 19523] [client 183.83.241.2:34892] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 15:07:21.297825 2020] [:error] [pid 19523] [client 183.83.241.2:34892] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 15:07:52.925893 2020] [:error] [pid 20143] [client 183.83.241.2:34923] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 15:07:53.283969 2020] [:error] [pid 20143] [client 183.83.241.2:34923] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 15:08:24.938196 2020] [:error] [pid 19840] [client 183.83.241.2:34958] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 15:08:25.310752 2020] [:error] [pid 19840] [client 183.83.241.2:34958] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 15:08:56.940730 2020] [:error] [pid 20091] [client 183.83.241.2:34966] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 15:08:57.317722 2020] [:error] [pid 20091] [client 183.83.241.2:34966] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 15:09:28.922363 2020] [:error] [pid 20307] [client 183.83.241.2:34995] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 15:09:29.276087 2020] [:error] [pid 20307] [client 183.83.241.2:34995] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 15:10:00.924498 2020] [:error] [pid 20307] [client 183.83.241.2:35020] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 15:10:01.287320 2020] [:error] [pid 20307] [client 183.83.241.2:35020] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 15:10:32.928224 2020] [:error] [pid 19523] [client 183.83.241.2:35040] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 15:10:33.283540 2020] [:error] [pid 19523] [client 183.83.241.2:35040] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 15:11:04.931648 2020] [:error] [pid 19523] [client 183.83.241.2:35075] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 15:11:05.305474 2020] [:error] [pid 19523] [client 183.83.241.2:35075] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 15:11:36.923347 2020] [:error] [pid 19737] [client 183.83.241.2:35140] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 15:11:37.283044 2020] [:error] [pid 19737] [client 183.83.241.2:35140] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 15:12:08.923448 2020] [:error] [pid 19737] [client 183.83.241.2:35169] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 15:12:09.265107 2020] [:error] [pid 19737] [client 183.83.241.2:35169] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 15:12:40.924868 2020] [:error] [pid 20091] [client 183.83.241.2:35226] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 15:12:41.272374 2020] [:error] [pid 20091] [client 183.83.241.2:35226] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 15:13:12.925158 2020] [:error] [pid 20091] [client 183.83.241.2:35243] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 15:13:13.288144 2020] [:error] [pid 20091] [client 183.83.241.2:35243] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 15:13:59.935587 2020] [:error] [pid 19952] [client 183.83.241.2:35254] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 15:14:00.305454 2020] [:error] [pid 19952] [client 183.83.241.2:35254] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 15:15:03.929260 2020] [:error] [pid 19523] [client 183.83.241.2:35359] script ‘/var/www/html/status.php’ not found or unable to stat
    [Fri Jul 24 15:15:04.292187 2020] [:error] [pid 19523] [client 183.83.241.2:35359] script ‘/var/www/html/remote.php’ not found or unable to stat
    [Fri Jul 24 15:15:41.935317 2020] [:error] [pid 19737] [client 183.83.241.2:35405] script ‘/var/www/html/status.php’ not found or unable to stat

I have upgraded the owncloud version 10.0.7 to 10.4.1 by these steps.
Step 1 : I have installed the owncloud setup by this article
AvoidErrors – 21 Jun 18

Install OwnCloud on Ubuntu 18.04 LTS with Apache2, MariaDB and PHP 7.1 -…
I recently installed Ubuntu 18.04 LTS on a mini PC, I decided why don’t we install OwnCloud and use this mini PC as a free cloud storage server. Here are the steps I took that shows how I got OwnCloud installed on Ubuntu. OwnCloud is free robust open…

In this article they didn’t Mention to install the php7.2-sqlite3 after i have installed php7.2-sqlite3 i started to run my owncloud 10.4.1 in an web browser.
Step 2: For migrating the db i stopped the apache service and put my owncloud in an maintenance mode and started replacing the db file.In owncloud 10.0.7 i have copied the sqlite3 source db file and replaced with my current owncloud 10.4.1 sqlite3 db file which exists in /var/www/html/owncloud/data/owncloud.db
Step3 : After i have replaced the owncloud db file i started to upgrade the occ to execute the db file by referring to this article
https://doc.owncloud.org/server/10.4/admin_manual/configuration/server/occ_command.html#apps-commands
Step4: After the upgrade my db file got reflected in my current owncloud 10.4.1 which still has sqlite3 db type and i have synced my data from my previous owncloud 10.0.7
Step 5: I want to convert my database from sqlite3 to mariadb i just referrred this article to convert my db type https://doc.owncloud.com/server/10.2/admin_manual/configuration/database/db_conversion.html

A post was merged into an existing topic: Upgrading owncloud from 10.0.7 to 10.4.1