Vsql error !!

Moderator: NorbertKrupa

Post Reply
adrian.oprea
Intermediate
Intermediate
Posts: 163
Joined: Tue Jun 19, 2012 2:44 pm
Location: Rio de Janeiro
Contact:

Vsql error !!

Post by adrian.oprea » Mon Jul 02, 2012 6:10 pm

After creating a new database on the cluster !! i got this error
vsql
vsql: could not connect to server: Connection refused
Is the server running on host "???" and accepting
TCP/IP connections on port 5433?

- i can connect to database with adminTools , but not with vsql or from external client!!
trying so hard !!!

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

Re: Vsql error !!

Post by JimKnicely » Tue Jul 03, 2012 2:06 pm

Adrian,

Can you connect if you specify the host when using the vsql command?

i.e.

Code: Select all

vsql -h hostname
Jim Knicely

Image

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

adrian.oprea
Intermediate
Intermediate
Posts: 163
Joined: Tue Jun 19, 2012 2:44 pm
Location: Rio de Janeiro
Contact:

Re: Vsql error !!

Post by adrian.oprea » Tue Jul 03, 2012 7:05 pm

The error was solved !!! the node i wa trying to start the vsql was down :( !!
- restarted vertica on the host and everything worked perfect !!


Thx !!
trying so hard !!!

khine
Beginner
Beginner
Posts: 33
Joined: Wed Apr 03, 2013 2:54 am

Re: Vsql error !!

Post by khine » Sat May 18, 2013 5:22 am

Even after I restart vertica on host there is still can connect.How can I do plz ?

adrian.oprea
Intermediate
Intermediate
Posts: 163
Joined: Tue Jun 19, 2012 2:44 pm
Location: Rio de Janeiro
Contact:

Re: Vsql error !!

Post by adrian.oprea » Mon May 20, 2013 3:11 pm

Chekc the logs , of the specific host !
Place this on the forum , or maybe you will see the error inside the log !! that is the first place you look !
trying so hard !!!

Post Reply

Return to “Vertica Error Codes”