Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uCzIc-004xyg-UT for pgsql-hackers@arkaria.postgresql.org; Thu, 08 May 2025 11:20:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uCzIb-002hKg-Hj for pgsql-hackers@arkaria.postgresql.org; Thu, 08 May 2025 11:20:21 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uCzIb-002hKY-4R for pgsql-hackers@lists.postgresql.org; Thu, 08 May 2025 11:20:21 +0000 Received: from smtp.outgoing.loopia.se ([93.188.3.37]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uCzIY-000o8V-0b for pgsql-hackers@postgresql.org; Thu, 08 May 2025 11:20:20 +0000 Received: from s807.loopia.se (localhost [127.0.0.1]) by s807.loopia.se (Postfix) with ESMTP id B013F38611C for ; Thu, 08 May 2025 13:20:17 +0200 (CEST) Received: from s979.loopia.se (unknown [172.22.191.5]) by s807.loopia.se (Postfix) with ESMTP id 96D7E3850EA; Thu, 08 May 2025 13:20:17 +0200 (CEST) Received: from s470.loopia.se (unknown [172.22.191.6]) by s979.loopia.se (Postfix) with ESMTP id 91D5C10BC4BE; Thu, 08 May 2025 13:20:17 +0200 (CEST) X-Virus-Scanned: amavisd-new at amavis.loopia.se X-Spam-Flag: NO X-Spam-Score: -1.2 X-Spam-Level: X-Spam-Status: No, score=-1.2 tagged_above=-999 required=6.2 tests=[ALL_TRUSTED=-1, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1] autolearn=disabled Authentication-Results: s470.loopia.se (amavisd-new); dkim=pass (2048-bit key) header.d=yesql.se Received: from s981.loopia.se ([172.22.191.6]) by s470.loopia.se (s470.loopia.se [172.22.190.34]) (amavisd-new, port 10024) with UTF8LMTP id 8fXEZghbMMeW; Thu, 8 May 2025 13:20:17 +0200 (CEST) X-Loopia-Auth: user X-Loopia-User: daniel@yesql.se X-Loopia-Originating-IP: 89.255.232.193 Received: from smtpclient.apple (customer-89-255-232-193.stosn.net [89.255.232.193]) (Authenticated sender: daniel@yesql.se) by s981.loopia.se (Postfix) with ESMTPSA id D49C222B17AA; Thu, 08 May 2025 13:20:16 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yesql.se; s=loopiadkim1707475645; t=1746703217; bh=GcT8tNzjvyXo+uPSKrLcttenvoMDT7n7DaTOWFgwWa4=; h=Subject:From:In-Reply-To:Date:Cc:References:To; b=XhPl/dSllhhRq+PRfCBy2CHTs/ZAl/qiLz08x07cRGQ/c9FN07i1NTWoFd4ZCgRLy p6xgilSKKDCyINVlXaO1pW2cWTywxqvJmkfB9XFcgRr4gLAXV3OxflhPjjFlHqdH2B h2RRXqlv8nPiieeVEzwgbYnI9SrU/q5Zba3K2wWseafh4ml3kSdNYbVvlkQaCnh6H+ lQQJQcdSbkhYW8bECIIh3sBlZQSkto554DTBMhU7TO31dyb3d21mf4DmvQ7FpEn8AM KegCK/jCPhh093n0gFIpuEiJ4O4DYxra/0ltzGZK62VLVzOV2pKkPeU7VclzQk+fml g8aKIFCMBXgRw== Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3776.700.51.11.1\)) Subject: Re: disabled SSL log_like tests From: Daniel Gustafsson In-Reply-To: <80137.1746654871@sss.pgh.pa.us> Date: Thu, 8 May 2025 13:20:06 +0200 Cc: Thomas Munro , Andrew Dunstan , PostgreSQL Hackers , Jacob Champion Content-Transfer-Encoding: quoted-printable Message-Id: References: <984fca80-85a8-4c6f-a5cc-bb860950b435@dunslane.net> <2199758.1744901785@sss.pgh.pa.us> <1ce11d3f-624c-4003-a032-1b10cc138305@dunslane.net> <2814408.1745005558@sss.pgh.pa.us> <2859105.1745015195@sss.pgh.pa.us> <1120735.1745350422@sss.pgh.pa.us> <3058990.1746485124@sss.pgh.pa.us> <3227092.1746580691@sss.pgh.pa.us> <3248136.1746592452@sss.pgh.pa.us> <3004EFB2-8FFA-429A-AC5E-E3F40E002A94@yesql.se> <3320404.1746633879@sss.pgh.pa.us> <8E3E58BF-CC99-4C45-9FB8-3BA83AA6FDC8@yesql.se> <51363.1746646179@sss.pgh.pa.us> <8293D36E-8027-4DB8-AB41-5EA2C2A9A788@yesql.se> <80137.1746654871@sss.pgh.pa.us> To: Tom Lane X-Mailer: Apple Mail (2.3776.700.51.11.1) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On 7 May 2025, at 23:54, Tom Lane wrote: >=20 > Daniel Gustafsson writes: >> I haven't looked at the test in question yet, but we do skip some SSL = tests if >> running against libressl already so I assume this will be able to = follow the >> same pattern. >=20 > Ah, thanks for the tip. I propose the attached, which disables the > RSA-PSS test altogether on LibreSSL, and modifies the > intermediate-cert test to accept the result we're actually getting > on LibreSSL. We could revert that one if anyone can figure out > how to make it better, but I don't wish to put any more time into > it myself. LGTM for now. > +# Determine whether this build uses OpenSSL or LibreSSL. As a = heuristic, the > +# HAVE_SSL_CTX_SET_CERT_CB macro isn't defined for LibreSSL. > +my $libressl =3D not check_pg_config("#define = HAVE_SSL_CTX_SET_CERT_CB 1"); Longer term it would be nice to move this into SSL::Server and have the = module export a function or symbol which returns the underlying library and = version, but that's not for this patch. > + > +# As of 5/2025, LibreSSL doesn't actually work for RSA-PSS = certificates. Should we add a link to the relevant thread for future readers? OpenBSD = refer to MARC for archiving which I believe is stable enough for an inclusion. https://marc.info/?l=3Dlibressl&m=3D174664225002441&w=3D2 -- Daniel Gustafsson