[Solve]Update error 27 -> 28

Hello,

I’ve had a problem with my nextcloud since I tried to update it.
It’s a small installation, with sqlite, and I’m the only one who uses it regularly.
Here’s the data.
Thank you in advance for your help, I absolutely need to find my agenda.
EM

The Basics

  • Nextcloud Server version (e.g., 28,0,14,1):
  • Operating system, version (e.g., Debian GNU/Linux 9.13 (stretch)):
  • Web server and version (e.g, Apache/2.4.43 (Unix)):
  • Reverse proxy and version _(e.g. nginx 1.27.2)
    • non installé
  • PHP version ( PHP Version 8.1.30):
  • Is this the first time you’ve seen this error? (No):
  • When did this problem seem to first start ?
    • when i try to update
  • Installation method (e.g. AlO, NCP, Bare Metal/Archive, etc.)
  • Are you using CloudfIare, mod_security, or similar?
    • ( ??? )
  • When I try to connect, I get a problem.
errors uring the update
$ php occ upgrade
The current PHP memory limit is below the recommended value of 512MB.
Nextcloud or one of the apps require upgrade - only a limited number of commands are available
You may use your browser or the occ upgrade command to do the upgrade
Setting log level to debug
Turned on maintenance mode
Updating database schema
Updated database
Disabled incompatible app: calendar
Disabled incompatible app: contacts
Disabled incompatible app: external
Disabled incompatible app: files_downloadlimit
Disabled incompatible app: mail
Disabled incompatible app: notes
Disabled incompatible app: polls
Disabled incompatible app: tasks
Updating <lookup_server_connector> ...
Updated <lookup_server_connector> to 1.16.0
Updating <oauth2> ...
Updated <oauth2> to 1.16.4
Updating <password_policy> ...
Updated <password_policy> to 1.18.0
Updating <files> ...
Updated <files> to 2.0.0
Updating <cloud_federation_api> ...
Updated <cloud_federation_api> to 1.11.0
Updating <dav> ...
Fix broken values of calendar objects

 Done
    0/0 [->--------------------------]   0%
Clean up old calendar subscriptions from deleted users that were not cleaned-up
 Done
    0/0 [----->----------------------]   0%
Updated <dav> to 1.29.2
Updating <files_sharing> ...
Updated <files_sharing> to 1.20.0
Updating <files_trashbin> ...
Updated <files_trashbin> to 1.18.0
Updating <files_versions> ...
Updated <files_versions> to 1.21.0
Updating <sharebymail> ...
Updated <sharebymail> to 1.18.0
Updating <workflowengine> ...
Updated <workflowengine> to 2.10.0
Updating <admin_audit> ...
Updated <admin_audit> to 1.18.0
Updating <comments> ...
Updated <comments> to 1.18.0
Updating <logreader> ...
Updated <logreader> to 2.13.0
Updating <nextcloud_announcements> ...
Updated <nextcloud_announcements> to 1.17.0
Updating <notifications> ...
Updated <notifications> to 2.16.0
Updating <theming> ...
Updated <theming> to 2.3.0
Updating <bruteforcesettings> ...
Updated <bruteforcesettings> to 2.8.0
Updating <dashboard> ...
Updated <dashboard> to 7.8.0
Updating <federatedfilesharing> ...
Updated <federatedfilesharing> to 1.18.0
Updating <files_pdfviewer> ...
Updated <files_pdfviewer> to 2.9.0
Updating <files_reminders> ...
Updated <files_reminders> to 1.1.0
Updating <privacy> ...
Updated <privacy> to 1.12.0
Updating <provisioning_api> ...
Updated <provisioning_api> to 1.18.0
Updating <recommendations> ...
Updated <recommendations> to 2.0.0
Updating <related_resources> ...
Updated <related_resources> to 1.3.0
Updating <settings> ...
Updated <settings> to 1.10.1
Updating <support> ...
Updated <support> to 1.11.1
Updating <survey_client> ...
Updated <survey_client> to 1.16.0
Updating <text> ...
Updated <text> to 3.9.2
Updating <twofactor_backupcodes> ...
Updated <twofactor_backupcodes> to 1.17.0
Updating <updatenotification> ...
Updated <updatenotification> to 1.18.0
Updating <user_status> ...
Updated <user_status> to 1.8.1
Updating <viewer> ...
Updated <viewer> to 2.2.0
Restore default tags that are missing
 Done
    0/0 [--------->------------------]   0%
Purify and migrate collected mail addresses
 Done
    0/0 [------------->--------------]   0%
