Re: SSL connection issue with JDBC - Mailing list pgsql-jdbc

From David Wall
Subject Re: SSL connection issue with JDBC
Date
Msg-id c3007a51-b7a8-23b3-a1f4-41f9bd2c1bed@computer.org
Whole thread Raw
In response to Re: SSL connection issue with JDBC  (Rob Sargent <robjsargent@gmail.com>)
Responses Re: SSL connection issue with JDBC  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc
On 5/14/19 9:31 AM, Rob Sargent wrote:

If I use latest JDBC postgrsql driver "postgresql-42.2.5" then I get below error.

 Anup

Update you jdbc driver to current release.


Sounds like that was done.

Are you sure your SSL certs are recognized?  The original exception suggests an issue with trust along the chain:

Caused by: java.security.cert.CertPathValidatorException: The certificate issued by CN=certificate-authority is not trusted; internal cause is:

                java.security.cert.CertPathValidatorException: Certificate chaining error

That does seem an unexpected CN.  Both your java cacerts and postgres would have to share the CA certs needed to validate the full chain.

David

pgsql-jdbc by date:

Previous
From: Rob Sargent
Date:
Subject: Re: SSL connection issue with JDBC
Next
From: Dave Cramer
Date:
Subject: Re: SSL connection issue with JDBC