[Informix] Incorrect password or user [email protected] is not known on the database server
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
$INFORMIXDIR/bin/oninit has wrong permissions and/or attributes
Assign $INFORMIXDIR/bin/oninit to user root and group informix, permissions 6754 by executing the following command as user root or user with root privilegeschown root:informix $INFORMIXDIR/bin/oninit chmod 6754 $INFORMIXDIR/bin/oninit
And thats all,