Re: Connect to database error -951

Posted in 2013

Topics: Installation, Setup & Upgrades, Security, Permissions & Auditing, Licensing & Editions

Art Kagel — Thu, 27 Jun 2013 15:08:22 — source: IIUG Forums & Mailing Lists

Your PC userid needs to exist on the SUSE box and the PC's address has to be trusted. Art Art S. Kagel 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 Thu, Jun 27, 2013 at 10:47 AM, DANNY DE KOSTER <ddk@fidelity-soft.be>wrote: > Hi all! > I've installed on a new SuSe server then Informix Innovator-C 12.10 > database. > When I want to make a connection with my program (written in Genero), I get > error -951. (Incorrect password or user danny@192.168.1.122[danny-PC] is > not > known on the database server. In what direction do I need to search? > Thanks for any tips! > > Danny > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --047d7b34419a51a47804e0242157

↪ replying to Art Kagel

Danny DE KOSTER — Thu, 27 Jun 2013 15:51:09 — source: IIUG Forums & Mailing Lists

Hi Art, thanks for your quick answer. So I need to define a user danny on my SuSe. Can you guide me for the trusting of my ip-address? Thanks! Met vriendelijke groeten / Sincères salutations / Kinds regards, Danny De Koster FIDELITY SOFT nv Cardijnstraat 5 1980 Eppegem Tel: 015/618.270 Fax: 015/616.052 -----Oorspronkelijk bericht----- Van: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Namens Art Kagel Verzonden: donderdag 27 juni 2013 17:08 Aan: ids@iiug.org Onderwerp: Re: Connect to database error -951 [30688] Your PC userid needs to exist on the SUSE box and the PC's address has to be trusted. Art Art S. Kagel 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 Thu, Jun 27, 2013 at 10:47 AM, DANNY DE KOSTER <ddk@fidelity-soft.be>wrote: > Hi all! > I've installed on a new SuSe server then Informix Innovator-C 12.10 > database. > When I want to make a connection with my program (written in Genero), > I get error -951. (Incorrect password or user > danny@192.168.1.122[danny-PC] is not known on the database server. In > what direction do I need to search? > Thanks for any tips! > > Danny > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --047d7b34419a51a47804e0242157 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Danny DE KOSTER

Art Kagel — Thu, 27 Jun 2013 16:02:16 — source: IIUG Forums & Mailing Lists

You can put the address into a .rhosts file in 'danny's home directory and make it read-only by owner only. Art Art S. Kagel 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 Thu, Jun 27, 2013 at 11:51 AM, Danny DE KOSTER <ddk@fidelity-soft.be>wrote: > Hi Art, thanks for your quick answer. > So I need to define a user danny on my SuSe. > Can you guide me for the trusting of my ip-address? > Thanks! > > Met vriendelijke groeten / Sincères salutations / Kinds regards, > > Danny De Koster > > FIDELITY SOFT nv > Cardijnstraat 5 > 1980 Eppegem > > Tel: 015/618.270 > Fax: 015/616.052 > > -----Oorspronkelijk bericht----- > Van: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Namens Art Kagel > Verzonden: donderdag 27 juni 2013 17:08 > Aan: ids@iiug.org > Onderwerp: Re: Connect to database error -951 [30688] > > Your PC userid needs to exist on the SUSE box and the PC's address has to > be > trusted. > > Art > > Art S. Kagel > 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 Thu, Jun 27, 2013 at 10:47 AM, DANNY DE KOSTER <ddk@fidelity-soft.be > >wrote: > > > Hi all! > > I've installed on a new SuSe server then Informix Innovator-C 12.10 > > database. > > When I want to make a connection with my program (written in Genero), > > I get error -951. (Incorrect password or user > > danny@192.168.1.122[danny-PC] is not known on the database server. In > > what direction do I need to search? > > Thanks for any tips! > > > > Danny > > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --047d7b34419a51a47804e0242157 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e013d17420fb5c304e024e20f

↪ replying to Art Kagel

Fernando Nunes — Thu, 27 Jun 2013 23:28:28 — source: IIUG Forums & Mailing Lists

No., no, please no... Informix/IBM took around 20 years to fix something that customer kept complaining... So now that it's solved let's not keep the bad habits Please use the parameter REMOTE_SERVER_CFG in $INFORMIXDIR/etc/$ONCONFIG.to define a file (located in $INFORMIXDIR/etc). Include the trust in that file. This parameter is dynamic: onmode -wf REMOTE_SERVER_CFG=some_file echo "192.168.1.122 danny" >> $INFORMIXDIR/etc/some_file But before all this... I assume error -951 is what you get on the client side... for security reasons, there are 3 authentication errors that are mapped to -951 on the client: -951 -952 -956 To make sure the issue is with the trust check the online.log (onstat -m) immediately after the connection attempt. If you see an error line with -956 that create the trust as above. If you see -951 you need to create user danny on the SUSE machine. If you see -952 you're probably using a user/pass to authenticate and the password is incorrect. Regards On Thu, Jun 27, 2013 at 5:02 PM, Art Kagel <art.kagel@gmail.com> wrote: > You can put the address into a .rhosts file in 'danny's home directory and > make it read-only by owner only. > > Art > > Art S. Kagel > 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 Thu, Jun 27, 2013 at 11:51 AM, Danny DE KOSTER <ddk@fidelity-soft.be > >wrote: > > > Hi Art, thanks for your quick answer. > > So I need to define a user danny on my SuSe. > > Can you guide me for the trusting of my ip-address? > > Thanks! > > > > Met vriendelijke groeten / Sincères salutations / Kinds regards, > > > > Danny De Koster > > > > FIDELITY SOFT nv > > Cardijnstraat 5 > > 1980 Eppegem > > > > Tel: 015/618.270 > > Fax: 015/616.052 > > > > -----Oorspronkelijk bericht----- > > Van: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Namens Art Kagel > > Verzonden: donderdag 27 juni 2013 17:08 > > Aan: ids@iiug.org > > Onderwerp: Re: Connect to database error -951 [30688] > > > > Your PC userid needs to exist on the SUSE box and the PC's address has to > > be > > trusted. > > > > Art > > > > Art S. Kagel > > 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 Thu, Jun 27, 2013 at 10:47 AM, DANNY DE KOSTER <ddk@fidelity-soft.be > > >wrote: > > > > > Hi all! > > > I've installed on a new SuSe server then Informix Innovator-C 12.10 > > > database. > > > When I want to make a connection with my program (written in Genero), > > > I get error -951. (Incorrect password or user > > > danny@192.168.1.122[danny-PC] is not known on the database server. In > > > what direction do I need to search? > > > Thanks for any tips! > > > > > > Danny > > > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --047d7b34419a51a47804e0242157 > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --089e013d17420fb5c304e024e20f > > > > ******************************************************************************* > 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... --20cf307f32d0cbae5804e02b1d20

Related threads

Glossary

Informix Innovator-C