Terry Miller wrote:
> I have DB2 V8.2 loaded on a Redhat Enterprise Linux version 3 (RHEL 3) box.
> RHEL is configured to talk to LDAP for authenticaton besides the local
> passwd file. I can verify this by executing an su to a User Id that exists
> in LDAP and not in the local /etc/passwd file. Also verified that the
> connection to LDAP is working by ssh into the box.
>
> The problem I have is when I try to connect to a local DB2 Database using a
> User Id and Password in LDAP, I get the following error:
> SQL30082N Attempt to establish connection failed with security reason
> "24" ("USERNAME AND/OR PASSWORD INVALID") SQLSTATE=08001
>
> The connection works if I connect to the databas using a local User ID and
> Password on the box, but does not work if I use an LDAP User Id and
> Password. I know RHEL3 is talking to LDAP because I can su, ssh, etc to
> userids that are in LDAP.
>
> How do I configure DB2 to work with User Ids and Passwords in LDAP?
> It appears that it is only using the local /etc/passwd file.
>
> I have checked the various /etc/pamd.d files and they appear correct.
>
> Thanks for any help.
>
In order to get LDAP support in DB2 UDB you must be on at least 8.2 and
you must code a PIM exit. See
http://www-128.ibm.com/developerwork.../dm-0512chong/
Larry Edelstein