Cannot see database after MC installation

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

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?

I made sure all the ports are open

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

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

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

You have to be root or sudo.

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!

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

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?

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

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:-)

@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;

here is the output:

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