Core Doctrine\DBAL\Exception mariadb with socket - openbsd

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 : 25.0
Operating system and version : OpenBSD 7.2
PHP version : r8.1

The issue you are facing:

Nextcloud boots up fine, and everything seems to be working, until i tried test the cron.php
using the following command:
doas -u www /usr/local/bin/php-8.1 -f /var/www/nextcloud/cron.php

Also the admin > logging page of nextcloud shows 8 diffrent errors all related to DBalException

Is this the first time you’ve seen this error? (Y/N): Y

Steps to replicate it:

  1. I’ve followed these guides to install nc: cmdbin , NC official for Db

  2. I use mariaDB with a socket connection. The sock file is located under
    /var/www/run/mysql/mysql.sock

My /etc/my.cnf file: (also after the official nextcloud guide)

[server]
skip_name_resolve = 1
innodb_buffer_pool_size = 128M
innodb_buffer_pool_instances = 1
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 32M
innodb_max_dirty_pages_pct = 90
query_cache_type = 1
query_cache_limit = 2M
query_cache_min_res_unit = 2k
query_cache_size = 64M
tmp_table_size= 64M
max_heap_table_size= 64M
slow_query_log = 1
slow_query_log_file = /var/www/log/mysql/slow.log
long_query_time = 1

[client-server]
socket=/var/www/run/mysql/mysql.sock

[client]
default-character-set = utf8mb4

[mysqld]
socket=/var/www/run/mysql/mysql.sock
bind-address=localhost
character_set_server = utf8mb4
collation_server = utf8mb4_general_ci
transaction_isolation = READ-COMMITTED
binlog_format = ROW
innodb_large_prefix=on
innodb_file_format=barracuda
innodb_file_per_table=1

3 I do have php_pdo-mysql installed:

$ cat /etc/php-8.1/pdo_mysql.ini 
extension=pdo_mysql.so

[mysql]
mysql.allow_local_infile=On
mysql.allow_persistent=On
mysql.cache_size=2000
mysql.max_persistent=-1
mysql.max_links=-1
mysql.default_port=
mysql.default_socket=/var/www/run/mysql/mysql.sock
mysql.default_host=
mysql.default_user=
mysql.default_password=
mysql.connect_timeout=60
mysql.trace_mode=Off

The output of your Nextcloud log in Admin > Logging:

[no app in context] Fatal: Doctrine\DBAL\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory at <<closure>>

 0. /pub/rockpuff.ddns.net/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1519
    OC\DB\Connection->connect()
 1. /pub/rockpuff.ddns.net/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1041
    Doctrine\DBAL\Connection->getWrappedConnection()
 2. /pub/rockpuff.ddns.net/nextcloud/lib/private/DB/Connection.php line 261
    Doctrine\DBAL\Connection->executeQuery("SELECT `class`, ... )", ["[]"], [2], null)
 3. /pub/rockpuff.ddns.net/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php line 345
    OC\DB\Connection->executeQuery("SELECT `class`, ... )", ["[]"], [2])
 4. /pub/rockpuff.ddns.net/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 281
    Doctrine\DBAL\Query\QueryBuilder->execute()
 5. /pub/rockpuff.ddns.net/nextcloud/apps/workflowengine/lib/Manager.php line 164
    OC\DB\QueryBuilder\QueryBuilder->execute()
 6. /pub/rockpuff.ddns.net/nextcloud/apps/workflowengine/lib/AppInfo/Application.php line 75
    OCA\WorkflowEngine\Manager->getAllConfiguredEvents()
 7. /pub/rockpuff.ddns.net/nextcloud/lib/private/AppFramework/Bootstrap/FunctionInjector.php line 67
    OCA\WorkflowEngine\AppInfo\Application->registerRuleListeners(OC\EventDispatcher\EventDispatcher {}, OC\Server {}, OC\AppFramework\Logger {})
 8. /pub/rockpuff.ddns.net/nextcloud/lib/private/AppFramework/Bootstrap/BootContext.php line 51
    OC\AppFramework\Bootstrap\FunctionInjector->injectFn(Closure {})
 9. /pub/rockpuff.ddns.net/nextcloud/apps/workflowengine/lib/AppInfo/Application.php line 67
    OC\AppFramework\Bootstrap\BootContext->injectFn(Closure {})
10. /pub/rockpuff.ddns.net/nextcloud/lib/private/AppFramework/Bootstrap/Coordinator.php line 190
    OCA\WorkflowEngine\AppInfo\Application->boot(OC\AppFramework\Bootstrap\BootContext {})
