vsql "connect to" issues

HI,

   Can you check if  firewall is closed for port 5434? If so please enable firewall for the port 5434 and try exporting.

-Regards,

 Sruthi

What's strange about this is that both databases are located in port 5433. Is there a reason why 5434 is being highlighted?

Also, how do I modify the firewall?

Hi,

   5434 is used for intra cluster communication which is what you are trying for. For more information on what port is used for what functionality, please refer to the URL

http://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/InstallationGuide/BeforeYouInstall/PortAvailability.htm%3FTocPath%3DInstallation%2520Guide%7CBefore%2520You%2520Install%2520HP%2520Vertica%7COperating%2520System%2520Configuration%2520Task%2520Overview%7CFirewall%2520Considerations%7C_____1

With regards to firewall, based on the type of OS you have commands vary. Please refer to the following URL and turn on firewall for port 5434

http://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/InstallationGuide/BeforeYouInstall/iptablesEnabled.htm%3FTocPath%3DInstallation%2520Guide%7CBefore%2520You%2520Install%2520HP%2520Vertica%7COperating%2520System%2520Configuration%2520Task%2520Overview%7CFirewall%2520Considerations%7C_____0

-Regards,

 Sruthi

Thank you. I will take a look and let you know if I have further issues. 

Hi Sruthi,

This message arises when I try to export something to another database:

ERROR 4572:  [v01] RemoteSend: Open failed on node [v_v3disk_node0001], IPAddr is [10.3.200.200], port is [5434] (socket error: Connection timed out)

Is this still a firewall issue?

Hi,

   Yes. Since from the error message it is clear that it is unable to make connection using IP Address and Port 5434

-Regards,

 Sruthi