[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
Incorrect password or user [email protected] is not known on 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 connection attempt
17:48:31 Get Shadow Password for user [user06] failed! 17:48:31 Check for password aging/account lock-out. 17:48:31 listener-thread: err = -951: oserr = 0: errstr = [email protected]: Incorrect password or user [email protected] 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 * failed
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
chown root:informix $INFORMIXDIR/bin/oninit chmod 6754 $INFORMIXDIR/bin/oninit
And thats all,
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?
IBM have a FAQ on this error, try and look here: http://www-01.ibm.com/support/docview.wss?uid=swg21588239
Please check pwd_algorithm atributte in /etc/security/login.cfg file, I have problems with sha256 value
Excelente, ese era el problema…
Exacto, me paso lo mismo y lo solucione con esos dos pasos….muchas gracias!