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


Authentication failed for username "seuser" in SSL certificate — Vertica Forum

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

  • SruthiASruthiA 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