Informix

nested-group-icon.png

DB2

Expand all | Collapse all

InformixHQ

  • 1.  InformixHQ

    Posted 16 days ago
    Edited by Cherry 16 days ago
    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
    ------------------------------


  • 2.  RE: InformixHQ

    Posted 16 days ago
    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
    ------------------------------



  • 3.  RE: InformixHQ

    Posted 16 days ago
    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
    ------------------------------



  • 4.  RE: InformixHQ

    Posted 16 days ago

    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

     

     






  • 5.  RE: InformixHQ

    Posted 16 days ago

    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
    ------------------------------



  • 6.  RE: InformixHQ

    Posted 16 days ago
    Test-NetConnection succeeded. 

    PS> Test-NetConnection -ComputerName "dxxxxx" -InformationLevel "Detailed" -Port 1525


    ComputerName : dcxxxx
    RemotePort : 1525
    ............
    TcpTestSucceeded : True


    ------------------------------
    Cherry
    ------------------------------



  • 7.  RE: InformixHQ

    Posted 16 days ago
    Edited by Gaurav Kumar 16 days ago
    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
    ------------------------------