Hello,
I’m using NextcloudPi since a year and everything was fine, but after last upgrade, it’s inaccessible.
I can access to webUI config (4443) but not via https (get 500 error)
Backup is blocked ( access denied for user ncadmin)
fix permission is blocked (datadir not found)
Can someone help me to find why so many errors ?
NextCloudPi diagnostics
NextCloudPi version v0.56.16
NextCloudPi image NextCloudPi_02-06-18
distribution Raspbian GNU/Linux 9 \n \l
automount yes
USB devices sda
datadir /media/USBdrive/ncdata
data in SD no
data filesystem btrfs
data disk usage 12G/448G
rootfs usage 1,8G/15G
swapfile /var/swap
Nextcloud check error
HTTPD service up
PHP service up
MariaDB service up
Redis service up
Postfix service up
internet check no }
port check 80 open
port check 443 open
IP 192.168.1.89
gateway 192.168.1.1
interface eth0
certificates cloud.****************.com
NAT loopback no
uptime 9min
Nextcloud configuration
An unhandled exception has been thrown:
Doctrine\DBAL\DBALException: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [1045] Access denied for user 'ncadmin'@'localhost' (using password: YES) in /var/www/nextcloud/lib/private/DB/Connection.php:64
Stack trace:
#0 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(429): OC\DB\Connection->connect()
#1 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(389): Doctrine\DBAL\Connection->getDatabasePlatformVersion()
#2 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(328): Doctrine\DBAL\Connection->detectDatabasePlatform()
#3 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(623): 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(172): 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(152): Doctrine\DBAL\DriverManager::getConnection(Array, Object(Doctrine\DBAL\Configuration), Object(Doctrine\Common\EventManager))
#7 /var/www/nextcloud/lib/private/Server.php(618): OC\DB\ConnectionFactory->getConnection('mysql', Array)
#8 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))
#9 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(116): Pimple\Container->offsetGet('OCP\\IDBConnecti...')
#10 /var/www/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('OCP\\IDBConnecti...')
#11 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(164): OC\ServerContainer->query('OCP\\IDBConnecti...')
#12 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(109): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(OC\Server))
#13 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(116): Pimple\Container->offsetGet('DatabaseConnect...')
#14 /var/www/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('DatabaseConnect...')
#15 /var/www/nextcloud/lib/private/Server.php(1490): OC\ServerContainer->query('DatabaseConnect...')
#16 /var/www/nextcloud/lib/private/Server.php(331): OC\Server->getDatabaseConnection()
#17 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))
#18 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(116): Pimple\Container->offsetGet('OC\\Authenticati...')
#19 /var/www/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('OC\\Authenticati...')
#20 /var/www/nextcloud/lib/private/Server.php(335): OC\ServerContainer->query('OC\\Authenticati...')
#21 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))
#22 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(116): Pimple\Container->offsetGet('OC\\Authenticati...')
#23 /var/www/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('OC\\Authenticati...')
#24 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(164): OC\ServerContainer->query('OC\\Authenticati...')
#25 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(109): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(OC\Server))
#26 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(116): Pimple\Container->offsetGet('OC\\Authenticati...')
#27 /var/www/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('OC\\Authenticati...')
#28 /var/www/nextcloud/lib/private/Server.php(351): OC\ServerContainer->query('OC\\Authenticati...')
#29 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))
#30 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(116): Pimple\Container->offsetGet('OCP\\IUserSessio...')
#31 /var/www/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('OCP\\IUserSessio...')
#32 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(164): OC\ServerContainer->query('OCP\\IUserSessio...')
#33 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(109): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(OC\Server))
#34 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(116): Pimple\Container->offsetGet('UserSession')
#35 /var/www/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('UserSession')
#36 /var/www/nextcloud/lib/private/Server.php(1359): OC\ServerContainer->query('UserSession')
#37 /var/www/nextcloud/lib/private/Server.php(678): OC\Server->getUserSession()
#38 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))
#39 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(116): Pimple\Container->offsetGet('OC\\App\\AppManag...')
#40 /var/www/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('OC\\App\\AppManag...')
#41 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(164): OC\ServerContainer->query('OC\\App\\AppManag...')
#42 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(109): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(OC\Server))
#43 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(116): Pimple\Container->offsetGet('AppManager')
#44 /var/www/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('AppManager')
#45 /var/www/nextcloud/lib/private/Server.php(1663): OC\ServerContainer->query('AppManager')
#46 /var/www/nextcloud/lib/private/legacy/app.php(330): OC\Server->getAppManager()
#47 /var/www/nextcloud/lib/private/legacy/app.php(113): OC_App::getEnabledApps()
#48 /var/www/nextcloud/lib/base.php(661): OC_App::loadApps(Array)
#49 /var/www/nextcloud/lib/base.php(1080): OC::init()
#50 /var/www/nextcloud/console.php(46): require_once('/var/www/nextcl...')
#51 /var/www/nextcloud/occ(11): require_once('/var/www/nextcl...')
#52 {main}
HTTPd logs
[Fri Jun 01 18:26:28.077228 2018] [authz_host:error] [pid 896:tid 1909638192] [client 192.168.1.4:60296] AH01753: access check of 'localhost' to /img/dashboard.svg failed, reason: unable to get the remote host name
[Fri Jun 01 18:26:28.080436 2018] [authz_host:error] [pid 896:tid 1934804016] [client 192.168.1.4:60296] AH01753: access check of 'localhost' to /img/settings-white.svg failed, reason: unable to get the remote host name
[Fri Jun 01 18:26:33.111527 2018] [authz_host:error] [pid 896:tid 1951581232] [client 192.168.1.4:60296] AH01753: access check of 'localhost' to /img/reboot.svg failed, reason: unable to get the remote host name
[Fri Jun 01 18:26:33.133092 2018] [authz_host:error] [pid 896:tid 1884472368] [client 192.168.1.4:60296] AH01753: access check of 'localhost' to /core/img/actions/triangle-s.svg failed, reason: unable to get the remote host name
[Fri Jun 01 18:26:43.667822 2018] [authz_host:error] [pid 896:tid 1817363504] [client 192.168.1.4:60296] AH01753: access check of 'localhost' to /ncp.js failed, reason: unable to get the remote host name
[Fri Jun 01 18:26:43.694158 2018] [authz_host:error] [pid 896:tid 1901249584] [client 192.168.1.4:60296] AH01753: access check of 'localhost' to /img/nc-button.svg failed, reason: unable to get the remote host name
[Fri Jun 01 18:26:43.694751 2018] [authz_host:error] [pid 896:tid 1918026800] [client 192.168.1.4:60296] AH01753: access check of 'localhost' to /img/wizard.svg failed, reason: unable to get the remote host name
[Fri Jun 01 18:26:43.903037 2018] [authz_host:error] [pid 896:tid 1867695152] [client 192.168.1.4:60296] AH01753: access check of 'localhost' to /ncp-output.php failed, reason: unable to get the remote host name
[Fri Jun 01 18:26:43.916645 2018] [authz_host:error] [pid 896:tid 1892860976] [client 192.168.1.4:60296] AH01753: access check of 'localhost' to /ncp-launcher.php failed, reason: unable to get the remote host name
[Fri Jun 01 18:26:45.366655 2018] [proxy_fcgi:error] [pid 896:tid 1867695152] [client 192.168.1.4:60296] AH01071: Got error 'PHP message: PHP Warning: touch(): Utime failed: Permission denied in /var/www/ncp-web/ncp-output.php on line 81\n'
[Fri Jun 01 18:27:06.633940 2018] [proxy_fcgi:error] [pid 896:tid 1892860976] [client 192.168.1.4:60296] AH01071: Got error 'PHP message: PHP Warning: fclose(): supplied resource is not a valid stream resource in /var/www/ncp-web/L10N.php on line 166\n'
[Fri Jun 01 18:27:06.648597 2018] [authz_host:error] [pid 896:tid 1850917936] [client 192.168.1.4:60296] AH01753: access check of 'localhost' to /ncp-launcher.php failed, reason: unable to get the remote host name
[Fri Jun 01 18:27:08.438776 2018] [proxy_fcgi:error] [pid 896:tid 1850917936] [client 192.168.1.4:60296] AH01071: Got error 'PHP message: PHP Warning: fclose(): supplied resource is not a valid stream resource in /var/www/ncp-web/L10N.php on line 166\n'
[Fri Jun 01 18:43:25.894493 2018] [proxy_fcgi:error] [pid 896:tid 1867695152] [client 192.168.1.4:60296] AH01067: Failed to read FastCGI header
[Fri Jun 01 18:43:25.894675 2018] [proxy_fcgi:error] [pid 896:tid 1867695152] (104)Connection reset by peer: [client 192.168.1.4:60296] AH01075: Error dispatching request to :4443:
[Fri Jun 01 18:43:27.239104 2018] [mpm_event:notice] [pid 830:tid 1992011776] AH00491: caught SIGTERM, shutting down
[Fri Jun 01 18:43:42.760397 2018] [ssl:warn] [pid 599:tid 1992241152] AH01909: localhost:4443:0 server certificate does NOT include an ID which matches the server name
[Fri Jun 01 18:43:43.048577 2018] [ssl:warn] [pid 806:tid 1992241152] AH01909: localhost:4443:0 server certificate does NOT include an ID which matches the server name
[Fri Jun 01 18:43:44.003365 2018] [mpm_event:notice] [pid 806:tid 1992241152] AH00489: Apache/2.4.25 (Raspbian) OpenSSL/1.0.2l configured -- resuming normal operations
[Fri Jun 01 18:43:44.003521 2018] [core:notice] [pid 806:tid 1992241152] AH00094: Command line: '/usr/sbin/apache2'
Database logs
2018-06-01 18:43:28 1639211840 [Note] /usr/sbin/mysqld: Shutdown complete
2018-06-01 18:44:22 1988497408 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-06-01 18:44:22 1988497408 [Note] InnoDB: The InnoDB memory heap is disabled
2018-06-01 18:44:22 1988497408 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-06-01 18:44:22 1988497408 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-06-01 18:44:22 1988497408 [Note] InnoDB: Compressed tables use zlib 1.2.8
2018-06-01 18:44:22 1988497408 [Note] InnoDB: Using Linux native AIO
2018-06-01 18:44:22 1988497408 [Note] InnoDB: Using generic crc32 instructions
2018-06-01 18:44:22 1988497408 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-06-01 18:44:22 1988497408 [Note] InnoDB: Completed initialization of buffer pool
2018-06-01 18:44:22 1988497408 [Note] InnoDB: Highest supported file format is Barracuda.
2018-06-01 18:44:23 1988497408 [Note] InnoDB: 128 rollback segment(s) are active.
2018-06-01 18:44:23 1988497408 [Note] InnoDB: Waiting for purge to start
2018-06-01 18:44:23 1988497408 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 471505862
2018-06-01 18:44:23 1442837312 [Note] InnoDB: Dumping buffer pool(s) not yet started
2018-06-01 18:44:23 1988497408 [Note] Plugin 'FEEDBACK' is disabled.
2018-06-01 18:44:23 1988497408 [Note] Server socket created on IP: '127.0.0.1'.
2018-06-01 18:44:23 1988497408 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.1.23-MariaDB-9+deb9u1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Raspbian 9.0