NCP Upgrade to 21.0.4 Error

DO NOT EDIT! THIS FILE HAS BEEN AUTOMATICALLY GENERATED. CHANGES WILL BE OVERWRITTEN

DocumentRoot /var/www/nextcloud ServerName XXXXXXXXXXXXXXXXXXXX CustomLog /var/log/apache2/nc-access.log combined ErrorLog /var/log/apache2/nc-error.log SSLEngine on SSLProxyEngine on SSLCertificateFile /etc/letsencrypt/live/XXXXXXXXXXXXXX/fullchain.pem SSLCertificateKeyFile /etc/letsencrypt/live/XXXXXXXXXXXXXXX/privkey.pem
# For notify_push app in NC21
ProxyPass /push/ws ws://127.0.0.1:7867/ws
ProxyPass /push/ http://127.0.0.1:7867/
ProxyPassReverse /push/ http://127.0.0.1:7867/

<Directory /var/www/nextcloud/>
Options +FollowSymlinks
AllowOverride All

Dav off

LimitRequestBody 0
SSLRenegBufferSize 10486000


Header always set Strict-Transport-Security “max-age=15768000; includeSubDomains”

Its the same for me as for @mcjoe. Works since you pushed the updates but it still says “none” in systeminfo.

/etc/apache2/sites-available/nextcloud.conf:

### DO NOT EDIT! THIS FILE HAS BEEN AUTOMATICALLY GENERATED. CHANGES WILL BE OVERWRITTEN ###

<IfModule mod_ssl.c>
  <VirtualHost _default_:443>
    DocumentRoot /var/www/nextcloud
    ServerName XX
    CustomLog /var/log/apache2/nc-access.log combined
    ErrorLog  /var/log/apache2/nc-error.log
    SSLEngine on
    SSLProxyEngine on
    SSLCertificateFile      /etc/letsencrypt/live/XX/fullchain.pem
    SSLCertificateKeyFile /etc/letsencrypt/live/XX/privkey.pem

    # For notify_push app in NC21
    ProxyPass /push/ws ws://127.0.0.1:7867/ws
    ProxyPass /push/ http://127.0.0.1:7867/
    ProxyPassReverse /push/ http://127.0.0.1:7867/
  </VirtualHost>

  <Directory /var/www/nextcloud/>
    Options +FollowSymlinks
    AllowOverride All
    <IfModule mod_dav.c>
      Dav off
    </IfModule>
    LimitRequestBody 0
    SSLRenegBufferSize 10486000
  </Directory>
  <IfModule mod_headers.c>
    Header always set Strict-Transport-Security "max-age=15768000; includeSubDomains"
  </IfModule>
</IfModule>

@mcjoe @oerkel47 I see what’s going on, thanks. It should be fixed in the latest NCP version.

Please confirm this

In v1.39.13 its fixed. Thankx for you support:-)

Update NCP to 1.39.13
→ Update Nextcloud to 21.04 within NCP-Webpanel.
–>Certificate invalid (letsencrypt).

NCP-Webpanel shows NC updated to 21.04 but not certificate.
Letsencrypt wont update.

Tried fix “ncp-update devel”: says “no internet connection”
Restart of docker container NCP produces:
image

Webpanel of NCP is not reachable.

I have no clue where to begin :frowning:

Post output of

sudo ncp-report

via pastebin service or txt file

Confirmed. Thanks.

details>

NextCloudPi diagnostics

Cannot load Zend OPcache - it was already loaded
NextCloudPi version  v1.39.6
NextCloudPi image    NextCloudPi_docker_09-20-21
distribution         Debian GNU/Linux 10 \n \l
automount            no
USB devices          sda
datadir              /data/nextcloud/data
data in SD           yes
data filesystem      btrfs
data disk usage      706G/1.9T
rootfs usage         706G/1.9T
swapfile             /dev/zram0
dbdir                /data/database
Nextcloud check      error
HTTPD service        down
PHP service          up
MariaDB service      down
Redis service        up
HPB service          down
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               9:04

Nextcloud configuration

