951 Error with dbaccess and informix account ...
Posted in 2000
I m working on Solaris 2.5.7 with Informix Dynamic Server 2000 Version 9.20.UC2 and like we needed to reboot and change informix password. I now find out each time I try to SELECT or CONNECT with DBACCESS the 951 Error : finderr 951 : -951 User username is not known on the database server. The database server that you tried to access does not accept either your user ID, the login name that is specified for the desired server host in your ~/.netrc file, or the user name that is specified in the USER clause of a CONNECT statement. If you are explicitly specifying your user name in the ~/.netrc file or in a CONNECT statement, check that the name is correct. If you do not have a valid user ID on the server computer, see your system administrator. This message appears with Version 6.0 and later. Like it was working few hours ago, I tried to see what changes were made in System files : ( Remember that we only changed the password with passwd command ) /etc/passwd : informix:x:104:10000::/usr/informix:/bin/ksh /etc/shadow : informix:T2RT3TXXT:11199::::Wed Aug 30 17:24:01 GMT 2003:: Doesn't someone have an idea ? I found in TECH INFO Center : Unfortunatly there is lot of others Bugs on 951 Product: Informix ONLINE Reported: 09/24/1998 -951 ERROR ON CONNECTING TO A DB ON SOLARIS IF PASSWORD AGING IS USED Verified in Fixed in 9.30.UC1 UNIX On Solaris 2.6, if you use password aging by specifying the number of days to age from when the password was changed, on the day the password expires, you will get a 951 error when an app tries to connect to an IDS database. This is probably a regression of bug 83754. If you age the password by specifying a date rather than the number of days, then you do not get this problem. But even trying to age the passwd it doesn't work any more. Here is my tries with /etc/shadow first thing : Without the third field ( BAD 951 Error ) informix:T2RT3TXXT::::::: second thing : With Expiration Date ( BAD 951 Error ) informix:T2RT3TXXT:::::Wed Aug 30 17:24:01 GMT 2000:: THANKS ----- REVEL Laurent / DBA Engineer ----- REEF - 116, rue du Faubourg St Martin - 75010 PARIS Office Tel: 33 (0)1-55-26-53-53 and ask : 5404