Connection Refused
A user running Informix 7.31.TD6 on Windows 10 suddenly could no longer connect from a VirtualBox VM (and from SQL Editor), getting error -908 "Attempt to connect to database server failed / Connection refused", despite unchanged ODBC, Setnet32 and firewall settings. Advice included checking online.log, using netstat to see which interface the listener was bound to, adding '*' before the hostname in sqlhosts to listen on all interfaces, and testing with telnet to host/port. The poster reported it fixed after changing the engine password and restarting the server; Fernando Nunes noted a password cannot cause -908 and that the engine restart was the likely real fix.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
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!
What does
onstat -msay?
You might have to dig further through the log backwards.
Regards,
Jack Parker
> On Mar 21, 2018, at 10:08 AM, GUSTAVO ECHENIQUE
<gustavo.echenique@cemdo.com.ar> wrote:
>
> 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.
>
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.
Hi Jack, thanks for your response.
The onstat -m says:
"Informix Dynamic Server Version 7.31.TD6 -- On-Line -- Up 03:17:51 -- 478208
Kbytes
Message Log File: c:\\\\INFORM~1\\\\ol_gechenique.log
Wed Mar 21 08:21:34 2018
08:21:34 DR: DRAUTO is 0 (Off)
08:21:34 Informix Dynamic Server Version 7.31.TD6 Software Serial Number
ACP#J267193
08:21:38 Informix Dynamic Server Initialized -- Shared Memory Initialized.
08:21:38 Physical Recovery Started.
08:21:40 Physical Recovery Complete: 0 Pages Restored.
08:21:40 Logical Recovery Started.
08:21:42 Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
08:21:44 Dataskip is now OFF for all dbspaces
08:21:44 Init operation complete - Mode Online
08:21:44 On-Line Mode
08:21:56 Checkpoint Completed: duration was 1 seconds.
08:21:56 Checkpoint loguniq 80, logpos 0x2974018
08:27:25 Checkpoint Completed: duration was 0 seconds.
08:27:25 Checkpoint loguniq 80, logpos 0x2975018"
Youll need to dig back further in the log (c:\\\\INFORM~1\\\\ol_gechenique.log ) to
see what the engine thought at the time you attempted to connection.
Regards,
Jack Parker
> On Mar 21, 2018, at 10:41 AM, GUSTAVO ECHENIQUE
<gustavo.echenique@cemdo.com.ar> wrote:
>
> Hi Jack, thanks for your response.
>
> The onstat -m says:
> "Informix Dynamic Server Version 7.31.TD6 -- On-Line -- Up 03:17:51 -- 478208
> Kbytes
>
> Message Log File: c:\\\\INFORM~1\\\\ol_gechenique.log
> Wed Mar 21 08:21:34 2018
>
> 08:21:34 DR: DRAUTO is 0 (Off)
> 08:21:34 Informix Dynamic Server Version 7.31.TD6 Software Serial Number
> ACP#J267193
> 08:21:38 Informix Dynamic Server Initialized -- Shared Memory Initialized.
> 08:21:38 Physical Recovery Started.
> 08:21:40 Physical Recovery Complete: 0 Pages Restored.
> 08:21:40 Logical Recovery Started.
> 08:21:42 Logical Recovery Complete.
>
> 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
>
> 08:21:44 Dataskip is now OFF for all dbspaces
> 08:21:44 Init operation complete - Mode Online
> 08:21:44 On-Line Mode
> 08:21:56 Checkpoint Completed: duration was 1 seconds.
> 08:21:56 Checkpoint loguniq 80, logpos 0x2974018
>
> 08:27:25 Checkpoint Completed: duration was 0 seconds.
> 08:27:25 Checkpoint loguniq 80, logpos 0x2975018"
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Hola Mauricio! Muchas gracias por responder, te debo tantas ya, que no puedo ni contarlas. Vos sabés que en el arhivo hosts de Windows, sólo se declara el nombre del equipo, y en la columna del lado, su dirección IP. ¿En dónde te aparece la información con ese formato?. Y lo más extraño es que funcionaba perfecto hasta el lunes. Te mando un abrazo!
A -908 on the client means it couldn't reach the server. There will be no
matching message in online.log.
The rational behind your request makes perfect sense if the error on the
client is -951 which can translate into -951, -952, -956 and maybe some
others I can't remember now.
But for -908 it's either a client misconfiguration, a firewall issue or
simply the listener is not there...
Regards.
On Wed, Mar 21, 2018 at 3:45 PM, Jack Parker <jack.parker4@verizon.net>
wrote:
> Youll need to dig back further in the log (c:\\\\INFORM~1\\\\ol_gechenique.log )
> to
> see what the engine thought at the time you attempted to connection.
>
> Regards,
> Jack Parker
>
> > On Mar 21, 2018, at 10:41 AM, GUSTAVO ECHENIQUE
> <gustavo.echenique@cemdo.com.ar> wrote:
> >
> > Hi Jack, thanks for your response.
> >
> > The onstat -m says:
> > "Informix Dynamic Server Version 7.31.TD6 -- On-Line -- Up 03:17:51 --
> 478208
> > Kbytes
> >
> > Message Log File: c:\\\\INFORM~1\\\\ol_gechenique.log
> > Wed Mar 21 08:21:34 2018
> >
> > 08:21:34 DR: DRAUTO is 0 (Off)
> > 08:21:34 Informix Dynamic Server Version 7.31.TD6 Software Serial Number
> > ACP#J267193
> > 08:21:38 Informix Dynamic Server Initialized -- Shared Memory
> Initialized.
> > 08:21:38 Physical Recovery Started.
> > 08:21:40 Physical Recovery Complete: 0 Pages Restored.
> > 08:21:40 Logical Recovery Started.
> > 08:21:42 Logical Recovery Complete.
> >
> > 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
> >
> > 08:21:44 Dataskip is now OFF for all dbspaces
> > 08:21:44 Init operation complete - Mode Online
> > 08:21:44 On-Line Mode
> > 08:21:56 Checkpoint Completed: duration was 1 seconds.
> > 08:21:56 Checkpoint loguniq 80, logpos 0x2974018
> >
> > 08:27:25 Checkpoint Completed: duration was 0 seconds.
> > 08:27:25 Checkpoint loguniq 80, logpos 0x2975018"
> >
> >
> >
> ************************************************************
> *******************
> > 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...
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...
Dear colleagues, at last I was able to solve my problem. Every time I ran the application, I threw the error warning that it could not connect to the database, and I unconfigured the data entered in the Setnet32. I did it as an administrator, and it told me that the variable INFORMIXSERVER was not configured, when it was. On the other hand, the SQL Editor also failed, therefore there were two possible failure options: the Windows Firewall, or the database engine. I deactivated the Firewall by registry and the failure persisted. By a hunch, I changed the engine password, and it worked correctly. The reason why the password could have been changed is something that I do not understand, since I did not install anything, and I did not make modifications either. I appreciate your help.
Dear colleagues, at last I was able to solve my problem. Every time I ran the application, I threw the error warning that it could not connect to the database, and I unconfigured the data entered in the Setnet32. I did it as an administrator, and it told me that the variable INFORMIXSERVER was not configured, when it was. On the other hand, the SQL Editor also failed, therefore there were two possible failure options: the Windows Firewall, or the database engine. I deactivated the Firewall by registry and the failure persisted. By a hunch, I changed the engine password, and it worked correctly. The reason why the password could have been changed is something that I do not understand, since I did not install anything, and I did not make modifications either. I appreciate your help.
Dear colleagues, at last I was able to solve my problem. Every time I ran the application, I threw the error warning that it could not connect to the database, and I unconfigured the data entered in the Setnet32. I did it as an administrator, and it told me that the variable INFORMIXSERVER was not configured, when it was. On the other hand, the SQL Editor also failed, therefore there were two possible failure options: the Windows Firewall, or the database engine. I deactivated the Firewall by registry and the failure persisted. By a hunch, I changed the engine password, and it worked correctly. The reason why the password could have been changed is something that I do not understand, since I did not install anything, and I did not make modifications either. I appreciate your help.
Not sure if I'm following you... a wrong password set on a client connection definition will NEVER raise a 908 error. Did you restart the engine?... On Thu, Mar 22, 2018 at 1:41 PM, GUSTAVO ECHENIQUE < gustavo.echenique@cemdo.com.ar> wrote: > Dear colleagues, at last I was able to solve my problem. > > Every time I ran the application, I threw the error warning that it could > not > connect to the database, and I unconfigured the data entered in the > Setnet32. > I did it as an administrator, and it told me that the variable > INFORMIXSERVER > was not configured, when it was. > > On the other hand, the SQL Editor also failed, therefore there were two > possible failure options: the Windows Firewall, or the database engine. > > I deactivated the Firewall by registry and the failure persisted. > > By a hunch, I changed the engine password, and it worked correctly. > > The reason why the password could have been changed is something that I do > not > understand, since I did not install anything, and I did not make > modifications > either. > > I appreciate your help. > > > ************************************************************ > ******************* > 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...
Hello Fernando: The password that I changed was in the informix engine, and yes, I had to restart it and everything worked fine.
That's the point... The bad thing in these mailing lists is that year from now, someone will have a similar issue, Google may find this thread, and the poor engineer may get the idea that changing a password may solve a 908 error. It won't. However, (re)starting a database engine is a good possibility to solve a 908 :) Regards. On Thu, Mar 22, 2018 at 2:02 PM, GUSTAVO ECHENIQUE < gustavo.echenique@cemdo.com.ar> wrote: > Hello Fernando: > > The password that I changed was in the informix engine, and yes, I had to > restart it and everything worked fine. > > > ************************************************************ > ******************* > 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...
Hi, Can you try telnet. telnet hostfromsqlhost portfromsqlhost. what's is response? Petr Dne 22.3.2018 v 14:51 Fernando Nunes napsal(a): > That's the point... The bad thing in these mailing lists is that year from > now, someone will have a similar issue, Google may find this thread, and > the poor engineer may get the idea that changing a password may solve a 908 > error. It won't. However, (re)starting a database engine is a good > possibility to solve a 908 :) > > Regards. > > On Thu, Mar 22, 2018 at 2:02 PM, GUSTAVO ECHENIQUE < > gustavo.echenique@cemdo.com.ar> wrote: > >> Hello Fernando: >> >> The password that I changed was in the informix engine, and yes, I had to >> restart it and everything worked fine. >> >> >> ************************************************************ >> ******************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >>
Firewall ports open? -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Petr Pomykacek Sent: Thursday, March 22, 2018 10:08 AM To: ids@iiug.org Subject: Re: Connection Refused (Solved) [40920] Hi, Can you try telnet. telnet hostfromsqlhost portfromsqlhost. what's is response? Petr Dne 22.3.2018 v 14:51 Fernando Nunes napsal(a): > That's the point... The bad thing in these mailing lists is that year > from now, someone will have a similar issue, Google may find this > thread, and the poor engineer may get the idea that changing a > password may solve a 908 error. It won't. However, (re)starting a > database engine is a good possibility to solve a 908 :) > > Regards. > > On Thu, Mar 22, 2018 at 2:02 PM, GUSTAVO ECHENIQUE < > gustavo.echenique@cemdo.com.ar> wrote: > >> Hello Fernando: >> >> The password that I changed was in the informix engine, and yes, I >> had to restart it and everything worked fine. >> >> >> ************************************************************ >> ******************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.