Cannot load Zend OPcache - it was already loaded
An unhandled exception has been thrown:
Doctrine\DBAL\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTA                                      TE[HY000] [2002] Connection refused in /data/nextcloud/lib/private/DB/Connection.php:85
Stack trace:
#0 /data/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1486): OC\DB\Connection->connect()
#1 /data/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1014): Doctrine\DBAL\Connection->getWrappe                                      dConnection()
#2 /data/nextcloud/lib/private/DB/Connection.php(226): Doctrine\DBAL\Connection->executeQuery('SELECT *                                       FROM `...', Array, Array, NULL)
#3 /data/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(210): OC\DB\Connection->executeQue                                      ry('SELECT * FROM `...', Array, Array)
#4 /data/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(287): Doctrine\DBAL\Query\QueryBuilder-                                      >execute()
#5 /data/nextcloud/lib/private/AppConfig.php(345): OC\DB\QueryBuilder\QueryBuilder->execute()
#6 /data/nextcloud/lib/private/AppConfig.php(110): OC\AppConfig->loadConfigValues()
#7 /data/nextcloud/lib/private/AppConfig.php(301): OC\AppConfig->getApps()
#8 /data/nextcloud/lib/private/legacy/OC_App.php(965): OC\AppConfig->getValues(false, 'installed_versi.                                      ..')
#9 /data/nextcloud/lib/private/Server.php(682): OC_App::getAppVersions()
#10 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(155): OC\Server->OC\{closure}(                                      Object(OC\Server))
#11 /data/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\AppFramework\Utility\Simpl                                      eContainer->OC\AppFramework\Utility\{closure}(Object(Pimple\Container))
#12 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(122): Pimple\Container->offset                                      Get('OC\\Memcache\\Fac...')
#13 /data/nextcloud/lib/private/ServerContainer.php(137): OC\AppFramework\Utility\SimpleContainer->quer                                      y('OC\\Memcache\\Fac...', false)
#14 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(56): OC\ServerContainer->query                                      ('OC\\Memcache\\Fac...')
#15 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(177): OC\AppFramework\Utility\                                      SimpleContainer->get('OC\\Memcache\\Fac...')
#16 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(155): OC\AppFramework\Utility\                                      SimpleContainer->OC\AppFramework\Utility\{closure}(Object(OC\Server))
#17 /data/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\Simpl                                      eContainer->OC\AppFramework\Utility\{closure}(Object(Pimple\Container))
#18 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(122): Pimple\Container->offset                                      Get('OCP\\ICacheFacto...')
#19 /data/nextcloud/lib/private/ServerContainer.php(137): OC\AppFramework\Utility\SimpleContainer->quer                                      y('OCP\\ICacheFacto...', false)
#20 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(56): OC\ServerContainer->query                                      ('OCP\\ICacheFacto...')
#21 /data/nextcloud/lib/private/Server.php(1031): OC\AppFramework\Utility\SimpleContainer->get('OCP\\IC                                      acheFacto...')
#22 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(155): OC\Server->OC\{closure}(                                      Object(OC\Server))
#23 /data/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\AppFramework\Utility\Simpl                                      eContainer->OC\AppFramework\Utility\{closure}(Object(Pimple\Container))
#24 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(122): Pimple\Container->offset                                      Get('OCP\\Lock\\ILocki...')
#25 /data/nextcloud/lib/private/ServerContainer.php(137): OC\AppFramework\Utility\SimpleContainer->quer                                      y('OCP\\Lock\\ILocki...', false)
#26 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(56): OC\ServerContainer->query                                      ('OCP\\Lock\\ILocki...')
#27 /data/nextcloud/lib/private/Server.php(1990): OC\AppFramework\Utility\SimpleContainer->get('OCP\\Lo                                      ck\\ILocki...')
#28 /data/nextcloud/lib/private/Files/View.php(119): OC\Server->getLockingProvider()
#29 /data/nextcloud/lib/private/Server.php(430): OC\Files\View->__construct()
#30 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(155): OC\Server->OC\{closure}(                                      Object(OC\Server))
#31 /data/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\AppFramework\Utility\Simpl                                      eContainer->OC\AppFramework\Utility\{closure}(Object(Pimple\Container))
#32 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(122): Pimple\Container->offset                                      Get('OC\\Files\\Node\\H...')
#33 /data/nextcloud/lib/private/ServerContainer.php(137): OC\AppFramework\Utility\SimpleContainer->quer                                      y('OC\\Files\\Node\\H...', false)
#34 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(56): OC\ServerContainer->query                                      ('OC\\Files\\Node\\H...')
#35 /data/nextcloud/lib/private/Server.php(1353): OC\AppFramework\Utility\SimpleContainer->get('OC\\Fil                                      es\\Node\\H...')
#36 /data/nextcloud/lib/base.php(588): OC\Server->boot()
#37 /data/nextcloud/lib/base.php(1076): OC::init()
#38 /data/nextcloud/console.php(49): require_once('/data/nextcloud...')
#39 /data/nextcloud/occ(11): require_once('/data/nextcloud...')
#40 {main}
HTTPd logs

