Grouper Users - Open Discussion List

[Michael McManaman <>]

Hi Shilen,

I've been following the documentation in the link you posted - 
https://spaces.internet2.edu/x/pAEOAQ.

I've got grouper reading the sources file, but i'm getting errors such 
as this -

Subject API error: error with subject source id: jdbc, name: Example 
JDBC Source Adapter, problem with getSubject by id, in sources.xml: 
search searchSubject: , 
edu.internet2.middleware.subject.SourceUnavailableException: Why are 
there parameters in the sql? jdbc

In the doc, under the subject heading  'Configuring a JDBC subject 
source adaptor 1 - a GrouperJdbcSourceAdapter' - there is an example 
data source against a C3p0JdbcConnectionProvider connection (only we're 
using oracle) and my question, and i think the cause of my problem is, 
for the 3 queries that are defined for the subject source, I can match 
up the first 2 examples to queries i can run against our database to 
retrieve an id, name and description, but the 3rd query i'm not sure how 
to go about this. Is grouper looking for 3 variables (the '?'s) to pass 
into the query before executing?

The description variable for our database isn't a viable column to 
search on so at best a wildcard search on id and name are the only options.

I'm wondering if the whittled down example, if followed exactly (except 
for sql content) leads to a non functional source adapter


Thanks,
Mike


On 09/23/2016 09:10 AM, Shilen Patel wrote:
> First you probably want to configure the sources.xml file to point to your
> database and confirm that it works with grouper (e.g. gsh) if you haven't
> done that already.  It's probably best to look at the examples in the file
> and modify them to work for your database.  Here's some documentation
> (https://spaces.internet2.edu/x/pAEOAQ) though it hasn't been updated in a
> while.  Here's a high level description/diagrams/videos -
> https://spaces.internet2.edu/x/rYXd .  Again, I would just go by the
> examples and ask questions here.
>
> Thanks!
>
> - Shilen
>
> On 9/22/16, 2:36 PM, "Michael McManaman" 
> <>
>  wrote:
>
> > Thanks Shilen!
> >
> > Can you point me to the documentation on how to set up the psp (?) to
> > use the sources.xml for finding subject sources?
> >
> > I'm a bit fuzzy on how this part of grouper would work, and i'm probably
> > missing the docs in the wiki.
> >
> > Thanks again for your help!
> >
> > Mike
> >
> >
> >
> > On 09/21/2016 03:16 PM, Shilen Patel wrote:
> > > The subject table doesn't have to be populated.  In fact, it's mainly
> > > for
> > > the quickstart and running tests.
> > >
> > > Rather, you should be using the sources.xml file to configure your
> > > subject
> > > source(s).  Both ldap and jdbc are supported by default.  So Grouper
> > > basically looks at your existing database table to find people.
> > >
> > > Thanks!
> > >
> > > - Shilen
> > >
> > > On 9/21/16, 1:59 PM, "Michael McManaman" 
> > > <>
> > >  wrote:
> > >
> > > > We have a database table populated with user names and user IDs.
> > > >
> > > > is is possible to use a loadergroup to run an sql query that populates
> > > > the subject list in grouper?
> > > >
> > > > I've been using gsh scripts with thousands of addSubject() lines -
> > > > where
> > > > each line corresponds to a database record.
> > > >
> > > > This just seems a bit cumbersome and a scheduled loadergroup seems more
> > > > practical?
> > > >
> > > >
> > > > also - is it possible from the grouper UI to see/edit the list of
> > > > subjects (or users, group members or whatever they're called)
> > > >
> > > >
> > > > Thanks
> > > >
> > > > Mike