Informix

 View Only
  • 1.  InformixHQ

    Posted Mon June 22, 2020 08:06 AM
    Edited by System Fri January 20, 2023 04:18 PM
    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


  • 2.  RE: InformixHQ

    Posted Mon June 22, 2020 08:58 AM
    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 Mon June 22, 2020 10:31 AM
    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

    IBM Champion
    Posted Mon June 22, 2020 10:35 AM

    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 Mon June 22, 2020 10:51 AM

    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 Mon June 22, 2020 11:03 AM
    Test-NetConnection succeeded. 

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


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


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



  • 7.  RE: InformixHQ

    Posted Tue June 23, 2020 01:05 AM
    Edited by System Fri January 20, 2023 04:10 PM
    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
    ------------------------------