IBM Support

SQL30082N rc=24 Password expired error on Redhat Linux 6 with SSSD enabled and DB2 Transparent LDAP v9.7

Technote (troubleshooting)


Linux Redhat 6 with SSSD (System Security Service Daemon) has problem working with DB2 Transparent LDAP


LDAP user fails to connect to DB2 database with error SQL30082N rc=24


There is a defect in Redhat 6 SSSD that would cause such an issue with DB2 Transparent LDAP.


Linux Redhat 6

Diagnosing the problem

db2diag.log messages shows user password expired even when correct or incorrect password is used:

FUNCTION: DB2 UDB, bsu security, sqlexLogPluginMessage, probe:20

DATA #1 : String with size, 65 bytes
Password validation for user mgrice failed with rc = -2146500508
FUNCTION: DB2 UDB, oper system services, sqlofica, probe:10
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -30082 sqlerrml: 19
sqlerrp : SQLEXSMC
sqlerrd : (1) 0x80370064 (2) 0x00000064 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000004
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 08001

Resolving the problem

Upgrade Redhat 6 to Redhat 6.2 where the defect is fixed.

Document information

More support for: DB2 for Linux, UNIX and Windows
Operating System Security - LDAP

Software version: 9.7

Operating system(s): Linux

Software edition: Advanced Enterprise Server, Enterprise Server, Workgroup Server

Reference #: 1588633

Modified date: 2012-08-13