RE: [EXTERNAL] Re: Java client connection problem on FIPS enabled hosts (with password_encryption = scram-sha-256)

From: "McDermott, Becky" <bmcderm(at)sandia(dot)gov>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: "pgsql-jdbc(at)lists(dot)postgresql(dot)org" <pgsql-jdbc(at)lists(dot)postgresql(dot)org>
Subject: RE: [EXTERNAL] Re: Java client connection problem on FIPS enabled hosts (with password_encryption = scram-sha-256)
Date: 2022-03-22 23:00:04
Message-ID: BY3PR09MB86271BB460206972302F1F96C8179@BY3PR09MB8627.namprd09.prod.outlook.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

> Is FIPS enabled on the host holding the PostgreSQL instance? I am afraid that you may run to run into problems in this case, in the shape of a crash in > > the backend.

FIPS is enabled on each of our Kubernetes cluster nodes. We are running our application as Kubernetes deployments. I have observed the following:

1) The Postgres pod itself reaches a "Running" state
2) I have another pod in the same namespace with psql installed and I can exec into this pod and successfully connect to postgres and run SQL select statements
3) All other application pods (java services) that connect to postgres do NOT reach a "Running" state and their logs are full of messages stating a connection cannot be established with a cause indicating " Unsupported PBKDF2 for SCRAM-SHA-256"

I am not a Java developer so I'm not sure how the postgres encryption method (SCRAM_SHA-256) was setup other than what I can see in the files:
- postgresql.conf
- pg_hba.conf

Our developers are going to transition to working on this in a few weeks. I don't know enough about password encryption but it looks like we are using an unsupported algorithm on the java client side.

> Postgres 14 is able to work by going through the EVP layer for its
> SHA-2 computations, instead.

Should we be looking at upgrading Postgres to version 14?

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Michael Paquier 2022-03-22 23:25:06 Re: Java client connection problem on FIPS enabled hosts (with password_encryption = scram-sha-256)
Previous Message Tom Lane 2022-03-22 22:54:29 Re: Java client connection problem on FIPS enabled hosts (with password_encryption = scram-sha-256)