Page 1 of 1

Connecting to DB from MC cannot see tables in DB

Posted: Fri Mar 15, 2013 6:45 pm
by clv100
I am VERY new at this. I am logged into the Management Console node. I enter vsql and enter the connection string to the database. It confirms "CONNECT". However, if I try to view the tables in the database, I only see the tables from the Management Console node. Can you tell me what I am doing wrong?? Thanks!!!

Re: Connecting to DB from MC cannot see tables in DB

Posted: Fri Mar 15, 2013 8:49 pm
by JimKnicely
Hi!

If you want to connect to your Vertica DB from the MC server, use the -h (host) option of vsql.

From the Linux command prompt on your MS server, try something like this:

vsql -h hostname -U username -w password

hostname = The IP or host name of any of the nodes in your DB cluster
username = The DB user you want to connect with
password = Password of that user

I hope this helps!

Re: Connecting to DB from MC cannot see tables in DB

Posted: Tue Mar 19, 2013 6:13 pm
by clv100
Got it!! Thanks!!