Skip to main content

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

  • February 6, 2018
  • 1 reply
  • 7 views
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

    1 reply

    Jim_Knicely
    Forum|alt.badge.img+2
    • Jim_Knicely
    • Participating Frequently
    • February 6, 2018

    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

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement