IDS Forum

Re: Connection Refused

Posted By: Fernando Nunes
Date: Wednesday, 21 March 2018, at 5:08 p.m.

In Response To: RE: Connection Refused (Mauricio Rapari)

The star "*" in front of the hostname has nothing (little?) to do with IPV6
vs IPV4. What it does is to open the listener on all the TCP interfaces on
the host.
So if you have a hostname that maps to the IPV6 address and you don't use
the star, the listener will only be connected to the IPV6 interface.
But if the same host has an IPV6 and an IPV4 interface, and you use the
start, a listener will be created in the IPV4 interface, and voilá, you're
working also with IPV4.
Same applies if your hostname resolves to the local interface (127.0.0.0)
which is very common on Windows. I'd say that the current situation matches
that.

The OP should check where the Informix listener is listening. A "netstat
-an" will show all the connections and listeners. Check the one with port
number that matches the Informix configuration and see where it's connected
to. Probably it will be 127.0.0.1 or the IPV6 equivalent. If that's the
case, the hostname resolution is probably broken. Naturally he should start
by checking if Informix is running :)
Being 7.x, it's not possible for the engine to be running and the listener
to be stopped. But assuming it's up, then he needs to find the listener. If
the listener is up and running, and is on an external interface, then it's
a firewall issue. From the client, a "telnet servername informix_port" will
be able to test basic connectivity and firewall configurations...

Regards.

On Wed, Mar 21, 2018 at 3:31 PM, Mauricio Rapari <
mrapari@aguasbonaerenses.com.ar> wrote:

> Hola Gustavo
>
> Si usas ipv4 debes agregarle al sqlhosts un * adelante del nombre del
> server.
>
> Te paso un ejemplo.
>
> C:\Program Files\IBM Informix Software Bundle\etc>more sqlhosts.ol*
> ol_informix1210 olsoctcp aguas-otic ol_informix1210
> #dr_informix1210 drsoctcp aguas-otic dr_informix1210
> #lo_informix1210 olsoctcp 127.0.0.1 lo_informix1210
> ids_win olsoctcp *aguas-otic ids_win
>
> De esta forma podes accede al port tcp/ip po r ipv4. Me volvió loco!. Lo
> busque en un documento de ibm por default viene en versión 12 para wind
> para
> ipv6
>
> Tenes que subir y bajar el motor,
>
> Saludos Mauricio Rapari.
>
> -----Mensaje original-----
> De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] En nombre de
> GUSTAVO
> ECHENIQUE
> Enviado el: miércoles, 21 de marzo de 2018 11:09 a.m.
> Para: ids@iiug.org
> Asunto: Connection Refused [40890]
>
> Dear colleagues:
>
> I have the following problem:
>
> My PC has a 64-bit Windows 10 installed, and I have an Informix 7.31 TD6
> engine installed, which works perfectly. I also have the SQL Editor
> installed,
> and it connects without any problem to said engine.
>
> As I also have to run a 16 bit application, I created a virtual machine
> with
> VirtualBox, which worked without problems until Monday. Suddenly the
> application could not connect to the database, and the SQL Editor could not
> either.
>
> I checked the Windows Firewall, but it is well configured, like the ODBC,
> and
> the Setnet32.
>
> I've also tried the ILogin and dbPing utilities, but they can not connect.
>
> The SQL Editor throws me the following error:
> "- [Informix] [isqct04b.dll] SQL Error (-908): Attempt to connect to
> database
> server (ol_gechenique) failed."
>
> The dbPing also throws an error, and is the following:
> "[INTERSOLV] [ODBC Informix Driver] [Informix] Attempt to connecto to
> database
> server (ol_gechenique) failed.
> [INTERSOLV] [ODBC Informix Driver] [Informix] Connection refused. "
>
> I no longer know where to look, since it always worked, and now, without
> having made modifications, it does not work anymore. The worst thing is
> that
> the configurations are well done.
>
> I hope someone can help me with this error.
>
> Regards!
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...

Messages In This Thread

• Connection Refused
  GUSTAVO ECHENIQUE -- Wednesday, 21 March 2018, at 10:08 a.m.
  • Re: Connection Refused
    Jack Parker -- Wednesday, 21 March 2018, at 10:12 a.m.
    • Re: Connection Refused
      GUSTAVO ECHENIQUE -- Wednesday, 21 March 2018, at 10:41 a.m.
      • Re: Connection Refused
        Jack Parker -- Wednesday, 21 March 2018, at 10:45 a.m.
        • Re: Connection Refused
          Fernando Nunes -- Wednesday, 21 March 2018, at 4:59 p.m.
          • Re: Connection Refused (Solved)
            GUSTAVO ECHENIQUE -- Thursday, 22 March 2018, at 8:41 a.m.
            • Re: Connection Refused (Solved)
              Fernando Nunes -- Thursday, 22 March 2018, at 8:45 a.m.
              • Re: Connection Refused (Solved)
                GUSTAVO ECHENIQUE -- Thursday, 22 March 2018, at 9:02 a.m.
                • Re: Connection Refused (Solved)
                  Fernando Nunes -- Thursday, 22 March 2018, at 9:51 a.m.
                  • Re: Connection Refused (Solved)
                    Petr Pomykacek -- Thursday, 22 March 2018, at 10:08 a.m.
                    • RE: Connection Refused (Solved)
                      Mueller, Daniel D. -- Thursday, 22 March 2018, at 10:29 a.m.
  • RE: Connection Refused
    Mauricio Rapari -- Wednesday, 21 March 2018, at 10:31 a.m.
    • Re: RE: Connection Refused
      GUSTAVO ECHENIQUE -- Wednesday, 21 March 2018, at 10:47 a.m.
    • Re: Connection Refused
      Fernando Nunes -- Wednesday, 21 March 2018, at 5:08 p.m.
    • Re: RE: Connection Refused (Solved)
      GUSTAVO ECHENIQUE -- Thursday, 22 March 2018, at 8:44 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.