Date: Thu, 9 Sep 2021 17:33:51 +0200
From: Christoph Berg <myon@debian.org>
To: Stefan Huehner <stefan@huehner.org>
Cc: pgsql-pkg-debian@postgresql.org,
	sysadmins <sysadmins@lists.postgresql.org>
Subject: Re: apt.postgresql.org repo via https will fail will some users
 starting 2021-10-01
Message-ID: <YTopX7uzJQUqGjum@msg.df7cb.de>
Mail-Followup-To: Christoph Berg <myon@debian.org>,
	Stefan Huehner <stefan@huehner.org>,
	pgsql-pkg-debian@postgresql.org,
	sysadmins <sysadmins@lists.postgresql.org>
References: <20210908164806.GC6114@huehner.biz>
 <YTn/LRZEtVi38f5G@msg.df7cb.de>
 <20210909151508.GE6114@huehner.biz>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20210909151508.GE6114@huehner.biz>
Archived-At: 
 <https://www.postgresql.org/message-id/YTopX7uzJQUqGjum%40msg.df7cb.de>
Precedence: bulk

Re: Stefan Huehner
> > > - Some on the website
> > > - Think on reconfiguring certbot/Let's Encrypt on the server to switch to the alternative chain (avoiding this bug but breaking compatibility with old Android
> > 
> > That's probably rather the ca-certificates package?
> 
> Not in this case, i know a bit confusing.
> That upstream article has more details:
> https://community.letsencrypt.org/t/openssl-client-compatibility-changes-for-let-s-encrypt-certificates/143816
> Part: How to support older OpenSSL versions
> 
> In (not so) short: ca-certificates is fine to have trust anchor for Lets Encrypt.
> However not everybody directly trust Let's Encrypt (missing entry in their equivalent of ca-certificates (i.e. old Android).
> 
> To keep those other clients supported they employed a bit of a trick which has an 'expired root certificates' in the chain from your server-cert to their root. At the same time there is 2nd valid path. But old version of software (openssl,gnutls) just stop + fail on seeing 'expired'.
> 
> Best they could do if offer server owner (certbot parameter when requesting ssl certificate to select):

Ah, I thought you meant the end-users servers running PostgreSQL when
you said "server".

For changing the webservers, we'd need to get pginfra on board, Cc'ed
now.

Christoph