[Fri Sep 24 04:40:48.508178 2021] [ssl:emerg] [pid 103:tid 3069627776] AH02572: Failed to configure at                                       least one certificate and key for localhost:4443
[Fri Sep 24 04:40:48.508272 2021] [ssl:emerg] [pid 103:tid 3069627776] SSL Library Error: error:0909006                                      C:PEM routines:get_name:no start line (Expecting: DH PARAMETERS) -- Bad file contents or format - or ev                                      en just a forgotten SSLCertificateKeyFile?
[Fri Sep 24 04:40:48.508341 2021] [ssl:emerg] [pid 103:tid 3069627776] SSL Library Error: error:0909006                                      C:PEM routines:get_name:no start line (Expecting: EC PARAMETERS) -- Bad file contents or format - or ev                                      en just a forgotten SSLCertificateKeyFile?
[Fri Sep 24 04:40:48.508400 2021] [ssl:emerg] [pid 103:tid 3069627776] SSL Library Error: error:140A80B                                      1:SSL routines:SSL_CTX_check_private_key:no certificate assigned
[Fri Sep 24 04:40:48.508442 2021] [ssl:emerg] [pid 103:tid 3069627776] AH02312: Fatal error initialisin                                      g mod_ssl, exiting.
AH00016: Configuration Failed
[Fri Sep 24 04:44:31.459156 2021] [mpm_event:notice] [pid 103:tid 3069242752] AH00489: Apache/2.4.38 (D                                      ebian) OpenSSL/1.1.1d configured -- resuming normal operations
[Fri Sep 24 04:44:31.459434 2021] [core:notice] [pid 103:tid 3069242752] AH00094: Command line: '/usr/s                                      bin/apache2'
[Fri Sep 24 04:46:17.346029 2021] [mpm_event:notice] [pid 103:tid 3069242752] AH00492: caught SIGWINCH,                                       shutting down gracefully
[Fri Sep 24 04:46:26.835528 2021] [mpm_event:notice] [pid 109:tid 3069656448] AH00489: Apache/2.4.38 (D                                      ebian) OpenSSL/1.1.1d configured -- resuming normal operations
[Fri Sep 24 04:46:26.835766 2021] [core:notice] [pid 109:tid 3069656448] AH00094: Command line: '/usr/s                                      bin/apache2'

Database logs

2021-09-24  4:46:27 0 [Note] InnoDB: Completed initialization of buffer pool
2021-09-24  4:46:27 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread pr                                      iority can be changed. See the man page of setpriority().
2021-09-24  4:46:27 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-09-24  4:46:27 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-09-24  4:46:27 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file                                       full; Please wait ...
2021-09-24  4:46:27 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2021-09-24  4:46:27 0 [Note] InnoDB: 10.3.22 started; log sequence number 12417353947; transaction id 3                                      2673766
2021-09-24  4:46:27 0 [Note] InnoDB: Loading buffer pool(s) from /data/database/ib_buffer_pool
2021-09-24  4:46:27 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-09-24  4:46:27 0 [Note] Server socket created on IP: '127.0.0.1'.
2021-09-24  4:46:27 0 [Note] Reading of all Master_info entries succeeded
2021-09-24  4:46:27 0 [Note] Added new Master_info '' to hash table
2021-09-24  4:46:27 0 [Note] mysqld: ready for connections.
Version: '10.3.22-MariaDB-0+deb10u1'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Debian 10
2021-09-24  4:46:27 0 [Note] InnoDB: Buffer pool(s) load completed at 210924  4:46:27
2021-09-24  5:02:15 13 [Warning] Aborted connection 13 to db: 'nextcloud' user: 'ncadmin' host: 'localh                                      ost' (Got an error reading communication packets)
2021-09-24  6:48:50 0 [Warning] The parameter innodb_file_format is deprecated and has no effect. It ma                                      y be removed in future releases. See https://mariadb.com/kb/en/library/xtradbinnodb-file-format/
2021-09-24  6:48:51 6 [ERROR] mysqld: Table './mysql/user' is marked as crashed and should be repaired
2021-09-24  6:48:51 6 [Warning] Checking table:   './mysql/user'
2021-09-24  6:48:51 6 [ERROR] mysql.user: 1 client is using or hasn't closed the table properly

Nextcloud logs