Insert background jobs for all accounts
 Done
    0/0 [---------------->-----------]   0%
Starting code integrity check...
Finished code integrity check
Update successful
Turned off maintenance mode
Resetting log level
hosting-user@Mon-serveur:/srv/data/web/vhosts/cloud.ahds.name/htdocs$ 
return : occ db:add-missing-indices
php occ db:add-missing-indices
The current PHP memory limit is below the recommended value of 512MB.

Summary of the issue you are facing:

When I try to connect, I have a problem.

error intern du serveur
Nextcloud
Erreur interne du serveur

Le serveur est incapable d'exécuter votre requête.

Si cela se reproduit, veuillez envoyer les détails techniques ci-dessous à l'administrateur du serveur.

Le fichier journal du serveur peut fournir plus de renseignements.
Renseignements techniques

    Adresse distante : 2a02:a03f:6a30:ed00:3759:12b8:3407:7333
    ID de la demande : UajguK7jWXFZ2SSmBQnV
    Type : DomainException
    Code : 0
    Message : OpenSSL unable to sign data
    Fichier : /srv/data/web/vhosts/cloud.ahds.name/htdocs/apps/external/lib/Vendor/Firebase/JWT/JWT.php
    Ligne : 255


Trace

#0 /srv/data/web/vhosts/cloud.ahds.name/htdocs/apps/external/lib/Vendor/Firebase/JWT/JWT.php(218): OCA\External\Vendor\Firebase\JWT\JWT::sign()
#1 /srv/data/web/vhosts/cloud.ahds.name/htdocs/apps/external/lib/JWTManager.php(64): OCA\External\Vendor\Firebase\JWT\JWT::encode()
#2 /srv/data/web/vhosts/cloud.ahds.name/htdocs/apps/external/lib/SitesManager.php(136): OCA\External\JWTManager->getToken()
#3 /srv/data/web/vhosts/cloud.ahds.name/htdocs/apps/external/lib/BeforeTemplateRenderedListener.php(107): OCA\External\SitesManager->getSitesToDisplay()
#4 /srv/data/web/vhosts/cloud.ahds.name/htdocs/apps/external/lib/BeforeTemplateRenderedListener.php(63): OCA\External\BeforeTemplateRenderedListener->generateNavigationLinks()
#5 /srv/data/web/vhosts/cloud.ahds.name/htdocs/lib/private/EventDispatcher/ServiceEventListener.php(86): OCA\External\BeforeTemplateRenderedListener->handle()
#6 /srv/data/web/vhosts/cloud.ahds.name/htdocs/3rdparty/symfony/event-dispatcher/EventDispatcher.php(230): OC\EventDispatcher\ServiceEventListener->__invoke()
#7 /srv/data/web/vhosts/cloud.ahds.name/htdocs/3rdparty/symfony/event-dispatcher/EventDispatcher.php(59): Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
#8 /srv/data/web/vhosts/cloud.ahds.name/htdocs/lib/private/EventDispatcher/EventDispatcher.php(94): Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
#9 /srv/data/web/vhosts/cloud.ahds.name/htdocs/lib/private/EventDispatcher/EventDispatcher.php(106): OC\EventDispatcher\EventDispatcher->dispatch()
#10 /srv/data/web/vhosts/cloud.ahds.name/htdocs/lib/private/AppFramework/Middleware/AdditionalScriptsMiddleware.php(53): OC\EventDispatcher\EventDispatcher->dispatchTyped()
#11 /srv/data/web/vhosts/cloud.ahds.name/htdocs/lib/private/AppFramework/Middleware/MiddlewareDispatcher.php(142): OC\AppFramework\Middleware\AdditionalScriptsMiddleware->afterController()
#12 /srv/data/web/vhosts/cloud.ahds.name/htdocs/lib/private/AppFramework/Http/Dispatcher.php(175): OC\AppFramework\Middleware\MiddlewareDispatcher->afterController()
#13 /srv/data/web/vhosts/cloud.ahds.name/htdocs/lib/private/AppFramework/App.php(184): OC\AppFramework\Http\Dispatcher->dispatch()
#14 /srv/data/web/vhosts/cloud.ahds.name/htdocs/lib/private/Route/Router.php(315): OC\AppFramework\App::main()
#15 /srv/data/web/vhosts/cloud.ahds.name/htdocs/lib/base.php(1069): OC\Route\Router->match()
#16 /srv/data/web/vhosts/cloud.ahds.name/htdocs/index.php(39): OC::handleRequest()
#17 {main}

Steps to replicate it (hint: details matter!):

Purge the cache of firefox and try to log

