Occ don't work, webinterface work

Hello all,

Support intro

Sorry to hear you’re facing problems :slightly_frowning_face:

help.nextcloud.com is for home/non-enterprise users. If you’re running a business, paid support can be accessed via portal.nextcloud.com where we can ensure your business keeps running smoothly.

In order to help you as quickly as possible, before clicking Create Topic please provide as much of the below as you can. Feel free to use a pastebin service for logs, otherwise either indent short log examples with four spaces:

example

Or for longer, use three backticks above and below the code snippet:

longer
example
here

Some or all of the below information will be requested if it isn’t supplied; for fastest response please provide as much as you can :heart:

Nextcloud version: 18.0.3 for Server
Operating system and version: Ubuntu 18.04.4 LTS (Bionic Beaver)
Apache or nginx version: Apache/2.4.29
PHP version: PHP 7.2.24

The issue you are facing:

unfortunately I can not get any further myself and find nothing in the forum.

I added the “Preview Generator” app and then ran the following command via occ “/ occ preview: generate-all -vvv”

meanwhile we had a power outage now comes the following message.

What can I do?

ghost@homeserver:/mnt/2TB/shares$ sudo -u www-data php /var/www/html/nextcloud/occ


An unhandled exception has been thrown:
Doctrine\DBAL\DBALException: Failed to connect to the database: An exception occurred in driver: could not find driver in /var/www/html/nextcloud/lib/private/DB/Connection.php:68
Stack trace:
#0 /var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(420): OC\DB\Connection->connect()
#1 /var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(380): Doctrine\DBAL\Connection->getDatabasePlatformVersion()
#2 /var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(324): Doctrine\DBAL\Connection->detectDatabasePlatform()
#3 /var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(683): Doctrine\DBAL\Connection->getDatabasePlatform()
#4 /var/www/html/nextcloud/lib/private/DB/Connection.php(155): Doctrine\DBAL\Connection->setTransactionIsolation()
#5 /var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php(195): OC\DB\Connection->__construct()
#6 /var/www/html/nextcloud/lib/private/DB/ConnectionFactory.php(157): Doctrine\DBAL\DriverManager::getConnection()
#7 /var/www/html/nextcloud/lib/private/Server.php(748): OC\DB\ConnectionFactory->getConnection()
#8 /var/www/html/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC\{closure}()
#9 /var/www/html/nextcloud/lib/private/ServerContainer.php(125): Pimple\Container->offsetGet()
#10 /var/www/html/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(162): OC\ServerContainer->query()
#11 /var/www/html/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}()
#12 /var/www/html/nextcloud/lib/private/ServerContainer.php(125): Pimple\Container->offsetGet()
#13 /var/www/html/nextcloud/lib/private/Server.php(1664): OC\ServerContainer->query()
#14 /var/www/html/nextcloud/lib/private/Server.php(421): OC\Server->getDatabaseConnection()
#15 /var/www/html/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC\{closure}()
#16 /var/www/html/nextcloud/lib/private/ServerContainer.php(125): Pimple\Container->offsetGet()
#17 /var/www/html/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(70): OC\ServerContainer->query()
#18 /var/www/html/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(100): OC\AppFramework\Utility\SimpleContainer->buildClass()
#19 /var/www/html/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(115): OC\AppFramework\Utility\SimpleContainer->resolve()
#20 /var/www/html/nextcloud/lib/private/ServerContainer.php(150): OC\AppFramework\Utility\SimpleContainer->query()
#21 /var/www/html/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(70): OC\ServerContainer->query()
#22 /var/www/html/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(100): OC\AppFramework\Utility\SimpleContainer->buildClass()
#23 /var/www/html/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(115): OC\AppFramework\Utility\SimpleContainer->resolve()
#24 /var/www/html/nextcloud/lib/private/ServerContainer.php(150): OC\AppFramework\Utility\SimpleContainer->query()
#25 /var/www/html/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(162): OC\ServerContainer->query()
#26 /var/www/html/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}()
#27 /var/www/html/nextcloud/lib/private/ServerContainer.php(125): Pimple\Container->offsetGet()
#28 /var/www/html/nextcloud/lib/private/Server.php(433): OC\ServerContainer->query()
#29 /var/www/html/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC\{closure}()
#30 /var/www/html/nextcloud/lib/private/ServerContainer.php(125): Pimple\Container->offsetGet()
#31 /var/www/html/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(162): OC\ServerContainer->query()
#32 /var/www/html/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}()
#33 /var/www/html/nextcloud/lib/private/ServerContainer.php(125): Pimple\Container->offsetGet()
#34 /var/www/html/nextcloud/lib/private/Server.php(1540): OC\ServerContainer->query()
#35 /var/www/html/nextcloud/lib/private/Server.php(801): OC\Server->getUserSession()
#36 /var/www/html/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC\{closure}()
#37 /var/www/html/nextcloud/lib/private/ServerContainer.php(125): Pimple\Container->offsetGet()
#38 /var/www/html/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(162): OC\ServerContainer->query()
#39 /var/www/html/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}()
#40 /var/www/html/nextcloud/lib/private/ServerContainer.php(125): Pimple\Container->offsetGet()
#41 /var/www/html/nextcloud/lib/private/Server.php(1835): OC\ServerContainer->query()
#42 /var/www/html/nextcloud/lib/private/legacy/app.php(347): OC\Server->getAppManager()
#43 /var/www/html/nextcloud/lib/private/legacy/app.php(114): OC_App::getEnabledApps()
#44 /var/www/html/nextcloud/lib/base.php(645): OC_App::loadApps()
#45 /var/www/html/nextcloud/lib/base.php(1089): OC::init()
#46 /var/www/html/nextcloud/console.php(48): require_once('/var/www/html/n...')
#47 /var/www/html/nextcloud/occ(11): require_once('/var/www/html/n...')
#48 {main}ghost@homeserver:/mnt/2TB/shares$

