Postgres with SSL

Note: please leave bug reports and feature requests on

Postgres with SSL

Postby ricop » Fri Aug 21, 2015 2:20 pm

Dear Beaver Team,

I am not able to connect to a Postgres database using SSL at all.

There are 2 different problems:

I did enable ssl on the 'Driver properties' tab of the JDBC Connection window.
For this I just put a 'true' in the value field.
But when I am clicking on 'Test connection' an error occurs:

"The connection attempt failed.
sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
"
Since in other tools its working well I guess its a problem somewhere in DBeaver.

The second problem is, when you put a value in the ssl field on the 'Driver properties' tab of the JDBC Connection window even if you remove it afterwards it will be consistent.
So you need to delete the connection to reset the field. Otherwise its keeping on trying to connect via SSL.


Thanks
Best regards

Rico
ricop
 
Posts: 1
Joined: Fri Aug 21, 2015 2:04 pm

Re: Postgres with SSL

Postby Serge » Fri Aug 21, 2015 4:19 pm

Currently DBeaver doesn't support SSL connections out of the box.
You could try to configure it manually if you are familiar with Java (instructions are at https://jdbc.postgresql.org/documentati ... lient.html).

Easy SSL support is in TODO and will be added in one of next versions.
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: Postgres with SSL

Postby moktpy » Sun Jan 03, 2016 6:57 pm

Not sure if this post is still relevant but I'm running into the same problem. Are there any updates on this?
moktpy
 
Posts: 1
Joined: Sun Jan 03, 2016 6:55 pm


Return to Support



Who is online

Users browsing this forum: No registered users and 17 guests