Log entries

Nextcloud

In nextcloud.log, I find these messages every time I try to log in.

errors message
{"reqId":"kQEG176y3a9zBKxRiZa6","level":4,"time":"2024-12-24T12:02:09+00:00","remoteAddr":"2a02:a03f:6a30:ed00:3759:12b8:3407:7333","user":"amh","app":"no app in context","method":"GET","url":"/index.php/apps/theming/favicon?v=9c2e8f70","message":"Could not boot external: OpenSSL unable to sign data","userAgent":"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:128.0) Gecko/20100101 Firefox/128.0","version":"28.0.14.1","exception":{"Exception":"DomainException","Message":"OpenSSL unable to sign data","Code":0,"Trace":[{"file":"/srv/data/web/vhosts/cloud.ahds.name/htdocs/apps/external/lib/Vendor/Firebase/JWT/JWT.php","line":218,"function":"sign","class":"OCA\\External\\Vendor\\Firebase\\JWT\\JWT","type":"::"},{"file":"/srv/data/web/vhosts/cloud.ahds.name/htdocs/apps/external/lib/JWTManager.php","line":64,"function":"encode","class":"OCA\\External\\Vendor\\Firebase\\JWT\\JWT","type":"::"},{"file":"/srv/data/web/vhosts/cloud.ahds.name/htdocs/apps/external/lib/SitesManager.php","line":136,"function":"getToken","class":"OCA\\External\\JWTManager","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/srv/data/web/vhosts/cloud.ahds.name/htdocs/apps/external/lib/AppInfo/Application.php","line":62,"function":"getSitesToDisplay","class":"OCA\\External\\SitesManager","type":"->"},{"file":"/srv/data/web/vhosts/cloud.ahds.name/htdocs/lib/private/AppFramework/Bootstrap/FunctionInjector.php","line":66,"function":"registerSites","class":"OCA\\External\\AppInfo\\Application","type":"->"},{"file":"/srv/data/web/vhosts/cloud.ahds.name/htdocs/lib/private/AppFramework/Bootstrap/BootContext.php","line":50,"function":"injectFn","class":"OC\\AppFramework\\Bootstrap\\FunctionInjector","type":"->"},{"file":"/srv/data/web/vhosts/cloud.ahds.name/htdocs/apps/external/lib/AppInfo/Application.php","line":54,"function":"injectFn","class":"OC\\AppFramework\\Bootstrap\\BootContext","type":"->"},{"file":"/srv/data/web/vhosts/cloud.ahds.name/htdocs/lib/private/AppFramework/Bootstrap/Coordinator.php","line":200,"function":"boot","class":"OCA\\External\\AppInfo\\Application","type":"->"},{"file":"/srv/data/web/vhosts/cloud.ahds.name/htdocs/lib/private/App/AppManager.php","line":434,"function":"bootApp","class":"OC\\AppFramework\\Bootstrap\\Coordinator","type":"->"},{"file":"/srv/data/web/vhosts/cloud.ahds.name/htdocs/lib/private/App/AppManager.php","line":213,"function":"loadApp","class":"OC\\App\\AppManager","type":"->"},{"file":"/srv/data/web/vhosts/cloud.ahds.name/htdocs/lib/private/legacy/OC_App.php","line":125,"function":"loadApps","class":"OC\\App\\AppManager","type":"->"},{"file":"/srv/data/web/vhosts/cloud.ahds.name/htdocs/lib/base.php","line":1049,"function":"loadApps","class":"OC_App","type":"::"},{"file":"/srv/data/web/vhosts/cloud.ahds.name/htdocs/index.php","line":39,"function":"handleRequest","class":"OC","type":"::"}],"File":"/srv/data/web/vhosts/cloud.ahds.name/htdocs/apps/external/lib/Vendor/Firebase/JWT/JWT.php","Line":255,"message":"Could not boot external: OpenSSL unable to sign data","exception":{},"CustomMessage":"Could not boot external: OpenSSL unable to sign data"}}
{"reqId":"aKCFVy0SgMPaAPCrueHV","level":3,"time":"2024-12-24T12:32:50+00:00","remoteAddr":"2a02:a03f:6a30:ed00:3759:12b8:3407:7333","user":"amh","app":"PHP","method":"GET","url":"/","message":"openssl_sign(): Supplied key param cannot be coerced into a private key at /srv/data/web/vhosts/cloud.ahds.name/htdocs/apps/external/lib/Vendor/Firebase/JWT/JWT.php#253","userAgent":"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:128.0) Gecko/20100101 Firefox/128.0","version":"28.0.14.1","data":{"app":"PHP"}}

