Issue when trying to use OCC command

Hello,

I installed Nextcloud yesterday, and while all seems to be working, when trying to use commands that need OCC, for instance for Memories app or generating photo previews, I get this:

#40 {main}root@nextcloud:/var/www# sudo -u www-data php occ preview:generate-all -vvv

An unhandled exception has been thrown:

Doctrine\DBAL\Exception: Failed to connect to the database: An exception occurred in the driver: could not find driver in /var/www/lib/private/DB/Connection.php:140
Stack trace:
#0 /var/www/3rdparty/doctrine/dbal/src/Connection.php(1531): OC\DB\Connection->connect()
#1 /var/www/3rdparty/doctrine/dbal/src/Connection.php(1029): Doctrine\DBAL\Connection->getWrappedConnection()
#2 /var/www/lib/private/DB/Connection.php(262): Doctrine\DBAL\Connection->executeQuery()
#3 /var/www/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\DB\Connection->executeQuery()
#4 /var/www/lib/private/DB/QueryBuilder/QueryBuilder.php(280): Doctrine\DBAL\Query\QueryBuilder->execute()
#5 /var/www/lib/private/AppConfig.php(418): OC\DB\QueryBuilder\QueryBuilder->execute()
#6 /var/www/lib/private/AppConfig.php(184): OC\AppConfig->loadConfigValues()
#7 /var/www/lib/private/AppConfig.php(374): OC\AppConfig->getApps()
#8 /var/www/lib/private/legacy/OC_App.php(803): OC\AppConfig->getValues()
#9 /var/www/lib/private/Server.php(733): OC_App::getAppVersions()
#10 /var/www/lib/private/AppFramework/Utility/SimpleContainer.php(171): OC\Server->OC{closure}()
#11 /var/www/3rdparty/pimple/pimple/src/Pimple/Container.php(122): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}()
#12 /var/www/lib/private/AppFramework/Utility/SimpleContainer.php(138): Pimple\Container->offsetGet()
#13 /var/www/lib/private/ServerContainer.php(171): OC\AppFramework\Utility\SimpleContainer->query()
#14 /var/www/lib/private/AppFramework/Utility/SimpleContainer.php(65): OC\ServerContainer->query()
#15 /var/www/lib/private/AppFramework/Utility/SimpleContainer.php(193): OC\AppFramework\Utility\SimpleContainer->get()
#16 /var/www/lib/private/AppFramework/Utility/SimpleContainer.php(171): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}()
#17 /var/www/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}()
#18 /var/www/lib/private/AppFramework/Utility/SimpleContainer.php(138): Pimple\Container->offsetGet()
#19 /var/www/lib/private/ServerContainer.php(171): OC\AppFramework\Utility\SimpleContainer->query()
#20 /var/www/lib/private/AppFramework/Utility/SimpleContainer.php(65): OC\ServerContainer->query()
#21 /var/www/lib/private/Server.php(1115): OC\AppFramework\Utility\SimpleContainer->get()
#22 /var/www/lib/private/AppFramework/Utility/SimpleContainer.php(171): OC\Server->OC{closure}()
#23 /var/www/3rdparty/pimple/pimple/src/Pimple/Container.php(122): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}()
#24 /var/www/lib/private/AppFramework/Utility/SimpleContainer.php(138): Pimple\Container->offsetGet()
#25 /var/www/lib/private/ServerContainer.php(171): OC\AppFramework\Utility\SimpleContainer->query()
#26 /var/www/lib/private/AppFramework/Utility/SimpleContainer.php(65): OC\ServerContainer->query()
#27 /var/www/lib/private/Server.php(2067): OC\AppFramework\Utility\SimpleContainer->get()
#28 /var/www/lib/private/Files/View.php(106): OC\Server->getLockingProvider()
#29 /var/www/lib/private/Server.php(467): OC\Files\View->__construct()
#30 /var/www/lib/private/AppFramework/Utility/SimpleContainer.php(171): OC\Server->OC{closure}()
#31 /var/www/3rdparty/pimple/pimple/src/Pimple/Container.php(122): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}()
#32 /var/www/lib/private/AppFramework/Utility/SimpleContainer.php(138): Pimple\Container->offsetGet()
#33 /var/www/lib/private/ServerContainer.php(171): OC\AppFramework\Utility\SimpleContainer->query()
#34 /var/www/lib/private/AppFramework/Utility/SimpleContainer.php(65): OC\ServerContainer->query()
#35 /var/www/lib/private/Server.php(1469): OC\AppFramework\Utility\SimpleContainer->get()
#36 /var/www/lib/base.php(631): OC\Server->boot()
#37 /var/www/lib/base.php(1173): OC::init()
#38 /var/www/console.php(48): require_once(‘…’)
#39 /var/www/occ(11): require_once(‘…’)

Can you help please?

Informational:
Nextcloud was installed with MariaDB, PHP 8.2.7 and Redis.
In config.php I have set ‘dbhost’ => ‘127.0.0.1:3306’,
No dbport.
When I run php -m | grep pdo, I get pdo_pgsql (shouldn’t this be mysql?)

php -v; php -m | grep xml
Result:
PHP 8.2.7 (cli) (built: Jun 8 2023 15:27:40) (NTS)
Copyright (c) The PHP Group
Zend Engine v4.2.7, Copyright (c) Zend Technologies
with Zend OPcache v8.2.7, Copyright (c), by Zend Technologies
libxml
xml
xmlreader
xmlwriter

Sorry if these are stupid questions, I am no Linux expert, I merely tried installing Nextcloud according to some docs on the net, including official one.

Thank you
Kosta

Read the link. Maybe e.g. package php-mysql is missing.

https://www.howtoforge.com/how-to-install-nextcloud-on-debian-11

Hello,
thank you, that helped, I actually went ahead and installed all the packages that were listed there.
Thank you

1 Like