Remote database connection failed

Posted in 2013

Summary

A user editing /etc/services and sqlhosts to reach a remote instance got SQL error -908 (connect to database server failed) from a COBOL app. Advice was that -908 usually means the client host/user isn't trusted by the server's host, and to search past forum posts. The poster fixed the first problem himself, then hit listener error -956 ("Client host or user ... not trusted") on 11.50FC9. Alexandre Marini suggested adding the appropriate entry to /etc/hosts.equiv; the poster replied he had already put the server name in the client's hosts.equiv and it still failed. No resolution is recorded in the thread.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: Error Codes & Troubleshooting, Server Administration

medkba — Wed, 09 Oct 2013 08:19:21 — source: IIUG Forums & Mailing Lists

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

↪ replying to medkba

Alexandre Marini — Wed, 09 Oct 2013 10:46:15 — source: IIUG Forums & Mailing Lists

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. >

↪ replying to medkba

Art Kagel — Wed, 09 Oct 2013 10:55:26 — source: IIUG Forums & Mailing Lists

Getting a -908 error usually means that your client is not trusted by the server's host. There are lots (hundreds?) of posts and responses about solving this one, so I'm not going to go into it again. Search the forum history! 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 4:19 AM, medkba <medkba@gmail.com> wrote: > 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. > > --001a11336bba7c357a04e84ca2dd

↪ replying to Alexandre Marini

medkba — Wed, 09 Oct 2013 12:16:59 — source: IIUG Forums & Mailing Lists

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

↪ replying to medkba

Alexandre Marini — Wed, 09 Oct 2013 13:11:24 — source: IIUG Forums & Mailing Lists

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. >

↪ replying to Alexandre Marini

medkba — Wed, 09 Oct 2013 13:18:28 — source: IIUG Forums & Mailing Lists

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.equivMHX001 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.@@N

↪ replying to medkba

Alexandre Marini — Wed, 09 Oct 2013 13:48:22 — source: IIUG Forums & Mailing Lists

Ok check in the /etc/hosts.equiv of the Informix server, it should also have an entry for the client machine. 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 [31664] > Date: Wed, 9 Oct 2013 09:18:28 -0400 > > 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

↪ replying to Alexandre Marini

medkba — Wed, 09 Oct 2013 13:52:17 — source: IIUG Forums & Mailing Lists

Yes, I have added both side and still giving this error. Is there anything missing out? Thank you very much Regards Baskaran On Wed, Oct 9, 2013 at 9:48 PM, Alexandre Marini <alexandre@briug.org>wrote: > Ok check in the /etc/hosts.equiv of the Informix server, it should also > have > an entry for the client machine. > > 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 [31664] > > Date: Wed, 9 Oct 2013 09:18:28 -0400 > > > > 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 > > >

↪ replying to medkba

Alexandre Marini — Wed, 09 Oct 2013 14:30:58 — source: IIUG Forums & Mailing Lists

Ok please make sure (double check) your /etc/hosts.equiv (I don´t know if you printed the correct file from client side). I have an 11.50 here, and it works just fine. You might do a simple test: 1) Include only a plus sign (+) at the file. If it works, that´s the right file (but don´t let this in production, it auths any external connection)! 2) in case the previous test worked, you might correct you machine name, do a ping test, and use the correct DNS name for your client/serve machines, instead of a simple name. That should fix your issues. 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 [31666] > Date: Wed, 9 Oct 2013 09:52:18 -0400 > > Yes, I have added both side and still giving this error. > > Is there anything missing out? > > Thank you very much > > Regards > Baskaran > > On Wed, Oct 9, 2013 at 9:48 PM, Alexandre Marini <alexandre@briug.org>wrote: > > > Ok check in the /etc/hosts.equiv of the Informix server, it should also > > have > > an entry for the client machine. > > > > 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 [31664] > > > Date: Wed, 9 Oct 2013 09:18:28 -0400 > > > > > > 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 > >

↪ replying to medkba

Art Kagel — Wed, 09 Oct 2013 14:52:53 — source: IIUG Forums & Mailing Lists

-956 Client client-name or user is not trusted by the database server. The desired database server does not consider the client computer or your user ID trusted. Ask the system administrator to include the client computer as a trusted host and/or your user id as a trusted user in the /etc/hosts.equiv file on the server computer or in the .rhosts file in your home directory on the server computer. See the UNIX manual pages on HOSTS.EQUIV(5) for more information. Alternatively, you can explicitly specify your user name and password in the USER clause of a CONNECT statement or in the .netrc file in your home directory on the client computer. See the IBM Informix Guide to SQL: Syntax for information on the CONNECT statement, and the UNIX manual pages regarding NETRC(5) for information on the .netrc file. This message appears with Version 6.0 and later. 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 8:16 AM, medkba <medkba@gmail.com> wrote: > 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 pos

↪ replying to medkba

Art Kagel — Wed, 09 Oct 2013 14:54:32 — source: IIUG Forums & Mailing Lists

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

↪ replying to Art Kagel

medkba — Wed, 09 Oct 2013 15:05:17 — source: IIUG Forums & Mailing Lists

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.equivwhd003 whd003.amk.st.com MHX003 MHD003 MHXD002 PMHX001 Informix Server informix@pmhx001$ more hosts.equiv NHX003 + WHX003-NEW + whxd003madcs-new + informix@pmhx001$ more .rhosts #testingwhx003-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

↪ replying to medkba

Paul Watson — Wed, 09 Oct 2013 15:11:17 — source: IIUG Forums & Mailing Lists

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 = >>

↪ replying to Paul Watson

medkba — Wed, 09 Oct 2013 15:26:42 — source: IIUG Forums & Mailing Lists

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@@N

↪ replying to medkba

Paul Watson — Wed, 09 Oct 2013 15:50:48 — source: IIUG Forums & Mailing Lists

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... >> >> > > > > > >> >

↪ replying to Paul Watson

medkba — Wed, 09 Oct 2013 15:56:55 — source: IIUG Forums & Mailing Lists

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 TERMINATE

↪ replying to medkba

Paul Watson — Wed, 09 Oct 2013 16:27:04 — source: IIUG Forums & Mailing Lists

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

↪ replying to Paul Watson

Fernando Nunes — Wed, 09 Oct 2013 23:06:49 — source: IIUG Forums & Mailing Lists

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