Prlblem:
When user runs installDA.bin script for Data Aggregator, got this error for Pre-requisite Checking. The error message is:
Error code: 1
Description: unable to execute test to verify db connection;cause:
[Vertica][VJDBC](100176) Failed to connect to host host-I51644 on port 5433.
Reason: No route to host
Workarond:
- Make sure the the hostname and ip address for Data Repository is correct.
- Turn off the firewall on both Data Aggregator and Data Repository via running these linux command:
service iptables save
service iptables stop
chkconfig iptables off
To verify the firewall on linux been turned off, run this command:
service iptables status
- If the firewall been stopped, it will shown like this:
[[email protected] ~]# service iptables status
Firewall is stopped.
- If the firewall still running, it will shown like this:
[[email protected] ~]# service iptables status
Table: filter
Chain INPUT (policy ACCEPT) num target prot opt source destination
Chain FORWARD (policy ACCEPT)
num target prot opt source destination
Chain OUTPUT (policy ACCEPT)
num target prot opt source destination
- Rerun the Data Aggregator installation script installDA.bin to continue the installation.