Skip to Content.
Sympa Menu

grouper-users - RE: [grouper-users] sources.xml question agina

Subject: Grouper Users - Open Discussion List

List archive

RE: [grouper-users] sources.xml question agina

Chronological Thread 
  • From: Chris Hyzer <>
  • To: Dick Visser <>
  • Cc: "" <>
  • Subject: RE: [grouper-users] sources.xml question agina
  • Date: Fri, 17 Aug 2012 15:58:42 +0000
  • Accept-language: en-US

Thanks. Just putting it back on the list so other people can benefit. Just
curious, did you change the sources.xml or the database, and is sources.xml,
can you paste that part to the list? :)


-----Original Message-----
From: Dick Visser

Sent: Friday, August 17, 2012 3:36 AM
To: Chris Hyzer
Subject: Re: [grouper-users] sources.xml question agina


> I can try this too, but in case you have a spare minute... the error is
> that postgres is having trouble reconciling the string subjectId in grouper
> with the integer user_id in your table. Any chance you can change the type
> of that col to varchar2/text/whatever and try it out? :) For referential
> integrity or other queries or whatever, you could have two cols for id, one
> that is int and one that is varchar2/text/whatever...

Hmm, that went easy:

SELECT u.user_id::text AS user_id,

Now it's not complaining anymore:

Using GROUPER_HOME: /opt/GROUPER_2_1_BRANCH/grouper/bin/..
Using GROUPER_CONF: /opt/GROUPER_2_1_BRANCH/grouper/bin/../conf
Using JAVA: java
using MEMORY: 64m-750m
Grouper starting up: version: 2.1.1, build date: 2012/08/03 15:26:40,
env: <no label configured> read from:
Grouper current directory is: /opt/GROUPER_2_1_BRANCH/grouper/bin read from:
Grouper is logging to file:
/opt/GROUPER_2_1_BRANCH/grouper/bin/../logs/grouper_error.log, at min
level WARN for package: edu.internet2.middleware.grouper, based on
sources.xml read from: /opt/GROUPER_2_1_BRANCH/grouper/conf/sources.xml
sources.xml groupersource id: g:gsa
sources.xml groupersource id: grouperEntities
sources.xml jdbc source id: sourceId:
Type help() for instructions
gsh 0%

So I think I'm all set now...
I'm sure there'll be stuff later that I don't grok, but for now I'm good ;-)


Dick Visser
System & Networking Engineer
TERENA Secretariat
Singel 468 D, 1017 AW Amsterdam
The Netherlands

Archive powered by MHonArc 2.6.16.

Top of Page