The output of your Nextcloud log in Admin > Logging:

{"reqId":"vhJzXD3Z93TBu0U7aAIv","level":3,"time":"2020-04-08T12:50:04+00:00","remoteAddr":"","user":"--","app":"PHP","method":"","url":"--","message":"Error while sending QUERY packet. PID=18779 at /var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#117","userAgent":"--","version":"18.0.3.0"}
{"reqId":"JvyzzobOFZRHMkz4cikR","level":3,"time":"2020-04-08T13:02:53+00:00","remoteAddr":"","user":"--","app":"PHP","method":"","url":"--","message":"You are using a fallback implementation of the intl extension. Installing the native one is highly recommended instead. at /var/www/html/nextcloud/3rdparty/patchwork/utf8/src/Patchwork/Utf8/Bootup/intl.php#18","userAgent":"--","version":"18.0.3.0"}
{"reqId":"ovrzY7x3ytfOsVom4psv","level":3,"time":"2020-04-08T13:03:43+00:00","remoteAddr":"","user":"--","app":"PHP","method":"","url":"--","message":"You are using a fallback implementation of the intl extension. Installing the native one is highly recommended instead. at /var/www/html/nextcloud/3rdparty/patchwork/utf8/src/Patchwork/Utf8/Bootup/intl.php#18","userAgent":"--","version":"18.0.3.0"}
{"reqId":"4xuFHCkJQrqYF5DaMUWw","level":3,"time":"2020-04-08T13:04:41+00:00","remoteAddr":"","user":"--","app":"PHP","method":"","url":"--","message":"You are using a fallback implementation of the intl extension. Installing the native one is highly recommended instead. at /var/www/html/nextcloud/3rdparty/patchwork/utf8/src/Patchwork/Utf8/Bootup/intl.php#18","userAgent":"--","version":"18.0.3.0"}
{"reqId":"rrgjMsQvBeXwD9TbVfWC","level":3,"time":"2020-04-08T13:05:30+00:00","remoteAddr":"","user":"--","app":"PHP","method":"","url":"--","message":"You are using a fallback implementation of the intl extension. Installing the native one is highly recommended instead. at /var/www/html/nextcloud/3rdparty/patchwork/utf8/src/Patchwork/Utf8/Bootup/intl.php#18","userAgent":"--","version":"18.0.3.0"}
{"reqId":"2vRzlvKHrYRpIeXhgjyQ","level":3,"time":"2020-04-08T13:06:29+00:00","remoteAddr":"","user":"--","app":"PHP","method":"","url":"--","message":"You are using a fallback implementation of the intl extension. Installing the native one is highly recommended instead. at /var/www/html/nextcloud/3rdparty/patchwork/utf8/src/Patchwork/Utf8/Bootup/intl.php#18","userAgent":"--","version":"18.0.3.0"}
{"reqId":"1OoPEYdnadh9dU3iu267","level":3,"time":"2020-04-08T13:08:37+00:00","remoteAddr":"","user":"--","app":"PHP","method":"","url":"--","message":"You are using a fallback implementation of the intl extension. Installing the native one is highly recommended instead. at /var/www/html/nextcloud/3rdparty/patchwork/utf8/src/Patchwork/Utf8/Bootup/intl.php#18","userAgent":"--","version":"18.0.3.0"}
{"reqId":"z21TMYACiuEyUEhV6O92","level":3,"time":"2020-04-08T13:09:10+00:00","remoteAddr":"","user":"--","app":"PHP","method":"","url":"--","message":"You are using a fallback implementation of the intl extension. Installing the native one is highly recommended instead. at /var/www/html/nextcloud/3rdparty/patchwork/utf8/src/Patchwork/Utf8/Bootup/intl.php#18","userAgent":"--","version":"18.0.3.0"}
{"reqId":"2NfZ8VkiQNHfCLOqWfQC","level":3,"time":"2020-04-08T13:16:27+00:00","remoteAddr":"","user":"--","app":"PHP","method":"","url":"--","message":"You are using a fallback implementation of the intl extension. Installing the native one is highly recommended instead. at /var/www/html/nextcloud/3rdparty/patchwork/utf8/src/Patchwork/Utf8/Bootup/intl.php#18","userAgent":"--","version":"18.0.3.0"}
{"reqId":"vZE4xj67WThJvdKrjTd5","level":3,"time":"2020-04-08T13:17:18+00:00","remoteAddr":"","user":"--","app":"PHP","method":"","url":"--","message":"You are using a fallback implementation of the intl extension. Installing the native one is highly recommended instead. at /var/www/html/nextcloud/3rdparty/patchwork/utf8/src/Patchwork/Utf8/Bootup/intl.php#18","userAgent":"--","version":"18.0.3.0"}
{"reqId":"eXfSHMwqKpl7881Ya5ds","level":3,"time":"2020-04-08T13:19:02+00:00","remoteAddr":"","user":"--","app":"PHP","method":"","url":"--","message":"You are using a fallback implementation of the intl extension. Installing the native one is highly recommended instead. at /var/www/html/nextcloud/3rdparty/patchwork/utf8/src/Patchwork/Utf8/Bootup/intl.php#18","userAgent":"--","version":"18.0.3.0"}
{"reqId":"VHiPrtYepxjw4Ni9UMxC","level":3,"time":"2020-04-08T13:20:08+00:00","remoteAddr":"","user":"--","app":"PHP","method":"","url":"--","message":"You are using a fallback implementation of the intl extension. Installing the native one is highly recommended instead. at /var/www/html/nextcloud/3rdparty/patchwork/utf8/src/Patchwork/Utf8/Bootup/intl.php#18","userAgent":"--","version":"18.0.3.0"}
{"reqId":"Cn6X2JCnOIqwCLOQGhZJ","level":3,"time":"2020-04-08T13:25:30+00:00","remoteAddr":"","user":"--","app":"PHP","method":"","url":"--","message":"You are using a fallback implementation of the intl extension. Installing the native one is highly recommended instead. at /var/www/html/nextcloud/3rdparty/patchwork/utf8/src/Patchwork/Utf8/Bootup/intl.php#18","userAgent":"--","version":"18.0.3.0"}
{"reqId":"A6LvVzYByJwPgnGerjwF","level":3,"time":"2020-04-08T13:26:31+00:00","remoteAddr":"","user":"--","app":"PHP","method":"","url":"--","message":"You are using a fallback implementation of the intl extension. Installing the native one is highly recommended instead. at /var/www/html/nextcloud/3rdparty/patchwork/utf8/src/Patchwork/Utf8/Bootup/intl.php#18","userAgent":"--","version":"18.0.3.0"}
{"reqId":"QAcYZAvvyq7rrE0hBF9Z","level":3,"time":"2020-04-08T13:29:32+00:00","remoteAddr":"","user":"--","app":"PHP","method":"","url":"--","message":"You are using a fallback implementation of the intl extension. Installing the native one is highly recommended instead. at /var/www/html/nextcloud/3rdparty/patchwork/utf8/src/Patchwork/Utf8/Bootup/intl.php#18","userAgent":"--","version":"18.0.3.0"}
{"reqId":"zDNT77YS7lc7plzQdat8","level":3,"time":"2020-04-08T13:29:37+00:00","remoteAddr":"","user":"--","app":"PHP","method":"","url":"--","message":"You are using a fallback implementation of the intl extension. Installing the native one is highly recommended instead. at /var/www/html/nextcloud/3rdparty/patchwork/utf8/src/Patchwork/Utf8/Bootup/intl.php#18","userAgent":"--","version":"18.0.3.0"}
{"reqId":"tOXuprSWsK7ZvJ0IYBzZ","level":3,"time":"2020-04-08T13:41:03+00:00","remoteAddr":"","user":"--","app":"PHP","method":"","url":"--","message":"You are using a fallback implementation of the intl extension. Installing the native one is highly recommended instead. at /var/www/html/nextcloud/3rdparty/patchwork/utf8/src/Patchwork/Utf8/Bootup/intl.php#18","userAgent":"--","version":"18.0.3.0"}
{"reqId":"LjrOO2LFq2Rtosylmy1O","level":3,"time":"2020-04-08T13:43:37+00:00","remoteAddr":"","user":"--","app":"PHP","method":"","url":"--","message":"You are using a fallback implementation of the intl extension. Installing the native one is highly recommended instead. at /var/www/html/nextcloud/3rdparty/patchwork/utf8/src/Patchwork/Utf8/Bootup/intl.php#18","userAgent":"--","version":"18.0.3.0"}
{"reqId":"x9J95HLcf69tddR9D4la","level":3,"time":"2020-04-08T14:05:22+00:00","remoteAddr":"","user":"--","app":"PHP","method":"","url":"--","message":"You are using a fallback implementation of the intl extension. Installing the native one is highly recommended instead. at /var/www/html/nextcloud/3rdparty/patchwork/utf8/src/Patchwork/Utf8/Bootup/intl.php#18","userAgent":"--","version":"18.0.3.0"}

