[Bug]: Upgrade to nextcloud 28.0.10 fails with Database error when running migration for app oauth2 [OpenProject integration] #48267
Labels
0. Needs triage
Pending check for reproducibility or if it fits our roadmap
28-feedback
bug
feature: authentication
feature: install and update
integration
Comments
cybertschunk
added
0. Needs triage
|
the nextcloud server log |
|
Coming from a recent change made in #47635. The error suggests one of your server/apps/oauth2/lib/Migration/Version011901Date20240829164356.php Lines 34 to 41 in 77c1db0 server/lib/private/Security/Crypto.php Lines 108 to 114 in 77c1db0
|
|
cc @julien-nc |
|
Thanks for looking into our bug report! I hope the infos provided below answer your questions. If there is anything else I can assist you with please let me know. We use oauth2 for our OpenProject integration. The format of our oauth2_clients table is as following: The content is as follow: |
|
@cybertschunk Hi. This is most likely because the OpenProject integration app that created this OAuth client was not in tune with the server at the moment it created it. Let me clarify 😁 . I think what happened is: The OAuth client was created by the OpenProject app while the server was in a (B) state. But the OpenProject app was not up-to-date and it created it unencrypted. And now the server migration is failing to decrypt the value when trying to migrate to (C). The easy way to get out of this would be to delete this OAuth app and reconfigure the OpenProject integration. Make sure you are using integration_openproject v2.7.0 which knows it has to hash the secret on Nextcloud 28.0.10. Does that make sense? |
|
hey @julien-nc thanks so much for your explanation! I will try out the steps outlined by you and keep you posted on how it went. Shall I open a bug report on the integration repo then so they can fix this issue? |
joshtrichards
changed the title
|
@cybertschunk As far as I know they have been informed and the next (or current latest) release of integration_openproject should be fine. |
|
Feel free to reopen this issue if needed. |
|
I performed the upgrade as you instructed and it worked just fine. Thanks so much for your help! |
|
You're welcome. Thanks for the feedback. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Bug description
When we try to upgrade our nextcloud version from 28.0.9 to 28.0.10 the upgrade fails with the following error:
Steps to reproduce
Expected behavior
The nextcloud installation updates to 28.0.10
Nextcloud Server version
28
Operating system
Other
PHP engine version
Other
Web server
Nginx
Database engine version
PostgreSQL
Is this bug present after an update or on a fresh install?
Updated from a MINOR version (ex. 28.0.1 to 28.0.2)
Are you using the Nextcloud Server Encryption module?
None
What user-backends are you using?
Configuration report
{ "system": { "instanceid": "***REMOVED SENSITIVE VALUE***", "passwordsalt": "***REMOVED SENSITIVE VALUE***", "datadirectory": "***REMOVED SENSITIVE VALUE***", "dbtype": "pgsql", "version": "28.0.9.1", "dbname": "***REMOVED SENSITIVE VALUE***", "dbhost": "***REMOVED SENSITIVE VALUE***", "dbtableprefix": "oc_", "dbuser": "***REMOVED SENSITIVE VALUE***", "dbpassword": "***REMOVED SENSITIVE VALUE***", "installed": true, "ldapIgnoreNamingRules": false, "loglevel": 0, "theme": "", "defaultapp": "files", "maintenance": true, "lost_password_link": "https:\/\/account.gremien-uzl.de\/", "trusted_domains": [ "files.asta.uni-luebeck.de", "141.83.153.154", "app-server", "nginx-serer", "onlyoffice-document-server" ], "allow_local_remote_servers": true, "share_folder": "\/Shared", "mail_smtpmode": "smtp", "secret": "***REMOVED SENSITIVE VALUE***", "mail_from_address": "***REMOVED SENSITIVE VALUE***", "mail_domain": "***REMOVED SENSITIVE VALUE***", "forcessl": true, "trashbin_retention_obligation": "30,60", "versions_retention_obligation": "auto, 730", "logtimezone": "Europe\/Berlin", "enable_previews": true, "updatechecker": false, "singleuser": false, "ldapProviderFactory": "\\OCA\\User_LDAP\\LDAPProviderFactory", "overwritehost": "files.asta.uni-luebeck.de", "overwriteprotocol": "https", "mail_smtphost": "***REMOVED SENSITIVE VALUE***", "mail_smtpsecure": "tls", "mail_smtpport": "587", "mail_smtpauthtype": "LOGIN", "mail_smtpauth": 1, "mail_smtpname": "***REMOVED SENSITIVE VALUE***", "mail_smtppassword": "***REMOVED SENSITIVE VALUE***", "debug": false, "onlyoffice": { "verify_peer_off": true }, "csrf.optout": [ "\/^WebDAVFS\/", "\/^Microsoft-WebDAV-MiniRedir\/", "\/KeeWeb\\\/\\d+[.]\\d+[.]\\d+\/" ], "htaccess.RewriteBase": "\/", "memcache.local": "\\OC\\Memcache\\APCu", "apps_paths": [ { "path": "\/var\/www\/html\/apps", "url": "\/apps", "writable": false }, { "path": "\/var\/www\/html\/custom_apps", "url": "\/custom_apps", "writable": true } ], "memcache.distributed": "\\OC\\Memcache\\Redis", "memcache.locking": "\\OC\\Memcache\\Redis", "redis": { "host": "***REMOVED SENSITIVE VALUE***", "port": 6379 }, "overwrite.cli.url": "https:\/\/files.asta.uni-luebeck.de", "mail_sendmailmode": "smtp", "updater.server.url": "***REMOVED SENSITIVE VALUE***", "updater.release.channel": "enterprise", "default_phone_region": "DE", "maintenance_window_start": 2 } }List of activated Apps
Nextcloud Signing status
Nextcloud Logs
too long for GitHubAdditional info
we use the community docker image for nextcloud
The text was updated successfully, but these errors were encountered: