Ncp-update v0.46.39 fails, nextcloud dead

ℹ️ Support 📦 Appliances (Docker, Snappy, VM, NCP, AIO)
1

Yesterday I tried updating the nextcloudPi via ssh through ncp-update. When it was finished there were several error-messages and I can’t connect to the server via nc-client or web (though ssh works).

Here’s what happened:

sudo ncp-update

Downloading updates
Performing updates
Installing nc-backup
Installing nc-backup-auto
./update.sh: line 165: /home/www/ncp-launcher.sh: No such file or directory
chmod: cannot access ‘/home/www/ncp-launcher.sh’: No such file or directory
Created symlink from /etc/systemd/system/multi-user.target.wants/nc-provisioning.service to /usr/lib/systemd/system/nc-provisioning.service.
Created symlink from /etc/systemd/system/nfs-blkmap.service to /dev/null.
insserv: warning: current start runlevel(s) (empty) of script nmbd' overrides LSB defaults (2 3 4 5). insserv: warning: current stop runlevel(s) (0 1 2 3 4 5 6) of scriptnmbd’ overrides LSB defaults (0 1 6).
grep: /lib/systemd/system/mariadb.service: No such file or directory
sed: can’t read /lib/systemd/system/mariadb.service: No such file or directory
grep: /lib/systemd/system/fail2ban.service: No such file or directory
sed: can’t read /lib/systemd/system/fail2ban.service: No such file or directory
chsh: user ‘ncp’ does not exist
Removed symlink /etc/systemd/system/multi-user.target.wants/ramlogs.service.
NextCloudPi updated to version v0.46.39

Any suggestions to get it alive again?

best, sfb

2

How come you don’t have the /lib/systemd/system folder in your system? and /home/www?

can we have the output of

sudo ncp-report
1 Like
3

Hi there @nachoparker and thanks for your reply.

How come you don’t have the /lib/systemd/system folder in your system? and /home/www ?

Actually I don’t know. I don’t think I touch any of those. And the system was running for at least a year or even longer.

Would it make sense to make a backup vie ncp-config, reinstall and then use the update to restore the certificate etc?
Here the output.

NextCloudPi diagnostics




NextCloudPi version  v0.47.0
NextCloudPi image    untagged
distribution         Raspbian GNU/Linux 8 \n \l
automount            no
USB devices          sda 
datadir              /media/owncloud/ncdata
data in SD           no
data filesystem      ext2/ext3
data disk usage      30G/458G
rootfs usage         2.3G/15G
swapfile             /var/swap
Nextcloud check      error
HTTPD service        up
PHP service          up
MariaDB service      up
Redis service        down
Postfix service      up
internet check       ok
port check 80        open
port check 443       open
IP                   192.168.0.109
gateway              192.168.0.1
interface            eth0
certificates         sfbrother.ddns.net 
certs due            41 days 
NAT loopback         no
uptime               3days
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 

[Sat Mar 10 06:39:05.000280 2018] [mpm_event:notice] [pid 2213:tid 1996255232] AH00489: Apache/2.4.25 (Raspbian) OpenSSL/1.0.2l configured -- resuming normal operations
[Sat Mar 10 06:39:05.000332 2018] [core:notice] [pid 2213:tid 1996255232] AH00094: Command line: '/usr/sbin/apache2'
Database logs
Nextcloud logs 

