Db:convert-type sqlite to MySQL driver error

sqlite
php
mysql

#1


Hi,
I want to convert my database to speed it up, but always get this error.
I know that its propably the fault of the missing php modules for mysql, but I checked in php -m that mysqlnd is installed and enabled, mysql and mysqli are too

Steps to reproduce

  1. setup new database and user for it
  2. php occ db:convert-type --all-apps mysql oc 127.0.0.1 oc_

Expected behaviour

convert the database

Actual behaviour

An unhandled exception has been thrown:
exception 'Doctrine\DBAL\DBALException' with message 'Failed to connect to the database: An exception occured in driver: could not find driver' in /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/private/DB/Connection.php:63
Stack trace:

0 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(992): OC\ DB\Connection->connect()

1 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/private/DB/Connection.php(211): Doctrine\DBAL\Connection->execute Update('PRAGMA read_unc...', Array, Array)

2 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(623): OC\ DB\Connection->executeUpdate('PRAGMA read_unc...')

3 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/private/DB/Connection.php(146): Doctrine\DBAL\Connection->setTran sactionIsolation(2)

4 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php(172): OC\DB\Connection->__construct(Array, Object(Doctrine\DBAL\Driver\PDOSqlite\Driver), Object(Doctrine\DBAL\Configuration), Object(Doc trine\Common\EventManager))

5 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/private/DB/ConnectionFactory.php(141): Doctrine\DBAL\DriverManage r::getConnection(Array, Object(Doctrine\DBAL\Configuration), Object(Doctrine\Common\EventManager))

6 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/private/Server.php(472): OC\DB\ConnectionFactory->getConnection(' sqlite3', Array)

7 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/composer/pimple/pimple/src/Pimple/Container.php(113): OC\Server-> OC{closure}(Object(OC\Server))

8 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(111): Pimple\Con tainer->offsetGet('DatabaseConnect...')

9 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/private/ServerContainer.php(87): OC\AppFramework\Utility\SimpleCo ntainer->query('DatabaseConnect...')

10 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/private/Server.php(1121): OC\ServerContainer->query('DatabaseCon nect...')

11 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/private/Server.php(233): OC\Server->getDatabaseConnection()

12 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/composer/pimple/pimple/src/Pimple/Container.php(113): OC\Server- >OC{closure}(Object(OC\Server))

13 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(111): Pimple\Co ntainer->offsetGet('AccountMapper')

14 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/private/ServerContainer.php(87): OC\AppFramework\Utility\SimpleC ontainer->query('AccountMapper')

15 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/private/Server.php(973): OC\ServerContainer->query('AccountMappe r')

16 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/private/Server.php(238): OC\Server->getAccountMapper()

17 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/composer/pimple/pimple/src/Pimple/Container.php(113): OC\Server- >OC{closure}(Object(OC\Server))

18 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(111): Pimple\Co ntainer->offsetGet('UserManager')

19 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/private/ServerContainer.php(87): OC\AppFramework\Utility\SimpleC ontainer->query('UserManager')

20 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/private/Server.php(966): OC\ServerContainer->query('UserManager' )

21 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/private/Server.php(278): OC\Server->getUserManager()

22 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/composer/pimple/pimple/src/Pimple/Container.php(113): OC\Server- >OC{closure}(Object(OC\Server))

23 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(111): Pimple\Co ntainer->offsetGet('UserSession')

24 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/private/ServerContainer.php(87): OC\AppFramework\Utility\SimpleC ontainer->query('UserSession')

25 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/private/Server.php(990): OC\ServerContainer->query('UserSession' )

26 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/private/Server.php(518): OC\Server->getUserSession()

27 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/composer/pimple/pimple/src/Pimple/Container.php(113): OC\Server- >OC{closure}(Object(OC\Server))

28 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/private/AppFramework/Utility/SimpleContainer.php(111): Pimple\Co ntainer->offsetGet('AppManager')

29 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/private/ServerContainer.php(87): OC\AppFramework\Utility\SimpleC ontainer->query('AppManager')

30 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/private/Server.php(1311): OC\ServerContainer->query('AppManager' )

31 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/private/legacy/app.php(313): OC\Server->getAppManager()

32 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/private/legacy/app.php(107): OC_App::getEnabledApps()

33 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/base.php(579): OC_App::loadApps(Array)

34 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/base.php(1013): OC::init()

35 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/console.php(64): require_once('/var/www/vhosts...')

36 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/occ(11): require_once('/var/www/vhosts...')

37 {main}PHP Fatal error: Uncaught exception 'Doctrine\DBAL\DBALException' with message 'Failed to connect to the database: An ex ception occured in driver: could not find driver' in /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/private/DB/Conn ection.php:63

Stack trace:

0 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(992): OC\ DB\Connection->connect()

1 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/private/DB/Connection.php(211): Doctrine\DBAL\Connection->execute Update('PRAGMA read_unc...', Array, Array)

2 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(623): OC\ DB\Connection->executeUpdate('PRAGMA read_unc...')

3 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/private/DB/Connection.php(146): Doctrine\DBAL\Connection->setTran sactionIsolation(2)

4 /var/www/vhosts/kiwitrip.noip.me/maxjung.ddns.net/owncloud/lib/composer/doctrine/dbal/lib/Doctrin in /var/www/vhosts/kiwitrip.no ip.me/maxjung.ddns.net/owncloud/lib/private/DB/Connection.php on line 63

Server configuration

Operating system: Ubuntu 14.04 LTS

Web server: Strato VServerr

Database:

PHP version: 5.6

ownCloud version: ownCloud 10.0.3 (stable)

Updated from an older ownCloud or fresh install: updated

Where did you install ownCloud from: official website download

Signing status (ownCloud 9.0 and above):
Technical information
=====================
The following list covers which files have failed the integrity check. Please read
the previous linked documentation to learn more about the errors and how to fix
them.

Results

  • flowupload
    • EXCEPTION
      • OC\IntegrityCheck\Exceptions\InvalidSignatureException
      • Signature data not found.
  • files_mv
    • EXCEPTION
      • OC\IntegrityCheck\Exceptions\InvalidSignatureException
      • Signature data not found.
  • documents
    • EXCEPTION
      • OC\IntegrityCheck\Exceptions\InvalidSignatureException
      • Signature data not found.

Raw output

Array
(
[flowupload] => Array
(
[EXCEPTION] => Array
(
[class] => OC\IntegrityCheck\Exceptions\InvalidSignatureException
[message] => Signature data not found.
)

    )

[files_mv] => Array
    (
        [EXCEPTION] => Array
            (
                [class] => OC\IntegrityCheck\Exceptions\InvalidSignatureException
                [message] => Signature data not found.
            )

    )

[documents] => Array
    (
        [EXCEPTION] => Array
            (
                [class] => OC\IntegrityCheck\Exceptions\InvalidSignatureException
                [message] => Signature data not found.
            )

    )

)

When I uninstall these extensions they just reappear again

The content of config/config.php:
couldnt find it in the new weg gui and the terminal throws same error as I am describing here, so here the sanitised config.php:

<?php
$CONFIG = array (
'instanceid' => '',
'passwordsalt' => '',
'secret' => '',
'trusted_domains' =>
array (
0 => 'XXX.ddns.net',
),
'datadirectory' => '/var/www/XXX.ddns.net/owncloud/data',
'overwrite.cli.url' => 'http://XXX.ddns.net/owncloud',
'dbtype' => 'sqlite3',
'version' => '10.0.3.3',
'logtimezone' => 'UTC',
'installed' => true,
'mail_from_address' => 'owncloud',
'mail_smtpmode' => 'php',
'mail_domain' => 'XXX.ddns.net',
'maintenance' => false,
'updater.secret' => '',
'loglevel' => 2,
'integrity.check.disabled' => false,
'memcache.local' => '\OC\Memcache\Redis',
'redis' => [
'host' => 'localhost',
'port' => 6379,
],
'memcache.locking' => '\OC\Memcache\Redis', // Add this for best performance
'filelocking.enabled' => true,
);

List of activated apps:
admin config report
default encryption module
deleted files
federation
provisioning api
share files
update notificiation
versions
activity
anti-virus
calendar
collaborative tags
comments
contacts
first run wizard
gallery
mail template editor
market
notifications
ownbackup
pdf viewer
text editor
two factor totp provider
video player

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

Are you using encryption: yes

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

Logs

Web server error log

in /var/log/apache/error.log is nothing from running this, or other log?

ownCloud log (data/owncloud.log)

empty when just running this


#2

Looks like you can't use that at all: https://doc.owncloud.org/server/10.0/admin_manual/release_notes.html#converting-the-database-type-doesn-t-work