Facing issue for SSL configuration in Vertica
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
Best Answer
-
verban Vertica Customer ✭
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.crt5
Answers
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 **************************
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 ..