Date: Sat, 05 Sep 2020 17:10:57 +0000 From: bugzilla-noreply@freebsd.org To: ports-bugs@FreeBSD.org Subject: [Bug 249129] www/nextcloud: PostgreSQL 12.4 connection problems (scram-sha-256) Message-ID: <bug-249129-7788@https.bugs.freebsd.org/bugzilla/>
next in thread | raw e-mail | index | archive | help
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D249129 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@freebsd.org Reporter: ohartmann@walstatt.org Flags: maintainer-feedback?(brnrd@freebsd.org) Assignee: brnrd@freebsd.org Running www/nextcloud on recent CURRENT (FreeBSD 13.0-CURRENT #3 r365358: S= at 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 tr= ee ().=20 The problem reported here is longstanding and has been introduced somehow w= ith nextcloud 18 and the migration towards postgresql 12. Due to several securi= ty 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 "nextclou= d" 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 le= vel "notice" and do not show anything unusual. The output shown below is taken = from=20 "su -m www -c "php ./occ upgrade" issued with folder /usr/local/www/nextclo= ud. [...] 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/...') --=20 You are receiving this mail because: You are the assignee for the bug.=
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-249129-7788>