MinatV
✭
MinatV ✭
I am unable to login to Vertica database without using the -h flag (HOSTNAME)
This worked perfectly fine in Vertica 11.1, but does not work in Vertica 23.4.
Obviously it works after setting the environment variable VSQL_HOST, but I am more interested in why it does not work, or what changed in the newer version.
h3. Failed auth when not using -h option:
dbadmin@5c99b9dd6671:/$ vsql -U dbadmin -w *****vsql: FATAL 2248: Authentication failed for username "dbadmin"
h3. Successful auth:
dbadmin@5c99b9dd6671:/$ vsql -U dbadmin -w ****** -h ids-databaseWelcome 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 quitSSL connection (cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256, protocol: TLSv1.2)insights_data=>
Badges
