PostgreSQL Connector

Hi Everyone

I am trying to access a postgres database using SSL

I am getting the following error:
image
This is my node configuration:
image
image
No other setting were changed. And using username and password to access the database

Any idea what the error might be?

@tiaandp I think you might need additional settings to use SSL:

@mlauber71 I have tried the sslfactory parameter and it did not work :frowning:

Hi,

I was just able to accomplish this.
Assuming that you have the hostname, database name and port set properly with credentials entered.

2 methods worked for me in the JDBC Parameters.
The one I use:
ssl = true
sslrootcert = D:<path to pem file>

I guessed to get this to work. I used my python knowledge for the proper parameter to use. Case matters.
The other one that worked:
ssl = true
sslfactory = org.postgresql.ssl.NonValidatingFactory

If the latter does not work, I’d guess that you, likely, don’t have the proper DB packages installed.

1 Like