We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Facing issue for SSL configuration in Vertica — Vertica Forum

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

  • kontactmaneeshkontactmaneesh Community Edition User

    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 **************************

  • kontactmaneeshkontactmaneesh Community Edition User

    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