The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):

$CONFIG = array (
  'instanceid' => 'oczdhaad85rl',
  'passwordsalt' => 'XXXXXXXXXXXXXXXXXXXXXXXXX',
  'secret' => 'XXXXXXXXXXXXXXXXXXXXXX',
  'trusted_domains' =>
  array (
    0 => 'XXXXXXXXXXXXXXXXX.ddns.net',
  ),
  'datadirectory' => '/mnt/2TB/nextcloud',
  'dbtype' => 'mysql',
  'version' => '18.0.3.0',
  'overwrite.cli.url' => 'https://XXXXXXXXXXXXXX.ddns.net',
  'dbname' => 'nextcloud',
  'dbhost' => 'localhost',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'dbuser' => 'nextcloud',
  'dbpassword' => 'XXXXXXXXXXXXXX',
  'installed' => true,
);

The output of your Apache/nginx/system log in /var/log/error.log:


[Wed Apr 08 15:00:16.981488 2020] [mpm_prefork:notice] [pid 6047] AH00163: Apache/2.4.29 (Ubuntu) OpenSSL/1.1.1d con$
[Wed Apr 08 15:00:16.981549 2020] [core:notice] [pid 6047] AH00094: Command line: '/usr/sbin/apache2'

Failed to connect to the database

Your database is down. Go start it and if it won’t start see what errors it throws. You’re probably dealing with a corrupted table so it’s up to you to fix it.

Edit: And if that’s not the case something on your file system is corrupted. You may need to run a fsck or reinstall everything. Backup your data directory, reinstall, import the files using occ.

Problem here was the missing version specification for php

Don’t work:
ghost@homeserver:/mnt/2TB/shares$ sudo -u www-data php /var/www/html/nextcloud/occ

Works:
ghost@homeserver:/mnt/2TB/shares$ sudo -u www-data php7.2 /var/www/html/nextcloud/occ