Nextcloud version (eg, 20.0.5): 26.0.3
Operating system and version (eg, Ubuntu 20.04): Ubuntu 20.04
Apache or nginx version (eg, Apache 2.4.25): Apache/2.4.57
PHP version (eg, 7.4): PHP 8.1.20
The issue you are facing:
Hi,
Let me say that there is a forum entry for a similar error, but it is not the same, and the solution that is suggested also does not work for me. For most posts, I see blame SQL, but I had it checked, and all seem to work correctly with the DB. So, I am not sure what else it could be, so I wanted to find out who maybe had the same issue and solved it. I must also mention that I have run this server for 2 years without issues; the issue arose a few weeks back.
For a few weeks, I have had the issue that the cron.php gives the following error:
root@mailapp:~# sudo -u ebm /usr/bin/php8.1 -f /home/www/public_html/ebm/NextCloud/cron.php
Doctrine\DBAL\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory in /home/www/public_html/ebm/NextCloud/lib/private/DB/Connection.php:140
Stack trace:
#0 /home/www/public_html/ebm/NextCloud/3rdparty/doctrine/dbal/src/Connection.php(1531): OC\DB\Connection->connect()
#1 /home/www/public_html/ebm/NextCloud/3rdparty/doctrine/dbal/src/Connection.php(1029): Doctrine\DBAL\Connection->getWrappedConnection()
#2 /home/www/public_html/ebm/NextCloud/lib/private/DB/Connection.php(262): Doctrine\DBAL\Connection->executeQuery()
#3 /home/www/public_html/ebm/NextCloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\DB\Connection->executeQuery()
#4 /home/www/public_html/ebm/NextCloud/lib/private/DB/QueryBuilder/QueryBuilder.php(280): Doctrine\DBAL\Query\QueryBuilder->execute()
#5 /home/www/public_html/ebm/NextCloud/lib/private/AppConfig.php(418): OC\DB\QueryBuilder\QueryBuilder->execute()
#6 /home/www/public_html/ebm/NextCloud/lib/private/AppConfig.php(184): OC\AppConfig->loadConfigValues()
#7 /home/www/public_html/ebm/NextCloud/lib/private/AppConfig.php(374): OC\AppConfig->getApps()
#8 /home/www/public_html/ebm/NextCloud/lib/private/legacy/OC_App.php(976): OC\AppConfig->getValues()
#9 /home/www/public_html/ebm/NextCloud/lib/private/Server.php(731): OC_App::getAppVersions()
#10 /home/www/public_html/ebm/NextCloud/lib/private/AppFramework/Utility/SimpleContainer.php(171): OC\Server->OC{closure}()
#11 /home/www/public_html/ebm/NextCloud/3rdparty/pimple/pimple/src/Pimple/Container.php(122): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}()
#12 /home/www/public_html/ebm/NextCloud/lib/private/AppFramework/Utility/SimpleContainer.php(138): Pimple\Container->offsetGet()
#13 /home/www/public_html/ebm/NextCloud/lib/private/ServerContainer.php(171): OC\AppFramework\Utility\SimpleContainer->query()
#14 /home/www/public_html/ebm/NextCloud/lib/private/AppFramework/Utility/SimpleContainer.php(65): OC\ServerContainer->query()
#15 /home/www/public_html/ebm/NextCloud/lib/private/AppFramework/Utility/SimpleContainer.php(193): OC\AppFramework\Utility\SimpleContainer->get()
#16 /home/www/public_html/ebm/NextCloud/lib/private/AppFramework/Utility/SimpleContainer.php(171): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}()
#17 /home/www/public_html/ebm/NextCloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}()
#18 /home/www/public_html/ebm/NextCloud/lib/private/AppFramework/Utility/SimpleContainer.php(138): Pimple\Container->offsetGet()
#19 /home/www/public_html/ebm/NextCloud/lib/private/ServerContainer.php(171): OC\AppFramework\Utility\SimpleContainer->query()
#20 /home/www/public_html/ebm/NextCloud/lib/private/AppFramework/Utility/SimpleContainer.php(65): OC\ServerContainer->query()
#21 /home/www/public_html/ebm/NextCloud/lib/private/Server.php(1112): OC\AppFramework\Utility\SimpleContainer->get()
#22 /home/www/public_html/ebm/NextCloud/lib/private/AppFramework/Utility/SimpleContainer.php(171): OC\Server->OC{closure}()
#23 /home/www/public_html/ebm/NextCloud/3rdparty/pimple/pimple/src/Pimple/Container.php(122): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}()
#24 /home/www/public_html/ebm/NextCloud/lib/private/AppFramework/Utility/SimpleContainer.php(138): Pimple\Container->offsetGet()
#25 /home/www/public_html/ebm/NextCloud/lib/private/ServerContainer.php(171): OC\AppFramework\Utility\SimpleContainer->query()
#26 /home/www/public_html/ebm/NextCloud/lib/private/AppFramework/Utility/SimpleContainer.php(65): OC\ServerContainer->query()
#27 /home/www/public_html/ebm/NextCloud/lib/private/Server.php(2067): OC\AppFramework\Utility\SimpleContainer->get()
#28 /home/www/public_html/ebm/NextCloud/lib/private/Files/View.php(119): OC\Server->getLockingProvider()
#29 /home/www/public_html/ebm/NextCloud/lib/private/Server.php(465): OC\Files\View->__construct()
#30 /home/www/public_html/ebm/NextCloud/lib/private/AppFramework/Utility/SimpleContainer.php(171): OC\Server->OC{closure}()
#31 /home/www/public_html/ebm/NextCloud/3rdparty/pimple/pimple/src/Pimple/Container.php(122): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}()
#32 /home/www/public_html/ebm/NextCloud/lib/private/AppFramework/Utility/SimpleContainer.php(138): Pimple\Container->offsetGet()
#33 /home/www/public_html/ebm/NextCloud/lib/private/ServerContainer.php(171): OC\AppFramework\Utility\SimpleContainer->query()
#34 /home/www/public_html/ebm/NextCloud/lib/private/AppFramework/Utility/SimpleContainer.php(65): OC\ServerContainer->query()
#35 /home/www/public_html/ebm/NextCloud/lib/private/Server.php(1469): OC\AppFramework\Utility\SimpleContainer->get()
#36 /home/www/public_html/ebm/NextCloud/lib/base.php(627): OC\Server->boot()
#37 /home/www/public_html/ebm/NextCloud/lib/base.php(1169): OC::init()
#38 /home/www/public_html/ebm/NextCloud/cron.php(43): require_once(‘…’)
#39 {main}
root@mailapp:~#
Is this the first time you’ve seen this error? (Y/N): Yes
Steps to replicate it:
- Not sure
The output of your Nextcloud log in Admin > Logging:
PASTE HERE
The output of your config.php file in /path/to/nextcloud
(make sure you remove any identifiable information!):
PASTE HERE
<?php
$CONFIG = array (
'instanceid' => 'oct5oaviw70a',
'passwordsalt' => 'glp1fiqs5dvd8dxexwgofiapl9y8mq',
'secret' => 'gn54gh6ibgnz4qzw5qot7atqetsl1l6fnbr5iimavtpi0cwz',
'trusted_domains' =>
array (
0 => 'mydomain.com',
),
'datadirectory' => '/data',
'dbtype' => 'mysql',
'version' => '26.0.3.2',
'overwrite.cli.url' => 'https://mydomain.com/NextCloud',
'dbname' => 'next481',
'dbhost' => 'localhost',
'dbport' => '3306',
'dbtableprefix' => 'oc_',
'mysql.utf8mb4' => true,
'dbuser' => 'next481',
'dbpassword' => '***********',
'installed' => true,
'default_phone_region' => 'MY',
'mail_smtpmode' => 'smtp',
'mail_sendmailmode' => 'smtp',
'mail_from_address' => 'server',
'mail_domain' => 'mydomain.com',
'mail_smtpauthtype' => 'PLAIN',
'mail_smtpauth' => 1,
'mail_smtphost' => 'mail.mydomain.net',
'mail_smtpport' => '587',
'mail_smtpname' => 'mail@mydomain.com',
'mail_smtppassword' => '******',
'theme' => '',
'loglevel' => 0,
'maintenance' => false,
'app_install_overwrite' =>
array (
0 => 'duplicatefinder',
1 => 'groupfolders',
2 => 'passwords',
3 => 'admin_notifications',
4 => 'impersonate',
),
'updater.secret' => '$2y$10$DF*******************TdPAYWLT4/O',
);
The output of your Apache/nginx/system log in `/var/log/____`:
```
PASTE HERE
```
PASTE HERE
```
Output errors in nextcloud.log in /var/www/ or as admin user in top right menu, filtering for errors. Use a pastebin service if necessary.
PASTE HERE
```