Connecting to DB from MC cannot see tables in DB

Moderator: NorbertKrupa

Post Reply
clv100
Beginner
Beginner
Posts: 27
Joined: Tue Oct 16, 2012 6:04 pm

Connecting to DB from MC cannot see tables in DB

Post by clv100 » Fri Mar 15, 2013 6:45 pm

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!!!

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1768
Joined: Sat Jan 21, 2012 4:58 am
Contact:

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

Post by JimKnicely » Fri Mar 15, 2013 8:49 pm

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!
Jim Knicely

Image

Note: I work for HPE. My views, opinions, and thoughts expressed here do not represent those of my employer.

clv100
Beginner
Beginner
Posts: 27
Joined: Tue Oct 16, 2012 6:04 pm

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

Post by clv100 » Tue Mar 19, 2013 6:13 pm

Got it!! Thanks!!

Post Reply

Return to “Vertica Management Console”