Having an issue with NextcloudPi. I logged in about two weeks ago, and the database was down. I ran apt-get update and upgrade, and the database came back up. But I am still having the issues noted below:
Internal Server Error
The server encountered an internal error and was unable to complete your request.
Please contact the server administrator if this error reappears multiple times, please include the technical details below in your report.
More details can be found in the server log.
Technical details
Remote Address: xx.xx.xx.xx
Request ID: reallylongid
<–! Paste this in GitHub report -->
NextCloudPi diagnostics
NextCloudPi version v1.24.0
NextCloudPi image NextCloudPi_07-21-19
distribution Raspbian GNU/Linux 10 \n \l
automount yes
USB devices sda
datadir /media/myCloudDrive/ncdata
data in SD no
data filesystem btrfs
data disk usage 898G/932G
rootfs usage 4.4G/59G
swapfile /var/swap
dbdir /media/USBdrive/mysql
Nextcloud check error
HTTPD service up
PHP service up
MariaDB service up
Redis service up
Postfix service up
internet check ok
port check 80 closed
port check 443 closed
IP ***REMOVED SENSITIVE VALUE***
gateway ***REMOVED SENSITIVE VALUE***
interface eth0
certificates ***REMOVED SENSITIVE VALUE***
NAT loopback no
uptime 10days
Nextcloud configuration
An unhandled exception has been thrown:
Doctrine\DBAL\DBALException: Failed to connect to the database: An exception occurred in driver: SQLSTATE[HY000] [1698] Access denied for user 'ncadmin'@'localhost' in /var/www/nextcloud/lib/private/DB/Connection.php:64
Stack trace:
#0 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(420): OC\DB\Connection->connect()
#1 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(380): Doctrine\DBAL\Connection->getDatabasePlatformVersion()
#2 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(324): Doctrine\DBAL\Connection->detectDatabasePlatform()
#3 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(683): Doctrine\DBAL\Connection->getDatabasePlatform()
#4 /var/www/nextcloud/lib/private/DB/Connection.php(151): Doctrine\DBAL\Connection->setTransactionIsolation(2)
#5 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php(195): OC\DB\Connection->__construct(Array, Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Configuration), Object(Doctrine\Common\EventManager))
#6 /var/www/nextcloud/lib/private/DB/ConnectionFactory.php(156): Doctrine\DBAL\DriverManager::getConnection(Array, Object(Doctrine\DBAL\Configuration), Object(Doctrine\Common\EventManager))
#7 /var/www/nextcloud/lib/private/Server.php(635): OC\DB\ConnectionFactory->getConnection('mysql', Array)
#8 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC\{closure}(Object(OC\Server))
#9 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet('OCP\\IDBConnecti...')
#10 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(161): OC\ServerContainer->query('OCP\\IDBConnecti...')
#11 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(OC\Server))
#12 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet('DatabaseConnect...')
#13 /var/www/nextcloud/lib/private/Server.php(1554): OC\ServerContainer->query('DatabaseConnect...')
#14 /var/www/nextcloud/lib/private/Server.php(362): OC\Server->getDatabaseConnection()
#15 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC\{closure}(Object(OC\Server))
#16 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet('OC\\Authenticati...')
#17 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(69): OC\ServerContainer->query('OC\\Authenticati...', true)
#18 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(99): OC\AppFramework\Utility\SimpleContainer->buildClass(Object(ReflectionClass))
#19 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(114): OC\AppFramework\Utility\SimpleContainer->resolve('OC\\Authenticati...')
#20 /var/www/nextcloud/lib/private/ServerContainer.php(145): OC\AppFramework\Utility\SimpleContainer->query('OC\\Authenticati...', true)
#21 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(69): OC\ServerContainer->query('OC\\Authenticati...', true)
#22 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(99): OC\AppFramework\Utility\SimpleContainer->buildClass(Object(ReflectionClass))
#23 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(114): OC\AppFramework\Utility\SimpleContainer->resolve('OC\\Authenticati...')
#24 /var/www/nextcloud/lib/private/ServerContainer.php(145): OC\AppFramework\Utility\SimpleContainer->query('OC\\Authenticati...', true)
#25 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(161): OC\ServerContainer->query('OC\\Authenticati...')
#26 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(OC\Server))
#27 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet('OC\\Authenticati...')
#28 /var/www/nextcloud/lib/private/Server.php(374): OC\ServerContainer->query('OC\\Authenticati...')
#29 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC\{closure}(Object(OC\Server))
#30 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet('OC\\User\\Session')
#31 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(161): OC\ServerContainer->query('OC\\User\\Session')
#32 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(OC\Server))
#33 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet('UserSession')
#34 /var/www/nextcloud/lib/private/Server.php(1430): OC\ServerContainer->query('UserSession')
#35 /var/www/nextcloud/lib/private/Server.php(688): OC\Server->getUserSession()
#36 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC\{closure}(Object(OC\Server))
#37 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet('OC\\App\\AppManag...')
#38 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(161): OC\ServerContainer->query('OC\\App\\AppManag...')
#39 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(OC\Server))
#40 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet('AppManager')
#41 /var/www/nextcloud/lib/private/Server.php(1725): OC\ServerContainer->query('AppManager')
#42 /var/www/nextcloud/lib/private/legacy/app.php(346): OC\Server->getAppManager()
#43 /var/www/nextcloud/lib/private/legacy/app.php(114): OC_App::getEnabledApps()
#44 /var/www/nextcloud/lib/base.php(640): OC_App::loadApps(Array)
#45 /var/www/nextcloud/lib/base.php(1078): OC::init()
#46 /var/www/nextcloud/console.php(46): require_once('/var/www/nextcl...')
#47 /var/www/nextcloud/occ(11): require_once('/var/www/nextcl...')
#48 {main}
HTTPd logs
[Mon Mar 30 15:29:52.252515 2020] [authz_host:error] [pid 24975:tid 1976087584] [client 192.168.1.89:60880] AH01753: access check of 'localhost' to /img/toggle.svg failed, reason: unable to get the remote host name
[Mon Mar 30 15:29:52.253183 2020] [authz_host:error] [pid 24975:tid 1934124064] [client 192.168.1.89:60880] AH01753: access check of 'localhost' to /img/defaults.svg failed, reason: unable to get the remote host name
[Mon Mar 30 15:29:52.253715 2020] [authz_host:error] [pid 24975:tid 1976087584] [client 192.168.1.89:60880] AH01753: access check of 'localhost' to /img/poweroff.svg failed, reason: unable to get the remote host name
[Mon Mar 30 15:29:52.253756 2020] [authz_host:error] [pid 24975:tid 1690678304] [client 192.168.1.89:60880] AH01753: access check of 'localhost' to /img/reboot.svg failed, reason: unable to get the remote host name
[Mon Mar 30 15:29:52.393641 2020] [authz_host:error] [pid 24975:tid 1976087584] [client 192.168.1.89:60880] AH01753: access check of 'localhost' to /img/poweroff.svg failed, reason: unable to get the remote host name, referer: https://192.168.1.73:4443/css/ncp.css
[Mon Mar 30 15:29:52.399384 2020] [authz_host:error] [pid 24975:tid 1690678304] [client 192.168.1.89:60880] AH01753: access check of 'localhost' to /img/search.svg failed, reason: unable to get the remote host name, referer: https://192.168.1.73:4443/css/ncp.css
[Mon Mar 30 15:29:52.399384 2020] [authz_host:error] [pid 24975:tid 1976087584] [client 192.168.1.89:60880] AH01753: access check of 'localhost' to /img/ncp-logo.svg failed, reason: unable to get the remote host name, referer: https://192.168.1.73:4443/css/ncp.css
[Mon Mar 30 15:29:52.399608 2020] [authz_host:error] [pid 24975:tid 1682277408] [client 192.168.1.89:60880] AH01753: access check of 'localhost' to /img/dashboard.svg failed, reason: unable to get the remote host name, referer: https://192.168.1.73:4443/css/ncp.css
[Mon Mar 30 15:29:52.400430 2020] [authz_host:error] [pid 24975:tid 1934124064] [client 192.168.1.89:60880] AH01753: access check of 'localhost' to /img/nc-button.svg failed, reason: unable to get the remote host name, referer: https://192.168.1.73:4443/css/ncp.css
[Mon Mar 30 15:29:52.405376 2020] [authz_host:error] [pid 24975:tid 1934124064] [client 192.168.1.89:60880] AH01753: access check of 'localhost' to /img/defaults-white.svg failed, reason: unable to get the remote host name, referer: https://192.168.1.73:4443/css/ncp.css
[Mon Mar 30 15:29:52.406319 2020] [authz_host:error] [pid 24975:tid 1682277408] [client 192.168.1.89:60880] AH01753: access check of 'localhost' to /img/settings-white.svg failed, reason: unable to get the remote host name, referer: https://192.168.1.73:4443/css/ncp.css
[Mon Mar 30 15:29:52.406449 2020] [authz_host:error] [pid 24975:tid 1690678304] [client 192.168.1.89:60880] AH01753: access check of 'localhost' to /img/info-white.svg failed, reason: unable to get the remote host name, referer: https://192.168.1.73:4443/css/ncp.css
[Mon Mar 30 15:29:52.407052 2020] [authz_host:error] [pid 24975:tid 1976087584] [client 192.168.1.89:60880] AH01753: access check of 'localhost' to /img/wizard.svg failed, reason: unable to get the remote host name, referer: https://192.168.1.73:4443/css/ncp.css
[Mon Mar 30 15:29:52.420231 2020] [authz_host:error] [pid 24975:tid 1699079200] [client 192.168.1.89:60880] AH01753: access check of 'localhost' to /img/files.svg failed, reason: unable to get the remote host name, referer: https://192.168.1.73:4443/css/ncp.css
[Mon Mar 30 15:29:52.553662 2020] [authz_host:error] [pid 24975:tid 1699079200] [client 192.168.1.89:60880] AH01753: access check of 'localhost' to /ncp-launcher.php failed, reason: unable to get the remote host name
[Mon Mar 30 15:29:52.553663 2020] [authz_host:error] [pid 24975:tid 1976087584] [client 192.168.1.89:60880] AH01753: access check of 'localhost' to /ncp-output.php failed, reason: unable to get the remote host name
[Mon Mar 30 15:29:57.802281 2020] [authz_host:error] [pid 24975:tid 1699079200] [client 192.168.1.89:60880] AH01753: access check of 'localhost' to /ncp-launcher.php failed, reason: unable to get the remote host name
[Mon Mar 30 15:58:24.778572 2020] [authz_host:error] [pid 24975:tid 1934124064] [client 192.168.1.89:60880] AH01753: access check of 'localhost' to /ncp-launcher.php failed, reason: unable to get the remote host name
[Mon Mar 30 16:03:22.401714 2020] [authz_host:error] [pid 24975:tid 1690678304] [client 192.168.1.89:60880] AH01753: access check of 'localhost' to /img/info.svg failed, reason: unable to get the remote host name, referer: https://192.168.1.73:4443/css/ncp.css
[Mon Mar 30 16:03:55.023164 2020] [authz_host:error] [pid 24975:tid 1690678304] [client 192.168.1.89:60880] AH01753: access check of 'localhost' to /ncp-launcher.php failed, reason: unable to get the remote host name
Database logs
2020-03-30 16:32:26 1867971 [Warning] Access denied for user 'ncadmin'@'localhost'
2020-03-30 16:32:26 1867972 [Warning] Access denied for user 'ncadmin'@'localhost'
2020-03-30 16:32:26 1867973 [Warning] Access denied for user 'ncadmin'@'localhost'
2020-03-30 16:32:26 1867974 [Warning] Access denied for user 'ncadmin'@'localhost'
2020-03-30 16:32:32 1867975 [Warning] Access denied for user 'ncadmin'@'localhost'
2020-03-30 16:32:32 1867976 [Warning] Access denied for user 'ncadmin'@'localhost'
2020-03-30 16:32:32 1867977 [Warning] Access denied for user 'ncadmin'@'localhost'
2020-03-30 16:32:32 1867978 [Warning] Access denied for user 'ncadmin'@'localhost'
2020-03-30 16:32:32 1867979 [Warning] Access denied for user 'ncadmin'@'localhost'
2020-03-30 16:32:32 1867980 [Warning] Access denied for user 'ncadmin'@'localhost'
2020-03-30 16:32:32 1867981 [Warning] Access denied for user 'ncadmin'@'localhost'
2020-03-30 16:32:32 1867982 [Warning] Access denied for user 'ncadmin'@'localhost'
2020-03-30 16:32:33 1867983 [Warning] Access denied for user 'ncadmin'@'localhost'
2020-03-30 16:32:33 1867984 [Warning] Access denied for user 'ncadmin'@'localhost'
2020-03-30 16:32:33 1867985 [Warning] Access denied for user 'ncadmin'@'localhost'
2020-03-30 16:32:33 1867986 [Warning] Access denied for user 'ncadmin'@'localhost'
2020-03-30 16:32:37 1867987 [Warning] Access denied for user 'ncadmin'@'localhost'
2020-03-30 16:32:37 1867988 [Warning] Access denied for user 'ncadmin'@'localhost'
2020-03-30 16:32:37 1867989 [Warning] Access denied for user 'ncadmin'@'localhost'
2020-03-30 16:32:37 1867990 [Warning] Access denied for user 'ncadmin'@'localhost'
Nextcloud logs
(Had to remove the rest because I hit limit)