Issue with PostgreSQL SSL connection

MT777 — Tue, 09 Aug 2022 13:58:01 GMT

I need to connect to remote postgresql database server inside my company network. This connection is SSL enabled, with correct ssl cert , ssl key and ssl root ca file.

When i pass all these as advance parameter, the error is as "SSL error: Received fatal alert: decrypt_error".

The connection string is as "jdbc:postgresql://hostname:portnumber/dbname?sslmode=verify-full&sslcert=path_to_certificate.crt&sslkey=path_to_key.pk8&sslrootcert=path_to_rootcert.crt"

I have also tried with setting up keystore for the certificate , it is not working in either case.

Please help me with this issue.

Thank you,

Re: Issue with PostgreSQL SSL connection

Anonymous — Wed, 10 Aug 2022 08:06:50 GMT

Hello,

Here is a stackoverflow article about this SSL exception, hope it helps.

https://stackoverflow.com/questions/30264487/decrypt-error-in-ssl

Best regards

Sabrina

topic Issue with PostgreSQL SSL connection in Talend Studio

Issue with PostgreSQL SSL connection

Re: Issue with PostgreSQL SSL connection