When adding a source system in the BAR Setup portlet, you might receive this warning message when you click Apply in the System and Nodes page:
This is caused by the DSU vNode not being able to resolve the SQL Engine / Teradata Database COP entries.
To resolve the connection warning, follow these steps to verify that the servers and domains configured in Viewpoint are also configured in the DSU vNode.
-
SSH into Viewpoint and extract the DNS servers and search domains.
-
Extract the DNS servers:
# grep "NETCONFIG_DNS_STATIC_SERVERS" /etc/sysconfig/network/config
Sample output:
NETCONFIG_DNS_STATIC_SERVERS="153.64.251.200 153.65.8.10"
-
Extract the DNS search domains:
# grep "NETCONFIG_DNS_STATIC_SEARCHLIST" /etc/sysconfig/network/config
Sample output:
NETCONFIG_DNS_STATIC_SEARCHLIST="td.teradata.com teradata.com"
-
Extract the DNS servers:
-
SSH into the DSU vNode, check the DNS servers and search domains in /etc/sysconfig/network/config, and if necessary, add those that are in Viewpoint.
-
Extract the DNS servers:
# grep "NETCONFIG_DNS_STATIC_SERVERS" /etc/sysconfig/network/config
Sample output:
NETCONFIG_DNS_STATIC_SERVERS="153.64.251.200"
Notice that 153.65.8.10 from Viewpoint is missing.
-
If necessary, add any missing servers.
# sed -i "s/^NETCONFIG_DNS_STATIC_SERVERS=.*$/NETCONFIG_DNS_STATIC_SERVERS=\"153.64.251.200 153.65.8.10\"/" /etc/sysconfig/network/config
-
If you added a server, verify it is now there.
# grep "NETCONFIG_DNS_STATIC_SERVERS" /etc/sysconfig/network/config
Sample output:
NETCONFIG_DNS_STATIC_SERVERS="153.64.251.200 153.65.8.10"
-
Extract the DNS search domains:
# grep "NETCONFIG_DNS_STATIC_SEARCHLIST" /etc/sysconfig/network/config
Sample output:
NETCONFIG_DNS_STATIC_SEARCHLIST="labs.teradata.com
Note that td.teradata.com and teradata.com from Viewpoint are missing.
-
If necessary, add any missing search domains:
# sed -i "s/^NETCONFIG_DNS_STATIC_SEARCHLIST=.*$/NETCONFIG_DNS_STATIC_SEARCHLIST=\"labs.teradata.com td.teradata.com teradata.com\"/" /etc/sysconfig/network/config
-
If you added a search domain, verify it is now there.
# grep "NETCONFIG_DNS_STATIC_SEARCHLIST" /etc/sysconfig/network/config
Sample output:
NETCONFIG_DNS_STATIC_SEARCHLIST="labs.teradata.com td.teradata.com teradata.com"
- Execute /sbin/netconfig update -f to apply the change at the end.
-
Extract the DNS servers:
-
If the warning message continues, it is because the DNS server doesn't contain any DNS record for the database COP entries. Extract the SQL Engine / Teradata Database COP entries from the hosts file in Viewpoint and append them to the hosts file in the DSU vNode.
The basic syntax is as follows:
# grep TeradataSystemNamecop* /etc/hosts | ssh root@DSU_public_ip 'cat >> /etc/hosts'
For example, if the TeradataSystemName is system1 and the public IP for the DSU vNode is 10.25.23.170, use the following syntax:
# grep system1cop* /etc/hosts | ssh root@10.25.23.170 'cat >> /etc/hosts'