Able to connect to Vertica locally, but not from remote!
I have a 3 node cluster of Vertica. I am able to login into individual nodes & connect to each local node using VSQL & issue SQL commands successfully. Even via admintools tools it shows the cluster with all 3 nodes is 'UP'.
But I am not able to connect to this cluster from remote. There are no firewall issues to speak of, as this was a working setup (was able to connect from remote without any issues!). I also flushed local IPTABLES on all nodes, but I'm still not able to connect.
One important aspect that I want to point out is that, last week one of the nodes went 'out of contact' with the rest of the 2 nodes, because someone accidently updated its IPTABLES. Those IPTABLES entries have since been removed, Vertica went through a recovery process after that & now admintools says that the cluster is 'UP'.
Remember, I'm still able to connect to the database when i login to the RHEL box & issue VSQL commands. I can even see my data on all 3 nodes. The issue here being that i'm not able to connect from remote!
Please adivice or help.