 |
IDS Forum
Re: Remote database connection failed
Posted By: medkba
Date: Wednesday, 9 October 2013, at 11:56 a.m.
In Response To: Re: Remote database connection failed (Paul Watson)
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
Messages In This Thread
IDS Forum is maintained by Administrator with WebBBS 5.12.
|
|
