Database Designer UI not responding to correct password
I am trying to access database designer through the admintools, when I provide the correct password there is no response from the UI. If I provide an "incorrect" password as expected I receive "Error: Unable to connect to database".
I have tail'd the admintools logs including errors while reproducing and I am not seeing anything. Any help will be appreciated.
0
Comments
What version of Vertica is this? After you enter the correct password, can you query the DB to see if a session is created?
select node_name, login_timestamp, last_statement, current_statement from sessions where client_type = 'vsql' and user_name = 'dbadmin' and session_id <> current_session();
Also, there is a file named /opt/vertica/log/uiMgr-dbadmin.log that logs the admintools requests. For example, I launched admintools, chose option 6, then option 2, chose my DB and entered the correct password.
In my log I see:
I found the issue by running strace, looks like there isnt enough memory allocated for passwords that are longer than 40 chars.
Solution use a password with 40 chars or less.
Thanks for the update! This is a known issue. I will keep this thread updated when the issue is resolved.