11. /pub/rockpuff.ddns.net/nextcloud/lib/private/legacy/OC_App.php line 208
    OC\AppFramework\Bootstrap\Coordinator->bootApp("workflowengine")
12. /pub/rockpuff.ddns.net/nextcloud/lib/private/legacy/OC_App.php line 141
    OC_App::loadApp("workflowengine")
13. /pub/rockpuff.ddns.net/nextcloud/lib/private/Files/SetupManager.php line 131
    OC_App::loadApps(["filesystem"])
14. /pub/rockpuff.ddns.net/nextcloud/lib/private/Files/SetupManager.php line 339
    OC\Files\SetupManager->setupBuiltinWrappers()
15. /pub/rockpuff.ddns.net/nextcloud/lib/private/Files/SetupManager.php line 379
    OC\Files\SetupManager->setupRoot()
16. /pub/rockpuff.ddns.net/nextcloud/lib/private/Files/Mount/Manager.php line 95
    OC\Files\SetupManager->setupForPath("/appdata_oc9bh272tzi6/js/core")
17. /pub/rockpuff.ddns.net/nextcloud/lib/private/Files/View.php line 1390
    OC\Files\Mount\Manager->find("/appdata_oc9bh272tzi6/js/core")
18. /pub/rockpuff.ddns.net/nextcloud/lib/private/Files/Node/Root.php line 205
    OC\Files\View->getFileInfo("/appdata_oc9bh272tzi6/js/core")
19. <<closure>>
    OC\Files\Node\Root->get("/appdata_oc9bh272tzi6/js/core")
20. /pub/rockpuff.ddns.net/nextcloud/lib/private/Files/Node/LazyFolder.php line 72
    call_user_func_array([OC\Files\Node\Root {},"get"], ["appdata_oc9bh272tzi6/js/core"])
21. /pub/rockpuff.ddns.net/nextcloud/lib/private/Files/Node/LazyFolder.php line 149
    OC\Files\Node\LazyFolder->__call("get", ["appdata_oc9bh272tzi6/js/core"])
22. /pub/rockpuff.ddns.net/nextcloud/lib/private/Files/AppData/AppData.php line 132
    OC\Files\Node\LazyFolder->get("appdata_oc9bh272tzi6/js/core")
23. /pub/rockpuff.ddns.net/nextcloud/lib/private/Template/JSCombiner.php line 88
    OC\Files\AppData\AppData->getFolder("core")
24. /pub/rockpuff.ddns.net/nextcloud/lib/private/Template/JSResourceLocator.php line 125
    OC\Template\JSCombiner->process("/pub/rockpuff.ddns.net/nextcloud", "core/js/merged-template-prepend.json", "core")
25. /pub/rockpuff.ddns.net/nextcloud/lib/private/Template/JSResourceLocator.php line 77
    OC\Template\JSResourceLocator->cacheAndAppendCombineJsonIfExist("/pub/rockpuff.ddns.net/nextcloud", "core/js/merged-template-prepend.json")
26. /pub/rockpuff.ddns.net/nextcloud/lib/private/Template/ResourceLocator.php line 78
    OC\Template\JSResourceLocator->doFind("core/js/merged-template-prepend")
27. /pub/rockpuff.ddns.net/nextcloud/lib/private/TemplateLayout.php line 379
    OC\Template\ResourceLocator->find(["core/js/common ... "])
28. /pub/rockpuff.ddns.net/nextcloud/lib/private/TemplateLayout.php line 211
    OC\TemplateLayout::findJavascriptFiles(["core/js/common ... "])
29. /pub/rockpuff.ddns.net/nextcloud/lib/private/legacy/OC_Template.php line 184
    OC\TemplateLayout->__construct("error", "")
30. /pub/rockpuff.ddns.net/nextcloud/lib/private/Template/Base.php line 132
    OC_Template->fetchPage()
31. /pub/rockpuff.ddns.net/nextcloud/lib/private/legacy/OC_Template.php line 333
    OC\Template\Base->printPage()
32. /pub/rockpuff.ddns.net/nextcloud/index.php line 74
    OC_Template::printExceptionErrorPage(OC\DB\Exceptions\DbalException {}, 500)

GET /index.php/apps/dashboard/
from 192.168.1.2 by CazacMihai at 2022-10-26T17:03:34+00:00

