Support intro
Sorry to hear you’re facing problems
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
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:
-
I’ve followed these guides to install nc: cmdbin , NC official for Db
-
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":[]}