Default Avatar



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=>


Ninth AnniversaryEighth AnniversaryFirst AnniversarySecond AnniversaryThird AnniversaryFourth AnniversaryFifth AnniversarySixth AnniversarySeventh Anniversary


  • Not much happening here, yet.