I can not change database type


#1

Steps to reproduce

  1. I configured the server with the sqlite3 database
  2. I created the new database within MYSQL and the new user of it, granting the corresponding privileges
  3. I used the command “php occ db: convert-type --all-apps mysql oc_mysql_user 127.0.0.1 new_db_name”
  4. An error occurs when creating one of the tables within the MYSQL database: “oc_jobs”

Expected behaviour

I would expect the type of database to change.

Actual behaviour

Continue with the conversion (y/n)? [n] y
oc_appconfig
 63/63 [============================] 100%oc_authtoken
 3/3 [============================] 100%oc_comments
 2/2 [============================] 100%oc_comments_read_markers
 2/2 [============================] 100%oc_credentials
    0 [>---------------------------]oc_file_locks
 35/35 [============================] 100%oc_filecache
 88/88 [============================] 100%oc_group_admin
    0 [>---------------------------]oc_group_user
 3/3 [============================] 100%oc_groups
 2/2 [============================] 100%oc_jobs
  1/12 [==>-------------------------]   8%
In AbstractMySQLDriver.php line 71:
                                                                               
  An exception occurred while executing 'INSERT INTO `oc_jobs` (`id`, `class`  
  , `argument`, `last_run`, `last_checked`, `reserved_at`, `execution_duratio  
  n`) VALUES(?, ?, ?, ?, ?, ?, ?)' with params ["1", "OCA\\Files\\BackgroundJ  
  ob\\ScanFiles", "null", "1528272296", "1528272296", "0", "0"]:               
                                                                               
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'execution_duration'  
   in 'field list'                                                             
                                                                               

In PDOStatement.php line 107:
                                                                               
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'execution_duration'  
   in 'field list'                                                             
                                                                               

In PDOStatement.php line 105:
                                                                               
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'execution_duration'  
   in 'field list'                                                             
                                                                               

db:convert-type [--port PORT] [--password PASSWORD] [--clear-schema] [--all-apps] [--chunk-size CHUNK-SIZE] [--] <type> <username> <hostname> <database>

Server configuration

Operating system: Debian GNU/Linux 9

Web server: Apache2

Database: MYSQL

PHP version: 0.7

ownCloud version: 10.0.8
Updated from an older ownCloud or fresh install: NO

Where did you install ownCloud from: The server terminal debian

Signing status (ownCloud 9.0 and above):

Login as admin user into your ownCloud and access 
http://example.com/index.php/settings/integrity/failed 
paste the results into https://gist.github.com/ and puth the link here.

The content of config/config.php:

