Informix Error 951 Unix
Contents |
password; user authentication; -951; 951; sanjitc; sanjitc2005; sanjit chakraborty Technote informix odbc incorrect password or user (troubleshooting) Problem(Abstract) Error -951 returned by Dynamic Server (IDS) on
Informix Error 952
Windows when using dbaccess. Resolving the problem As user informix, you attempt to connect to IBM
Informix Sql Error
Informix server on a Windows platform using dbaccess, and receive the following error message: -951: Incorrect password or user informix is not known
Informix Allow Remote Connections
on the database server Same time you may receive following error message in the message log file: listener-thread: err = -951: oserr = -###: errstr = informix: Incorrect password or user informix is not known on the database server. CAUSE The error -951 typically relates to the domain name server (DNS) error 651 or user authentication. The following situations can cause error -951: Informix user account was deleted and recreated Windows server membership has changed from domain to workgroup Windows server membership has changed from workgroup to domain Change in domain default policy for informix domain user User ‘informix’ is not a member of administrator group at the server Informix user password has expired SOLUTION The problem can generally be resolved by reinstalling Informix server product per the Installation Guide for IBM Informix Dynamic Server for your Windows platform. It may be necessary to remove the Informix registry entries and remove and recreate the user informix and group Informix-Admin. Document information More support for: Informix Servers Software version: 10.0, 11.1, 11.5, 11.7, 12.1 Operating system(s): Windows Reference #: 1200068 Modified date: 2005-04-22 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 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.ibm.com/support/docview.wss?uid=swg21200068 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
a recent discussion on c.d.i and also from checking the URL referrers that bring people here.Most of this blog visits comes from Google or other search engines. And apparently there are http://informix-technology.blogspot.com/2009/04/informix-authentication-and-connections.html a lot of questions about how Informix authenticates and establishes user connections.I will try http://www.dbdummy.com/67/informix-err-951-troubleshoot-unknown-remote-host.html go give a generic overview on these subjects. I'll point out a few less known aspects of Informix authentication.This article in no way tries to substitute the official documentation, but I hope this can be used as a concentrated information resource about the subject.Authentication versus privilegesFirst, we have to create a distinction between two steps involved informix error in a connection establishment.As we all know, IDS and other databases have several privileges required for doing any action in the database.At the first level we have Database level privileges. These are CONNECT, RESOURCE and DBA. Then we have object level privileges. For tables we have INSERT, DELETE, ALTER, REFERENCE and for column level we have SELECT and UPDATEThe list above is not exhaustive. The privileges relevant for this informix error 951 article are the database level ones. In particular the CONNECT privilege. Without it we will not be able to connect.Privileges can be given using the SQL stament GRANT and removed with the REVOKE. Object level privileges can be GRANT'ed to individual users or to ROLEs. You can imagine ROLEs as groups and you can GRANT a role to individual users.But let's get back on track. The purpose here is not to explain the privilege infra-structure, but to explain how do we connect to the database. I just explained the privileges because we need to go through two steps for establishing a connection:First Informix has to make sure we are who we pretend to be. This is called the authentication phase Second, Informix will check if the user we are defining in the connection has the required privileges to establish the connection.It cannot do the second step without first completing the authentication.To be able to connect we need at least CONNECT privilege on the database level. This privilege can be granted specifically to the user or to the special role PUBLIC which means "anyone"User repositoriesOne very important aspect of Informix is that it doesn't use the concept of database only users. Any user in an Informix database must
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 Informix message logs. But there is no schedule on when this feature request will be incorporated into future versions of IDS. Posted by helloworld in Database General, Informix Database No Comments Read more Tagged Under : -951, IDS, incorrect password, Informix, xtrace Make a Comment Name (required) Mail (will not be published) (required) Website Search : Recent Posts Intercepting your record with triggles How to check from Informix server if connections came from shared memory Informix Archecker – point in time restore/recover table (Scenario 2) Undefined subroutine &main::read_file called at crspatch.pm line 86. while running ./rootcrs.pl HAIP is up on some nodes but not on all RAC nodes Sponsors Categories Database General Informix Database Operating System Oracle Database Raspberry Pi Ubuntu UNIX / Linux Utilities Archives