Informix Error -952: User's password is not correct for the database server.
Cause and resolution
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 User (<user-id>)'s password is not correct for the database server. </user-id>
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.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-952 fires when the password specified for a remote server connection (via ~/.netrc or a
CONNECT statement's USER clause) is incorrect — per the official guidance, this message
appears with Version 6.0 and later.
- An incorrect password in
~/.netrcfor the target host, per the official guidance. - An incorrect password supplied in a
CONNECTstatement'sUSERclause, per the official guidance. - A password that changed on the remote server without the local
~/.netrc/connection code being updated to match.
Solutions / Resolution
- Check that your password is specified correctly, per the official guidance, in whichever
location (
~/.netrcor theCONNECTstatement) supplied it. - Try again, per the official guidance, once the password is corrected.
- If the password is genuinely forgotten/expired, have it reset by whoever administers accounts on the remote server.
Examples
Checking ~/.netrc's password entry
$ cat ~/.netrc
machine remote_host login myusername password ...
Confirm the password value is current and correct for remote_host.
Diagnostic Checks
- Check the password specified in
~/.netrcor theCONNECTstatement'sUSERclause against what's actually valid on the remote server.
Related Errors / Related Topics
- -951 — "User username is not known on the database server." A related authentication error, about the username being unrecognized rather than the password being wrong.
- -950 — "User username is not known on the database server." A related authentication error, in the PAM-specific context.
Check the password specified in ~/.netrc or CONNECT ... USER — the same two locations -951
checks for the username.