InformixHQ
Posted in 2020
Cherry installed Informix 12.10.FC14 on Windows 2016 for InformixHQ, but the server showed offline and the HQ log reported a socket connection failure to port 1525. SangGyu Jeong suggested an IP address; that failed. Paul Watson suggested telnet to the port and Martin Graney Test-NetConnection, which succeeded. Gaurav Kumar asked about the network and online.log. Unresolved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Topics: Installation, Setup & Upgrades, Connectivity: ODBC / JDBC / .NET
Hello, I have installed informix 12.10.FC14 and created informix instance in windows 2016 server. This setup is to be used for InformixHQ Tool. I have logged into informixhq and tried to add same machine. After providing Informix server name, host name and port, the server status is showing offline in informixhq. I am able to access Informix instance remotely but could add it to informixhq locally. I see below error details in hq log. 2020-06-22 13:03:11.779 [qtp14899164-160] ERROR c.i.h.s.informix.InformixConnector - Could not connect to Informix: jdbc:informix-sqli://dcxxx:1525: sysmaster. Socket connection to server (dcxxx:1525) failed. Check your server is reachable from this client on the host:port specified.2020-06-22 13:03:11.779 [qtp14899164-160] ERROR c.i.h.s.informix.InformixConnector - Could not connect to Informix: jdbc:informix-sqli://dcxxx:1525: sysmaster. Socket connection to server (dcxxx:1525) failed. ------------------------------ Cherry ------------------------------ #Informix
Hello, If it's a local connection, it doesn't seem like a firewall issue. How about trying an ip address instead of hostname? ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------
Tried IP Address, but no luck. Could not connect to Informix: jdbc:informix-sqli://1x.xxx.xxx.xx:1525: sysmaster. Socket connection to server (1x.xxx.xxx.xx:1525) failed. ------------------------------ Cherry ------------------------------
From the HQ server try Telnet <ip> <port> If you get a connection hit <return> and you should see a 408 (28014 if using ssl) error on the server. If you don't see either then you are not connecting where you think you are If you get connection refused something is blocking you or you are using the wrong ip/port Cheers Paul
Cherry: If you do not have the Telnet client installed on your Win2016 server you can use PowerShell's Test-NetConnection command: Test-NetConnection -ComputerName "localhost" -InformationLevel "Detailed" -Port 1525 WARNING: TCP connect to (::1 : 1525) failed WARNING: TCP connect to (127.0.0.1 : 1525) failed You can substitute your system's IP or name for "localhost" ------------------------------ Best regards, Martin Graney Queues Enforth Development, Inc. Stoneham, MA 02148 ------------------------------
Test-NetConnection succeeded. PS> Test-NetConnection -ComputerName "dxxxxx" -InformationLevel "Detailed" -Port 1525 ComputerName : dcxxxx RemotePort : 1525 ............ TcpTestSucceeded : True ------------------------------ Cherry ------------------------------
At first it looks like your server is not reachable? have you tested the connection between your HQ machine and IDS machine? Are they on same network? HQ Agent gets started after Informix HQ server is up and running. What is the status of your Informix HQ server? Did you see connection attempt in IDS online.log? ------------------------------ Gaurav Kumar ------------------------------