Doctrine\DBAL\Exception: Failed to connect to the database Nextcloud 28.0.2

Support intro

When I try to run an occ command I get the following error. I have searched the internet and tried fixed I have found but none of them fixed my issue, I even broke my server once I had to restore a backup.

An unhandled exception has been thrown:
Doctrine\DBAL\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory in /var/www/7b98cb5e-a140-4bcf-bde6-291aaf569057/cloud/lib/private/DB/Connection.php:139
Stack trace:
#0 /var/www/7b98cb5e-a140-4bcf-bde6-291aaf569057/cloud/3rdparty/doctrine/dbal/src/Connection.php(1654): OC\DB\Connection->connect()
#1 /var/www/7b98cb5e-a140-4bcf-bde6-291aaf569057/cloud/3rdparty/doctrine/dbal/src/Connection.php(1081): Doctrine\DBAL\Connection->getWrappedConnection()
#2 /var/www/7b98cb5e-a140-4bcf-bde6-291aaf569057/cloud/lib/private/DB/Connection.php(261): Doctrine\DBAL\Connection->executeQuery()
#3 /var/www/7b98cb5e-a140-4bcf-bde6-291aaf569057/cloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(341): OC\DB\Connection->executeQuery()
#4 /var/www/7b98cb5e-a140-4bcf-bde6-291aaf569057/cloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(377): Doctrine\DBAL\Query\QueryBuilder->executeQuery()
#5 /var/www/7b98cb5e-a140-4bcf-bde6-291aaf569057/cloud/lib/private/DB/QueryBuilder/QueryBuilder.php(280): Doctrine\DBAL\Query\QueryBuilder->execute()
#6 /var/www/7b98cb5e-a140-4bcf-bde6-291aaf569057/cloud/lib/private/AppConfig.php(421): OC\DB\QueryBuilder\QueryBuilder->execute()
#7 /var/www/7b98cb5e-a140-4bcf-bde6-291aaf569057/cloud/lib/private/AppConfig.php(187): OC\AppConfig->loadConfigValues()
#8 /var/www/7b98cb5e-a140-4bcf-bde6-291aaf569057/cloud/lib/private/AppConfig.php(377): OC\AppConfig->getApps()
#9 /var/www/7b98cb5e-a140-4bcf-bde6-291aaf569057/cloud/lib/private/App/AppManager.php(128): OC\AppConfig->getValues()
#10 /var/www/7b98cb5e-a140-4bcf-bde6-291aaf569057/cloud/lib/private/App/AppManager.php(149): OC\App\AppManager->getInstalledAppsValues()
#11 /var/www/7b98cb5e-a140-4bcf-bde6-291aaf569057/cloud/lib/private/legacy/OC_App.php(231): OC\App\AppManager->getInstalledApps()
#12 /var/www/7b98cb5e-a140-4bcf-bde6-291aaf569057/cloud/lib/private/AppFramework/Bootstrap/Coordinator.php(90): OC_App::getEnabledApps()
#13 /var/www/7b98cb5e-a140-4bcf-bde6-291aaf569057/cloud/lib/base.php(700): OC\AppFramework\Bootstrap\Coordinator->runInitialRegistration()
#14 /var/www/7b98cb5e-a140-4bcf-bde6-291aaf569057/cloud/lib/base.php(1200): OC::init()
#15 /var/www/7b98cb5e-a140-4bcf-bde6-291aaf569057/cloud/console.php(48): require_once('...')
#16 /var/www/7b98cb5e-a140-4bcf-bde6-291aaf569057/cloud/occ(11): require_once('...')

Nextcloud version: 28.0.2
Operating system and version: Linux 5.15.0-91-generic x86_64
Apache or nginx version: Apache 2
PHP version (eg, 7.4): 8.1.26

The output of config.php file:

{
“passwordsalt”: “REMOVED SENSITIVE VALUE”,
“secret”: “REMOVED SENSITIVE VALUE”,
“trusted_domains”: [
“localhost”,
cloud.karib-tech.com
],
“force_language”: “fr”,
“default_phone_region”: “GP”,
“datadirectory”: “REMOVED SENSITIVE VALUE”,
“dbtype”: “mysql”,
“version”: “28.0.2.5”,
“overwrite.cli.url”: “http://localhost”,
“dbname”: “REMOVED SENSITIVE VALUE”,
“dbhost”: “REMOVED SENSITIVE VALUE”,
“dbport”: “”,
“dbtableprefix”: “oc_”,
“mysql.utf8mb4”: true,
“dbuser”: “REMOVED SENSITIVE VALUE”,
“dbpassword”: “REMOVED SENSITIVE VALUE”,
“installed”: true,
“instanceid”: “REMOVED SENSITIVE VALUE”,
“mail_smtpmode”: “smtp”,
“mail_sendmailmode”: “smtp”,
“mail_from_address”: “REMOVED SENSITIVE VALUE”,
“mail_domain”: “REMOVED SENSITIVE VALUE”,
“mail_smtpauth”: 1,
“mail_smtpauthtype”: “LOGIN”,
“mail_smtphost”: “REMOVED SENSITIVE VALUE”,
“mail_smtpport”: “8025”,
“mail_smtpname”: “REMOVED SENSITIVE VALUE”,
“mail_smtppassword”: “REMOVED SENSITIVE VALUE”,
“enforce_theme”: “”,
“maintenance”: false,
“theme”: “”,
“loglevel”: 2,
“maintenance_window_start”: 1,
“memcache.locking”: “\OC\Memcache\Redis”,
“memcache.distributed”: “\OC\Memcache\Redis”,
“memcache.local”: “\OC\Memcache\Redis”,
“app_install_overwrite”: [
“libresign”,
“signlive”
]
}

