Skip to Content.
Sympa Menu

grouper-users - Re: [grouper-users] Subject/Member question.

Subject: Grouper Users - Open Discussion List

List archive

Re: [grouper-users] Subject/Member question.

Chronological Thread 
  • From: Michael McManaman <>
  • To: Shilen Patel <>, "" <>
  • Subject: Re: [grouper-users] Subject/Member question.
  • Date: Tue, 27 Sep 2016 16:52:23 -0400
  • Ironport-phdr: 9a23:Wa82BhHpe6v0wisbbqPaNp1GYnF86YWxBRYc798ds5kLTJ75osqwAkXT6L1XgUPTWs2DsrQf1LqQ7vurADFIyK3CmU5BWaQEbwUCh8QSkl5oK+++Imq/EsTXaTcnFt9JTl5v8iLzG0FUHMHjew+a+SXqvnY6Uy/yPgttJ+nzBpWaz4Huj7jzqNXvZFBzhDu5bLU6FByqoAGZ4tIWgI9vLI491xjE5HZEZrISjSlnP1WOhxvmo9qr8YR42yVWp/878cNcC+P3c7lyBehXFjM7K20vodDwuAPYZQqJ+nYGVGgKyFxFDxWTvz/gWZKklyrxtuNw3GG/Nuj/S7kxUDLqu6JkTUDAgjoJOTc99yfahtEm3/ETmw6ouxEqm92cW4qSLvcrO/qFJd4=

Hi Shilen,

I've been following the documentation in the link you posted -

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


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
( though it hasn't been updated in a
while. Here's a high level description/diagrams/videos - . Again, I would just go by the
examples and ask questions here.


- Shilen

On 9/22/16, 2:36 PM, "Michael McManaman"

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!


On 09/21/2016 03:16 PM, Shilen Patel wrote:
The subject table doesn't have to be populated. In fact, it's mainly
the quickstart and running tests.

Rather, you should be using the sources.xml file to configure your
source(s). Both ldap and jdbc are supported by default. So Grouper
basically looks at your existing database table to find people.


- Shilen

On 9/21/16, 1:59 PM, "Michael McManaman"

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 -
each line corresponds to a database record.

This just seems a bit cumbersome and a scheduled loadergroup seems more

also - is it possible from the grouper UI to see/edit the list of
subjects (or users, group members or whatever they're called)



Archive powered by MHonArc 2.6.19.

Top of Page