Grouper Users - Open Discussion List

[Chris Hyzer <>]

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?  :)

Thanks,
Chris

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

Chris

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

root@grouper:/opt/GROUPER_2_1_BRANCH/grouper/bin#
 ./gsh.sh
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>
grouper.properties read from:
/opt/GROUPER_2_1_BRANCH/grouper/conf/grouper.properties
Grouper current directory is: /opt/GROUPER_2_1_BRANCH/grouper/bin
log4j.properties read from:
/opt/GROUPER_2_1_BRANCH/grouper/conf/log4j.properties
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
log4j.properties
grouper.hibernate.properties:
/opt/GROUPER_2_1_BRANCH/grouper/conf/grouper.hibernate.properties
grouper.hibernate.properties:
grouper_user@jdbc:postgresql://ip6-localhost:5432/grouper
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:
core_user@jdbc:postgresql://[2001:610:148:dead::8]/tnc2012?ssl=true
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 ;-)


Thanks!!!



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