<?php
$CONFIG = array (
  'updatechecker' => false,
  'instanceid' => 'ocfwli57dlel',
  'passwordsalt' => 'Co1ltB/VbkQLXr5UU0WOhY5j+yk4Hd',
  'secret' => 'NTJAH0TwMOUaAu9cDJiFdMAeMqDHHQZq40MSBZaZH80PUbMP',
  'trusted_domains' => 
  array (
    0 => '192.168.55.215',
  ),
  'datadirectory' => '/var/www/owncloud/data',
  'overwrite.cli.url' => 'http://192.168.55.215/owncloud',
  'dbtype' => 'sqlite3',
  'version' => '10.0.8.5',
  'dbname' => 'owncloud',
  'dbhost' => '192.168.55.215:80',
  'dbtableprefix' => 'oc_',
  'logtimezone' => 'UTC',
  'installed' => true,
  'maintenance' => false,

List of activated apps:

Enabled:
  - comments: 0.3.0
  - configreport: 0.1.1
  - dav: 0.3.2
  - federatedfilesharing: 0.3.1
  - federation: 0.1.0
  - files: 1.5.1
  - files_external: 0.7.1
  - files_sharing: 0.10.1
  - files_trashbin: 0.9.1
  - files_versions: 1.3.0
  - files_videoplayer: 0.9.8
  - firstrunwizard: 1.1
  - market: 0.2.4
  - notifications: 0.3.3
  - provisioning_api: 0.5.0
  - systemtags: 0.3.0
  - updatenotification: 0.2.1
Disabled:
  - encryption
  - external
  - theme-example
  - user_external

Are you using external storage, if yes which one: NO

Are you using encryption: NO

Are you using an external user-backend, if yes which one: NO

LDAP configuration (delete this part if not used)

With access to your command line run e.g.:
sudo -u www-data php occ ldap:show-config
from within your ownCloud installation folder

Without access to your command line download the data/owncloud.db to your local
computer or access your SQL server remotely and run the select query:
SELECT * FROM `oc_appconfig` WHERE `appid` = 'user_ldap';


Eventually replace sensitive data as the name/IP-address of your LDAP server or groups.

Client configuration

Browser:

Operating system:

Logs

Web server error log

[Tue Jun 05 13:35:09.502438 2018] [mpm_event:notice] [pid 18181:tid 139715021989056] AH00489: Apache/2.4.25 (Debian) configured -- resuming normal operations
[Tue Jun 05 13:35:09.502510 2018] [core:notice] [pid 18181:tid 139715021989056] AH00094: Command line: '/usr/sbin/apache2'
[Tue Jun 05 13:35:26.683683 2018] [mpm_event:notice] [pid 18181:tid 139715021989056] AH00491: caught SIGTERM, shutting down
[Tue Jun 05 13:35:26.726679 2018] [mpm_prefork:notice] [pid 21742] AH00163: Apache/2.4.25 (Debian) configured -- resuming normal operations
[Tue Jun 05 13:35:26.726741 2018] [core:notice] [pid 21742] AH00094: Command line: '/usr/sbin/apache2'
[Tue Jun 05 13:35:26.957441 2018] [mpm_prefork:notice] [pid 21742] AH00169: caught SIGTERM, shutting down
[Tue Jun 05 13:35:27.251098 2018] [mpm_prefork:notice] [pid 21797] AH00163: Apache/2.4.25 (Debian) configured -- resuming normal operations
[Tue Jun 05 13:35:27.251145 2018] [core:notice] [pid 21797] AH00094: Command line: '/usr/sbin/apache2'
[Tue Jun 05 15:06:36.570603 2018] [mpm_prefork:notice] [pid 21797] AH00169: caught SIGTERM, shutting down
[Tue Jun 05 15:06:36.751176 2018] [mpm_prefork:notice] [pid 24854] AH00163: Apache/2.4.25 (Debian) configured -- resuming normal operations
[Tue Jun 05 15:06:36.751227 2018] [core:notice] [pid 24854] AH00094: Command line: '/usr/sbin/apache2'
[Tue Jun 05 15:06:52.142521 2018] [mpm_prefork:notice] [pid 24854] AH00169: caught SIGTERM, shutting down
[Tue Jun 05 15:06:52.261278 2018] [mpm_prefork:notice] [pid 24904] AH00163: Apache/2.4.25 (Debian) configured -- resuming normal operations
[Tue Jun 05 15:06:52.261337 2018] [core:notice] [pid 24904] AH00094: Command line: '/usr/sbin/apache2'
[Tue Jun 05 15:07:15.075227 2018] [mpm_prefork:notice] [pid 24904] AH00169: caught SIGTERM, shutting down
[Tue Jun 05 15:07:15.213424 2018] [mpm_prefork:notice] [pid 24961] AH00163: Apache/2.4.25 (Debian) configured -- resuming normal operations
[Tue Jun 05 15:07:15.213502 2018] [core:notice] [pid 24961] AH00094: Command line: '/usr/sbin/apache2'
[Tue Jun 05 15:09:16.051162 2018] [mpm_prefork:notice] [pid 24961] AH00169: caught SIGTERM, shutting down
[Tue Jun 05 15:09:16.178998 2018] [mpm_prefork:notice] [pid 25050] AH00163: Apache/2.4.25 (Debian) configured -- resuming normal operations
[Tue Jun 05 15:09:16.179055 2018] [core:notice] [pid 25050] AH00094: Command line: '/usr/sbin/apache2'
[Tue Jun 05 15:41:14.484810 2018] [:error] [pid 25140] [client 192.168.50.141:32816] creating sqlite db
[Tue Jun 05 16:06:54.681980 2018] [autoindex:error] [pid 27113] [client 192.168.50.180:48244] AH01276: Cannot serve directory /var/www/owncloud/core/doc/user/_static/: No matching DirectoryIndex (index.php,index.html) found, and server-generated directory index forbidden by Options directive, referer: http://192.168.55.215/owncloud/core/doc/user/index.html
[Tue Jun 05 16:13:54.672716 2018] [core:crit] [pid 27130] (13)Permission denied: [client 192.168.50.180:48360] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:13:55.815881 2018] [core:crit] [pid 27130] (13)Permission denied: [client 192.168.50.180:48360] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:14:01.673211 2018] [core:crit] [pid 27113] (13)Permission denied: [client 192.168.50.141:33670] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:14:05.892830 2018] [core:crit] [pid 27341] (13)Permission denied: [client 192.168.50.180:48362] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:14:07.740192 2018] [core:crit] [pid 27341] (13)Permission denied: [client 192.168.50.180:48362] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:14:09.483340 2018] [core:crit] [pid 27341] (13)Permission denied: [client 192.168.50.180:48362] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:14:25.817469 2018] [core:crit] [pid 27271] (13)Permission denied: [client 192.168.50.180:48392] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:14:31.673822 2018] [core:crit] [pid 27276] (13)Permission denied: [client 192.168.50.141:33672] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:14:55.867664 2018] [core:crit] [pid 27103] (13)Permission denied: [client 192.168.50.180:48394] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:15:01.672603 2018] [core:crit] [pid 27261] (13)Permission denied: [client 192.168.50.141:33676] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:15:25.817412 2018] [core:crit] [pid 25139] (13)Permission denied: [client 192.168.50.180:48396] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:15:25.868323 2018] [core:crit] [pid 25139] (13)Permission denied: [client 192.168.50.180:48396] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:15:31.675218 2018] [core:crit] [pid 27409] (13)Permission denied: [client 192.168.50.141:33678] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:15:35.185700 2018] [core:crit] [pid 27314] (13)Permission denied: [client 192.168.50.180:48406] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:15:36.325726 2018] [core:crit] [pid 27314] (13)Permission denied: [client 192.168.50.180:48406] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:15:40.669342 2018] [core:crit] [pid 27314] (13)Permission denied: [client 192.168.50.180:48406] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:16:01.672285 2018] [core:crit] [pid 27130] (13)Permission denied: [client 192.168.50.141:33682] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:16:01.836363 2018] [core:crit] [pid 27261] (13)Permission denied: [client 192.168.50.180:48410] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:16:31.672971 2018] [core:crit] [pid 25139] (13)Permission denied: [client 192.168.50.141:33684] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:17:01.673240 2018] [core:crit] [pid 27113] (13)Permission denied: [client 192.168.50.141:33688] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:17:31.673499 2018] [core:crit] [pid 27341] (13)Permission denied: [client 192.168.50.141:33690] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:18:01.672349 2018] [core:crit] [pid 27271] (13)Permission denied: [client 192.168.50.141:33694] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:18:31.676246 2018] [core:crit] [pid 27276] (13)Permission denied: [client 192.168.50.141:33696] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:19:01.676419 2018] [core:crit] [pid 27103] (13)Permission denied: [client 192.168.50.141:33702] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:19:31.673972 2018] [core:crit] [pid 27130] (13)Permission denied: [client 192.168.50.141:33704] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:19:37.559636 2018] [core:crit] [pid 27261] (13)Permission denied: [client 192.168.50.180:48442] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:20:01.672731 2018] [core:crit] [pid 25139] (13)Permission denied: [client 192.168.50.141:33708] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:20:05.687519 2018] [core:crit] [pid 27113] (13)Permission denied: [client 192.168.50.180:48446] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:20:31.673913 2018] [core:crit] [pid 27341] (13)Permission denied: [client 192.168.50.141:33712] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:21:01.672395 2018] [core:crit] [pid 27276] (13)Permission denied: [client 192.168.50.141:33716] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:21:31.673434 2018] [core:crit] [pid 27103] (13)Permission denied: [client 192.168.50.141:33718] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:21:37.138121 2018] [core:crit] [pid 27130] (13)Permission denied: [client 192.168.50.141:33720] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:21:38.252510 2018] [core:crit] [pid 27130] (13)Permission denied: [client 192.168.50.141:33720] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:21:38.468181 2018] [core:crit] [pid 27130] (13)Permission denied: [client 192.168.50.141:33720] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:21:38.720032 2018] [core:crit] [pid 27130] (13)Permission denied: [client 192.168.50.141:33720] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:21:38.971430 2018] [core:crit] [pid 27130] (13)Permission denied: [client 192.168.50.141:33720] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:21:39.276670 2018] [core:crit] [pid 27130] (13)Permission denied: [client 192.168.50.141:33720] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:21:39.479103 2018] [core:crit] [pid 27130] (13)Permission denied: [client 192.168.50.141:33720] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:21:39.735170 2018] [core:crit] [pid 27130] (13)Permission denied: [client 192.168.50.141:33720] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:21:39.964259 2018] [core:crit] [pid 27130] (13)Permission denied: [client 192.168.50.141:33720] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:21:40.222316 2018] [core:crit] [pid 27130] (13)Permission denied: [client 192.168.50.141:33720] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:21:40.459172 2018] [core:crit] [pid 27130] (13)Permission denied: [client 192.168.50.141:33720] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:21:40.702062 2018] [core:crit] [pid 27130] (13)Permission denied: [client 192.168.50.141:33720] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:21:40.923255 2018] [core:crit] [pid 27130] (13)Permission denied: [client 192.168.50.141:33720] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:21:41.177295 2018] [core:crit] [pid 27130] (13)Permission denied: [client 192.168.50.141:33720] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:21:41.451411 2018] [core:crit] [pid 27130] (13)Permission denied: [client 192.168.50.141:33720] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:21:41.694322 2018] [core:crit] [pid 27130] (13)Permission denied: [client 192.168.50.141:33720] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:21:41.940790 2018] [core:crit] [pid 27130] (13)Permission denied: [client 192.168.50.141:33720] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:21:42.171996 2018] [core:crit] [pid 27130] (13)Permission denied: [client 192.168.50.141:33720] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:21:42.363635 2018] [core:crit] [pid 27130] (13)Permission denied: [client 192.168.50.141:33720] AH00529: /var/www/owncloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/owncloud/' is executable
[Tue Jun 05 16:22:19.972907 2018] [:error] [pid 27276] [client 192.168.50.141:33736] script '/var/www/owncloud/index.php' not found or unable to stat
[Tue Jun 05 16:22:23.339966 2018] [:error] [pid 27276] [client 192.168.50.141:33736] script '/var/www/owncloud/index.php' not found or unable to stat
[Tue Jun 05 16:22:23.607112 2018] [:error] [pid 27276] [client 192.168.50.141:33736] script '/var/www/owncloud/index.php' not found or unable to stat
[Tue Jun 05 16:22:23.839458 2018] [:error] [pid 27276] [client 192.168.50.141:33736] script '/var/www/owncloud/index.php' not found or unable to stat
[Tue Jun 05 16:22:24.027964 2018] [:error] [pid 27276] [client 192.168.50.141:33736] script '/var/www/owncloud/index.php' not found or unable to stat
[Tue Jun 05 16:22:24.219255 2018] [:error] [pid 27276] [client 192.168.50.141:33736] script '/var/www/owncloud/index.php' not found or unable to stat
[Tue Jun 05 16:22:24.381573 2018] [:error] [pid 27276] [client 192.168.50.141:33736] script '/var/www/owncloud/index.php' not found or unable to stat
[Tue Jun 05 16:22:24.537307 2018] [:error] [pid 27276] [client 192.168.50.141:33736] script '/var/www/owncloud/index.php' not found or unable to stat
[Tue Jun 05 16:22:24.713405 2018] [:error] [pid 27276] [client 192.168.50.141:33736] script '/var/www/owncloud/index.php' not found or unable to stat
[Tue Jun 05 16:22:24.882813 2018] [:error] [pid 27276] [client 192.168.50.141:33736] script '/var/www/owncloud/index.php' not found or unable to stat
[Tue Jun 05 16:22:25.066931 2018] [:error] [pid 27276] [client 192.168.50.141:33736] script '/var/www/owncloud/index.php' not found or unable to stat
[Tue Jun 05 16:22:25.228103 2018] [:error] [pid 27276] [client 192.168.50.141:33736] script '/var/www/owncloud/index.php' not found or unable to stat
[Tue Jun 05 16:22:25.395470 2018] [:error] [pid 27276] [client 192.168.50.141:33736] script '/var/www/owncloud/index.php' not found or unable to stat
[Tue Jun 05 16:43:42.072067 2018] [autoindex:error] [pid 27760] [client 192.168.50.141:33954] AH01276: Cannot serve directory /var/www/owncloud/core/doc/user/_static/: No matching DirectoryIndex (index.php,index.html) found, and server-generated directory index forbidden by Options directive, referer: http://192.168.55.215/owncloud/core/doc/user/index.html
[Wed Jun 06 10:35:07.867228 2018] [:error] [pid 27996] [client 192.168.50.180:38356] PHP Parse error:  syntax error, unexpected ''dbhost'' (T_CONSTANT_ENCAPSED_STRING), expecting ')' in /var/www/owncloud/config/config.php on line 18
[Wed Jun 06 10:35:37.865355 2018] [:error] [pid 28143] [client 192.168.50.180:38358] PHP Parse error:  syntax error, unexpected ''dbhost'' (T_CONSTANT_ENCAPSED_STRING), expecting ')' in /var/www/owncloud/config/config.php on line 18
[Wed Jun 06 10:36:07.866845 2018] [:error] [pid 28308] [client 192.168.50.180:38360] PHP Parse error:  syntax error, unexpected ''dbhost'' (T_CONSTANT_ENCAPSED_STRING), expecting ')' in /var/www/owncloud/config/config.php on line 18
[Wed Jun 06 10:36:37.864105 2018] [:error] [pid 28484] [client 192.168.50.180:38362] PHP Parse error:  syntax error, unexpected ''dbhost'' (T_CONSTANT_ENCAPSED_STRING), expecting ')' in /var/www/owncloud/config/config.php on line 18
[Wed Jun 06 10:37:07.865682 2018] [:error] [pid 28318] [client 192.168.50.180:38364] PHP Parse error:  syntax error, unexpected ''dbhost'' (T_CONSTANT_ENCAPSED_STRING), expecting ')' in /var/www/owncloud/config/config.php on line 18
[Wed Jun 06 10:37:37.865538 2018] [:error] [pid 28160] [client 192.168.50.180:38366] PHP Parse error:  syntax error, unexpected ''dbhost'' (T_CONSTANT_ENCAPSED_STRING), expecting ')' in /var/www/owncloud/config/config.php on line 18
[Wed Jun 06 11:10:12.881053 2018] [autoindex:error] [pid 28607] [client 192.168.50.141:56124] AH01276: Cannot serve directory /var/www/owncloud/core/doc/user/_static/: No matching DirectoryIndex (index.php,index.html) found, and server-generated directory index forbidden by Options directive, referer: http://192.168.55.215/owncloud/core/doc/user/index.html
[Wed Jun 06 11:12:25.163309 2018] [autoindex:error] [pid 2193] [client 192.168.50.141:56170] AH01276: Cannot serve directory /var/www/owncloud/core/doc/user/_static/: No matching DirectoryIndex (index.php,index.html) found, and server-generated directory index forbidden by Options directive, referer: http://192.168.55.215/owncloud/core/doc/user/index.html

