SSL Error when connecting to Heroku PostgreSQL server

glimpseio / Splice

Issues and support files for the Splice app by Glimpse I/O

https://glimpse.io

0 stars 0 forks source link

SSL Error when connecting to Heroku PostgreSQL server #13

Closed CodeMeister closed 1 year ago

CodeMeister commented 6 years ago

When trying to connect over SSL I get the error:

SSL error: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

I have no problem connecting over SSL to this database from other software apps.

Is there a setting I'm missing?

marcprux commented 6 years ago

Can you let us know the type of database you are connecting to, and whether it is hosted locally or on a cloud server?

CodeMeister commented 6 years ago

Hi, I'm testing with one of the free Heroku Postgres (10.0) databases.

marcprux commented 6 years ago

We don't include the Heroku certificate in Splice currently. For the time being, you should be able to work around the issue by clicking the "Advanced" tab for the connection configuration, and in the row with the key "sslfactory" setting the value to be: "org.postgresql.ssl.NonValidatingFactory".

Please let us know if this works for you.

CodeMeister commented 6 years ago

That worked for me. Many thanks