return to PRS Technologies website
I can login to Unix (HP/UX) without a problem. But when I try to connect to Informix, I get an Informix -952 error (User's password is not correct for the database server.) How can that be ?
This drove me crazy for hours. Unix and Informix use the same Unix facility to
validate passwords. How could it be that I could log into Unix (HP/UX) without a problem,
but not Informix, using the same login ID and password ?
Well, under HP/UX, only the first eight characters of a password are significant
(if it is not set up as a "trusted" system). HP/UX throws away everything but the first
8 characters of your password when it creates the encrypted password in the
But Informix does no such thing. So - if you have a password that exceeds 8 characters
(like I did), Informix uses the entire password to authenticate. Of course this fails
since it doesn't match the 8 character password.
So most likely you will want to use a password that has 8 or less characters.
In addition, HP/UX wants you to have at least 6 characters AND must contain at least
two uppercase and/or lowercase letters and at least one numeric or special character.
Yikes! That doesn't leave much flexibility.
952 User's password is not correct for the database server.
The password that is specified for the server computer in your ~/.netrc
file or in the USER clause of a CONNECT statement is incorrect. The
database server does not accept (or cannot find) your account password.
Check that your password is specified correctly, and try again. This
message appears with Version 6.0 and later.
-952 Incorrect user password for remote host.
The database server resides on another computer system that does not
accept (or cannot find) your account password. Verify that your
password is correctly entered in the appropriate authorization or
password file. This message appears prior to Version 6.0.