Date: Wed, 8 Sep 2021 16:48:06 +0000
From: Stefan Huehner <stefan@huehner.org>
To: pgsql-pkg-debian@postgresql.org
Subject: apt.postgresql.org repo via https will fail will some users starting
 2021-10-01
Message-ID: <20210908164806.GC6114@huehner.biz>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.5.23 (2014-03-12)
Archived-At: 
 <https://www.postgresql.org/message-id/20210908164806.GC6114%40huehner.biz>
Precedence: bulk

Hello,

sending this here as looks like https://apt.postgresql.org is affected by this so this could trigger some support/user questions.

Note this only (!) happens when using https:// in sources.list for the pgdg repo.

Benefit of that is debatable (see recent debian-devel discussion) but i would not be surprised if some/many people use it.

Trigger:
https://community.letsencrypt.org/t/openssl-client-compatibility-changes-for-let-s-encrypt-certificates/143816

End of this month some CA cert will expire related to Let's Encrypt which will trigger an bug in clients using old openssl/gnutls.

apt is using gnutls backend and at least the version in Ubuntu <= 18.04 are affected and "apt update" will already fail for people starting that date.

Note that canonical is working in patching gnutls so if that finishes in time and (!) if people update before that date all good.

If not they will get error similar to:
Err:9 https://apt.postgresql.org/pub/repos/apt focal-pgdg Release               
  Certificate verification failed: The certificate is NOT trusted. The revocation or OCSP data are old and have been superseded. The certificate chain uses expired certificate.  Could not handshake: Error in the certificate verification. [IP: 87.238.57.227 443]

Can be triggered today i.e. with:

faketime "2021-10-01" apt update

Ideas:
- Do nothing apt.postgresql suggest http:// in the instructions
- 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

- Raise as bug to debian also (against openssl/gnutls) to maybe patch both in stable also to avoid this ?
  - Not sure if that is a interesting/acceptable material for stable/old-stable?

Please CC me on replies i'm not on the list

Stefan