Skip to main content
Question

Facing issue for SSL configuration in Vertica

  • September 28, 2019
  • 3 replies
  • 17 views

kontactmaneesh

HI All
I installed Vertica on CentOS 7 - 64 bit machine . Now I want to enable SSL into vertica . Generated SSL certificate.
Now , I am running below command to configure SSL certificate as a root .
vertica_ssl_setup --enable-ssl --vertica-cert-path server.crt --vertica-key-path server.key --client-ca-path ca.crt
But facing below issue
Issue coming **************************************************
2019-09-28 08:50:34,143 DEBUG Installing Certs/Keys for SSL: Return code: 1, Output: I/O error(2): No such file or directory
['Set config parameter failed for SSLCertificate']

2019-09-28 08:50:34,143 ERROR Installing Certs/Keys for SSL: Cmd: ['su', '-', '-c', '/opt/vertica/bin/admintools -t set_ssl_params -d investigate -k server.key -c server.crt -a issue_ca.crt -p "control1234"', 'dbadmin'], Return code: 1, Output: I/O error(2): No such file or directory
['Set config parameter failed for SSLCertificate']


Kindly provide me your needful help .
Thanks

3 replies

verban
Forum|alt.badge.img+1
  • Participating Frequently
  • September 28, 2019

Move your files to current directory an run this command:
vertica_ssl_setup --enable-ssl --vertica-cert-path ./server.crt --vertica-key-path ./server.key --client-ca-path ./ca.crt


kontactmaneesh
  • Author
  • Participating Frequently
  • September 30, 2019

Thanks for the valuable reply but still issue did not fix. I am able to pass the file properly. It's something else.
Kindly check my command again. Your help will be really apprecetaed . it's blocker for me .
***********************************Command *******************************************************
[root@vlab052000vertica]# ./vertica_ssl_setup --enable-ssl --vertica-cert-path ./server.crt --vertica-key-path ./server.key --client-ca-path ./issue_ca.crt
*************Command End ***********************
***********Error on console log ********************************
2019-09-30 02:49:31,722 DEBUG Installing Certs/Keys for SSL: Return code: 1, Output: I/O error(2): No such file or directory
['Set config parameter failed for SSLCertificate']

2019-09-30 02:49:31,723 ERROR Installing Certs/Keys for SSL: Cmd: ['su', '-', '-c', '/opt/vertica/bin/admintools -t set_ssl_params -d database -k ./server.key -c ./server.crt -a ./issue_ca.crt -p "control1234"', 'dbadmin'], Return code: 1, Output: I/O error(2): No such file or directory
['Set config parameter failed for SSLCertificate']
*************End **************************


kontactmaneesh
  • Author
  • Participating Frequently
  • September 30, 2019

Hi Thanks, I got a solution .
it's worked like that
./vertica_ssl_setup --enable-ssl --vertica-cert-path /opt/arcsight-vertica/server.crt --vertica-key-path /opt/arcsight-vertica/server.key --client-ca-path /opt/arcsight-vertica/ca.crt
Thanks a lot ..