Web Browser

No errors on my server in apache or php

Configuration

Nextcloud

The output of occ config:list system or similar is best, but, if not possible, the contents of your config.php file from /path/to/nextcloud is fine (make sure to remove any identifiable information!):

occ config:list
php occ config:list system 
The current PHP memory limit is below the recommended value of 512MB.
{
    "system": {
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "cloud.ahds.name",
            "hassoun.be",
            "www.hassoun.be"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "sqlite3",
        "version": "28.0.14.1",
        "installed": true,
        "overwrite.cli.url": "https:\/\/cloud.ahds.name",
        "overwriteprotocol": "https",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpmode": "smtp",
        "mail_sendmailmode": "smtp",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "465",
        "mail_smtpsecure": "ssl",
        "mail_smtpauth": 1,
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "default_phone_region": ".be",
        "app_install_overwrite": [
            "mindmap_app",
            "backup",
            "mail_roundcube"
        ],
        "debug": true,
        "maintenance": false,
        "theme": "",
        "loglevel": 2
    }
}
hosting-user@Mon-serveur:/srv/data/web/vhosts/cloud.ahds.name/htdocs$ 

Apps

The output of `occ app:list`
php occ app:list
The current PHP memory limit is below the recommended value of 512MB.
Enabled:
  - admin_audit: 1.18.0
  - bruteforcesettings: 2.8.0
  - calendar: 4.7.16
  - cloud_federation_api: 1.11.0
  - comments: 1.18.0
  - contacts: 5.5.3
  - dashboard: 7.8.0
  - dav: 1.29.2
  - external: 5.3.1
  - federatedfilesharing: 1.18.0
  - files: 2.0.0
  - files_downloadlimit: 1.2.0
  - files_pdfviewer: 2.9.0
  - files_reminders: 1.1.0
  - files_sharing: 1.20.0
  - files_trashbin: 1.18.0
  - files_versions: 1.21.0
  - logreader: 2.13.0
  - lookup_server_connector: 1.16.0
  - mail: 3.7.17
  - nextcloud_announcements: 1.17.0
  - notes: 4.11.0
  - notifications: 2.16.0
  - oauth2: 1.16.4
  - password_policy: 1.18.0
  - polls: 7.2.5
  - privacy: 1.12.0
  - provisioning_api: 1.18.0
  - recommendations: 2.0.0
  - related_resources: 1.3.0
  - settings: 1.10.1
  - sharebymail: 1.18.0
  - support: 1.11.1
  - survey_client: 1.16.0
  - tasks: 0.16.1
  - text: 3.9.2
  - theming: 2.3.0
  - twofactor_backupcodes: 1.17.0
  - updatenotification: 1.18.0
  - user_status: 1.8.1
  - viewer: 2.2.0
  - workflowengine: 2.10.0
Disabled:
  - activity: 2.20.0 (installed 2.19.0)
  - circles: 28.0.0 (installed 27.0.1)
  - contactsinteraction: 1.9.0 (installed 1.8.0)
  - encryption: 2.16.0
  - federation: 1.18.0 (installed 1.17.0)
  - files_external: 1.20.0 (installed 1.19.0)
  - firstrunwizard: 2.17.0 (installed 2.16.0)
  - photos: 2.4.0 (installed 2.3.0)
  - serverinfo: 1.18.0 (installed 1.17.0)
  - suspicious_login: 6.0.0
  - systemtags: 1.18.0 (installed 1.17.0)
  - twofactor_totp: 10.0.0-beta.2
  - user_ldap: 1.19.0 (installed 1.17.0)
  - weather_status: 1.8.0 (installed 1.7.0)

Hi @emena.

Debian 9 (stretch) end of LTS Support was end of june in 2022, that is 2 years and 5 months ago!!

That version is not supported any more!
(Or did you not fill out the template corect?)


Alter the memory in the php.ini of the sapi in use.


The internal server error and the error messages in the logfile come from the app “external”.
It looks like something is wrong with openssl.

As a workaround you should disable that app or fix the openssl error.

h.t.h.


Much and good luck,
ernolf

Thank you for your reply,

I’m on a shared gandi host, it’s debian, I’ve checked.
I don’t have more memory, but since I’m almost the only one personne using the site, it’s never caused any performance problems.

I can do without the “external” application, it’s just a convenience. I’m looking for a clean way to disable it without logging in. If you know the solution by heart, I’m interested.

I have found : php occ app:disable external

Thanks again
Happy holidays
EM

MERCI

It work