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
[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
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');"