[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

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 *