Err -25571 to connect server
Posted in 2011
User couldn't connect to IDS 11.70 FC1 from Windows client SDK 3.50 TC1, getting error -25571 "Cannot create a user thread", though connections to IDS 11.10 worked fine. The issue was resolved by changing the IXUSERS setting in $INFORMIXDIR/dbssodir/seccfg from "informix" to "*", matching the IDS 11.10 configuration.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Topics: Installation, Setup & Upgrades, Platform-Specific Issues
Hello guys, I have the following scenario: Recently i installed the new IDS 11.70 FC1 on RedHat EL 5.5 (server A) without problem until this time, but today i tried to connect to this server from clientsdk 3.50 TC1 on windows (client) and i get the following error to apply and test connection : Cannot create a user thread: online.log : listener-thread: err = -25571: oserr = 0: errstr = informix: Cannot create a user thread I can connect from the same client to other server (server B) which it has installed IDS 11.10 UC1 on Red hat linux too. this work it fine Also i can connect server B as client of server A Both server A and B are configure in similar way and belong to the same net. /var/log/messages doesn't have any info about this case Could be a bug of IDS 11.70 or clientsdk 3.50? Does anyone have some idea about how solve this? Thanks in advance Alberto
I cannot think of any reason why it should make a difference, but have you tried installing the 3.70 release of the CSDK for Windows? Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) 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 Thu, Feb 17, 2011 at 11:18 AM, alberto rodriguez <sqlweb@hotmail.com>wrote: > Hello guys, > I have the following scenario: > Recently > i installed the new IDS 11.70 FC1 on RedHat EL 5.5 (server A) > without problem until this time, but today i tried to connect to this > server > from clientsdk 3.50 TC1 on windows (client) and i get the following error > to > apply and test connection : > Cannot create a user thread: > online.log : > listener-thread: err = -25571: oserr = 0: errstr = informix: Cannot create > a > user thread > > I can connect from the same client to other server > (server B) which it has installed IDS 11.10 UC1 on Red hat > linux too. this work it fine > Also i can connect server B as client of server > A > > Both server A and B are configure in similar way and > belong to the same net. > /var/log/messages doesn't have any info about this > case > > Could be a bug of IDS 11.70 or clientsdk > 3.50? > > Does anyone have some idea about how solve this? > > Thanks in advance > > Alberto > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001517503b084561bd049c7ccd6c
I also recomend you to 1) remove the old client 3.50 2) install clientsdk 3.70 (ready for informix 11.70). See if it works, if you have another issue, just tell us ok? Best regards! Em 17/02/2011 12:22, Art Kagel escreveu: > I cannot think of any reason why it should make a difference, but have you > tried installing the 3.70 release of the CSDK for Windows? > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > IIUG Board of Directors (art@iiug.org) > 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 Thu, Feb 17, 2011 at 11:18 AM, alberto rodriguez<sqlweb@hotmail.com>wrote: > >> Hello guys, >> I have the following scenario: >> Recently >> i installed the new IDS 11.70 FC1 on RedHat EL 5.5 (server A) >> without problem until this time, but today i tried to connect to this >> server >> from clientsdk 3.50 TC1 on windows (client) and i get the following error >> to >> apply and test connection : >> Cannot create a user thread: >> online.log : >> listener-thread: err = -25571: oserr = 0: errstr = informix: Cannot create >> a >> user thread >> >> I can connect from the same client to other server >> (server B) which it has installed IDS 11.10 UC1 on Red hat >> linux too. this work it fine >> Also i can connect server B as client of server >> A >> >> Both server A and B are configure in similar way and >> belong to the same net. >> /var/log/messages doesn't have any info about this >> case >> >> Could be a bug of IDS 11.70 or clientsdk >> 3.50? >> >> Does anyone have some idea about how solve this? >> >> Thanks in advance >> >> Alberto >> >> >> >> > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > --001517503b084561bd049c7ccd6c > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Alexandre Marini Tecnologia da Informação - DBA msn: alexandre_marini@hotmail.com SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix Cert-Info-Mgmt_color <Cert-Info-Mgmt_color.jpg> IBM Certified System Administrator - Informix Dynamic Server V10 / V11
Double check the SQLHOSTS entry on client machine... Verify that the user group does not conflict with anything you may have configured in $INFORMIXDIR/dbssodir/seccfg Regards. On Thu, Feb 17, 2011 at 4:18 PM, alberto rodriguez <sqlweb@hotmail.com>wrote: > Hello guys, > I have the following scenario: > Recently > i installed the new IDS 11.70 FC1 on RedHat EL 5.5 (server A) > without problem until this time, but today i tried to connect to this > server > from clientsdk 3.50 TC1 on windows (client) and i get the following error > to > apply and test connection : > Cannot create a user thread: > online.log : > listener-thread: err = -25571: oserr = 0: errstr = informix: Cannot create > a > user thread > > I can connect from the same client to other server > (server B) which it has installed IDS 11.10 UC1 on Red hat > linux too. this work it fine > Also i can connect server B as client of server > A > > Both server A and B are configure in similar way and > belong to the same net. > /var/log/messages doesn't have any info about this > case > > Could be a bug of IDS 11.70 or clientsdk > 3.50? > > Does anyone have some idea about how solve this? > > Thanks in advance > > Alberto > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --0015174be8c466e343049c7d0f21
The file $INFORMIXDIR/dbssodir/seccfg it had IXUSERS=informix in IDS 11.70. I made the change to IXUSERS=*, same as it is in IDS 11.10 and the problem was solved. I never had touched this file. What does do this file Thanks for your help Sent from my BlackBerry® wireless device -----Original Message----- From: "Fernando Nunes" <domusonline@gmail.com> Sender: ids-bounces@iiug.org Date: Thu, 17 Feb 2011 11:41:02 To: <ids@iiug.org> Reply-To: ids@iiug.org Subject: Re: Err -25571 to connect server [22818] Double check the SQLHOSTS entry on client machine... Verify that the user group does not conflict with anything you may have configured in $INFORMIXDIR/dbssodir/seccfg Regards. On Thu, Feb 17, 2011 at 4:18 PM, alberto rodriguez <sqlweb@hotmail.com>wrote: > Hello guys, > I have the following scenario: > Recently > i installed the new IDS 11.70 FC1 on RedHat EL 5.5 (server A) > without problem until this time, but today i tried to connect to this > server > from clientsdk 3.50 TC1 on windows (client) and i get the following error > to > apply and test connection : > Cannot create a user thread: > online.log : > listener-thread: err = -25571: oserr = 0: errstr = informix: Cannot create > a > user thread > > I can connect from the same client to other server > (server B) which it has installed IDS 11.10 UC1 on Red hat > linux too. this work it fine > Also i can connect server B as client of server > A > > Both server A and B are configure in similar way and > belong to the same net. > /var/log/messages doesn't have any info about this > case > > Could be a bug of IDS 11.70 or clientsdk > 3.50? > > Does anyone have some idea about how solve this? > > Thanks in advance > > Alberto > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --0015174be8c466e343049c7d0f21 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Sent from my BlackBerry® wireless device -----Original Message----- From: sqlweb@hotmail.com Date: Fri, 18 Feb 2011 13:15:14 To: <ids@iiug.org> Reply-To: sqlweb@hotmail.com Subject: Re: Err -25571 to connect server [22818] The file $INFORMIXDIR/dbssodir/seccfg it had IXUSERS=informix in IDS 11.70. I made the change to IXUSERS=*, same as it is in IDS 11.10 and the problem was solved. I never had touched this file. What does do this file Thanks for your help Sent from my BlackBerry® wireless device -----Original Message----- From: "Fernando Nunes" <domusonline@gmail.com> Sender: ids-bounces@iiug.org Date: Thu, 17 Feb 2011 11:41:02 To: <ids@iiug.org> Reply-To: ids@iiug.org Subject: Re: Err -25571 to connect server [22818] Double check the SQLHOSTS entry on client machine... Verify that the user group does not conflict with anything you may have configured in $INFORMIXDIR/dbssodir/seccfg Regards. On Thu, Feb 17, 2011 at 4:18 PM, alberto rodriguez <sqlweb@hotmail.com>wrote: > Hello guys, > I have the following scenario: > Recently > i installed the new IDS 11.70 FC1 on RedHat EL 5.5 (server A) > without problem until this time, but today i tried to connect to this > server > from clientsdk 3.50 TC1 on windows (client) and i get the following error > to > apply and test connection : > Cannot create a user thread: > online.log : > listener-thread: err = -25571: oserr = 0: errstr = informix: Cannot create > a > user thread > > I can connect from the same client to other server > (server B) which it has installed IDS 11.10 UC1 on Red hat > linux too. this work it fine > Also i can connect server B as client of server > A > > Both server A and B are configure in similar way and > belong to the same net. > /var/log/messages doesn't have any info about this > case > > Could be a bug of IDS 11.70 or clientsdk > 3.50? > > Does anyone have some idea about how solve this? > > Thanks in advance > > Alberto > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --0015174be8c466e343049c7d0f21 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
IDS 11.70 $INFORMIXDIR/dbssodir/seccfg : IXUSERS=informix IDS 11.10 $INFORMIXDIR/dbssodir/seccfg : IXUSERS=* doing the change to IDS 11.10 format solved it the problem. what does do this file? why doesn't work with IXUSERS=informix? help a lot for your help > To: ids@iiug.org > From: domusonline@gmail.com > Subject: Re: Err -25571 to connect server [22818] > Date: Thu, 17 Feb 2011 11:41:02 -0500 > > Double check the SQLHOSTS entry on client machine... > Verify that the user group does not conflict with anything you may have > configured in $INFORMIXDIR/dbssodir/seccfg > > Regards. > > On Thu, Feb 17, 2011 at 4:18 PM, alberto rodriguez <sqlweb@hotmail.com>wrote: > > > Hello guys, > > I have the following scenario: > > Recently > > i installed the new IDS 11.70 FC1 on RedHat EL 5.5 (server A) > > without problem until this time, but today i tried to connect to this > > server > > from clientsdk 3.50 TC1 on windows (client) and i get the following error > > to > > apply and test connection : > > Cannot create a user thread: > > online.log : > > listener-thread: err = -25571: oserr = 0: errstr = informix: Cannot create > > a > > user thread > > > > I can connect from the same client to other server > > (server B) which it has installed IDS 11.10 UC1 on Red hat > > linux too. this work it fine > > Also i can connect server B as client of server > > A > > > > Both server A and B are configure in similar way and > > belong to the same net. > > /var/log/messages doesn't have any info about this > > case > > > > Could be a bug of IDS 11.70 or clientsdk > > 3.50? > > > > Does anyone have some idea about how solve this? > > > > Thanks in advance > > > > Alberto > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > -- > Fernando Nunes > Portugal > > http://informix-technology.blogspot.com > My email works... but I don't check it frequently... > > --0015174be8c466e343049c7d0f21 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
That file specifies the group of users who can connect to the instance. Having "informix" in there restricts the ability to connect to users belonging to the group informix. Did you change it manually? The default is "*"... Maybe the installation allows it to be specified... not sure, but I believe it will change it if you ask for role separation... Glad to help. On Fri, Feb 18, 2011 at 5:52 PM, alberto rodriguez <sqlweb@hotmail.com>wrote: > IDS 11.70 $INFORMIXDIR/dbssodir/seccfg : IXUSERS=informix > IDS 11.10 $INFORMIXDIR/dbssodir/seccfg : IXUSERS=* > > doing the change to IDS 11.10 format solved it the problem. > what does do this file? > why doesn't work with IXUSERS=informix? > > help a lot for your help > > > To: ids@iiug.org > > From: domusonline@gmail.com > > Subject: Re: Err -25571 to connect server [22818] > > Date: Thu, 17 Feb 2011 11:41:02 -0500 > > > > Double check the SQLHOSTS entry on client machine... > > Verify that the user group does not conflict with anything you may have > > configured in $INFORMIXDIR/dbssodir/seccfg > > > > Regards. > > > > On Thu, Feb 17, 2011 at 4:18 PM, alberto rodriguez > <sqlweb@hotmail.com>wrote: > > > > > Hello guys, > > > I have the following scenario: > > > Recently > > > i installed the new IDS 11.70 FC1 on RedHat EL 5.5 (server A) > > > without problem until this time, but today i tried to connect to this > > > server > > > from clientsdk 3.50 TC1 on windows (client) and i get the following > error > > > to > > > apply and test connection : > > > Cannot create a user thread: > > > online.log : > > > listener-thread: err = -25571: oserr = 0: errstr = informix: Cannot > create > > > a > > > user thread > > > > > > I can connect from the same client to other server > > > (server B) which it has installed IDS 11.10 UC1 on Red hat > > > linux too. this work it fine > > > Also i can connect server B as client of server > > > A > > > > > > Both server A and B are configure in similar way and > > > belong to the same net. > > > /var/log/messages doesn't have any info about this > > > case > > > > > > Could be a bug of IDS 11.70 or clientsdk > > > 3.50? > > > > > > Does anyone have some idea about how solve this? > > > > > > Thanks in advance > > > > > > Alberto > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > -- > > Fernando Nunes > > Portugal > > > > http://informix-technology.blogspot.com > > My email works... but I don't check it frequently... > > > > --0015174be8c466e343049c7d0f21 > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --0015174c1038d54e93049c9243c4
I don't remember to ask for role separation when i installed. Yes, i changed it manually Regards Sent from my BlackBerry® wireless device -----Original Message----- From: "Fernando Nunes" <domusonline@gmail.com> Sender: ids-bounces@iiug.org Date: Fri, 18 Feb 2011 12:58:56 To: <ids@iiug.org> Reply-To: ids@iiug.org Subject: Re: Err -25571 to connect server [22831] That file specifies the group of users who can connect to the instance. Having "informix" in there restricts the ability to connect to users belonging to the group informix. Did you change it manually? The default is "*"... Maybe the installation allows it to be specified... not sure, but I believe it will change it if you ask for role separation... Glad to help. On Fri, Feb 18, 2011 at 5:52 PM, alberto rodriguez <sqlweb@hotmail.com>wrote: > IDS 11.70 $INFORMIXDIR/dbssodir/seccfg : IXUSERS=informix > IDS 11.10 $INFORMIXDIR/dbssodir/seccfg : IXUSERS=* > > doing the change to IDS 11.10 format solved it the problem. > what does do this file? > why doesn't work with IXUSERS=informix? > > help a lot for your help > > > To: ids@iiug.org > > From: domusonline@gmail.com > > Subject: Re: Err -25571 to connect server [22818] > > Date: Thu, 17 Feb 2011 11:41:02 -0500 > > > > Double check the SQLHOSTS entry on client machine... > > Verify that the user group does not conflict with anything you may have > > configured in $INFORMIXDIR/dbssodir/seccfg > > > > Regards. > > > > On Thu, Feb 17, 2011 at 4:18 PM, alberto rodriguez > <sqlweb@hotmail.com>wrote: > > > > > Hello guys, > > > I have the following scenario: > > > Recently > > > i installed the new IDS 11.70 FC1 on RedHat EL 5.5 (server A) > > > without problem until this time, but today i tried to connect to this > > > server > > > from clientsdk 3.50 TC1 on windows (client) and i get the following > error > > > to > > > apply and test connection : > > > Cannot create a user thread: > > > online.log : > > > listener-thread: err = -25571: oserr = 0: errstr = informix: Cannot > create > > > a > > > user thread > > > > > > I can connect from the same client to other server > > > (server B) which it has installed IDS 11.10 UC1 on Red hat > > > linux too. this work it fine > > > Also i can connect server B as client of server > > > A > > > > > > Both server A and B are configure in similar way and > > > belong to the same net. > > > /var/log/messages doesn't have any info about this > > > case > > > > > > Could be a bug of IDS 11.70 or clientsdk > > > 3.50? > > > > > > Does anyone have some idea about how solve this? > > > > > > Thanks in advance > > > > > > Alberto > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > -- > > Fernando Nunes > > Portugal > > > > http://informix-technology.blogspot.com > > My email works... but I don't check it frequently... > > > > --0015174be8c466e343049c7d0f21 > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --0015174c1038d54e93049c9243c4 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Related threads
- Transaction not available
- Error -25571 errstr = informix : Cannot creta a us
- Bug? Role Separation ... informix can't access...
- NETTYPE maximum support to user connections ?