Grouper Users - Open Discussion List

["Dr. Loris Bennett" <>]

Hi,

I have solved this problem now. For the SearchBySubjectId in sources.xml
I now use 'login', which is the uid I then use in LDAPPC's
source-subject-identifier as the filter. 

Although I now have things working, it took me some while and I feel
that the current documentation is somewhat opaque when it comes to
configuration. For instance I still don't understand what the
SubjectID_AttributeType in sources.xml is for (A post in the archive
suggests to me it has something to do with the export function).

I would have like to have had something on the lines of 'recipes' (e.g.
more examples for the search functions needed if one is using an
existing database as a source) and 'troubleshooting' (e.g. make sure
ldappc is reading the correct sources.xml.

I would be more than willing to contribute to such documentation.

Regards

Loris


On Fri, 2008-06-20 at 02:41 -0400, 

wrote:
> 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

-- 
Dr. Loris Bennett 
<>