Testing Connectivity to a Specific TCP Port From the Delphix Engine (KBA1732)
KBA
KBA#1732
Applicable Delphix Versions
- Click here to view the versions of the Delphix engine to which this article applies
-
Major Release All Sub Releases 6.0 6.0.0.0, 6.0.1.0, 6.0.1.1, 6.0.2.0, 6.0.2.1, 6.0.3.0, 6.0.3.1, 6.0.4.0, 6.0.4.1, 6.0.4.2, 6.0.5.0, 6.0.6.0, 6.0.6.1, 6.0.7.0, 6.0.8.0, 6.0.8.1, 6.0.9.0, 6.0.10.0, 6.0.10.1, 6.0.11.0, 6.0.12.0, 6.0.12.1, 6.0.13.0 5.3
5.3.0.0, 5.3.0.1, 5.3.0.2, 5.3.0.3, 5.3.1.0, 5.3.1.1, 5.3.1.2, 5.3.2.0, 5.3.3.0, 5.3.3.1, 5.3.4.0, 5.3.5.0 5.3.6.0, 5.3.7.0, 5.3.7.1, 5.3.8.0, 5.3.8.1, 5.3.9.0 5.2
5.2.2.0, 5.2.2.1, 5.2.3.0, 5.2.4.0, 5.2.5.0, 5.2.5.1, 5.2.6.0, 5.2.6.1
5.1
5.1.0.0, 5.1.1.0, 5.1.2.0, 5.1.3.0, 5.1.4.0, 5.1.5.0, 5.1.5.1, 5.1.6.0, 5.1.7.0, 5.1.8.0, 5.1.8.1, 5.1.9.0, 5.1.10.0
Issue
The Delphix Engine establishes connections to databases and host environments in a number of ways including JDBC and ssh.
Delphix documentation has a comprehensive list of incoming and outgoing ports that need to be accessible for each of the data platforms supported (search the documentation site for the key words "Network and Connectivity Requirements"). Very often when setting up new environments it is necessary to test connectivity between the Delphix Engine and a listening port on another host. Customers can easily test connectivity to ports listening on the Delphix Engine from their own hosts using various tests (telnet, mconnect, netcat, nc, etc.). Since customers do not have access to operating system commands on the Delphix Engine, connectivity to ports on other hosts can be tested from the Delphix Command Line Interface (CLI).
Troubleshooting Connectivity to a Specific TCP Port
Most frequently this error presents itself when adding a new environment or linking a new dSource with an error message indicating a failure to connect to a specific port:
The TCP/IP connection to the host 10.12.0.6, port 1433 has failed. Error: "Connection timed out: no further information. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
It is also possible to see this type of error message in existing environments for various reasons (database is down, firewall or networking changes, et cetera).
Resolution
If you know the listening port number (or it is displayed in the error message), the "ssh" test from the Delphix Command Line Interface (CLI) using an Admin login (delphix_admin or admin, by default, but any Admin user is permissible) can be used to exercise a connection to the desired host and port. Unless you are testing connectivity to an actual ssh port, it is perfectly acceptable to use a dummy user name and password.
The "jdbc" test is only compatible with Oracle at the time of this writing.
The "connector" test is used for testing connectivity to the Delphix Connector running on Windows hosts.
Configuring the test parameters
$ ssh delphix_admin@10.120.1.50 Password: 10.120.1.50> connectivity 10.120.1.50 connectivity> ls Operations connector jdbc ssh 10.120.1.50 connectivity> ssh 10.120.1.50 connectivity ssh *> ls Properties type: SSHConnectivity address: (required) credentials: type: KerberosCredential port: 22 (*) username: (required) 10.120.1.50 connectivity ssh *> set address=10.124.0.6 10.120.1.50 connectivity ssh *> set port=12345 10.120.1.50 connectivity ssh *> set username=dummyuser 10.120.1.50 connectivity ssh *> set credentials.type=PasswordCredential 10.120.1.50 connectivity ssh *> set credentials.password=dummypassword
Test Results - Pre-Delphix 5.3.x
In Delphix 5.1.x-5.2.x, the "Diagnoses" indicates whether the Delphix engine can successfully reach the port on the specified host.
5.1.x-5.2.x Connection failed
10.120.1.50 connectivity ssh *> commit Error: Unable to SSH to host "10.124.0.6". Action: Make sure "10.124.0.6" is running and is reachable via SSH from the Delphix Engine. Diagnoses: Failure:Could not connect on SSH port 12345 on host "10.124.0.6".
5.1.x-5.2.x Successful connection (Reached a server process listening on the specified port)
10.120.1.50 connectivity ssh *> set port=1433 10.120.1.50 connectivity ssh *> commit Error: Unable to SSH to host "10.124.0.6". Action: Make sure "10.124.0.6" is running and is reachable via SSH from the Delphix Engine. Diagnoses: Success:Reached a server listening on port 1433 on host "10.124.0.6" from the Delphix Engine.
Test Results - Delphix 5.3.x and Later
In Delphix versions 5.3.x, Diagnoses is now Output, and the possible results are:
5.3.x and Later Successful connection (remote Unix/Linux server closes connection, confirming we reached a remote service)
delphix connectivity ssh *> commit Error: An error occurred when attempting to connect to remote host "linuxhost". Action: Check connectivity to the host and try again. Verify the host address is correct for the environment. Output: net.schmizz.sshj.transport.TransportException: Server closed connection during identification exchange
5.3.x and Later Successful connection (remote Windows server resets connection, confirming we reached a remote service)
delphix connectivity ssh *> commit Error: An error occurred when attempting to connect to remote host "windowshost". Action: Check connectivity to the host and try again. Verify the host address is correct for the environment. Output: net.schmizz.sshj.transport.TransportException: Connection reset
5.3.x and Later Connection failure (connection refused, remote server is not listening on the given port but the test did reach the host successfully)
delphix connectivity ssh *> set port=800 delphix connectivity ssh *> commit Error: An error occurred when attempting to connect to remote host "linuxhost". Action: Check connectivity to the host and try again. Verify the host address is correct for the environment. Output: java.net.ConnectException: Connection refused (Connection refused)
5.3.x and Later Connection failure (cannot reach the address/port specified)
This result can indicate an unreachable address provided, bad routing configuration, or a firewall connection failure.
delphix connectivity ssh *> commit Error: An error occurred when attempting to connect to remote host "linuxhost". Action: Check connectivity to the host and try again. Verify the host address is correct for the environment. Output: java.net.ConnectException: Connection timed out (Connection timed out)
If it is unable to successfully reach the port, make sure that there is a process listening on the port by logging in directly to the specified host and issuing the netstat command:
UNIX: netstat -an | grep 5400 tcp 0 0 10.43.16.80:5400 0.0.0.0:* LISTEN Windows: netstat -an | find "1433" TCP 0.0.0.0:1433 0.0.0.0:0 LISTENING
If you are able to confirm that the port is listening on the IP (or ANY 0.0.0.0) address but Delphix cannot reach the host, please raise a ticket with your network/firewall team to request connectivity be granted between the two hosts.