vsql "connect to" issues
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!
0
Comments
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