Facing certificate issue while connecting to vertical database
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.
Tagged:
0
Answers
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