IBM Support

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

Troubleshooting


Problem

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.

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Security \/ Plug-Ins - LDAP","Platform":[{"code":"PF016","label":"Linux"}],"Version":"9.7","Edition":"Advanced Enterprise Server;Enterprise Server;Workgroup Server","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21588633

Page Feedback