The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
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