Cannot see database after MC installation

kfruchtman

Hello,
I need help please.I have an Ubuntu 18.04.4 LTS, on it vertica db 9 with one node.I have installed the MC on the same box.
The MC is not recognizing the running db on it.When I am trying to run "Import a Vertica running cluster" it sais that it cannot connect to the agent.Default port 5444 of the agent is open on the box.
The console log file shows:
3 Feb 2021 17:11:49,389 [qtp1775282465-108] VuiUtils INFO - Check host:35.246.154.161 reachable via port 22
23 Feb 2021 17:11:49,397 [qtp1775282465-108] AgentCommands INFO - agentapi=GET, https://35.246.154.161:5444/
23 Feb 2021 17:13:59,603 [qtp1775282465-108] AgentCommands INFO - Connect to 35.246.154.161:5444 [/35.246.154.161] failed: Connection timed out (Connection timed out)
23 Feb 2021 17:13:59,607 [qtp1775282465-108] AgentCommands WARN - executeCommandWithRetryWithinHost>> host with ip: 35.246.154.161 is null

Any help would be very much appreciated!
Kind regards,
Keren

Jim_Knicely

Make sure you've opened all of the ports needed by Vertica and MC!
https://www.vertica.com/docs/latest/HTML/Content/Authoring/InstallationGuide/BeforeYouInstall/EnsurePortsAreAvailable.htm

If it's just a test box (i.e. you said this is a single node install) sometimes it's just easier to disable the firewall completely
https://www.vertica.com/docs/latest/HTML/Content/Authoring/InstallationGuide/BeforeYouInstall/iptablesEnabled.htm

kfruchtman

Thanks Jim but I read now that the agent needs to be started and when I do
dbadmin@vertica-sandbox-1:/$ /etc/init.d/vertica_agent start
-su: /etc/init.d/vertica_agent: No such file or directory
Or:
badmin@vertica-sandbox-1:/$ sudo /etc/init.d/vertica_agent status
sudo: /etc/init.d/vertica_agent: command not found
dbadmin@vertica-sandbox-1:/$ /etc/init.d/vertica_agent enable
-su: /etc/init.d/vertica_agent: No such file or directory
dbadmin@vertica-sandbox-1:/$ sudo /etc/init.d/vertica_agent enable
sudo: /etc/init.d/vertica_agent: command not found
dbadmin@vertica-sandbox-1:/$ /etc/init.d/vertica_agent enable
-su: /etc/init.d/vertica_agent: No such file or directory
dbadmin@vertica-sandbox-1:/$ /etc/init.d/vertica_agent start
-su: /etc/init.d/vertica_agent: No such file or directory

could it be that the agent is not installed?

kfruchtman

I made sure all the ports are open

Jim_Knicely

Maybe try:
/opt/vertica/sbin/vertica_agent restart

kfruchtman

wow its working but asking for a password - which password is it exactly? dbadmn did not work....

kfruchtman

the pass for the dbadmin user of vertica I meant.It did not work.Which password is he asking for ?

Jim_Knicely

You have to be root or sudo.

kfruchtman

right now it worked:
root@vertica-sandbox-1:~# /opt/vertica/sbin/vertica_agent restart
Stopping vertica agent:
starting agent
Opening PID file "/opt/vertica/log/agent.pid".
Overwriting /opt/vertica/log/agent_dbadmin.log
Overwriting /opt/vertica/log/agent_dbadmin.err
OK for user: dbadmin
*
but the MC is still giving the same error when I am trying to import the db."Could not establish a connection with the agent" ...... please help!

DaveT

I have seen this issue when port 5433 is not open. It is also required for the import. Please double-check that one.

kfruchtman

when I do netstat -a I get this:

tcp 0 0 localhost:6010 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:5434 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:39005 0.0.0.0:* LISTEN
tcp 0 0 localhost:4803 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:5444 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:5450 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:8079 0.0.0.0:* LISTEN
tcp 0 0 localhost:domain 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:ssh 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:5433 0.0.0.0:* LISTEN

So it looks open.... no?

kfruchtman

port 5433 is open for sure.
Can you advise me further? problem still exists, cannot connect to the db via MC.
many thanks

kfruchtman

Hi ! I just want to inform that problem was solved.The problem was that the MC didn't recognize the public ip of the machine and it needed to use the 127.0.0.1 ip for it to work.Many thanks for all your help! much appreciated:-)

Jim_Knicely

@kfruchtman - Thanks for letting us know. For fun, what is the output of:

SELECT node_name, node_address, export_address FROM nodes ORDER BY 1;

kfruchtman

here is the output:

Jim_Knicely

Ok. That explains it!

Before you do a whole lot of work, know that you won't be able expand this cluster to more nodes because you installed on the looback address.

See the Important Notes section here:
https://www.vertica.com/docs/latest/HTML/Content/Authoring/InstallationGuide/BeforeYouInstall/ConfiguringTheNetwork.htm