Skip to main content
Question

Facing certificate issue while connecting to vertical database

  • December 9, 2019
  • 1 reply
  • 9 views

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.

1 reply

mosheg
Forum|alt.badge.img+2
  • Participating Frequently
  • December 9, 2019

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