 |
IDS Forum
Re: Remote database connection failed
Posted By: Fernando Nunes
Date: Wednesday, 9 October 2013, at 7:06 p.m.
In Response To: Re: Remote database connection failed (Paul Watson)
Agreed...
If the error is:
cm172895@whxd003madcs-new.sing.micron.com[whx003n]:
Do the following steps:
1- add this to /etc/hosts.equiv or ~cm172895/.rhosts:
whxd003madcs-new.sing.micron.com <cm172895@whxd003madcs-new.sing.micron.com>
cm172895 <cm172895@whxd003madcs-new.sing.micron.com>
2- If the above doesn't work add the following to the same file (without
removing the previous):
whx003n cm172895 <cm172895@whxd003madcs-new.sing.micron.com>
Please tell us the result.
The ping test doesn't prove anything... It shows the server can resolve the
FQDMN, but what matters is how the server REVERSE DNS the client IP
address. If it's to a fully qualified name then that's what you need to add.
If it only works with both entries... than it's "normal"... But it's a long
story. I'm not sure if there is any full fixpack version where that
happens... but it's highly likely there is...
Regards
On Wed, Oct 9, 2013 at 5:27 PM, Paul Watson <paul@oninit.com> wrote:
> you could be right but the error says
>
> cm172895@whxd003madcs-new.sing.micron.com
>
> is not trusted and the FQDN is not in the hosts.equiv - a very simple test
>
> Cheers
> Paul;
>
> > Dear Paul,
> >
> > Sorry, I don't think issue on FQDN. please see below
> >
> > C:\Users\bkrishna>ping whxd003madcs-new
> >
> > Pinging whxd003madcs-new.sing.micron.com [10.80.88.40] with 32 bytes of
> > data:
> > Reply from 10.80.88.40: bytes=32 time<1ms TTL=254
> > Reply from 10.80.88.40: bytes=32 time<1ms TTL=254
> > Reply from 10.80.88.40: bytes=32 time<1ms TTL=254
> > Reply from 10.80.88.40: bytes=32 time<1ms TTL=254
> >
> > On Wed, Oct 9, 2013 at 11:50 PM, Paul Watson <paul@oninit.com> wrote:
> >
> >> trying adding the FQDN as well
> >>
> >> > Yes, I have added already
> >> >
> >> > Informix Server
> >> >> informix@pmhx001$ more hosts.equiv
> >> >> NHX003 +
> >> >> WHX003-NEW +
> >> >> whxd003madcs-new +
> >> >
> >> > On Wed, Oct 9, 2013 at 11:11 PM, Paul Watson <paul@oninit.com> wrote:
> >> >
> >> >> Add
> >> >>
> >> >> whxd003madcs-new.sing.micron.com
> >> >>
> >> >> to the hosts.equiv file
> >> >>
> >> >> Cheers
> >> >> Paul
> >> >>
> >> >> > Dear All,
> >> >> >
> >> >> > Error:
> >> >> > 18:54:06 listener-thread: err = -956: oserr = 0: errstr =
> >> >> > cm172895@whxd003madcs-new.sing.micron.com[whx003n]: Client host or
> >> >> user
> >> >> > cm172895@whxd003madcs-new[whx003n] is not trusted by the server.
> >> >> >
> >> >> > Informix Client
> >> >> > root@whx003n# more hosts.equiv
> >> >> > whd003
> >> >> > whd003.amk.st.com
> >> >> > MHX003
> >> >> > MHD003
> >> >> > MHXD002
> >> >> > PMHX001
> >> >> >
> >> >> > Informix Server
> >> >> > informix@pmhx001$ more hosts.equiv
> >> >> > NHX003 +
> >> >> > WHX003-NEW +
> >> >> > whxd003madcs-new +
> >> >> >
> >> >> > informix@pmhx001$ more .rhosts
> >> >> > #testing
> >> >> > whx003-new informix
> >> >> > whd003-new informix
> >> >> > whxd003-new informix
> >> >> > whxd003ifx-new informix
> >> >> > whxd003app-new informix
> >> >> > whxd003madcs-new informix
> >> >> > whxd003tpm-new informix
> >> >> > whxd003qt-new informix
> >> >> >
> >> >> > On Wed, Oct 9, 2013 at 10:54 PM, Art Kagel <art.kagel@gmail.com>
> >> >> wrote:
> >> >> >
> >> >> >> You need to add the client to the hosts.equiv on the server!
> >> >> >>
> >> >> >> Art
> >> >> >>
> >> >> >> Art S. Kagel, Principal Consultant
> >> >> >>
> >> >> >> Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Wed, Oct 9, 2013 at 9:18 AM, medkba <medkba@gmail.com> wrote:
> >> >> >>
> >> >> >> > Yes, I have added earlier but still this error occurs. This is
> >> >> >> (MHX001)
> >> >> >> > informix server host name.
> >> >> >> >
> >> >> >> > whx003n - This is the client server host name
> >> >> >> >
> >> >> >> > root@whx003n# more hosts.equiv
> >> >> >> > MHX001
> >> >> >> >
> >> >> >> > On Wed, Oct 9, 2013 at 9:11 PM, Alexandre Marini
> >> >> <alexandre@briug.org
> >> >> >> > >wrote:
> >> >> >> >
> >> >> >> > > Ok.
> >> >> >> > > The description of this error suggests that the client
> >> computer
> >> >> or
> >> >> >> client
> >> >> >> > > user
> >> >> >> > > is not trusted by the Informix server.
> >> >> >> > >
> >> >> >> > > Check if your /etc/hosts.equiv file has an entry for the
> >> Informix
> >> >> >> server,
> >> >> >> > > in
> >> >> >> > > you client machine. That should fix your issue.
> >> >> >> > >
> >> >> >> > > Hope it helps.
> >> >> >> > > Regards.
> >> >> >> > >
> >> >> >> > > Alexandre Marini
> >> >> >> > > IBM Informix Certified Professional v10 / v11.50 / v11.70 /
> >> >> v12.10
> >> >> >> > >
> >> >> >> > > IBM Information Management Informix Technical Professional
> >> >> >> > >
> >> >> >> > > IBM Infosphere DataStage Technical Professional
> >> >> >> > > Informix Senior DBA - Orizon Brasil
> >> >> >> > > BRIUG website administrator
> >> >> >> > > Informix independent consultant
> >> >> >> > >
> >> >> >> > > > To: ids@iiug.org
> >> >> >> > > > From: medkba@gmail.com
> >> >> >> > > > Subject: Re: Remote database connection failed [31662]
> >> >> >> > > > Date: Wed, 9 Oct 2013 08:16:59 -0400
> >> >> >> > > >
> >> >> >> > > > Thank you Alexandre Marini
> >> >> >> > > >
> >> >> >> > > > I have managed to find the issue and fix it. But, I have
> >> >> another
> >> >> >> error.
> >> >> >> > > If
> >> >> >> > > > you could give me some clue may be able to fix this issue.
> >> >> version
> >> >> >> > > 11.50FC9
> >> >> >> > > >
> >> >> >> > > > 18:54:06 listener-thread: err = -956: oserr = 0: errstr =
> >> >> >> > > > cm172895@whxd003madcs-new.sing.micron.com[whx003n]: Client
> >> host
> >> >> or
> >> >> >> > user
> >> >> >> > > > cm172895@whxd003madcs-new.
> >> >> >> > > >
> >> >> >> > > > On Wed, Oct 9, 2013 at 6:46 PM, Alexandre Marini <
> >> >> >> alexandre@briug.org
> >> >> >> > > >wrote:
> >> >> >> > > >
> >> >> >> > > > > Hello.
> >> >> >> > > > > Could you specify your Informix version, and architecture?
> >> >> >> > > > >
> >> >> >> > > > > 1) What specific changes have you made in your sqlhosts
> >> file?
> >> >> >> > > > > 2) If you rollback your changes, does it works fine?
> >> >> >> > > > > Please post your changes, in old/new format of sqlhosts
> >> file,
> >> >> so
> >> >> >> that
> >> >> >> > > we
> >> >> >> > > > > could
> >> >> >> > > > > try to help.
> >> >> >> > > > >
> >> >> >> > > > > Regards.
> >> >> >> > > > >
> >> >> >> > > > > Alexandre Marini
> >> >> >> > > > > IBM Informix Certified Professional v10 / v11.50 / v11.70
> >> /
> >> >> >> v12.10
> >> >> >> > > > >
> >> >> >> > > > > IBM Information Management Informix Technical Professional
> >> >> >> > > > >
> >> >> >> > > > > IBM Infosphere DataStage Technical Professional
> >> >> >> > > > > Informix Senior DBA - Orizon Brasil
> >> >> >> > > > > BRIUG website administrator
> >> >> >> > > > > Informix independent consultant
> >> >> >> > > > >
> >> >> >> > > > > > To: ids@iiug.org
> >> >> >> > > > > > From: medkba@gmail.com
> >> >> >> > > > > > Subject: Remote database connection failed [31658]
> >> >> >> > > > > > Date: Wed, 9 Oct 2013 04:19:22 -0400
> >> >> >> > > > > >
> >> >> >> > > > > > Hi All,
> >> >> >> > > > > >
> >> >> >> > > > > > I have modified /etc/services and /etc/sqlhost file
> >> >> pointing
> >> >> >> to
> >> >> >> the
> >> >> >> > > > > > instance and try to access through application but gives
> >> >> error
> >> >> >> to
> >> >> >> > > > > connect.
> >> >> >> > > > > > Any suggestion or advise on this
> >> >> >> > > > > >
> >> >> >> > > > > > cat
> >> >> >> /users/wksogrp/cm172895/cmt001_err_17150_cm172895_whx003n.log
> >> >> >> > > > > > The following diagnostic information has been written by
> >> >> Image
> >> >> >> > cmt001
> >> >> >> > > > > > under Unix Username cm172895, Host whx003n, Process ID
> >> >> 17150
> >> >> >> > > > > > at Wed Oct 9 15:00:13 SST 2013.
> >> >> >> > > > > >
> >> >> >> > > > > > CMT005 FATAL ERROR: MSG CODE = CMT001
> >> >> >> > > > > > THE CURRENT FACILITY NAME IS
> >> >> >> > > > > > THE CURRENT USER NAME IS
> >> >> >> > > > > > THE CURRENT FUNCTION NAME IS
> >> >> >> > > > > > THE CURRENT FORM NAME IS
> >> >> >> > > > > > PROGRAM TERMINATED DUE TO DATABASE ERROR
> >> >> >> > > > > > ******************************
> >> >> >> > > > > > * LAST TXN RELATED SQL STATEMENTS *
> >> >> >> > > > > > ******************************
> >> >> >> > > > > > SUBROUTINE = CMT001
> >> >> >> > > > > > PARAGRAPH = B001-2
> >> >> >> > > > > > TXN TYPE PRIOR TO EXECUTION OF SQL... NA
> >> >> >> > > > > > CONNECT TO :DB-NAME AS 'LOCAL' WITH CONC TRANS
> >> >> >> > > > > > CMT001-TXN-REQUEST-STATUS............ 0
> >> >> >> > > > > > CMT001-DB-STATUS..................... 97
> >> >> >> > > > > > SUBROUTINE =
> >> >> >> > > > > > PARAGRAPH =
> >> >> >> > > > > > TXN TYPE PRIOR TO EXECUTION OF SQL...
> >> >> >> > > > > >
> >> >> >> > > > > > CMT001-TXN-REQUEST-STATUS............ 0
> >> >> >> > > > > > CMT001-DB-STATUS..................... 0
> >> >> >> > > > > > SUBROUTINE =
> >> >> >> > > > > > PARAGRAPH =
> >> >> >> > > > > > TXN TYPE PRIOR TO EXECUTION OF SQL...
> >> >> >> > > > > >
> >> >> >> > > > > > CMT001-TXN-REQUEST-STATUS............ 0
> >> >> >> > > > > > CMT001-DB-STATUS..................... 0
> >> >> >> > > > > > SUBROUTINE =
> >> >> >> > > > > > PARAGRAPH =
> >> >> >> > > > > > TXN TYPE PRIOR TO EXECUTION OF SQL...
> >> >> >> > > > > >
> >> >> >> > > > > > CMT001-TXN-REQUEST-STATUS............ 0
> >> >> >> > > > > > CMT001-DB-STATUS..................... 0
> >> >> >> > > > > > SUBROUTINE =
> >> >> >> > > > > > PARAGRAPH =
> >> >> >> > > > > > TXN TYPE PRIOR TO EXECUTION OF SQL...
> >> >> >> > > > > >
> >> >> >> > > > > > CMT001-TXN-REQUEST-STATUS............ 0
> >> >> >> > > > > > CMT001-DB-STATUS..................... 0
> >> >> >> > > > > > ******************************
> >> >> >> > > > > > * DML CALL HISTORY FOLLOWS *
> >> >> >> > > > > > ******************************
> >> >> >> > > > > > SUBROUTINE = CMT001
> >> >> >> > > > > > PARAGRAPH = B001-2
> >> >> >> > > > > > CONNECT TO :DB-NAME AS 'LOCAL' WITH CONC TRANS
> >> >> >> > > > > > SUBROUTINE =
> >> >> >> > > > > > PARAGRAPH =
> >> >> >> > > > > >
> >> >> >> > > > > > SUBROUTINE =
> >> >> >> > > > > > PARAGRAPH =
> >> >> >> > > > > >
> >> >> >> > > > > > SUBROUTINE =
> >> >> >> > > > > > PARAGRAPH =
> >> >> >> > > > > >
> >> >> >> > > > > > SUBROUTINE =
> >> >> >> > > > > > PARAGRAPH =
> >> >> >> > > > > >
> >> >> >> > > > > > ERROR CODE = -908
> >> >> >> > > > > > SQLCODE: -908
> >> >> >> > > > > >
> >> >> >> > > > > > -908 Attempt to connect to database server (servername,
> >> >> >> > > > > > conerr=connection-error-number,
> >> oserr=system-error-number)
> >> >> >> failed.
> >> >> >> > > > > >
> >> >> >> > > > > > The program or application is trying to access another
> >> >> >> database
> >> >> >> > > server
> >> >> >> > > > > > but has failed. Note the server name in the current
> >> >> statement.
> >> >> >> Note
> >> >> >> > > > > > also the connection error number and/or system error
> >> number
> >> >> >> that
> >> >> >> is
> >> >> >> > > > > > shown in the message.
> >> >> >> > > > > >
> >> >> >> > > > > > The desired database server is unavailable, or the
> >> network
> >> >> is
> >> >> >> down
> >> >> >> > or
> >> >> >> > > > > > is congested. Ask your DBA and system administrator to
> >> >> verify
> >> >> >> that
> >> >> >> > > the
> >> >> >> > > > > > server and network are operational. If the network is
> >> >> >> congested,
> >> >> >> > use
> >> >> >> > > > > > the environment variables INFORMIXCONTIME and
> >> >> INFORMIXCONRETRY
> >> >> >> to
> >> >> >> > > tune
> >> >> >> > > > > > connection timing. See Chapter 4 in the Informix Guide
> >> to
> >> >> SQL:
> >> >> >> > > > > > Reference for information on setting these environment
> >> >> >> variables.
> >> >> >> > > > > >
> >> >> >> > > > > > This message appears in Version 6.0 and later.
> >> >> >> > > > > >
> >> >> >> > > > > > environment variables.
> >> >> >> > > > > >
> >> >> >> > > > > > This message appears starting with Version 6.0.
> >> >> >> > > > > >
> >> >> >> > > > > > -908 Attempt to connect to remote system failed.
> >> >> >> > > > > >
> >> >> >> > > > > > INFORMIX-STAR or INFORMIX-NET is trying to access
> >> another
> >> >> >> computer
> >> >> >> > > > > > system but has failed. Note the site name in the current
> >> >> >> statement.
> >> >> >> > > > > > Start your daemon with a log file, and check for
> >> >> >> operating-system
> >> >> >> > > > > > errors in the log file. If this action is inconclusive,
> >> >> >> contact
> >> >> >> > your
> >> >> >> > > > > > system administrator, and ask for a check that the
> >> network
> >> >> is
> >> >> >> > > > > > operational and that the particular site is active.
> >> >> >> > > > > >
> >> >> >> > > > > > This message appears in database servers prior to
> >> Version
> >> >> 6.0.
> >> >> >> > > > > >
> >> >> >> > > > > > cmt001 terminated at Wed Oct 9 15:01:45 SST 2013
> >> >> >> > > > > >
> >> >> >> > > > > > --001a11336460585e9704e84a8af0
> >> >> >> > > > > >
> >> >> >> > > > > >
> >> >> >> > > > > >
> >> >> >> > > > >
> >> >> >> > > > >
> >> >> >> > > >
> >> >> >> > >
> >> >> >> > >
> >> >> >> >
> >> >> >> >
> >> >> >>
> >> >> >>
> >> >> >
> >> >>
> >> >>
> >> >
> >>
> >>
> >
>
> *******************************************************************************
> >> >> >> > > > > > Forum Note: Use "Reply" to post a response in the
> >> >> discussion
> >> >> >> forum.
> >> >> >> > > > > >
> >> >> >> > > > >
> >> >> >> > > > >
> >> >> >> > > > >
> >> >> >> > > > >
> >> >> >> > > >
> >> >> >> > >
> >> >> >> > >
> >> >> >> >
> >> >> >> >
> >> >> >>
> >> >> >>
> >> >> >
> >> >>
> >> >>
> >> >
> >>
> >>
> >
>
> *******************************************************************************
> >> >> >> > > > > Forum Note: Use "Reply" to post a response in the
> >> discussion
> >> >> >> forum.
> >> >> >> > > > >
> >> >> >> > > > >
> >> >> >> > > >
> >> >> >> > > > --047d7b343cd23b47e204e84ddc0c
> >> >> >> > > >
> >> >> >> > > >
> >> >> >> > > >
> >> >> >> > >
> >> >> >> > >
> >> >> >> >
> >> >> >> >
> >> >> >>
> >> >> >>
> >> >> >
> >> >>
> >> >>
> >> >
> >>
> >>
> >
>
> *******************************************************************************
> >> >> >> > > > Forum Note: Use "Reply" to post a response in the discussion
> >> >> >> forum.
> >> >> >> > > >
> >> >> >> > >
> >> >> >> > >
> >> >> >> > >
> >> >> >> > >
> >> >> >> >
> >> >> >> >
> >> >> >>
> >> >> >>
> >> >> >
> >> >>
> >> >>
> >> >
> >>
> >>
> >
>
> *******************************************************************************
> >> >> >> > > Forum Note: Use "Reply" to post a response in the discussion
> >> >> forum.
> >> >> >> > >
> >> >> >> > >
> >> >> >> >
> >> >> >> > --001a11c3db7415110604e84eb8fa
> >> >> >> >
> >> >> >> >
> >> >> >> >
> >> >> >> >
> >> >> >>
> >> >> >>
> >> >> >
> >> >>
> >> >>
> >> >
> >>
> >>
> >
>
> *******************************************************************************
> >> >> >> > Forum Note: Use "Reply" to post a response in the discussion
> >> forum.
> >> >> >> >
> >> >> >> >
> >> >> >>
> >> >> >> --089e0158b8663bfdc304e8500d6e
> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >
> >> >>
> >> >>
> >> >
> >>
> >>
> >
>
> *******************************************************************************
> >> >> >> Forum Note: Use "Reply" to post a response in the discussion
> >> forum.
> >> >> >>
> >> >> >>
> >> >> >
> >> >> > --001a11c373e439a60804e8503631
> >> >> >
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >
> >>
> >>
> >
>
> *******************************************************************************
> >> >> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >> >> >
> >> >>
> >> >> --
> >> >> Paul Watson
> >> >> Tel: +1 913-674-0360
> >> >> Mob: +1 913-387-7529
> >> >> Web: www.oninit.com
> >> >>
> >> >> www.advancedatatools.com
> >> >>
> >> >> Failure is not as frightening as regret.
> >> >> If you want to improve, be content to be thought foolish and stupid.
> >> >> What this country needs are more unemployed politicians
> >> >>
> >> >>
> >> >>
> >> >>
> >> >
> >>
> >>
> >
>
> *******************************************************************************
> >> >> Forum Note: Use "Reply" to post a response in the discussion forum.
> >> >>
> >> >>
> >> >
> >> > --089e0160bb043bfdc104e8508249
> >> >
> >> >
> >> >
> >>
> >>
> >
>
> *******************************************************************************
> >> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >> >
> >>
> >> --
> >> Paul Watson
> >> Tel: +1 913-674-0360
> >> Mob: +1 913-387-7529
> >> Web: www.oninit.com
> >>
> >> www.advancedatatools.com
> >>
> >> Failure is not as frightening as regret.
> >> If you want to improve, be content to be thought foolish and stupid.
> >> What this country needs are more unemployed politicians
> >>
> >>
> >>
> >>
> >
>
> *******************************************************************************
> >> Forum Note: Use "Reply" to post a response in the discussion forum.
> >>
> >>
> >
> > --001a11c34932c394ae04e850ee71
> >
> >
> >
>
> *******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
> --
> Paul Watson
> Tel: +1 913-674-0360
> Mob: +1 913-387-7529
> Web: www.oninit.com
>
> www.advancedatatools.com
>
> Failure is not as frightening as regret.
> If you want to improve, be content to be thought foolish and stupid.
> What this country needs are more unemployed politicians
>
>
>
> *******************************************************************************
> 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...
--001a11c2672a21875404e856f066
Messages In This Thread
IDS Forum is maintained by Administrator with WebBBS 5.12.
|
|
