Page 1 of 1

JDBC connection using SSL gives error

Posted: Tue May 07, 2013 12:51 am
by van
We're running Vertica 6.0.1 Community Edition. We went through the instructions for enabling SSL and can verify that SSL access is working when using vsql. We also went through the additional steps given for enabling SSL for JDBC. Using a regular JDBC connection we are able to successfully connect, however when we try adding "ssl=true" as a property (through a database client app), we get the following error:
An error occurred while establishing the connection:
Long Message:
[Vertica][VJDBC](100066) Authentication failed.
Details:
Type: java.sql.SQLException
Error Code: 100066
SQL State: 28000
Any pointers for how to set up an SSL JDBC connection would be greatly appreciated!

Thanks,
Van

Re: JDBC connection using SSL gives error

Posted: Tue Oct 13, 2015 8:22 am
by muthu1086
Am too facing the same issue, can anybody direct where to look at.

I had generated keys and distributed and enabled the SSL for database.

Using the keys with ODBC am able to connect through SSL but when i generate truststore and keystore and use them using JDBC getting this error.

Thanks
Muthu