Re: Support for NSS as a libpq TLS backend

Daniel Gustafsson <daniel@yesql.se>

From: Daniel Gustafsson <daniel@yesql.se>

To: Jacob Champion <pchampion@vmware.com>, "sfrost@snowman.net" <sfrost@snowman.net>, "pgsql-hackers@lists.postgresql.org" <pgsql-hackers@lists.postgresql.org>, "hlinnaka@iki.fi" <hlinnaka@iki.fi>, "andrew.dunstan@2ndquadrant.com" <andrew.dunstan@2ndquadrant.com>, "thomas.munro@gmail.com" <thomas.munro@gmail.com>, "michael@paquier.xyz" <michael@paquier.xyz>, "andres@anarazel.de" <andres@anarazel.de>

Date: 2021-05-28T09:04:12Z

Lists: pgsql-hackers

Attachments

v36-0009-nss-Build-infrastructure.patch (application/octet-stream) patch v36-0009
v36-0008-nss-Support-NSS-in-cryptohash.patch (application/octet-stream) patch v36-0008
v36-0007-nss-Support-NSS-in-sslinfo.patch (application/octet-stream) patch v36-0007
v36-0006-nss-Support-NSS-in-pgcrypto.patch (application/octet-stream) patch v36-0006
v36-0005-nss-Documentation.patch (application/octet-stream) patch v36-0005
v36-0004-nss-pg_strong_random-support.patch (application/octet-stream) patch v36-0004
v36-0003-nss-Add-NSS-specific-tests.patch (application/octet-stream) patch v36-0003
v36-0002-Refactor-SSL-testharness-for-multiple-library.patch (application/octet-stream) patch v36-0002
v36-0001-nss-Support-libnss-as-TLS-library-in-libpq.patch (application/octet-stream) patch v36-0001
(unnamed) (text/plain)

Attached is a rebase to keep bitrot at bay.  On top rebasing and smaller fixes
in comments etc, this version fixes/adds a number things:

* Performs DN resolution to support the DN mapping
* Locks the SECMOD parts and PR_Init call in the frontend as per Jacobs
  findings upthread
* Properly set the tokenname of the database to avoid ambigious lookups in case
  multiple databases are loaded (a better name to ensure uniqueness is a TODO)
* Adds a test for certificate lookup without sslcert set

Commits

Add tab-completion for CREATE FOREIGN TABLE.
- 74527c3e022d 15.0 cited
Add tap tests for the schema publications.
- 6b0f6f79eef2 15.0 cited
Move Perl test modules to a better namespace
- b3b4d8e68ae8 15.0 cited
Adjust configure to insist on Perl version >= 5.8.3.
- 92e6a98c3636 15.0 cited
Simplify code related to compilation of SSL and OpenSSL
- 092b785fad3d 14.0 landed
Introduce --with-ssl={openssl} as a configure option
- fe61df7f82aa 14.0 landed
Implement support for bulk inserts in postgres_fdw
- b663a4136331 14.0 cited
Fix redundant error messages in client tools
- 6be725e70161 14.0 cited
doc: Apply more consistently <productname> markup for OpenSSL
- 089da3c4778f 14.0 landed
Check ssl_in_use flag when reporting statistics
- 6a5c750f3f72 14.0 cited