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

Technote (troubleshooting)


Problem(Abstract)

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

Symptom

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


Cause

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

Environment

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
sqlerrmc: 1 PASSWORD EXPIRED
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.

Rate this page:

(0 users)Average rating

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

Translate my page

Machine Translation

Content navigation