Grouper Users - Open Discussion List

[Tom Barton <>]

I have no such experience, but I must ask: why do you want to use JDBC 
to access an LDAP source? Is there something about the JNDISourceAdapter 
that does not meet your needs?

Tom

Thomas M Goerger wrote:
> Has anyone had any experience connecting to an LDAP server using a JDBC
> connector?  I'm trying to query our LDAP directory to search for users
> here, and am not having any success with it.  Just wondering if anyone has
> tried to do this and had any success?  What adapter would you use?  I'm
> trying a Novell connector.  This is the code I'm using in my sources.xml
> module.  Anybody see anything that might be wrong?
>
> <source
> adapterClass="edu.internet2.middleware.subject.provider.JDBCSourceAdapter">
>     <id>ldapjdbc</id>
>     <name>LDAP JDBC Source Adapter</name>
>     <type>person</type>
>     <init-param>
>       <param-name>maxActive</param-name>
>       <param-value>4</param-value>
>     </init-param>
>     <init-param>
>       <param-name>maxIdle</param-name>
>       <param-value>2</param-value>
>     </init-param>
>     <init-param>
>       <param-name>maxWait</param-name>
>       <param-value>5</param-value>
>     </init-param>
>
>     <init-param>
>       <param-name>dbDriver</param-name>
>       <param-value>com.novell.sql.LDAPDriver</param-value>
>     </init-param>
>
>     <init-param>
>       <param-name>dbUser</param-name>
>       <param-value>Grouper Testing</param-value>
>     </init-param>
>     <init-param>
>       <param-name>dbPwd</param-name>
>       <param-value>#########</param-value>
>     </init-param>
>     <init-param>
>       <param-name>dbUrl</param-name>
>       <param-value>jdbc:ldap://lde-d.tc.umn.edu</param-value>
>     </init-param>
>
>     <init-param>
>       <param-name>SubjectID_AttributeType</param-name>
>       <param-value>uid</param-value>
>     </init-param>
>     <init-param>
>       <param-name>Name_AttributeType</param-name>
>       <param-value>cn</param-value>
>     </init-param>
>     <init-param>
>       <param-name>Description_AttributeType</param-name>
>       <param-value>sn</param-value>
>     </init-param>
>
>     <search>
>       <searchType>searchSubject</searchType>
>       <param>
>         <param-name>filter</param-name>
>         <param-value>
>           (&amp; (uid=%TERM%)(objectclass=umnPERSON))
>         </param-value>
>       </param>
>       <param>
>         <param-name>scope</param-name>
>         <param-value>SUBTREE_SCOPE</param-value>
>       </param>
>       <param>
> <param-name>base</param-name>
>         <param-value>
>           ou=PEOPLE,o=UNIVERSITY OF MINNESOTA,c=US
>         </param-value>
>       </param>
>     </search>
>
>     <search>
>       <searchType>searchSubjectByIdentifier</searchType>
>       <param>
>         <param-name>filter</param-name>
>         <param-value>
>           (&amp; (uid=%TERM%)(objectclass=umnPERSON))
>         </param-value>
>       </param>
>       <param>
>         <param-name>scope</param-name>
>         <param-value>
>           SUBTREE_SCOPE
>         </param-value>
>       </param>
>       <param>
>         <param-name>base</param-name>
>         <param-value>
>           ou=PEOPLE,o=UNIVERSITY OF MINNESOTA,c=US
>         </param-value>
>       </param>
>     </search>
>
>     <search>
>       <searchType>search</searchType>
>         <param>
>           <param-name>filter</param-name>
>           <param-value>
>             (&amp;
> (|uid=*%TERM%*)(cn=*%TERM%*)(sn=*%TERM%*))(objectclass=umnPERSON))
>           </param-value>
>         </param>
>         <param>
>           <param-name>scope</param-name>
>           <param-value>SUBTREE_SCOPE</param-value>
>         </param>
>         <param>
>           <param-name>base</param-name>
>           <param-value>
>             ou=PEOPLE,o=UNIVERSITY OF MINNESOTA,c=US
>           </param-value>
>         </param>
>       </search>
>     <attribute>sn</attribute>
>     <attribute>ou</attribute>
>     <attribute>uid</attribute>
>     <attribute>cn</attribute>
>   </source>
begin:vcard
fn:Tom Barton
n:Barton;Tom
org:University of Chicago;Networking Services & Information Technology
adr;dom:1155 E. 60th St.;;Rm 309, 1155 Bldg;Chicago;IL;60637
email;internet:
title:Sr. Director - Integration
tel;work:+1 773 834 1700
version:2.1
end:vcard