Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Authentication failed for username "seuser" in SSL certificate

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
[[email protected] 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
[[email protected] 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"
[[email protected] v_XXX_node0001_catalog]$
...................
Thanks in advance

Tagged:

Answers

  • 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

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