Nextcloud version (eg, 20.0.5): 24.0.5.1
22.04.1 LTS
Operating system and version (eg, Ubuntu 20.04): Ubuntu
Apache or nginx version (eg, Apache 2.4.25): Apache 2.4.52
PHP version (eg, 7.4): Zend OPcache v8.1.2
The issue you are facing:
After updating Linux Ubuntu to 22.04.1 LTS,
Nextcloud is not starting. I get an Error in the Apache log:
PHP Fatal error: Uncaught 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/html/nextcloud/lib/private/DB/Connection.php:139
However i can remotely connect to the database with same credentials like before the upgrade
Is this the first time you’ve seen this error? (Y/N): Y
Steps to replicate it:
- Start Ubuntu
- Check Apace log
The output of your Nextcloud log in Admin > Logging:
No Nextcloud log yet
<?php
$CONFIG = array (
'auth.bruteforce.protection.enabled' => true,
'instanceid' => 'oc6ebywp5leh',
'passwordsalt' => 'dLnSmrEJ3T1iDiXh+c9MxKejzt7veh',
'secret' => 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX',
'trusted_domains' =>
array (
0 => 'localhost',
1 => 'w392cloud.homeip.net',
2 => '212.51.158.53',
),
'datadirectory' => '/var/www/html/nextcloud/data',
'dbtype' => 'mysql',
'version' => '24.0.5.1',
'overwrite.cli.url' => 'http://localhost/nextcloud',
'dbname' => 'nextcloud',
'dbhost' => 'localhost',
'dbport' => '',
'dbtableprefix' => 'oc_',
'dbuser' => 'thomas',
'dbpassword' => 'XXXXXXXXXXX',
'installed' => true,
'memcache.distributed' => '\\OC\\Memcache\\APCu',
'memcache.local' => '\\OC\\Memcache\\APCu',
'opcache.interned_strings_buffer' => '16',
'enable_previews' => true,
'enabledPreviewProviders' =>
array (
0 => 'OC\\Preview\\PNG',
1 => 'OC\\Preview\\JPEG',
2 => 'OC\\Preview\\GIF',
3 => 'OC\\Preview\\BMP',
4 => 'OC\\Preview\\HEIC',
5 => 'OC\\Preview\\XBitmap',
6 => 'OC\\Preview\\MP3',
7 => 'OC\\Preview\\MP4',
8 => 'OC\\Preview\\TXT',
9 => 'OC\\Preview\\MarkDown',
10 => 'OC\\Preview\\PDF',
),
'preview_max_x' => NULL,
'preview_max_y' => NULL,
'preview_max_filesize_image' => 80,
'preview_max_memory' => 256,
'maintenance' => false,
'theme' => '',
'log_type' => 'file',
'logfile' => '/var/log/nextcloud.log',
'logfilemode' => 416,
'loglevel' => 1,
'logdateformat' => 'F d, Y H:i:s',
'mysql.utf8mb4' => true,
'updater.release.channel' => 'stable',
'default_phone_region' => 'ISO 3166-2:CH',
'mail_smtpmode' => 'smtp',
'mail_sendmailmode' => 'smtp',
'mail_from_address' => 'w392cloud',
'mail_domain' => '3sweb.net',
'mail_smtphost' => '3sweb.net',
'mail_smtpport' => '587',
'mail_smtpauth' => 1,
'mail_smtpname' => ' w392cloud@3sweb.net',
'mail_smtppassword' => 'XXXXXXXX',
'mail_smtpsecure' => 'tls',
'mail_smtpstreamoptions' =>
array (
'ssl' =>
array (
'security_level' => 2,
),
),
'mail_smtpauthtype' => 'LOGIN',
);
The output of your Apache/nginx/system log in /var/log/____
:
[Wed Sep 14 01:05:36.198982 2022] [php7:error] [pid 1024945] [client 89.216.52.197:32174]
PHP Fatal error: Uncaught 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/html/nextcloud/lib/private/DB/Connection.php:139
Stack trace:
#0 /var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\\DB\\Connection->connect()
#1 /var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\\DBAL\\Connection->getWrappedConnection()
#2 /var/www/html/nextcloud/lib/private/DB/Connection.php(261): Doctrine\\DBAL\\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)
#3 /var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\\DB\\Connection->executeQuery('SELECT * FROM `...', Array, Array)
#4 /var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(281): Doctrine\\DBAL\\Query\\QueryBuilder->execute()
#5 /var/www/html/nextcloud/lib/private/AppConfig.php(411): OC\\DB\\QueryBuilder\\QueryBuilder->execute()
#6 /var/www/html/nextcloud/lib/private/AppConfig in /var/www/html/nextcloud/lib/private/DB/Connection.php on line 139