We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Connection refused in MAC — Vertica Forum

Connection refused in MAC

Rishi_DeRishi_De
in General Discussion
I have installed vsql and database in my MAC. but while connecting from vsql m getting following error 
vsql: could not connect to server: Connection refused Is the server running on host "???" and accepting
TCP/IP connections on port 5433?

am executing following command,
vsql  -U dbadmin -w password

and my odbc.ini is like ,

[VMart]Description = Vmart Database
Driver = /Library/ODBC/vertica/lib64/libverticaodbc.dylib
Database = vmartdb
Servername = host01
UID = dbadmin
PWD = password
Port = 5433
Locale = en_GB


Comments

  • Matt_OldhamMatt_Oldham
    If you are trying to connect using vsql, then you are not using an ODBC connection.  Try adding the "-h host01" parameter to your vsql command.
  • Rishi_DeRishi_De
    Hi ,

    After adding host name , am getting following error ,

    vsql: could not translate host name "host01" to address: nodename nor servname provided, or not known

    Please help
  • Navin_CNavin_C Vertica Customer ✭
    Hello Rishi,

    Please check if your database is up and running.


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...