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 1r6GpE-000HaV-Hl for pgsql-bugs@arkaria.postgresql.org; Thu, 23 Nov 2023 21:01:28 +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 1r6GpC-004bjX-26 for pgsql-bugs@arkaria.postgresql.org; Thu, 23 Nov 2023 21:01:26 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r6Fvo-004DuQ-AZ; Thu, 23 Nov 2023 20:04:12 +0000 Received: from imp.madness.at ([2a02:16a8:dc41::218]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r6Fvl-0071sc-0v; Thu, 23 Nov 2023 20:04:11 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=kaltenbrunner.cc; s=20190215; h=Content-Transfer-Encoding:Content-Type: In-Reply-To:Cc:From:References:To:Subject:MIME-Version:Date:Message-ID:Sender :Reply-To:Content-ID:Content-Description; bh=7RRN/ZxHySvLyXQiet7bGoTIjakug0kg4a/P5SOaKA8=; b=xb0P7l+LK/FGrEj25/53w9HL4r LZySSv0kyo/8EOjRG+YkZqLBFwHBSBQGxytG4e814kLWDJCLJBsXpRuyonnMZyyAEYvP7yilQXZT+ k36sNcXQTvGIbPgXTnx6/3JDK8H0ZkTu+Pv5JcXn4mnoqct9TbjKaf9quuXRiol7DzBBzhdXMyxnT J58ukNLPDvQH1W5Aem4svBK3QF4x+AxZaapw0zUfc5I6KDpam6wj+WqSpZO1iTIr/joSLSJwnu/19 sCQRyEIwepsL/WW+JgrlRdRZ+4kF2jvLwlbk8/WBjDhKiBa6Ub+fc5To75xNIsD6M3tQUUMgoYNmO FlNeCE9w==; Received: from 83-215-245-171.p2p.cablelink.at ([83.215.245.171] helo=[192.168.8.138]) by imp.madness.at with esmtpsa (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1r6Fvf-003KrJ-38; Thu, 23 Nov 2023 21:04:06 +0100 Message-ID: <580fc76b-21ae-4ecc-a255-84eef8379161@kaltenbrunner.cc> Date: Thu, 23 Nov 2023 21:04:01 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Misconfiguration on SSL for download.postgresql.org ? To: =?UTF-8?Q?Frank_B=C3=BCttner?= References: <618816f6-d07a-4d1b-88ad-ef2113e463af@mdc-berlin.de> Content-Language: en-US From: Stefan Kaltenbrunner Cc: pgsql-bugs@lists.postgresql.org, PostgreSQL WWW In-Reply-To: <618816f6-d07a-4d1b-88ad-ef2113e463af@mdc-berlin.de> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 11/23/23 09:21, Frank Büttner wrote: > Hi at all, Hi Frank! > since some day's all our servers can't download updates for the RPM > packages of PostgreSQL. the current TLS configuration has been in place for a long time now - so I suspect the issue started when you constrained your local TLS client in terms of elliptic curves... > > Error: > Errors during downloading metadata for repository 'pgdg-common': >   - Curl error (35): SSL connect error for > https://download.postgresql.org/pub/repos/yum/common/redhat/rhel-9-x86_64/repodata/repomd.xml [error:0A000410:SSL routines::sslv3 alert handshake failure] > Fehler: Failed to download metadata for repo 'pgdg-common': Cannot > download repomd.xml: Cannot download repodata/repomd.xml: All mirrors > were tried > > After checking the site via nmap: > nmap -p 443 download.postgresql.org  --script ssl-enum-ciphers > |   TLSv1.3: > |     ciphers: > |       TLS_AKE_WITH_AES_256_GCM_SHA384 (secp384r1) - A > |       TLS_AKE_WITH_CHACHA20_POLY1305_SHA256 (secp384r1) - A > |       TLS_AKE_WITH_AES_128_GCM_SHA256 (secp384r1) - A > > > I found the problem, the "x25519" ciphers are missing. > |   TLSv1.3: > |     ciphers: > |       TLS_AKE_WITH_AES_256_GCM_SHA384 (ecdh_x25519) - A > |       TLS_AKE_WITH_CHACHA20_POLY1305_SHA256 (ecdh_x25519) - A > > > Which are need on systems where the NIST curves are blocked for security > reasons. > > > So please re enable the x25519 curve. I would kinda argue that your current configuration is in direct violation of RFC8446(TLS 1.3) as well as 7748(elliptic curves for security) which explicitly state that x25519 only a SHOULD while supporting secp256r1 is declared a MUST and a mandatory supported key exchange so it seems a bit of a stretch to consider us not supporting it a "misconfiguration". However we have now modified our TLS configuration to fall back to the embedded curves list within openssl (which among other things) enables x25519. Stefan