From owner-freebsd-ports-bugs@freebsd.org Sat Oct 3 10:32:05 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 DFF8642AF7D for ; Sat, 3 Oct 2020 10:32:05 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from mailman.nyi.freebsd.org (mailman.nyi.freebsd.org [IPv6:2610:1c1:1:606c::50:13]) by mx1.freebsd.org (Postfix) with ESMTP id 4C3NTK5fYWz4Cx3 for ; Sat, 3 Oct 2020 10:32:05 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: by mailman.nyi.freebsd.org (Postfix) id C204D42B0C8; Sat, 3 Oct 2020 10:32:05 +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 C1CCF42B1A5 for ; Sat, 3 Oct 2020 10:32:05 +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 4C3NTK4qTBz4Cnk for ; Sat, 3 Oct 2020 10:32:05 +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 89B4911D23 for ; Sat, 3 Oct 2020 10:32:05 +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 093AW514045288 for ; Sat, 3 Oct 2020 10:32:05 GMT (envelope-from bugzilla-noreply@freebsd.org) Received: (from www@localhost) by kenobi.freebsd.org (8.15.2/8.15.2/Submit) id 093AW5In045285 for ports-bugs@FreeBSD.org; Sat, 3 Oct 2020 10:32:05 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 250068] databases/postgres12-server: psql: error: could not connect to server: server closed the connection unexpectedly Date: Sat, 03 Oct 2020 10:32:05 +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 Only Me X-Bugzilla-Who: ohartmann@walstatt.org X-Bugzilla-Status: New X-Bugzilla-Resolution: X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: ports-bugs@FreeBSD.org X-Bugzilla-Flags: X-Bugzilla-Changed-Fields: bug_id short_desc product version rep_platform op_sys bug_status bug_severity priority component assigned_to reporter 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, 03 Oct 2020 10:32:05 -0000 https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D250068 Bug ID: 250068 Summary: databases/postgres12-server: psql: error: could not connect to server: server closed the connection unexpectedly Product: Ports & Packages Version: Latest Hardware: Any OS: Any Status: New Severity: Affects Only Me Priority: --- Component: Individual Port(s) Assignee: ports-bugs@FreeBSD.org Reporter: ohartmann@walstatt.org Running databases/postgresql12on a recent CURRENT (at the moment FreeBSD 13.0-CURRENT #50 r366364: Fri Oct 2 17:51:18 CEST 2020 amd64). The problem persists a couple of months for now, last checked in March 2020. OS and por= ts are updated on a regular basis. Host is running dual stack IPv4 and IPv6. We switched password encryption from md5 to scram-sha-256 and I believe sin= ce then the mysterious problems occured, not sure. But I'll proceed and explai= n. postgresql.conf has been adapted as well via "password_encryption =3D scram-sha-256". Passwords in question have been changed within databases accordingly, especially the passowrd for database superuser "postgres". pg_hba.conf has been adapted accordingly as well: local all postgres scram-sha-256|trust # alternative for tests host all postgres 127.0.0.1/32 scram-sha-256 host all postgres ::1/128 scram-sha-256 The server is listening on all addresses, checked via sockstat. Trying to login on any database with the owner of the database or even post= gres results in: psql -U postgres -d postgres -h localhost -W (or IP of the host, even 127.0= .0.1 or ::1)=20 Result: psql: error: could not connect to server: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. Login omitting -h localhost (or IP) is all right. Login via any on-host cli= ent authenticating locally fails. Login via remote session from another host us= ing psql client also results in a fail. There are other users accessing databases and authentication via LDAP (OpenLDAP). This works from the local host as well from remote hosts. Looking at log protocolls revela nothing. The failed logins seeme to bee se= en by the server, the server logs aline like LOG: connection received: host=3Dlocalhost port=3D37906 Then nothing and after a while I receive the error=20 psql: error: could not connect to server: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. This might be a bug. --=20 You are receiving this mail because: You are the assignee for the bug.=