Cannot Import Existing Vertica Cluster via Management Console
vertica-console_9.0.1-0_amd64.deb, I can reach and can enter. But when I want to import existing vertica cluster, I am getting
invalid username or password error. I am pretty sure that username and password is true because I am reaching to database with the same username and password. I even don't try to write it, I do copy-paste extreme carefully (no space etc.) but still getting the same error.
vertica-consoled several times but still no luck.
I am sure that getting the right API Key as following:
Any help would be appreciated. Thank you!
Jim_Knicely - Select Field - Administrator
If you log into the server running MC, can you connect using the command below? (Replace the variables with your values)
/opt/vconsole/bin/vsql -U user_name -w user_password -h db_server_ip -d db_name
Actually, this might give you an error since you are trying to connect to an older database version ...5
Jim_Knicely - Select Field - Administrator
Hmm. Well, MC is obviously trying to connect to some DB as you are getting an invalid user/pw error. However, a failure does not show up in the DB. Either you are hitting a bug (MC 9 reading Vertica 8.1) or MC is going against some other unexpected DB. The fact that you don't see any log entries in the vertica.log means that MC is NOT hitting that DB.5
Hey @Jim_Knicely , thank you for your response... I accepted answer accidentally.
yes, I can do it in vertica server or remote cli with -h command and cli is opening with username. I also can query with this cli w.r.t user grants.
Hmm. I would try creating a another database user without a password just to see if MC can connect using it:
If you can import the DB as that user, then you have the original user name or password wrong.
Don't forget to drop this user...
Thank you for your fast response @Jim_Knicely . But no luck
Ok. Can you check the LOGIN_FAILURES system table?
SELECT * FROM login_failures WHERE user_name = 'mctest' ORDER BY login_timestamp DESC;
Yeap, I checked it, there is nothing... I guess mc even cannot try to login to db.
Mc installation is on same machine where vertica resides.
I just verified that using an invalid user name from MC will show up in LOGIN_FAILURES with the REASON "INVALID USER" and that using an invalid password from MC will show up in LOGIN_FAILURES with the REASON "FAILURE".
Seems like you aren't even hitting the DB? Can you look at the Vertica log? Do you see connection attempts as the user you are trying to connect with?
I tried the following commands but nothing happened... I am seeing some lines when I search for dbadmin but not with these at all:
Vertica version is 8.1 and management is 9.0.1. Do you think this is happening because of version numbers?
cat vertica.log | grep -i "mctest"
The only authentication is done by me through cli... Not from mc
Look at the following lines:
2018-02-19 15:42:12.152 Init Session:7fb6cf7d5700 @v_******node0001: 00000/4686: Authentication - sendAuthRequest: user=mctest database=****** host=::1 authType=0
2018-02-19 15:42:12.152 Init Session:7fb6cf7d5700 @v******_node0001: 00000/2703: Connection authenticated: user=mctest database=****** host=::1
I assume those are a connection from vsql.
Did you edit the database name in the output? It seems different than the one MC is showing.
Note: I used asterisks.
Yes this is from vsql connection, I tested if it can connect through command line after creating user.
You are right, I changed the names a bit.
Thank you @Jim_Knicely for all your help. I will try after upgrading vertica db version.
Maybe take a quick look at the /opt/vconsole/log/mc/mconsole.log file.
Look for the mctest user and make sure the info you see is expected. That is, there should be an IP address in the api response entry. Is the IP address correct?
IP address and /databases/_ are true
Those entries look correct ... But edit the file and look at the errors that you see immediately following those lines.
For instance, I see these for an invalid password:
What error do you see?
Yeap you are right but I see nothing other than "invalid username or password" error as I shared 2nd screen shot of my first message.
Agent is working, I restarted with several combinations (restart agent first then mc; restart mc first then agent) but no luck. I know that the agent port is OK because I checked config.py file of agent and settings page of mc.
Agent may not respond to POST request, may be there is a setting, I will check how to make it happen.
I created new api key and made a curl request as following:
and got the response:
Then I mimic the mc's POST request as following (I created another user for this test):
I got the following response:
This API key is following (I created a new one):
Do you have any idea @Jim_Knicely ?
We are facing the exact the same issue as described above, did anyone find any solution or a way yo fix this?