The output of doas -u www /usr/local/bin/php-8.1 -f /var/www/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 /var/www/pub/rockpuff.ddns.net/nextcloud/lib/private/DB/Connection.php:139
Stack trace:
#0 /var/www/pub/rockpuff.ddns.net/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\DB\Connection->connect()
#1 /var/www/pub/rockpuff.ddns.net/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\DBAL\Connection->getWrappedConnection()
#2 /var/www/pub/rockpuff.ddns.net/nextcloud/lib/private/DB/Connection.php(261): Doctrine\DBAL\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)
#3 /var/www/pub/rockpuff.ddns.net/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\DB\Connection->executeQuery('SELECT * FROM `...', Array, Array)
#4 /var/www/pub/rockpuff.ddns.net/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(281): Doctrine\DBAL\Query\QueryBuilder->execute()
#5 /var/www/pub/rockpuff.ddns.net/nextcloud/lib/private/AppConfig.php(411): OC\DB\QueryBuilder\QueryBuilder->execute()
#6 /var/www/pub/rockpuff.ddns.net/nextcloud/lib/private/AppConfig.php(176): OC\AppConfig->loadConfigValues()
#7 /var/www/pub/rockpuff.ddns.net/nextcloud/lib/private/AppConfig.php(367): OC\AppConfig->getApps()
#8 /var/www/pub/rockpuff.ddns.net/nextcloud/lib/private/legacy/OC_App.php(965): OC\AppConfig->getValues(false, 'installed_versi...')
#9 /var/www/pub/rockpuff.ddns.net/nextcloud/lib/private/Server.php(724): OC_App::getAppVersions()
#10 /var/www/pub/rockpuff.ddns.net/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(162): OC\Server->OC\{closure}(Object(OC\Server))
#11 /var/www/pub/rockpuff.ddns.net/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(122): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(Pimple\Container))
#12 /var/www/pub/rockpuff.ddns.net/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(129): Pimple\Container->offsetGet('OC\\Memcache\\Fac...')
#13 /var/www/pub/rockpuff.ddns.net/nextcloud/lib/private/ServerContainer.php(136): OC\AppFramework\Utility\SimpleContainer->query('OC\\Memcache\\Fac...', false)
#14 /var/www/pub/rockpuff.ddns.net/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(57): OC\ServerContainer->query('OC\\Memcache\\Fac...')
#15 /var/www/pub/rockpuff.ddns.net/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(184): OC\AppFramework\Utility\SimpleContainer->get('OC\\Memcache\\Fac...')
#16 /var/www/pub/rockpuff.ddns.net/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(162): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(OC\Server))
#17 /var/www/pub/rockpuff.ddns.net/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(Pimple\Container))
#18 /var/www/pub/rockpuff.ddns.net/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(129): Pimple\Container->offsetGet('OCP\\ICacheFacto...')
#19 /var/www/pub/rockpuff.ddns.net/nextcloud/lib/private/ServerContainer.php(136): OC\AppFramework\Utility\SimpleContainer->query('OCP\\ICacheFacto...', false)
#20 /var/www/pub/rockpuff.ddns.net/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(57): OC\ServerContainer->query('OCP\\ICacheFacto...')
#21 /var/www/pub/rockpuff.ddns.net/nextcloud/lib/private/Server.php(1117): OC\AppFramework\Utility\SimpleContainer->get('OCP\\ICacheFacto...')
#22 /var/www/pub/rockpuff.ddns.net/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(162): OC\Server->OC\{closure}(Object(OC\Server))
#23 /var/www/pub/rockpuff.ddns.net/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(122): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(Pimple\Container))
#24 /var/www/pub/rockpuff.ddns.net/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(129): Pimple\Container->offsetGet('OCP\\Lock\\ILocki...')
#25 /var/www/pub/rockpuff.ddns.net/nextcloud/lib/private/ServerContainer.php(136): OC\AppFramework\Utility\SimpleContainer->query('OCP\\Lock\\ILocki...', false)
#26 /var/www/pub/rockpuff.ddns.net/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(57): OC\ServerContainer->query('OCP\\Lock\\ILocki...')
#27 /var/www/pub/rockpuff.ddns.net/nextcloud/lib/private/Server.php(2067): OC\AppFramework\Utility\SimpleContainer->get('OCP\\Lock\\ILocki...')
#28 /var/www/pub/rockpuff.ddns.net/nextcloud/lib/private/Files/View.php(117): OC\Server->getLockingProvider()
#29 /var/www/pub/rockpuff.ddns.net/nextcloud/lib/private/Server.php(461): OC\Files\View->__construct()
#30 /var/www/pub/rockpuff.ddns.net/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(162): OC\Server->OC\{closure}(Object(OC\Server))
#31 /var/www/pub/rockpuff.ddns.net/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(122): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(Pimple\Container))
#32 /var/www/pub/rockpuff.ddns.net/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(129): Pimple\Container->offsetGet('OC\\Files\\Node\\H...')
#33 /var/www/pub/rockpuff.ddns.net/nextcloud/lib/private/ServerContainer.php(136): OC\AppFramework\Utility\SimpleContainer->query('OC\\Files\\Node\\H...', false)
#34 /var/www/pub/rockpuff.ddns.net/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(57): OC\ServerContainer->query('OC\\Files\\Node\\H...')
#35 /var/www/pub/rockpuff.ddns.net/nextcloud/lib/private/Server.php(1469): OC\AppFramework\Utility\SimpleContainer->get('OC\\Files\\Node\\H...')
#36 /var/www/pub/rockpuff.ddns.net/nextcloud/lib/base.php(617): OC\Server->boot()
#37 /var/www/pub/rockpuff.ddns.net/nextcloud/lib/base.php(1144): OC::init()
#38 /var/www/pub/rockpuff.ddns.net/nextcloud/cron.php(43): require_once('/var/www/pub/ro...')
#39 {main}

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