{"reqId":"YU0-lu8V1Rt@HBuE14@5GgAAVAM","level":0,"time":"2021-09-24T05:01:43+02:00","remoteAddr":"192.1                                      68.1.178","user":"--","app":"maps","method":"GET","url":"/index.php/csrftoken","message":"/appinfo/app.                                      php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","u                                      serAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/93.0                                      .4577.82 Safari/537.36","version":"21.0.4.1"}
{"reqId":"YU0-lu8V1Rt@HBuE14@5GgAAVAM","level":1,"time":"2021-09-24T05:01:43+02:00","remoteAddr":"192.1                                      68.1.178","user":"--","app":"no app in context","method":"GET","url":"/index.php/csrftoken","message":{                                      "Exception":"Symfony\\Component\\Routing\\Exception\\RouteNotFoundException","Message":"Unable to gener                                      ate a URL for the named route \"ocs.password_policy.API.generate\" as such route does not exist.","Code                                      ":0,"Trace":[{"file":"/data/nextcloud/lib/private/Route/Router.php","line":365,"function":"generate","c                                      lass":"Symfony\\Component\\Routing\\Generator\\UrlGenerator","type":"->","args":["ocs.password_policy.A                                      PI.generate",[],1]},{"file":"/data/nextcloud/lib/private/Route/CachingRouter.php","line":60,"function":                                      "generate","class":"OC\\Route\\Router","type":"->","args":["ocs.password_policy.API.generate",[],false]                                      },{"file":"/data/nextcloud/lib/private/URLGenerator.php","line":101,"function":"generate","class":"OC\\                                      Route\\CachingRouter","type":"->","args":["ocs.password_policy.API.generate",[],false]},{"file":"/data/                                      nextcloud/apps/password_policy/lib/Capabilities.php","line":57,"function":"linkToOCSRouteAbsolute","cla                                      ss":"OC\\URLGenerator","type":"->","args":["password_policy.API.generate"]},{"file":"/data/nextcloud/li                                      b/private/CapabilitiesManager.php","line":72,"function":"getCapabilities","class":"OCA\\Password_Policy                                      \\Capabilities","type":"->","args":[]},{"file":"/data/nextcloud/lib/private/Template/JSConfigHelper.php                                      ","line":183,"function":"getCapabilities","class":"OC\\CapabilitiesManager","type":"->","args":[]},{"fi                                      le":"/data/nextcloud/lib/private/TemplateLayout.php","line":211,"function":"getConfig","class":"OC\\Tem                                      plate\\JSConfigHelper","type":"->","args":[]},{"file":"/data/nextcloud/lib/private/legacy/OC_Template.p                                      hp","line":183,"function":"__construct","class":"OC\\TemplateLayout","type":"->","args":["guest","core"                                      ]},{"file":"/data/nextcloud/lib/private/Template/Base.php","line":132,"function":"fetchPage","class":"O                                      C_Template","type":"->","args":[]},{"file":"/data/nextcloud/lib/base.php","line":780,"function":"printP                                      age","class":"OC\\Template\\Base","type":"->","args":[]},{"file":"/data/nextcloud/lib/base.php","line":                                      1076,"function":"init","class":"OC","type":"::","args":[]},{"file":"/data/nextcloud/index.php","line":3                                      5,"args":["/data/nextcloud/lib/base.php"],"function":"require_once"}],"File":"/data/nextcloud/3rdparty/                                      symfony/routing/Generator/UrlGenerator.php","Line":143,"CustomMessage":"--"},"userAgent":"Mozilla/5.0 (                                      Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/93.0.4577.82 Safari/537.36",                                      "version":"21.0.4.1"}
{"reqId":"YU0-lu8V1Rt@HBuE14@5GgAAVAM","level":1,"time":"2021-09-24T05:01:43+02:00","remoteAddr":"192.1                                      68.1.178","user":"--","app":"no app in context","method":"GET","url":"/index.php/csrftoken","message":{                                      "Exception":"Symfony\\Component\\Routing\\Exception\\RouteNotFoundException","Message":"Unable to gener                                      ate a URL for the named route \"ocs.password_policy.API.validate\" as such route does not exist.","Code                                      ":0,"Trace":[{"file":"/data/nextcloud/lib/private/Route/Router.php","line":365,"function":"generate","c                                      lass":"Symfony\\Component\\Routing\\Generator\\UrlGenerator","type":"->","args":["ocs.password_policy.A                                      PI.validate",[],1]},{"file":"/data/nextcloud/lib/private/Route/CachingRouter.php","line":60,"function": 
...(too long --> removed)

Solved by friend.
Somehow the letsencrypt certificate got lost during update and apache could not start.
Solution was to copy the certificates from btrfs snapshot.
Thank you!