Db:convert-type sqlite to MySQL driver error

Server
, ,
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: ownCloud Documentation Overview