Grouper Users - Open Discussion List

Hello Kathryn,

Thanks for your help.

Regarding your questions, no, 'uid' is not indexed, but from 
ldappcTemplate.xml I understood that to be just a performance issue.

As for the case of 'id', as far as I can see it is always lowercase - only 
the display in the Grouper UI is uppercase.

Here is my sources.xml:

<sources>

  <!-- Group Subject Resolver -->
  <source 
adapterClass="edu.internet2.middleware.grouper.GrouperSourceAdapter">
    <id>g:gsa</id>
    <name>Grouper: Group Source Adapter</name>
    <type>group</type>
  </source>

  <!-- Example JDBC Person Resolver -->
  <source 
adapterClass="edu.internet2.middleware.subject.provider.JDBCSourceAdapter">
    <id>fu</id>
    <name>testdb</name>
    <type>person</type>

    <init-param>
      <param-name>maxActive</param-name>
      <param-value>16</param-value>
    </init-param>
    <init-param>
      <param-name>maxIdle</param-name>
      <param-value>16</param-value>
    </init-param>
    <init-param>
      <param-name>maxWait</param-name>
      <param-value>-1</param-value>
    </init-param>
    <init-param>
      <param-name>dbDriver</param-name>
      <param-value>org.postgresql.Driver</param-value>
    </init-param>
    <init-param>
      <param-name>dbUrl</param-name>
      
<param-value>jdbc:postgresql://xxxxxx.xxxxx.fu-berlin.de:xxxx/testdb</param-value>
    </init-param>
    <init-param>
      <param-name>dbUser</param-name>
      <param-value>xxxxxxxx</param-value>
    </init-param>
    <init-param>
      <param-name>dbPwd</param-name>
      <param-value>xxxxxxxx</param-value>
    </init-param>
    <init-param>
      <param-name>SubjectID_AttributeType</param-name>
      <param-value>id</param-value>
    </init-param>
    <init-param>
      <param-name>Name_AttributeType</param-name>
      <param-value>name</param-value>
    </init-param>
    <init-param>
      <param-name>Description_AttributeType</param-name>
      <param-value>name</param-value>
    </init-param>

    <search>
        <searchType>searchSubject</searchType>
       <param>
         <param-name>numParameters</param-name>
         <param-value>1</param-value>
       </param>
        <param>
            <param-name>sql</param-name>
            <param-value>
select accounts.aid as id,
  firstname||' '||lastname as name,
  lastname||', '||firstname as lfname,
  lastname as lastname, firstname as firstname,
  accounts.username as loginid,
  dept as department
from
  people
  left join accounts on (accounts.pid=people.pid)
where (accounts.aid=?);
            </param-value>
       </param>
    </search>
    <search>
        <searchType>searchSubjectByIdentifier</searchType>
       <param>
         <param-name>numParameters</param-name>
         <param-value>1</param-value>
       </param>
        <param>
            <param-name>sql</param-name>
            <param-value>
select accounts.aid as id,
  firstname||' '||lastname as name,
  lastname||', '||firstname as lfname,
  lastname as lastname, firstname as firstname,
  accounts.username as loginid,
  dept as department
from
  people
  left join accounts on (accounts.pid=people.pid)
where (accounts.aid=?);
            </param-value>
        </param>
    </search>
    <search>
       <searchType>search</searchType>
       <param>
         <param-name>numParameters</param-name>
         <param-value>4</param-value>
       </param>

        <param>
            <param-name>sql</param-name>
            <param-value>
select accounts.aid as id,
  firstname||' '||lastname as name,
  lastname||', '||firstname as lfname,
  lastname as lastname, firstname as firstname,
  accounts.username as loginid,
  dept as department
from
  people
  left join accounts on (accounts.pid=people.pid)
where (firstname similar to '%'||?||'%')
  or (lastname similar to '%'||?||'%') 
  or (dept similar to '%'||?||'%') 
  or (accounts.username similar to '%'||?||'%')
            </param-value>
        </param>
    </search>
  </source>

</sources>

Thanks again for your help.

Loris