Facing certificate issue while connecting to vertical database

iadarsh

Hi All,

I am facing below-mentioned error while connecting to the Vertica database.

[Vertica]VJDBC IOException while communicating with server: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target.

Any leads on how to fix this issue.

mosheg

Probably the DB server certificate is a self-signed certificate that is not registered with the local Java trusted key store.
Verify that your Vertica database uses non-self-signed SSL certificates.
Or turn SSL security off.
See https://www.vertica.com/docs/9.3.x/HTML/Content/Authoring/Security/TLS/ConfiguringTLS.htm