From owner-freebsd-ports-bugs@freebsd.org Sat Sep 5 17:10:58 2020 Return-Path: Delivered-To: freebsd-ports-bugs@mailman.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.nyi.freebsd.org (Postfix) with ESMTP id 770FF3D1532 for ; Sat, 5 Sep 2020 17:10:58 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from mailman.nyi.freebsd.org (unknown [127.0.1.3]) by mx1.freebsd.org (Postfix) with ESMTP id 4BkLfV2gy3z4fYb for ; Sat, 5 Sep 2020 17:10:58 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: by mailman.nyi.freebsd.org (Postfix) id 5BF8E3D1531; Sat, 5 Sep 2020 17:10:58 +0000 (UTC) Delivered-To: ports-bugs@mailman.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.nyi.freebsd.org (Postfix) with ESMTP id 5BBC53D1530 for ; Sat, 5 Sep 2020 17:10:58 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "mxrelay.nyi.freebsd.org", Issuer "Let's Encrypt Authority X3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4BkLfV1sj4z4fWj for ; Sat, 5 Sep 2020 17:10:58 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from kenobi.freebsd.org (kenobi.freebsd.org [IPv6:2610:1c1:1:606c::50:1d]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (Client did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id 2390321287 for ; Sat, 5 Sep 2020 17:10:58 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from kenobi.freebsd.org ([127.0.1.5]) by kenobi.freebsd.org (8.15.2/8.15.2) with ESMTP id 085HAw9h049745 for ; Sat, 5 Sep 2020 17:10:58 GMT (envelope-from bugzilla-noreply@freebsd.org) Received: (from www@localhost) by kenobi.freebsd.org (8.15.2/8.15.2/Submit) id 085HAwcs049744 for ports-bugs@FreeBSD.org; Sat, 5 Sep 2020 17:10:58 GMT (envelope-from bugzilla-noreply@freebsd.org) X-Authentication-Warning: kenobi.freebsd.org: www set sender to bugzilla-noreply@freebsd.org using -f From: bugzilla-noreply@freebsd.org To: ports-bugs@FreeBSD.org Subject: [Bug 249129] www/nextcloud: PostgreSQL 12.4 connection problems (scram-sha-256) Date: Sat, 05 Sep 2020 17:10:57 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: new X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: Ports & Packages X-Bugzilla-Component: Individual Port(s) X-Bugzilla-Version: Latest X-Bugzilla-Keywords: X-Bugzilla-Severity: Affects Some People X-Bugzilla-Who: ohartmann@walstatt.org X-Bugzilla-Status: New X-Bugzilla-Resolution: X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: brnrd@freebsd.org X-Bugzilla-Flags: maintainer-feedback? X-Bugzilla-Changed-Fields: bug_id short_desc product version rep_platform op_sys bug_status bug_severity priority component assigned_to reporter flagtypes.name Message-ID: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Bugzilla-URL: https://bugs.freebsd.org/bugzilla/ Auto-Submitted: auto-generated MIME-Version: 1.0 X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.33 Precedence: list List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 05 Sep 2020 17:10:58 -0000 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.=