“Support intro”
Nextcloud version _14.04.02
Operating system and version _(armbian stretch:
Apache or nginx version (Apache 2.4.):
PHP version _(7.
The issue you are facing:
cant connect to db, mariadb is not starting.
edit. apache is running. edit
Is this the first time you’ve seen this error? _(Y
Steps to replicate it:
- All subdirectories under /var were owned by user www-data. Why? I dont know
2.I tried to fix this by changing the owner to root:root for all directories but nextcloud.
-
That seemed to be wrong.
-
I restored as much rights and owners As I could by comparison with different installation. Sadly this did not suffice.
Here is my errortext:
An unhandled exception has been thrown:
Doctrine\DBAL\DBALException: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [2002] No such file or directory in /var/www/html/nextcloud/lib/private/DB/Connection.php:64
Stack trace:
#0 /var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(429): OC\DB\Connection->connect()
#1 /var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(389): Doctrine\DBAL\Connection->getDatabasePlatformVersion()
#2 /var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(328): Doctrine\DBAL\Connection->detectDatabasePlatform()
#3 /var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(623): Doctrine\DBAL\Connection->getDatabasePlatform()
#4 /var/www/html/nextcloud/lib/private/DB/Connection.php(151): Doctrine\DBAL\Connection->setTransactionIsolation(2)
#5 /var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php(172): OC\DB\Connection->__construct(Array, Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Configuration), Object(Doctrine\Common\EventManager))
#6 /var/www/html/nextcloud/lib/private/DB/ConnectionFactory.php(152): Doctrine\DBAL\DriverManager::getConnection(Array, Object(Doctrine\DBAL\Configuration), Object(Doctrine\Common\EventManager))
#7 /var/www/html/nextcloud/lib/private/Server.php(630): OC\DB\ConnectionFactory->getConnection(‘mysql’, Array)
#8 /var/www/html/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC{closure}(Object(OC\Server))
#9 /var/www/html/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(117): Pimple\Container->offsetGet(‘OCP\IDBConnecti…’)
#10 /var/www/html/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query(‘OCP\IDBConnecti…’)
#11 /var/www/html/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(165): OC\ServerContainer->query(‘OCP\IDBConnecti…’)
#12 /var/www/html/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}(Object(OC\Server))
#13 /var/www/html/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(117): Pimple\Container->offsetGet(‘DatabaseConnect…’)
#14 /var/www/html/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query(‘DatabaseConnect…’)
#15 /var/www/html/nextcloud/lib/private/Server.php(1533): OC\ServerContainer->query(‘DatabaseConnect…’)
#16 /var/www/html/nextcloud/lib/private/Server.php(352): OC\Server->getDatabaseConnection()
#17 /var/www/html/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC{closure}(Object(OC\Server))
#18 /var/www/html/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(117): Pimple\Container->offsetGet(‘OC\Authenticati…’)
#19 /var/www/html/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query(‘OC\Authenticati…’)
#20 /var/www/html/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(68): OC\ServerContainer->query(‘OC\Authenticati…’)
#21 /var/www/html/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(98): OC\AppFramework\Utility\SimpleContainer->buildClass(Object(ReflectionClass))
#22 /var/www/html/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(119): OC\AppFramework\Utility\SimpleContainer->resolve(‘OC\Authenticati…’)
#23 /var/www/html/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query(‘OC\Authenticati…’)
#24 /var/www/html/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(68): OC\ServerContainer->query(‘OC\Authenticati…’)
#25 /var/www/html/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(98): OC\AppFramework\Utility\SimpleContainer->buildClass(Object(ReflectionClass))
#26 /var/www/html/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(119): OC\AppFramework\Utility\SimpleContainer->resolve(‘OC\Authenticati…’)
#27 /var/www/html/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query(‘OC\Authenticati…’)
#28 /var/www/html/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(165): OC\ServerContainer->query(‘OC\Authenticati…’)
#29 /var/www/html/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}(Object(OC\Server))
#30 /var/www/html/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(117): Pimple\Container->offsetGet(‘OC\Authenticati…’)
#31 /var/www/html/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query(‘OC\Authenticati…’)
#32 /var/www/html/nextcloud/lib/private/Server.php(364): OC\ServerContainer->query(‘OC\Authenticati…’)
#33 /var/www/html/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC{closure}(Object(OC\Server))
#34 /var/www/html/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(117): Pimple\Container->offsetGet(‘OCP\IUserSessio…’)
#35 /var/www/html/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query(‘OCP\IUserSessio…’)
#36 /var/www/html/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(165): OC\ServerContainer->query(‘OCP\IUserSessio…’)
#37 /var/www/html/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}(Object(OC\Server))
#38 /var/www/html/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(117): Pimple\Container->offsetGet(‘UserSession’)
#39 /var/www/html/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query(‘UserSession’)
#40 /var/www/html/nextcloud/lib/private/Server.php(1409): OC\ServerContainer->query(‘UserSession’)
#41 /var/www/html/nextcloud/lib/private/Server.php(683): OC\Server->getUserSession()
#42 /var/www/html/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC{closure}(Object(OC\Server))
#43 /var/www/html/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(117): Pimple\Container->offsetGet(‘OC\App\AppManag…’)
#44 /var/www/html/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query(‘OC\App\AppManag…’)
#45 /var/www/html/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(165): OC\ServerContainer->query(‘OC\App\AppManag…’)
#46 /var/www/html/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}(Object(OC\Server))
#47 /var/www/html/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(117): Pimple\Container->offsetGet(‘AppManager’)
#48 /var/www/html/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query(‘AppManager’)
#49 /var/www/html/nextcloud/lib/private/Server.php(1704): OC\ServerContainer->query(‘AppManager’)
#50 /var/www/html/nextcloud/lib/private/legacy/app.php(342): OC\Server->getAppManager()
#51 /var/www/html/nextcloud/lib/private/legacy/app.php(113): OC_App::getEnabledApps()
#52 /var/www/html/nextcloud/lib/base.php(654): OC_App::loadApps(Array)
#53 /var/www/html/nextcloud/lib/base.php(1068): OC::init()
#54 /var/www/html/nextcloud/console.php(46): require_once(’/var/www/html/n…’)
#55 {main}PHP Fatal error: Uncaught Doctrine\DBAL\DBALException: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [2002] No such file or directory in /var/www/html/nextcloud/lib/private/DB/Connection.php:64
Here is my systemctl status:
- mariadb.service - MariaDB 10.1.37 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Active: failed (Result: exit-code) since Thu 2019-01-03 22:06:56 CET; 20s ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 4016 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Process: 3939 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=/usr/bin/galera_recovery; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
Process: 3933 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 3931 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Main PID: 4016 (code=exited, status=1/FAILURE)
Status: “MariaDB server is down”
Jan 03 22:06:52 vxxlxx systemd[1]: Starting MariaDB 10.1.37 database server…
Jan 03 22:06:53 vxxlxx mysqld[4016]: 2019-01-03 22:06:53 3063427072 [Note] /usr/sbin/mysqld (mysqld 10.1.37-MariaDB-0+deb9u1) starting as process 4016 …
Jan 03 22:06:56 vxxlxx systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jan 03 22:06:56 vxxlxx systemd[1]: Failed to start MariaDB 10.1.37 database server.
Jan 03 22:06:56 vxxlxx systemd[1]: mariadb.service: Unit entered failed state.
Jan 03 22:06:56 vxxlxx systemd[1]: mariadb.service: Failed with result ‘exit-code’.
Here my journalctl:
–
– Unit mariadb.service has begun starting up.
Jan 03 22:06:53 vxxlxx mysqld[4016]: 2019-01-03 22:06:53 3063427072 [Note] /usr/sbin/mysqld (mysqld 10.1.37-MariaDB-0+deb9u1) starting as process 4016 …
Jan 03 22:06:56 vxxlxx systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jan 03 22:06:56 vxxlxx systemd[1]: Failed to start MariaDB 10.1.37 database server.
– Subject: Unit mariadb.service has failed
– Defined-By: systemd
– Support: https://www.debian.org/support
– Unit mariadb.service has failed.
– The result is failed.
Jan 03 22:06:56 vxxlxx systemd[1]: mariadb.service: Unit entered failed state.
Jan 03 22:06:56 vxxlxx systemd[1]: mariadb.service: Failed with result ‘exit-code’.
What can I do next? Does anybody know how to repair the MariaDB or do I have to supply more logs?
kind regards
John