OAT is not connecting to database server
A user reported that OAT could only connect to the Informix server when sqlhosts contained the IP address; using the hostname (even fully qualified) failed. Respondents suggested name-resolution problems: check that the hostname pings and resolves to the correct machine/IP, and in particular that the server's /etc/hosts doesn't map the machine name to 127.0.0.1, which would make the listener bind to localhost only — verifiable with netstat -an. The poster did not report back, so no confirmed resolution is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Thank you all who are responding and very active in IIUG. Hello, I am able to connect to database server through OAT only while i mention the IP address instead of hostname in SQLHOSTS file. but whlie using the hostname in SQLHOSTS file it is not connecting to database server. What is the solution for this.
Probably the hostname needs to be qualified. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Jun 30, 2017 at 7:30 AM, MUKESH TANUKU <mukeshbt1328@gmail.com> wrote: > Thank you all who are responding and very active in IIUG. > > Hello, > I am able to connect to database server through OAT only while i mention > the > IP address instead of hostname in SQLHOSTS file. > > but whlie using the hostname in SQLHOSTS file it is not connecting to > database > server. > > What is the solution for this. > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >
I am giving the fully qualified hostname. but not connecting
Or that hostname = resolves to a different IP address .. ? On different hosts? ----- Original message ----- From: "Art Kagel" <art.kagel@gmai= l.com> Sent by: ids-bounces@iiug.org To: ids@iiug.org Cc: Su= bject: Re: OAT is not connecting to database server [39482] Date: Fri, J= un 30, 2017 2:19 PM Probably the hostname needs to be qualified. Art Art S. = Kagel, President and Principal Consultant ASK Database Management www= .askdbmgt.com Blog: [1]http://informix-myview.blogspot.com/ Discla= imer: Please keep in mind that my own opinions are my own opinions and d= o not reflect on the IIUG, nor any other organization with which I am as= sociated either explicitly, implicitly, or by inference. Neither do thos= e opinions reflect those of other individuals affiliated with any entity= with which I am affiliated nor those of the entities themselves. On= Fri, Jun 30, 2017 at 7:30 AM, MUKESH TANUKU <mukeshbt1328@gmail.com>= wrote: > Thank you all who are responding and very active in = IIUG. > > Hello, > I am able to connect to database serve= r through OAT only while i mention > the > IP address instead o= f hostname in SQLHOSTS file. > > but whlie using the hostname i= n SQLHOSTS file it is not connecting to > database > server. > > What is the solution for this. > > > ******= ****************************************************** > ************= ******* > Forum Note: Use "Reply" to post a response in the discussio= n forum. > > ***************************************= **************************************** Forum Note: Use "Re= ply" to post a response in the discussion forum. References 1. 3D"http://informix-myview.blogspot.com"/
Try pinging and double check the name resolves to the correct machine Cheers Paul -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of MUKESH TANUKU Sent: Friday, June 30, 2017 7:35 AM To: ids@iiug.org Subject: Re: OAT is not connecting to database server [39484] I am giving the fully qualified hostname. but not connecting **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.
Yes, I've seen that. At one client the local hosts file had the machine name mapped to localhost while on the remote clients it had the correct hostname so the server wasn't actually listening on the network to it's actual IP address only to localhost. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Jun 30, 2017 at 8:39 AM, Andreas Legner <andreas.legner@de.ibm.com> wrote: > Or that hostname = resolves to a different IP address .. ? On > > different hosts? > > ----- Original message ----- > > From: "Art Kagel" <art.kagel@gmai= l.com> > > Sent by: ids-bounces@iiug.org > > To: ids@iiug.org > > Cc: > > Su= bject: Re: OAT is not connecting to database server [39482] > > Date: Fri, J= un 30, 2017 2:19 PM > > Probably the hostname needs to be qualified. > > Art > > Art S. = Kagel, President and Principal Consultant > > ASK Database Management > > www= .askdbmgt.com > > Blog: [1]http://informix-myview.blogspot.com/ > > Discla= imer: Please keep in mind that my own opinions are my own > > opinions > > and d= o not reflect on the IIUG, nor any other organization with > > which I am > > as= sociated either explicitly, implicitly, or by inference. Neither > > do > > thos= e opinions reflect those of other individuals affiliated with > > any > > entity= with which I am affiliated nor those of the entities > > themselves. > > On= Fri, Jun 30, 2017 at 7:30 AM, MUKESH TANUKU > > <mukeshbt1328@gmail.com>= > > wrote: > > > Thank you all who are responding and very active in = IIUG. > > > > > > Hello, > > > I am able to connect to database serve= r through OAT only while i > > mention > > > the > > > IP address instead o= f hostname in SQLHOSTS file. > > > > > > but whlie using the hostname i= n SQLHOSTS file it is not connecting > > to > > > database > > > server. > > > > > > What is the solution for this. > > > > > > > > > ******= ****************************************************** > > > ************= ******* > > > Forum Note: Use "Reply" to post a response in the discussio= n > > forum. > > > > > > > > ***************************************= > > **************************************** > > Forum Note: Use "Re= ply" to post a response in the discussion > > forum. > > References > > 1. 3D"http://informix-myview.blogspot.com"/ > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >
I have had this same problem too. Use netstat -an on the server to verify that the listener is running on the server's IP/port and not localhost (127.0.0.1). This could be the problem with your HDR connection too, but you said that you have fixed that. Mike -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel Sent: Friday, June 30, 2017 6:54 AM To: ids@iiug.org Subject: Re: OAT is not connecting to database server [39487] Yes, I've seen that. At one client the local hosts file had the machine name mapped to localhost while on the remote clients it had the correct hostname so the server wasn't actually listening on the network to it's actual IP address only to localhost. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Jun 30, 2017 at 8:39 AM, Andreas Legner <andreas.legner@de.ibm.com> wrote: > Or that hostname = resolves to a different IP address .. ? On > > different hosts? > > ----- Original message ----- > > From: "Art Kagel" <art.kagel@gmai= l.com> > > Sent by: ids-bounces@iiug.org > > To: ids@iiug.org > > Cc: > > Su= bject: Re: OAT is not connecting to database server [39482] > > Date: Fri, J= un 30, 2017 2:19 PM > > Probably the hostname needs to be qualified. > > Art > > Art S. = Kagel, President and Principal Consultant > > ASK Database Management > > www= .askdbmgt.com > > Blog: [1]http://informix-myview.blogspot.com/ > > Discla= imer: Please keep in mind that my own opinions are my own > > opinions > > and d= o not reflect on the IIUG, nor any other organization with > > which I am > > as= sociated either explicitly, implicitly, or by inference. Neither > > do > > thos= e opinions reflect those of other individuals affiliated with > > any > > entity= with which I am affiliated nor those of the entities > > themselves. > > On= Fri, Jun 30, 2017 at 7:30 AM, MUKESH TANUKU > > <mukeshbt1328@gmail.com>= > > wrote: > > > Thank you all who are responding and very active in = IIUG. > > > > > > Hello, > > > I am able to connect to database serve= r through OAT only while i > > mention > > > the > > > IP address instead o= f hostname in SQLHOSTS file. > > > > > > but whlie using the hostname i= n SQLHOSTS file it is not connecting > > to > > > database > > > server. > > > > > > What is the solution for this. > > > > > > > > > ******= ****************************************************** > > > ************= ******* > > > Forum Note: Use "Reply" to post a response in the discussio= n > > forum. > > > > > > > > ***************************************= > > **************************************** > > Forum Note: Use "Re= ply" to post a response in the discussion > > forum. > > References > > 1. 3D"http://informix-myview.blogspot.com"/ > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.