[Informix] Incorrect password or user [email protected] is not known on the database server

While trying to connect remotely to a Informix DB I have encounter this error message

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 connection attempt

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

I found my answer on the first page. in IBM support site. basically it was wrong permission on the oninit file

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

And thats all,

Source

Related Post

You may also like...

3 Responses

  1. Amrita Pandey says:

    I am getting the below error line while connecting to database.
    951: Incorrect password or user [email protected] is not known on the database server.
    Instead of [email protected], I get the error for [email protected] Could you advise what should be done here?

    • Rabin says:

      IBM have a FAQ on this error, try and look here: http://www-01.ibm.com/support/docview.wss?uid=swg21588239

      Several symptoms can cause such behaviour:

      1. SQLHOSTS file mispelled entries;
      2. DBSERVERNAME or DBSERVERALIASES onconfig parameters have no related entries in the SQLHOSTS file;
      3. NIS or LDAP servers misconfiguration or maintenance;
      4. INFORMIXDIR filesystem and/or its subdirectories have wrong permissions or ownership;
      5. User is locked or expired;
      6. oninit binary is somehow damaged or have wrong permissions.
  2. Diego says:

    Please check pwd_algorithm atributte in /etc/security/login.cfg file, I have problems with sha256 value

Leave a Reply

Your email address will not be published. Required fields are marked *