Re: Replace current implementations in crypt() and gen_salt() to OpenSSL
Peter Eisentraut <peter@eisentraut.org>
From: Peter Eisentraut <peter@eisentraut.org>
To: Daniel Gustafsson <daniel@yesql.se>, Joe Conway <mail@joeconway.com>
Cc: Robert Haas <robertmhaas@gmail.com>,
"Koshi Shibagaki (Fujitsu)" <shibagaki.koshi@fujitsu.com>,
"pgsql-hackers@lists.postgresql.org" <pgsql-hackers@lists.postgresql.org>
Date: 2024-12-12T11:07:39Z
Lists: pgsql-hackers
On 09.12.24 22:37, Daniel Gustafsson wrote: >> On 9 Dec 2024, at 15:11, Joe Conway <mail@joeconway.com> wrote: >> >> On 12/9/24 07:23, Daniel Gustafsson wrote: >>>> On 4 Dec 2024, at 16:57, Joe Conway <mail@joeconway.com> wrote: >>>> I can send you the source RPM for openssl 1.1.1c which was an earlier FIPS validated version, but the main FIPS patch contains: >>> AFAICT the forks of 1.1.1 which offer FIPS certification all patch the common >>> OpenSSL API FIPS_mode() rather than invent a new one, so the earlier approach >>> should work fine. PFA an updated version which I propose we go ahead with. >> >> That sounds correct from my memory of it. >> >> I have not done any actual testing (yet), but on quick scan this part looks suspicious: > > Not only suspicious but plain wrong, fixed in the attached, thanks! I think these function names are wrong: + <varname>pgcrypto.legacy_crypto_enabled</varname> determines if the + built in legacy crypto functions <literal>pg_gen_salt</literal>, + <literal>pg_gen_salt_rounds</literal>, and <literal>pg_crypt</literal> + are available for use. Those are the C-level functions. The SQL-level functions are called gen_salt and crypt.
Commits
-
pgcrypto: Make it possible to disable built-in crypto
- 035f99cbebe5 18.0 landed
-
pgcrypto: Add function to check FIPS mode
- 924d89a35475 18.0 landed
-
citext: Allow tests to pass in OpenSSL FIPS mode
- 3c551ebede46 17.0 cited
-
pgcrypto: Remove non-OpenSSL support
- db7d1a7b0530 15.0 cited