Nextcloudpi Update from 1.12.7 to 1.13.0 don't work and crash webgui

[Cydras]

Hi,
the update from 1.12.7 to 1.13.0 has crashed and now my webgui don’t work anymore.
When i try to update by console (sudo ncp-update) i become this:

Downloading updates
Performing updates
Running nc-autoupdate-nc
automatic Nextcloud updates enabled
Cannot load Zend OPcache - it was already loaded
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 /data/nextcloud/lib/
private/DB/Connection.php:64
Stack trace:
#0 /data/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(429): OC\DB\Connection->connect()
#1 /data/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(389): Doctrine\DBAL\Connection->getDatabasePlatformVersion()
#2 /data/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(328): Doctrine\DBAL\Connection->detectDatabasePlatform()
#3 /data/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(623): Doctrine\DBAL\Connection->getDatabasePlatform()
#4 /data/nextcloud/lib/private/DB/Connection.php(151): Doctrine\DBAL\Connection->setTransactionIsolation(2)
#5 /data/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), Objec
t(Doctrine\Common\EventManager))
#6 /data/nextcloud/lib/private/DB/ConnectionFactory.php(158): Doctrine\DBAL\DriverManager::getConnection(Array, Object(Doctrine\DBAL\Configuration), Object(Doctrine\Common\EventManager))
#7 /data/nextcloud/lib/private/Server.php(641): OC\DB\ConnectionFactory->getConnection(‘mysql’, Array)
#8 /data/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC{closure}(Object(OC\Server))
#9 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(117): Pimple\Container->offsetGet(‘OCP\IDBConnecti…’)
#10 /data/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query(‘OCP\IDBConnecti…’)
#11 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(165): OC\ServerContainer->query(‘OCP\IDBConnecti…’)
#12 /data/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}(Object(OC\Server))
#13 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(117): Pimple\Container->offsetGet(‘DatabaseConnect…’)
#14 /data/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query(‘DatabaseConnect…’)
#15 /data/nextcloud/lib/private/Server.php(1552): OC\ServerContainer->query(‘DatabaseConnect…’)
#16 /data/nextcloud/lib/private/Server.php(360): OC\Server->getDatabaseConnection()
#17 /data/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC{closure}(Object(OC\Server))
#18 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(117): Pimple\Container->offsetGet(‘OC\Authenticati…’)
#19 /data/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query(‘OC\Authenticati…’)
#20 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(68): OC\ServerContainer->query(‘OC\Authenticati…’)
#21 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(98): OC\AppFramework\Utility\SimpleContainer->buildClass(Object(ReflectionClass))
#22 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(119): OC\AppFramework\Utility\SimpleContainer->resolve(‘OC\Authenticati…’)
#23 /data/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query(‘OC\Authenticati…’)
#24 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(68): OC\ServerContainer->query(‘OC\Authenticati…’)
#25 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(98): OC\AppFramework\Utility\SimpleContainer->buildClass(Object(ReflectionClass))
#26 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(119): OC\AppFramework\Utility\SimpleContainer->resolve(‘OC\Authenticati…’)
#27 /data/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query(‘OC\Authenticati…’)
#28 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(165): OC\ServerContainer->query(‘OC\Authenticati…’)
#29 /data/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}(Object(OC\Server))
#30 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(117): Pimple\Container->offsetGet(‘OC\Authenticati…’)
#31 /data/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query(‘OC\Authenticati…’)
#32 /data/nextcloud/lib/private/Server.php(372): OC\ServerContainer->query(‘OC\Authenticati…’)
#33 /data/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC{closure}(Object(OC\Server))
#34 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(117): Pimple\Container->offsetGet(‘OC\User\Session’)
#35 /data/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query(‘OC\User\Session’)
#36 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(165): OC\ServerContainer->query(‘OC\User\Session’)
#37 /data/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}(Object(OC\Server))
#38 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(117): Pimple\Container->offsetGet(‘UserSession’)
#39 /data/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query(‘UserSession’)
#40 /data/nextcloud/lib/private/Server.php(1428): OC\ServerContainer->query(‘UserSession’)
#41 /data/nextcloud/lib/private/Server.php(694): OC\Server->getUserSession()
#42 /data/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC{closure}(Object(OC\Server))
#43 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(117): Pimple\Container->offsetGet(‘OC\App\AppManag…’)
#44 /data/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query(‘OC\App\AppManag…’)
#45 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(165): OC\ServerContainer->query(‘OC\App\AppManag…’)
#46 /data/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}(Object(OC\Server))
#47 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(117): Pimple\Container->offsetGet(‘AppManager’)
#48 /data/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query(‘AppManager’)
#49 /data/nextcloud/lib/private/Server.php(1723): OC\ServerContainer->query(‘AppManager’)
#50 /data/nextcloud/lib/private/legacy/app.php(342): OC\Server->getAppManager()
#51 /data/nextcloud/lib/private/legacy/app.php(113): OC_App::getEnabledApps()
#52 /data/nextcloud/lib/base.php(654): OC_App::loadApps(Array)
#53 /data/nextcloud/lib/base.php(1068): OC::init()
#54 /data/nextcloud/console.php(46): require_once(’/data/nextcloud…’)
#55 /data/nextcloud/occ(11): require_once(’/data/nextcloud…’)
#56 {main}

Does somebody know how i get it again to work?
Or can i install nextcloupi completely new mit my old settings and users?

[acesabe]

Hmmm, I thought that the issue was due to an error on my part (see my post: Ncadmin database password and ncp update issues of earlier), but perhaps there are other gremlins at work here complicating matters!

Can you access via ssh? If so from inside the container ( docker exec -it nextcloudpi /bin/bash ) check what passwords are configured in /data/nextcloud/config/config.php

[Cydras]

No i can’t access via ssh. It refuses the connection.
I can run only docker commands.

Looks like we have the same problem with ncadmin

[acesabe]

OK if you have access to the host then you can “get in” by running

docker exec -it nextcloudpi /bin/bash

Then check logs such as:

/var/log/ncp.log
/var/log/mysql/error.log

etc to check for clues and what config you have in place currently

[nachoparker]

are you running docker?

[Cydras]

Yes i am using docker on my QNAP NAS.
With /bin/bash i get in, but i can’t open files
vi or any other text editor is not there

[nachoparker]

apt-get update; apt-install vim

[acesabe]

No cat, less or more available just to view files?

[Cydras]

I installed vi, but when i try to open files nothing happens. Only black

I tried with
vi config.php
vi ncp.log

[Cydras]

Ok i don’t know why, but i started again an update and now it has worked and is on 1.13.1!
WebGui also working again!