<?php
$CONFIG = array (
  'instanceid' => 'myd',
  'passwordsalt' => 'pass',
  'secret' => 'secret',
  'trusted_domains' =>
  array (
    0 => 'rockpuff.ddns.net',
  ),
  'datadirectory' => '/cloud_data',
  'dbtype' => 'mysql',
  'version' => '25.0.0.18',
  'overwrite.cli.url' => 'https://rockpuff.ddns.net',
  'dbname' => 'name',
  'dbhost' => 'localhost:/run/mysql/mysql.sock',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'mysql.utf8mb4' => true,
  'dbuser' => 'nour',
  'dbpassword' => '/DM;SXRG1]DJ;9S~I7X3GdaWt@mbCd',
  'installed' => true,
  'filelocking.enabled' => true,
  'memcache.local' => '\\OC\\Memcache\\Redis',
  'memcache.locking' => '\\OC\\Memcache\\Redis',
  'memcache.distributed' => '\\OC\\Memcache\\Redis',
  'redis' =>
  array (
          'host' => '/redis/redis.sock',
          'port' => 0,
          'timeout' => 1.5,
        ),
);


The output of your httpd log in /var/www/logs/error.log:

Access to the script '/pub/rockpuff.ddns.net/nextcloud' has been denied (see security.limit_extensions)

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.

{"reqId":"bd3UOvSP6AhXT2LNE8na","level":2,"time":"2022-10-26T16:21:29+00:00",
"remoteAddr":"192.168.1.2","user":"--","app":"no app in context","method":"GE
T","url":"/index.php/apps/dashboard/","message":"Could not detect any host in
https:///data/htaccesstest.txt","userAgent":"Mozilla/5.0 (Windows NT 10.0; r
v:105.0) Gecko/20100101 Firefox/105.0","version":"","data":[]}
{"reqId":"bd3UOvSP6AhXT2LNE8na","level":2,"time":"2022-10-26T16:21:29+00:00",
"remoteAddr":"192.168.1.2","user":"--","app":"no app in context","method":"GE
T","url":"/index.php/apps/dashboard/","message":"Could not detect any host in
http:///data/htaccesstest.txt","userAgent":"Mozilla/5.0 (Windows NT 10.0; rv
:105.0) Gecko/20100101 Firefox/105.0","version":"","data":[]}
{"reqId":"ocvOsGIag1MHs9x8n0lO","level":2,"time":"2022-10-26T16:22:43+00:00",
"remoteAddr":"192.168.1.2","user":"--","app":"no app in context","method":"PO
ST","url":"/index.php/apps/dashboard/index.php","message":"Could not detect a
ny host in https:///data/htaccesstest.txt","userAgent":"Mozilla/5.0 (Windows
NT 10.0; rv:105.0) Gecko/20100101 Firefox/105.0","version":"","data":[]}
{"reqId":"ocvOsGIag1MHs9x8n0lO","level":2,"time":"2022-10-26T16:22:43+00:00",
"remoteAddr":"192.168.1.2","user":"--","app":"no app in context","method":"PO
ST","url":"/index.php/apps/dashboard/index.php","message":"Could not detect a
ny host in http:///data/htaccesstest.txt","userAgent":"Mozilla/5.0 (Windows N
T 10.0; rv:105.0) Gecko/20100101 Firefox/105.0","version":"","data":[]}