951 Informix Error Message
Contents |
(FAQ) This document applies only to the following language version(s): English Question When client connections try to reach the informix sql error Informix instance, the error -951 (User username is not known on the informix odbc error database server/User is not known on remote host) is raised, avoiding clients to connect. Cause You see errors informix error codes list 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 error 908 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 is
Informix Error 23101
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, consider calling
Question Error 951: Incorrect password or user informix is not known on the database server Cause
Informix Error 674
File system where Informix server is installed is mounted with -nosuid informix error 201 option Answer Informix server gives error -951 while creating sysmaster database and following message is seen in informix error 349 the online.log 14:17:40 On-Line Mode 14:17:40 Building 'sysmaster' database ... 14:17:40 Get Shadow Password for user [informix] failed! 14:17:40 Check for password aging/account lock-out. 14:17:40 listener-thread: err = http://www-01.ibm.com/support/docview.wss?uid=swg21588239 -951: oserr = 0: errstr = informix@nke-lnx-sci-p001: Incorrect password or user informix@nke-lnx-sci-p001 is not known on the database server. Check /etc/fstab file to find the options which are used for mounting the device where Informix is installed. If nosuid option is used please remount the device without nosuid option. Below is the sample entry from /etc/fstab. Informix http://www.ibm.com/support/docview.wss?uid=swg21584399 was installed under /manh directory. cat /etc/fstab | grep manh /dev/vg02/lvmanh /manh ext3 nosuid 1 2 nosuid prevents set-user-identifier (suid) or set-group-identifier bits to take effect. $INFORMIXDIR/bin/oninit binary has s-bit set which allows users to run an executable with the permissions of the executable's owner or group. -rwsr-sr-- 1 root informix 22116667 Jan 9 13:54 oninit If the file system where INFORMIX is installed is mounted with -nosuid option it prevents oninit to be run with effective userid of root. ps -ef | grep oninit lists 'oninit' processes as owned by informix and not root. So this was preventing sysmaster to be created. Unmount and mount the file system where INFORMIX is installed with default settings. Document information More support for: Informix Dynamic Server Enterprise Edition Software version: 11.5 Operating system(s): Linux Software edition: Enterprise Reference #: 1584399 Modified date: 2012-04-20 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
trying to connect remotely to a Informix DB I have encounter this error message Incorrect password or user user06@informix-class2 is not known on the https://blog.rabin.io/linux/informix-db-incorrect-password-or-user-is-not-known-on-the-database-server database server.1Incorrect password or user user06@informix-class2 is not known on http://www.dbforums.com/showthread.php?491358-Error-951 the database server. while i was able to connect via dbaccess tool from the command (locally).
looking into the log file at $INFORMIXDIR/tmp/online.log , showed this error lines for each conecting attempt 17:48:31 Get Shadow Password for user [user06] failed! 17:48:31 informix error Check for password aging/account lock-out. 17:48:31 listener-thread: err = -951: oserr = 0: errstr = user06@informix-class2: Incorrect password or user user06@informix-class2 is not known on the database server.12317:48:31Get Shadow Password for user [user06] failed!17:48:31Check for password aging/account lock-out.17:48:31listener-thread: err = -951: oserr = 0: errstr = user06@informix-class2: Incorrect password 951 informix error or user user06@informix-class2 is not known on the database server.At first i was searching Google for the original error message i got, and found a lots links which didn't help in my case.But after searching for Get Shadow Password for user * failed1Get Shadow Password for user * failedI found my answer on the first page. in IBM support site. basically it was wrong permission on the oninit fileCAUSE$INFORMIXDIR/bin/oninit has wrong permissions and/or attributesSOLUTIONAssign $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/oninit12chown root:informix $INFORMIXDIR/bin/oninitchmod 6754$INFORMIXDIR/bin/oninitAnd thats all,Sourcehttp://www-01.ibm.com/support/docview.wss?uid=swg21218436Related Post המחשב לא מזהה את הרשת האלחוטית שלי ,אבל כן רואה רש... Speed up RT Shreeder / or why RT shredder is so sl... Setup Xdebug for remote debug over SSH צילום מסך באנדרויד דרך שורת הפקודה... Tags: ConnectDBFOSSInthe 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 clien