What’s the state of your MySQL database server? It looks like it’s offline.

Thanks @jtr

● mysql.service - MySQL Community Server
     Loaded: loaded (/lib/systemd/system/mysql.service; disabled; vendor preset>
     Active: active (running) since Thu 2024-02-22 05:10:18 UTC; 2min 14s ago
    Process: 1171127 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (cod>
   Main PID: 1171135 (mysqld)
     Status: "Server is operational"
      Tasks: 38 (limit: 9389)
     Memory: 366.0M
        CPU: 1.249s
     CGroup: /system.slice/mysql.service
             └─1171135 /usr/sbin/mysqld

I’m getting a bit of a different error now though (my nc instance works well):

An unhandled exception has been thrown:
Doctrine\DBAL\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [1045] Access denied for user 'xxx'@'localhost' (using password: YES) in /var/www/7b98cb5e-a140-4bcf-bde6-291aaf569057/mycloud/lib/private/DB/Connection.php:139
Stack trace:
#0 /var/www/7b98cb5e-a140-4bcf-bde6-291aaf569057/mycloud/3rdparty/doctrine/dbal/src/Connection.php(1654): OC\DB\Connection->connect()
#1 /var/www/7b98cb5e-a140-4bcf-bde6-291aaf569057/mycloud/3rdparty/doctrine/dbal/src/Connection.php(1081): Doctrine\DBAL\Connection->getWrappedConnection()
#2 /var/www/7b98cb5e-a140-4bcf-bde6-291aaf569057/mycloud/lib/private/DB/Connection.php(261): Doctrine\DBAL\Connection->executeQuery()
#3 /var/www/7b98cb5e-a140-4bcf-bde6-291aaf569057/mycloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(341): OC\DB\Connection->executeQuery()
#4 /var/www/7b98cb5e-a140-4bcf-bde6-291aaf569057/mycloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(377): Doctrine\DBAL\Query\QueryBuilder->executeQuery()
#5 /var/www/7b98cb5e-a140-4bcf-bde6-291aaf569057/mycloud/lib/private/DB/QueryBuilder/QueryBuilder.php(280): Doctrine\DBAL\Query\QueryBuilder->execute()
#6 /var/www/7b98cb5e-a140-4bcf-bde6-291aaf569057/mycloud/lib/private/AppConfig.php(421): OC\DB\QueryBuilder\QueryBuilder->execute()
#7 /var/www/7b98cb5e-a140-4bcf-bde6-291aaf569057/mycloud/lib/private/AppConfig.php(187): OC\AppConfig->loadConfigValues()
#8 /var/www/7b98cb5e-a140-4bcf-bde6-291aaf569057/mycloud/lib/private/AppConfig.php(377): OC\AppConfig->getApps()
#9 /var/www/7b98cb5e-a140-4bcf-bde6-291aaf569057/mycloud/lib/private/App/AppManager.php(128): OC\AppConfig->getValues()
#10 /var/www/7b98cb5e-a140-4bcf-bde6-291aaf569057/mycloud/lib/private/App/AppManager.php(149): OC\App\AppManager->getInstalledAppsValues()
#11 /var/www/7b98cb5e-a140-4bcf-bde6-291aaf569057/mycloud/lib/private/legacy/OC_App.php(231): OC\App\AppManager->getInstalledApps()
#12 /var/www/7b98cb5e-a140-4bcf-bde6-291aaf569057/mycloud/lib/private/AppFramework/Bootstrap/Coordinator.php(90): OC_App::getEnabledApps()
#13 /var/www/7b98cb5e-a140-4bcf-bde6-291aaf569057/mycloud/lib/base.php(700): OC\AppFramework\Bootstrap\Coordinator->runInitialRegistration()
#14 /var/www/7b98cb5e-a140-4bcf-bde6-291aaf569057/mycloud/lib/base.php(1200): OC::init()
#15 /var/www/7b98cb5e-a140-4bcf-bde6-291aaf569057/mycloud/console.php(48): require_once('...')
#16 /var/www/7b98cb5e-a140-4bcf-bde6-291aaf569057/mycloud/occ(11): require_once('...')

I still get the same issue, here’s my command line: “php occ config:app:set dav calendarSubscriptionRefreshRate --value “PT3M” --character-set-server=utf8”

1 Like