{"reqId":"lLUwhsetvnJXnGM2ADaP","level":0,"time":"2018-03-07T12:30:03+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Finished OCA\\Activity\\BackgroundJob\\EmailNotification job with ID 8 in 0 seconds","userAgent":"--","version":"13.0.0.14"}
{"reqId":"lLUwhsetvnJXnGM2ADaP","level":0,"time":"2018-03-07T12:30:04+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Run OCA\\Files_Sharing\\DeleteOrphanedSharesJob job with ID 12","userAgent":"--","version":"13.0.0.14"}
{"reqId":"lLUwhsetvnJXnGM2ADaP","level":0,"time":"2018-03-07T12:30:04+00:00","remoteAddr":"","user":"--","app":"DeleteOrphanedSharesJob","method":"--","url":"--","message":"0 orphaned share(s) deleted","userAgent":"--","version":"13.0.0.14"}
{"reqId":"lLUwhsetvnJXnGM2ADaP","level":0,"time":"2018-03-07T12:30:04+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Finished OCA\\Files_Sharing\\DeleteOrphanedSharesJob job with ID 12 in 0 seconds","userAgent":"--","version":"13.0.0.14"}
{"reqId":"lLUwhsetvnJXnGM2ADaP","level":0,"time":"2018-03-07T12:30:05+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Run OC\\Authentication\\Token\\DefaultTokenCleanupJob job with ID 15","userAgent":"--","version":"13.0.0.14"}
{"reqId":"lLUwhsetvnJXnGM2ADaP","level":0,"time":"2018-03-07T12:30:05+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Invalidating session tokens older than 2018-03-06T12:30:05+00:00","userAgent":"--","version":"13.0.0.14"}
{"reqId":"lLUwhsetvnJXnGM2ADaP","level":0,"time":"2018-03-07T12:30:05+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Invalidating remembered session tokens older than 2018-02-20T12:30:05+00:00","userAgent":"--","version":"13.0.0.14"}
{"reqId":"lLUwhsetvnJXnGM2ADaP","level":0,"time":"2018-03-07T12:30:05+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Finished OC\\Authentication\\Token\\DefaultTokenCleanupJob job with ID 15 in 0 seconds","userAgent":"--","version":"13.0.0.14"}
{"reqId":"lLUwhsetvnJXnGM2ADaP","level":0,"time":"2018-03-07T12:30:07+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Run OCA\\UpdateNotification\\ResetTokenBackgroundJob job with ID 16","userAgent":"--","version":"13.0.0.14"}
{"reqId":"lLUwhsetvnJXnGM2ADaP","level":0,"time":"2018-03-07T12:30:07+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Finished OCA\\UpdateNotification\\ResetTokenBackgroundJob job with ID 16 in 0 seconds","userAgent":"--","version":"13.0.0.14"}
{"reqId":"lLUwhsetvnJXnGM2ADaP","level":0,"time":"2018-03-07T12:30:07+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Run OC\\Authentication\\Token\\DefaultTokenCleanupJob job with ID 406","userAgent":"--","version":"13.0.0.14"}
{"reqId":"lLUwhsetvnJXnGM2ADaP","level":0,"time":"2018-03-07T12:30:07+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Invalidating session tokens older than 2018-03-06T12:30:07+00:00","userAgent":"--","version":"13.0.0.14"}
{"reqId":"lLUwhsetvnJXnGM2ADaP","level":0,"time":"2018-03-07T12:30:07+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Invalidating remembered session tokens older than 2018-02-20T12:30:07+00:00","userAgent":"--","version":"13.0.0.14"}
{"reqId":"lLUwhsetvnJXnGM2ADaP","level":0,"time":"2018-03-07T12:30:07+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Finished OC\\Authentication\\Token\\DefaultTokenCleanupJob job with ID 406 in 0 seconds","userAgent":"--","version":"13.0.0.14"}
{"reqId":"lLUwhsetvnJXnGM2ADaP","level":0,"time":"2018-03-07T12:30:12+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Run OC\\Log\\Rotate job with ID 407","userAgent":"--","version":"13.0.0.14"}
{"reqId":"lLUwhsetvnJXnGM2ADaP","level":0,"time":"2018-03-07T12:30:12+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Finished OC\\Log\\Rotate job with ID 407 in 0 seconds","userAgent":"--","version":"13.0.0.14"}
{"reqId":"lLUwhsetvnJXnGM2ADaP","level":0,"time":"2018-03-07T12:30:15+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Run OCA\\Files_Trashbin\\BackgroundJob\\ExpireTrash job with ID 2","userAgent":"--","version":"13.0.0.14"}
{"reqId":"lLUwhsetvnJXnGM2ADaP","level":0,"time":"2018-03-07T12:30:15+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Finished OCA\\Files_Trashbin\\BackgroundJob\\ExpireTrash job with ID 2 in 0 seconds","userAgent":"--","version":"13.0.0.14"}
{"reqId":"lLUwhsetvnJXnGM2ADaP","level":0,"time":"2018-03-07T12:30:15+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Run OCA\\Files\\BackgroundJob\\ScanFiles job with ID 4","userAgent":"--","version":"13.0.0.14"}
{"reqId":"lLUwhsetvnJXnGM2ADaP","level":0,"time":"2018-03-07T12:30:15+00:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Finished OCA\\Files\\BackgroundJob\\ScanFiles job with ID 4 in 0 seconds","userAgent":"--","version":"13.0.0.14"}
4

hi @sfb

well I can see that you have a super old instance. You are still in Raspbian 8, which is no longer supported, so yes, I suggest that you start over from a fresh Raspbian 9 image that will still be good for another year and a half.

it really depends. If you only have files there, you can just start over, then copy the files to the datadir of the new instance, and run nc-scan to make NC aware of them.

if you have many users, calendars, tasks and so on you need to fix redis, so that you can perform a backup.

some options for that

  • change from redis to apcu in /var/www/nextcloud/config/config.php. ( see this )
  • see why redis is not working and fix it. Probably the other solution is the simplest.
1 Like
5

Right; guess I’ll start anew. But just for the next time and considering you keep up with your great work: Do I need to do the dist-upgrade myself when debian moves to 10 or would I have to flash a new image?

6

We shall see… last time I announced this here

I suggest you suscribe to the blog to get the news :wink: