Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  InformixHQ

    Posted 06/22/20 08:06 AM
    Edited by System Admin 01/20/23 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 06/22/20 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 06/22/20 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
    ------------------------------

    Original Message


  • 4.  RE: InformixHQ

    Posted 06/22/20 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

     

     




    Original Message


  • 5.  RE: InformixHQ

    Posted 06/22/20 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
    ------------------------------

    Original Message


  • 6.  RE: InformixHQ

    Posted 06/22/20 11:03 AM
    Test-NetConnection succeeded. 

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


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


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

    Original Message


  • 7.  RE: InformixHQ

    Posted 06/23/20 01:05 AM
    Edited by System Admin 01/20/23 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
    ------------------------------



Related Content