Use Telnet to Diagnose PSQL Communication & Port Disabling Problem

Use Telnet to Diagnose PSQL Communication & Port Disabling Problem

Release Date: 08/02/2021

If you are running Elliott directly on the PSQL server console, and Elliott suddenly stops working and displays a file access error like 3XXXX for the SYSPASS.BTR file on a workstation while it is working, it is an indication of a network error. If this error is consistent, then it is likely because there's some kind of TCP port blocking the PSQL communication traffic. The likely causes could be:
  • The Windows Server firewall is turned on -- This could be the result of configuring the role of the server  to be a "public" server, which will cause the Windows server OS to tightly control the allowed port number access.  Often the installation of a service pact update can cause an issue like this.
  • Anti-Virus Software -- The anti-virus software can block network traffic communication and cause similar issues.
  • Physical Firewall -- If a physical firewall is installed and a configuration is changed, it can block the network traffic for PSQL.
PSQL TCP Port Number
The best way to diagnose and confirm if the network traffic is blocked is to use the Telnet utility to confirm.  PSQL uses the following two port numbers to communicate, and we need to make sure they are not blocked:
  • 1583
  • 3351
Use Telnet to Check If PSQL Port Number Is Open
For example, you could use the following command prompt:
    Telnet IP-address 1583
where IP-address is the PSQL server IP address like 10.0.16.10...etc.
  • If the command prompt screen becomes blank, that means the port is open and a connection is made. To exit, you can simply close the command prompt window.
  • If the command prompt screen does not change and looks as if it is stuck, then eventually times out with an error, that means the port is not open. See sample screen below.


Should Netcellent Support Look into the Port Number Problem?
It is important to know whether the PSQL issue is due to the port opening problem to determine who you should talk to.  Netcellent support cannot resolve it for you if the necessary ports for PSQL on the server or client are not open. You will need to get your IT support for a proper solution.  On the other hand, if the port is open and PSQL is not working, that it is something Netcellent support should look into further.

Enable Telnet Client
Just FYI, Telnet utility is not installed by default.  To install it, go to the bottom left corner of your desktop and choose "Search," then type "Turn Windows features on or off." See sample screen below:


In Windows Features, find "Telnet Client" and check it to install. See sample screen below:


EMK


    • Related Articles

    • IPV6 May Cause Problem for PSQL 11 Relational Query

      Release Date: 01/20/19 IPV6 (Internet Protocol Version 6) is designed to eventually replace IPV4. IPV4 has an IP address like 192.168.1.1. Each segment can have a value from 0 - 255, so the theoretical maximum number of IPV4 addresses is a little ...

    • How to Use EL850DB.EXE Utility to Create PSQL Databases

      Release Date: 12/4/2018 Modified Date: 06/20/2020 Version: Elliott 8.5 Elliott 8.5 includes an EL850DB.EXE utility to make it easy to create PSQL databases. The new utility EL850DB.EXE is included in the Elliott 8.5 release, and you can find it in ...

    • Hardware Recommendations for Your PSQL Database Server

      Release Date: 10/10/2017 This article was written by Bill Bach and is provided at the courtesy of Goldstar Software. Recommendations for hardware for your PSQL database environment One of the most common questions we get is “What kind of hardware ...

    • Installing Elliott 8.5 and Received "PSQL v11, v12 or V13 Is Required" Message

      Release Date: 11/14/19 Version: 8.5 & up When you are installing Elliott 8.5 on your server, you may receive the following message: PSQL v11, V12, or V13 is required. Please install PSQL first. See sample screen below: While you can confirm that you ...

    • How to Use Procdump.exe to Create a Memory Dump for PSQL Engine

      Released Date: 7/10/2017 If your PSQL server crashes from time to time, then it is necessary to get a memory dump of the PSQL engine processor and send that to Actian tech support for further analysis. The following procedure outlines how to do this. ...