vsql: FATAL 2248: Authentication failed for username "dbadmin"

RKvertica

One of my customers is trying to do a vbr (backup local) and is receiving an authentication failure:
vsql /opt/vertica/bin/vsql -q -t -X -dsfdmverpoc -p5433 -Udbadmin -h172.28.166.8
vsql: FATAL 2248: Authentication failed for username "dbadmin"

Whenever they try a vsql on command line with -h option and specify either the node name(DNS) or the ip, they receive the same authentication error.

What can they check/modify to allow this authentication?

thanks much.
Raj

Jim_Knicely

Hi,

Most likely the error is the result of the dbadmin user not having HOST authentication set up or not set up properly.

See:
https://my.vertica.com/docs/9.0.x/HTML/index.htm#Authoring/Security/ClientAuth/PreservingDBADMINAuthenticationAccess.htm