Skip to main content

Connection refused in MAC

  • May 8, 2014
  • 3 replies
  • 26 views
Rishi_De
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


    3 replies

    Matt_Oldham
    • Matt_Oldham
    • New Participant
    • May 8, 2014
    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_De
    • Rishi_De
    • Author
    • New Participant
    • May 9, 2014
    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_C
    Forum|alt.badge.img+2
    • Navin_C
    • Participating Frequently
    • May 9, 2014
    Hello Rishi,

    Please check if your database is up and running.


    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement