I'm running into an issue attempting to connect to a PostgreSQL datasource. I have the latest version of the PostgreSQL Lucee extension installed. Lucee is running in a container built from the CommandBox Docker image via podman on a RHEL 9 host. The database I'm trying to connect to is an Amazon Aurora cluster. The error I receive is: "The authentication type 10 is not supported. Check that you have configured the pg_hba.conf file to include the client's IP address or subnet, and that it is using an authentication scheme supported by the driver." Has anyone run into this? I can connect to the database via pgAdmin running in a Docker container on the same host, so the IP rules should be set up correctly. I'm wondering if I need to update the JDBC driver to the latest PostgreSQL version, which is higher than what the Lucee extension is pulling in. What is the best way to go about doing that?

the error is relating to encryption, so in /etc/progresssql/usuallVErsionNUmber/ you have your porgresssql.conf in that file you have a config for password_encryption, what is that set to?

on the RHEL host or on the database host?

database host

I don't control that server. The issue is only happening with Postgres Aurora version 14 (testing 14.5 specifically).

well when you go check your encryption, it needs to be the same in what you are sending and what the server is expecting. that is your issue. Switch everything to md5 or plain text on your test server.

yeah I found that while searching Google but the recommendation is to update the driver. I thought I reproduced locally but my PostgreSQL extension wasn't updated, and after updating it works. So the db server admins may not have provisioned access to my IP correctly... thanks for your help!