vsql "connect to" issues

ssheikh

Hi,

 

I'm trying to connect to another database within the same port and exporting a table, but I keep receiving this mesage:

 

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)

 

I'm not sure how to deal with this and am hoping for some help.

 

Thanks in advance!

 

SruthiA

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

ssheikh

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?

 

 

SruthiA

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

ssheikh

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

ssheikh

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?

SruthiA

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