Grouper Users - Open Discussion List

[Thomas M Goerger <>]

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>