Informix Error 951
Contents |
(FAQ) This document applies only to the following language version(s): English Question When client connections try to reach informix odbc incorrect password or user the Informix instance, the error -951 (User username is not known on informix error 952 the database server/User is not known on remote host) is raised, avoiding clients to connect. Cause You see errors informix sql error 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 = -951: oserr = 0: errstr = informix allow remote connections 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 permissions or ownership; User is locked or expired; oninit binary
Error 651
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 ixbar files. Important: these are just a few probable causes for this problem, if this document didn't solve your issue, con
(troubleshooting) Problem(Abstract) All users get error "Get Shadow password 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 http://www-01.ibm.com/support/docview.wss?uid=swg21588239 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: http://www-01.ibm.com/support/docview.wss?uid=swg21599148 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 http://www.dbforums.com/showthread.php?491358-Error-951 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 http://www.dbdummy.com/67/informix-err-951-troubleshoot-unknown-remote-host.html 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: informix error 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 error 951 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.equiv In dbaccess, don't forget everything is case-sensitive. Check whether you defined the user informix with capital I or not. Stuff like that. Check in the table sysusers to have a full user list. rws Reply With Quote 09-06-02,15:46 #5 jlturco View Profile View Forum Posts Registered User Join Date Aug 2002 Location Quilmes
from Informix message logs. Similar error messages are repeating frequently within a second, these will fill up the message logs file and filesystem. #- Informix message logs -# 10:22:45 listener-thread: err = -951: oserr = 0: errstr = jsmith: Incorrect password or user jsmith is not known on the database server. 10:22:45 listener-thread: err = -951: oserr = 0: errstr = jsmith: Incorrect password or user jsmith is not known on the database server. The error messages description clearly shows that there are possibilities on, (1) Userid "jsmith" connect with invalid password or account is locked. (2) Userid "jsmith" is unknown or not found on database server (not found in /etc/passwd entry). For my case, it is (2), no userid "jsmaith" found in database host. The challenge for DBA is to find out which is remote client host attempting an invalid userid connection. Obviously, Informix message logs does not provide remote client host information. Workaround applies to IDS 10.00, 11.10, 11.50 and above: Tracing client IP address with xtrace which only available on IDS 10.00 and above. (1) Ensure IDS instance is On-Line. $ onstat - (2) From IDS 10.00 and above, you may find $INFORMIXDIR/bin/xtrace. (3) Initialize the IP trace components with xtrace. $ xtrace heavy –c XTF_IPTRACE –f XTF_SYSCALLS (4) Activate tracing. $ xtrace on (5) View client host connection details. $ xtrace view (6) You will get following sample output for socket connection, File Line session imcsoc_be.c 2763 0 accpsocket - Accepted IP Address 26.253.126.49|2748|soctcp imcsoc_be.c 2763 0 accpsocket - Accepted IP Address 26.253.126.49|2749|soctcp (7) Terminate tracing session. $ xtrace off Looking forward: A feature request has been raised to IBM Informix to include client host/IP in Inf