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: Shilen Patel <>
  • To: Michael McManaman <>, "" <>
  • Subject: Re: [grouper-users] Subject/Member question.
  • Date: Tue, 27 Sep 2016 22:21:07 +0000
  • Accept-language: en-US
  • Authentication-results: spf=none (sender IP is ) ;
  • Ironport-phdr: 9a23:IGu6oBaVNFBufzqK/ApU4+z/LSx+4OfEezUN459isYplN5qZpc++bnLW6fgltlLVR4KTs6sC0LWG9f27EjVdqb+681k8M7V0HycfjssXmwFySOWkMmbcaMDQUiohAc5ZX0Vk9XzoeWJcGcL5ekGA6ibqtW1aSV3DMl9QJ+/1E4PWx+G88um08pjaZU0cgTW4Ppt4MRu4pAHW8MQanN0mYuw+0BzUunZSPvlNyHlzDVOVgxvm4Mqspthu/zka86Yu7cldSajgOrkjQKZDJDUgL20v4sD371/OQRbZtVUGVWBDqRpJBwXDpCnzQpr1+n/htut51S+yMdD1QPY5VSn0vPQjcwPhlCpSb21xy2rQkMEl1K8=
  • Spamdiagnosticmetadata: NSPM
  • Spamdiagnosticoutput: 1:99

Looks like that example in the wiki is outdated.  You probably want to use the example in the sources.xml file as a starting point.  And you can configure the third query to search on whatever makes sense for your environment.   So not an issue to exclude description.


- Shilen

On 9/27/16, 4:52 PM, "Michael McManaman" <> wrote:

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
while.  Here's a high level description/diagrams/videos -
examples and ask questions here.


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


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