[Bug 249129] www/nextcloud: PostgreSQL 12.4 connection problems (scram-sha-256)

[bugzilla-noreply at freebsd.org]

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=249129

            Bug ID: 249129
           Summary: www/nextcloud: PostgreSQL 12.4 connection problems
                    (scram-sha-256)
           Product: Ports & Packages
           Version: Latest
          Hardware: Any
                OS: Any
            Status: New
          Severity: Affects Some People
          Priority: ---
         Component: Individual Port(s)
          Assignee: brnrd at freebsd.org
          Reporter: ohartmann at walstatt.org
             Flags: maintainer-feedback?(brnrd at freebsd.org)
          Assignee: brnrd at freebsd.org

Running www/nextcloud on recent CURRENT (FreeBSD 13.0-CURRENT #3 r365358: Sat
Sep  5 09:03:14 CEST 2020 amd64) with PostgreSQL backend on the same host
(localhost), PostgreSQL is 12.4 and up to date according to recent ports tree
(). 

The problem reported here is longstanding and has been introduced somehow with
nextcloud 18 and the migration towards postgresql 12. Due to several security
requirements, "security" (encryption) of local passwords has moved from md5 to
scram-sha-256 (for the record, if necessary info).

The problem in general is: I can not access an installation of nextcloud via
most recent www/nextcloud. It seems the database is inaccessible, but local or
remote logins via PostgreSQL's client psql work fine, even the login to the
database "nextcloud", as "oc_administrator", which is owner of db "nextcloud"
and granted with all access and rights necessary. Since my abilities in php are
limited, I haven't checked whether the problem could php related.

Trying to investigate logs fail: postgresql logs to syslog and file with level
"notice" and do not show anything unusual. The output shown below is taken from 

"su -m www -c "php ./occ upgrade" issued with folder /usr/local/www/nextcloud.

[...]
An unhandled exception has been thrown:
OC\DatabaseException: An exception occurred while executing 'SHOW
SERVER_VERSION':

Failed to connect to the database: An exception occurred in driver:
SQLSTATE[08006] [7] server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request. in
/usr/local/www/nextcloud/lib/private/legacy/OC_DB.php:73
Stack trace:
#0 /usr/local/www/nextcloud/lib/private/legacy/OC_DB.php(139):
OC_DB::prepare('SHOW SERVER_VER...', NULL, NULL)
#1 /usr/local/www/nextcloud/lib/private/legacy/OC_Util.php(971):
OC_DB::executeAudited(Array)
#2 /usr/local/www/nextcloud/lib/private/legacy/OC_Util.php(951):
OC_Util::checkDatabaseVersion()
#3 /usr/local/www/nextcloud/lib/private/Console/Application.php(161):
OC_Util::checkServer(Object(OC\SystemConfig))
#4 /usr/local/www/nextcloud/console.php(99):
OC\Console\Application->loadCommands(Object(Symfony\Component\Console\Input\ArgvInput),
Object(Symfony\Component\Console\Output\ConsoleOutput))
#5 /usr/local/www/nextcloud/occ(11): require_once('/usr/local/www/...')

-- 
You are receiving this mail because:
You are the assignee for the bug.