ownCloud log (data/owncloud.log)

{"reqId":"zD1DKi6wYYPYhw1qmcpO","level":3,"time":"2018-06-05T13:24:02+00:00","remoteAddr":"192.168.50.141","user":"--","app":"PHP","method":"POST","url":"\/owncloud\/index.php","message":"PDO::__construct(): Error while reading greeting packet. PID=25139 at \/var\/www\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOConnection.php#43"}
{"reqId":"dH919OQaX3bBdFQnw5yu","level":3,"time":"2018-06-05T13:33:25+00:00","remoteAddr":"192.168.50.141","user":"--","app":"PHP","method":"POST","url":"\/owncloud\/index.php","message":"PDO::__construct(): Error while reading greeting packet. PID=25135 at \/var\/www\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOConnection.php#43"}
{"reqId":"3BfIrXwewj1OsagcMlSx","level":3,"time":"2018-06-05T13:41:13+00:00","remoteAddr":"192.168.50.141","user":"--","app":"PHP","method":"POST","url":"\/owncloud\/index.php","message":"PDO::__construct(): Error while reading greeting packet. PID=25221 at \/var\/www\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOConnection.php#43"}
{"reqId":"D58pEKJbxmnlm6F8oZKM","level":3,"time":"2018-06-05T13:41:15+00:00","remoteAddr":"192.168.50.141","user":"--","app":"no app in context","method":"POST","url":"\/owncloud\/index.php","message":"User backend OC\\User\\Database is returning home: \/var\/www\/owncloud\/data\/sistemas for user: sistemas which differs from existing value: "}
{"reqId":"53D3dwAo5k7o8uB82vvu","level":3,"time":"2018-06-05T13:59:52+00:00","remoteAddr":"192.168.50.180","user":"sistemas","app":"no app in context","method":"POST","url":"\/owncloud\/index.php\/settings\/users\/users","message":"User backend OC\\User\\Database is returning home: \/var\/www\/owncloud\/data\/maider for user: maider which differs from existing value: "}
{"reqId":"b7kfGlv84RgXm7a7s3he","level":3,"time":"2018-06-05T14:00:47+00:00","remoteAddr":"192.168.50.180","user":"sistemas","app":"no app in context","method":"POST","url":"\/owncloud\/index.php\/settings\/users\/users","message":"User backend OC\\User\\Database is returning home: \/var\/www\/owncloud\/data\/maider for user: maider which differs from existing value: "}
{"reqId":"lJ7gRnL8DOGiKUcurHmj","level":3,"time":"2018-06-05T14:35:27+00:00","remoteAddr":"192.168.50.180","user":"sistemas","app":"no app in context","method":"POST","url":"\/owncloud\/index.php\/settings\/users\/users","message":"User backend OC\\User\\Database is returning home: \/var\/www\/owncloud\/data\/daniel for user: daniel which differs from existing value: "}
{"reqId":"3YYix2dgHl6ZXN0rNUIt","level":2,"time":"2018-06-05T14:41:05+00:00","remoteAddr":"192.168.50.180","user":"--","app":"core","method":"POST","url":"\/owncloud\/index.php\/login","message":"Login failed: 'maider.cao' (Remote IP: '192.168.50.180')"}
{"reqId":"GID703CZMNgjSq3ZiTgo","level":2,"time":"2018-06-05T14:41:15+00:00","remoteAddr":"192.168.50.180","user":"--","app":"core","method":"POST","url":"\/owncloud\/index.php\/login?user=maider.cao","message":"Login failed: 'sistemas' (Remote IP: '192.168.50.180')"}
{"reqId":"Ehi7Xlr4LWIuDIYjZhzB","level":2,"time":"2018-06-05T14:46:11+00:00","remoteAddr":"192.168.50.180","user":"sistemas","app":"dav","method":"DELETE","url":"\/owncloud\/remote.php\/webdav\/Sin%20t%C3%ADtulo%201.odt","message":"Could not get node for path: \"Sin t\u00edtulo 1.odt\" : File with name Sin t\u00edtulo 1.odt could not be located"}
{"reqId":"EYt3XJkLAl1V7RWg9oPg","level":2,"time":"2018-06-05T14:48:18+00:00","remoteAddr":"192.168.50.141","user":"--","app":"core","method":"POST","url":"\/owncloud\/index.php\/login","message":"Login failed: 'daniel' (Remote IP: '192.168.50.141')"}

Browser log

Insert your browser log here, this could for example include:

a) The javascript console log
b) The network log 
c) ...

#2

Problem solved:

https://www.2daygeek.com/how-to-migrate-owncloud-from-sqlite-to-mysql-database/#other


#3

Nice work! :slight_smile:


#4

This is not really a solution. No actual data is migrated from sqlite to mysql.

No users, no shares, no calendars, no addressbooks … nothing


#5

Yeah, after reading the linked guide - I am not sure how this solved the problem.

The author just set the “installed” parameter in config.php to false and created a new database in mysql.

It’s true that you don’t get the same error, as with the occ migration command, but as @DeepDiver1975 mentioned, you don’t migrate your date to the new database, you just create a new one.


#6

Well, I’m just installing and I do not have much data, that’s why it helped me


#7

After a lot of contemplation on the various ins and outs of converting the database I am fast coming to the Realisation that converting from SQLite to MYSQL is not a viable option.

Just out of interest, why do we use the SQLite 3 option at all?

Currently with my set up growing, I’m seriously contemplating putting a stop on any further development on the current OwnCloud installation, and making a completely new one, but using a full MYSQL database instead. Then, once everything is up and running as it should be, I can migrate the data over to the new installation.


#8

Just tried to do the same conversion and ran into the same error. Really don’t want to lose all data by creating a new database.

Any ideas?

Jason