Skip to main content
Question

SSL error: certificate verify failed

  • September 30, 2019
  • 2 replies
  • 20 views

kontactmaneesh

Hi All
I created crt & keys. Even I am getting below result if running my command.
command : openssl verify -CAfile ca.crt server.crt
Expected output:
server.crt: OK
But when running below command so giving vsql issue and giving console output
vsql: SSL error: certificate verify failed .
Kindly provide me your needul help .
Thanks & Regards
Maneesh Kumar
*****************Command & Issue start ***************************************************
[dbadmin@vlab052000 root]$ vsql -m require
vsql: SSL error: certificate verify failed
[dbadmin@vlab052000 root]$ vsql
Password:
Welcome to vsql, the Vertica Analytic Database interactive terminal.
Type: \h or \? for help with vsql commands
\g or terminate with semicolon to execute query
\q to quit
dbadmin=> select user,authentication_method, ssl_state from sessions where session_id = current_session();
current_user | authentication_method | ssl_state
--------------+-----------------------+-----------
dbadmin | Password | None
*****************Command & Issue End ***************************************************

2 replies

SruthiA
Forum|alt.badge.img+1
  • Participating Frequently
  • September 30, 2019

Did you complete steps under "Option 2: Add SSL keys and certificates using vsql." in the below link. If not, please go ahead and set those parameters.

https://www.vertica.com/kb/Using-SSL-Server-Authentication-with-Vertica-Validating-Your-SSL/Content/BestPractices/Using-SSL-Server-Authentication-with-Vertica-Validating-Your-SSL.htm


kontactmaneesh
  • Author
  • Participating Frequently
  • October 1, 2019

Thanks . it's worked .