It runs the following containers :
Here my issue is with postgres. I m running postgres 13, and try to follow all upgrade of nextcloud and postgres.
This time, I would like to upgrade from postgres 13 to postgres 15
But it seems the password encryption changed from V13 to V14(and V15)
It went from md5 to SCRAM.
So when I update from postgres v13 to v15, I get the “Internal Server error” on my browser.
and in syslog I get the following error message :
Dec 18 17:32:00 Nuage nextcloud-postgres\[3123447\]: 2022-12-18 16:32:00.114 UTC \[43\] FATAL: password authentication failed for user "oc\_feydreva"
Dec 18 17:32:00 Nuage nextcloud-postgres\[3123447\]: 2022-12-18 16:32:00.114 UTC \[43\] DETAIL: User "oc\_feydreva" does not have a valid SCRAM secret.
Is this the first time you’ve seen this error? (Y/N): Each time I tryu to upgrade from pgsql v13 to v15
Steps to replicate it:
upgrade pgsql to v15
There is no log to show, since nextcloud doesn’t start at all.
As anybody been able to upgrade its db from v13 to v14 and v15 ?
AFAIK there is no “upgrade” for Postgres - you need to dump/backup and restore into new version. Usually if there is braking change you will find upgrade procedures in the release notes of specific software version.
As this question is related to Postgres I think it better to ask this question at Postgres forum - likely you get better answers there.
Starting V14, password encryption is SCRAM instead of md5… that s why I get a SCRAM error.
I can change the pg_hba.conf from
host all all all scram-sha-256
host all all all md5
and get password working, but after that i get an aother error :
sudo docker exec -it nextcloud-apache php occ upgrade
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
Exception: Database error when running migration 25000Date20220602190540 for app core
An exception occurred while executing a query: SQLSTATE: Insufficient privilege: 7 ERROR: permission denied for schema public
Maintenance mode is kept active