Skip to main content
Delphix

KBA1732 How to Test Connectivity to a Specific TCP Port From the Delphix Engine

 

 

Applicable Delphix Versions

Major Release

All Sub Releases

5.2 5.2.2.0, 5.2.2.1, 5.2.3.0

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

Issue

The Delphix Engine establishes connections to databases and host environments in a number of ways including JDBC and ssh. The 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

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, etc). 

Resolution

If you know the listening port number (or it is displayed in the error message), use the "ssh" test from Delphix's Command Line Interface (CLI) to try connecting to the desired 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.

$ 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
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".


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.

The "Diagnoses" indicates whether the Delphix engine can successfully reach the port on the specified host.

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.

Additional Information

 

External Links