The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

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

Tagged:

Best Answer

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 *******************************************************
    [[email protected]]# ./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 ..

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.