Options

Authentication failed for username "seuser" in SSL certificate

kontactmaneeshkontactmaneesh Community Edition User

Hi All
I provided SSL mutual authentication to Vertica .it's mutula autentication. Cross checking via below command.
But I am unable to run my application even I can't connect from DBeaver or anyother tool to vertica.
I checked the vertica log and seeing the issue.
Yes, I can see 2 users are available 1. dbadmin & 2 seuser. I am not getting what should I do next. I already provided crt & key. Even I am unable to login to user also.

Kindly provide me your suggestion.

ISSUE from vertica log ************************
2019-10-01 14:02:01.306 Init Session:0x7f4f83fff700 @v_investigate_node0001: {SessionRun} 28000/2248: Authentication failed for username "seuser"


*****************SSL connection cross check
[dbadmin@vlab052000 v_investigate_node0001_catalog]$ vsql
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

SSL connection (cipher: DHE-RSA-AES256-GCM-SHA384, bits: 256, protocol: TLSv1.2)
****************End **********************
****************************Unable to login user seuser
[dbadmin@vlab052000 v_XXXX_node0001_catalog]$ vsql -u seuser
vsql: Warning: The -u option is deprecated. Use -U.
User name: seuser
Password:
vsql: FATAL 2248: Authentication failed for username "seuser"
[dbadmin@vlab052000 v_XXX_node0001_catalog]$
...................
Thanks in advance

Tagged:

Answers

  • Options
    SruthiASruthiA Vertica Employee Administrator

    Did you restart the DB after enabling SSL ? If not please restart it and then try logging in. Before restarting, please make sure everything is set appropriately.

    select parameter_name, current_value, default_value from
    vs_configuration_parameters where parameter_name in ('EnableSSL',
    'SSLCertificate', 'SSLPrivateKey');"

Leave a Comment

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