Grouper Users - Open Discussion List

[Kathryn Huxtable <>]

I'm glad you got it working. For what it's worth, I agree with you  
about the documentation. I'll incorporate your suggestions into the  
next release, which will be a bit different. -K

On Jun 25, 2008, at 3:14 AM, Dr. Loris Bennett wrote:

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