From nobody Thu Jul 15 11:28:38 2021 X-Original-To: ports-bugs@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 24A9C127488E for ; Thu, 15 Jul 2021 11:28:38 +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 "R3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4GQXF20JRXz4m3W for ; Thu, 15 Jul 2021 11:28:38 +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 E24BB9EA for ; Thu, 15 Jul 2021 11:28:37 +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 16FBSbbc047810 for ; Thu, 15 Jul 2021 11:28:37 GMT (envelope-from bugzilla-noreply@freebsd.org) Received: (from www@localhost) by kenobi.freebsd.org (8.15.2/8.15.2/Submit) id 16FBSbTw047809 for ports-bugs@FreeBSD.org; Thu, 15 Jul 2021 11:28:37 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 257201] databases/postgresql13-{server|client}: SSL SYSCALL error: EOF detected Date: Thu, 15 Jul 2021 11:28:38 +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 Many People X-Bugzilla-Who: ohartmann@walstatt.org X-Bugzilla-Status: New X-Bugzilla-Resolution: X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: pgsql@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 List-Id: Ports bug reports List-Archive: https://lists.freebsd.org/archives/freebsd-ports-bugs List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-ports-bugs@freebsd.org X-BeenThere: freebsd-ports-bugs@freebsd.org MIME-Version: 1.0 X-ThisMailContainsUnwantedMimeParts: N https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D257201 Bug ID: 257201 Summary: databases/postgresql13-{server|client}: SSL SYSCALL error: EOF detected Product: Ports & Packages Version: Latest Hardware: Any OS: Any Status: New Severity: Affects Many People Priority: --- Component: Individual Port(s) Assignee: pgsql@FreeBSD.org Reporter: ohartmann@walstatt.org Flags: maintainer-feedback?(pgsql@FreeBSD.org) Assignee: pgsql@FreeBSD.org Host is running FreeBSD 14.0-CURRENT #88 main-n247993-7a0c0ff7ee2: Thu Jul = 15 08:08:53 CEST 2021 amd64, KTLS enabled (if it matters). databses/postgresql13-server|client are installed and have been recompiled recently via "portmaster -df", even today the binaries have been recompiled again to asure the problem is not to be caused by outdated binaries. Authetication method switched to SCRAM-SHA-256, passwords reset accordingly. Problem: connecting to the DB server from the local machine via socket caus= es no problem. Connecting to the DB server on the local machine from the local machine via "-h 127.0.0.1" or "-h ::1" or "-h localhost" does end up in a v= ery long login phase which ends with=20 psql: error: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. From a remote machine, also 14-CURRENT of the same state and with pgsql from databases/postgresql13-client, I receive the same - the server's log does s= how a connection entry like 2021-07-15 13:11:57.420 CEST [52991] LOG: connection received: host=3Dhost.name.bla port=3D33146 and nothing further. I tried to adjust pg_hba.conf according to host/hostssl entries for remote login (the user in question is allowed to remotely login) and played around with this, tried as many permutations as possible, without success. Connecting from a host running a recent FreeBSD 13-STABLE-p3, also with a recent databases/postgresql13-client, connecting to the DB running on the 14-CURRENT box gives me: psql: error: SSL SYSCALL error: EOF detected The ppstgresql server seems to be completely "off grid" when it comes to network access, even when IPFW is configured to allow any to any (of course= I have configured remote access and opened port 5432/tcp). I'm out of ideas here. On FreeBSD 13-STABLE running psql 12 or 13 I do not = see such problems. --=20 You are receiving this mail because: You are the assignee for the bug.=