Password Changes and Connecting to an IBM Informix database

Rocky Linux Help & Support
1

We are running on a Rocky 9.3 OS connecting to an IBM Informix 14.10 database.

We have system users. When running our software, we connect to the database using the command:

CONNECT TO dbname USER user_name USING user_password

When an administrator changes the user’s password using the passwd command, the user can log into our software and connect to the database with no issue.

Say the user logs out and the administrator changes the password again. When the user logs into our software using the new password, they get this error:

10:09:30 Password Validation for user [kal] failed!
10:09:30 Check for password aging/account lock-out.
10:09:30 listener-thread: err = -952: oserr = 0: errstr = kal@rnsmt: User (kal@rnsmt)'s password is not correct for the database server.

This user can log into the Rocky server using the new password with no issue but cannot connect to the database with the new password.

However, when the user waits maybe 20 minutes or so, it will finally recognize the new password when connecting to the database.

Has anyone had a similar issue and could it be a setting on the Rocky Linux server? We did not have this issue on Centos 7.

Thanks!
Kimberly

2

The behavior you’re describing sounds like an informix issue and not a Rocky Linux issue.

How exactly do you have informix setup to do authentication? Are you using PAM authentication? If not, can you switch to using PAM authentication and attempt to reproduce your issue?

3

Yes, we are using PAM authentication.

4

How do you have PAM configured on the system? This means in /etc/pam.d, so files such as system-auth, password-auth, and if applicable the pam file you setup for informix (according to the documentation).

5

Thanks for your response. We did resolve the issue by working with Informix and we changed the NS_CACHE config parameter. We reduced the user cache parameter. Thanks!
Kimberly