Error 951
Contents |
(FAQ) This document applies only to the following language version(s): English Question When client connections informix error code 951 try to reach the Informix instance, the error -951 (User username informix windows 951 is not known on the database server/User is not known on remote host) is raised, avoiding clients to informix error 952 connect. Cause You see errors like this in the online.log file: 13:14:57 Get Shadow Password for user [username] failed! 13:14:57 Check for password aging/account lock-out. 13:14:57 listener-thread: err informix odbc incorrect password or user = -951: oserr = 0: errstr = username@::ffff:10.10.10.31[server.host.net]: Incorrect password or user username@::ffff:10.10.10.31[server.host.net] is not known on the database server. Several symptoms can cause such behaviour: SQLHOSTS file mispelled entries; DBSERVERNAME or DBSERVERALIASES onconfig parameters have no related entries in the SQLHOSTS file; NIS or LDAP servers misconfiguration or maintenance; INFORMIXDIR filesystem and/or its subdirectories have wrong
Informix Sql Error
permissions or ownership; User is locked or expired; oninit binary is somehow damaged or have wrong permissions. Answer Here's a list of things to check when facing such a problem: 1) Double-check the SQLHOSTS file for missing or mispelled entries regarding the DBSERVERNAME and DBSERVERALIASES onconfig parameter values; 2) Validate with the OS staff changes in the LDAP or NIS servers; If none of the above were causing the issue, check the INFORMIXDIR filesystem for proper permissions and/or ownership: 1) Collect an ls -ltrR output from the INFORMIXDIR filesystem and compare its contents with the $INFORMIXDIR/etc/IIFfiles file; 2) Check for onwership too; If the contents of the ls -ltrR diverges from the $INFORMIXDIR/etc/IIFfiles file, consider doing one of following: 1) Fix manually the missing permissions or ownership of every file/subdirectory; 2) Copy the INFORMIXDIR filesystem from another validated non-productive host; 3) Restore this filesystem from backup; 4) Re-install the Informix Server binaries. In any of the options above, make proper backups of critical files like the onconfig, sqlhosts and ixb
Linux, HP-UX or Solaris INFORMIX
Error 651
CONNECTION DYNAMIC Technote (troubleshooting) Problem(Abstract) All users get error "Get Shadow password for user [username]" when connecting to database server running on Linux, HP-UX or Solaris Resolving the problem PROBLEM When you try to connect to the database server you get error -951, and any user http://www-01.ibm.com/support/docview.wss?uid=swg21588239 that tries to connect to the database server gets the same error as well. If the instance is up and you are trying to connect you will see the following error message: Get Shadow Password for user [informix] failed! Check for password aging/account lock-out. listener-thread: err http://www.ibm.com/support/docview.wss?uid=swg21218436 = -951: oserr = 0: errstr = informix: Incorrect password or user informix is not known on the database server. If you are initializing for the first time you will also see the following message Error building sysmaster database The instance is initialized but the sysmaster database creation fails. CAUSE $INFORMIXDIR/bin/oninit has wrong permissions and/or attributes SOLUTION Assign $INFORMIXDIR/bin/oninit to user root and group informix, permissions 6754 by executing the following command as user root or user with root privileges chown root:informix $INFORMIXDIR/bin/oninit chmod 6754 $INFORMIXDIR/bin/oninit Document information More support for: Informix Servers Software version: 10.0, 11.1, 11.5, 11.7, 12.1 Operating system(s): HP-UX, Linux, Solaris Reference #: 1218436 Modified date: 2011-10-11 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility
(troubleshooting) Problem(Abstract) All users get error "Get Shadow password http://www.dbforums.com/showthread.php?491358-Error-951 for user [username]" when connecting to database server running on Linux, Unix Symptom When you try to connect to the database server you get error -951, and any user that tries to connect informix error to the database server gets the same error as well. If the instance is up and you are trying to connect you will see the following error message: Get Shadow Password for user [informix] failed! Check for password aging/account lock-out. listener-thread: informix error code err = -951: oserr = 0: errstr = informix: Incorrect password or user informix is not known on the database server. Cause $INFORMIXDIR/bin/oninit has wrong permissions and/or attributes Resolving the problem Assign $INFORMIXDIR/bin/oninit to user root and group informix, permissions 6754 by executing the following command as user root or user with root privileges chown root:informix $INFORMIXDIR/bin/oninit chmod 6754 $INFORMIXDIR/bin/oninit You will also need to bounce the engine after correcting the problem. Document information More support for: Informix Servers Software version: 9.4, 11.1, 11.5, 11.7 Operating system(s): AIX, HP-UX, Linux, Solaris Reference #: 1599148 Modified date: 2012-08-23 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility
the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 7 of 7 Thread: Error -951 Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 09-04-02,15:35 #1 jlturco View Profile View Forum Posts Registered User Join Date Aug 2002 Location Quilmes Posts 3 Unanswered: Error -951 What is this error? listener-thread: err = -951: oserr = 0: errstr = informix: Incorrect password or user informix is not known on the database server. The user informix is setting good in the Informix instalation. I'm test with the user informix and her password for connect to motor. But testing without user and password and de connection is good. Thanks Reply With Quote 09-04-02,23:04 #2 rnealejr View Profile View Forum Posts Registered User Join Date Feb 2002 Posts 2,232 Which version of informix are you using ? Are you running under unix(which type/version) or windows (which type/version ? Have you looked at your release notes ? When does this error occur ? Reply With Quote 09-05-02,09:52 #3 jlturco View Profile View Forum Posts Registered User Join Date Aug 2002 Location Quilmes Posts 3 Originally posted by rnealejr Which version of informix are you using ? Are you running under unix(which type/version) or windows (which type/version ? Have you looked at your release notes ? When does this error occur ? Version 9.21 on Win2k. And this error occur on connection to database. Thanks Reply With Quote 09-06-02,07:53 #4 Roelwe View Profile View Forum Posts Visit Homepage Registered User Join Date Aug 2002 Location Belgium Posts 534 Hi, How are you testing? Are you testing with a remote connection (ODBC?) or just with dbaccess/CONNECTION tab? If you use ODBC, don't forget that you have to 'trust your client machine on the server in c:\winnt\system32\hosts.equ