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

FATAL 3781: Invalid username or password

I'm trying to connect to a vertica data base with vsql from my windows 7 machine.  Here is the command and the resulting error I'm getting:

 

C:\Program Files\Vertica Systems\bin>vsql -h shr2-vrt-pro-vglb1.houston.hp.com -
p 5433 -U <myusername> -w <mypassword> -C
vsql: FATAL 3781: Invalid username or password

 

But I know <myusername> and <mypassword> are correct because I can connect and perform a successful query using php with the same credentials and an ODBC driver. Toad Data Point also connects just fine on the same machine using an ODBC driver.  Any ideas on how to troubleshoot this issue?

Comments

  • Well I figured it out.  The url was incorrect.  But what a crappy error in that case.  Couldn't it have given me something better?

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.