Grouper Users - Open Discussion List

["Chris Franks" <>]

Hi Everyone,

I'm having trouble with the sources.xml in Grouper 1.2.

When I log in to the system, by default I have to use the "name"
attribute in the Subject table (I assume because the sources.xml
searchSubjectByIdentifier search block says select * from Subject where
(name=?) and the searchSubject search block says select * from Subject
where (subjectId=?)).  When I switch these around (which seems to make
more sense because the searchSubjectByIdentifier used the subjectId
attribute) this is cured.

When I can do this, I can login.  But when I try to view my subject's
summary I get:

Unexpected error   -
edu.internet2.middleware.subject.SubjectNotFoundException:subject not
found: 
,person

Is this because the searchSubjectByIdentifier and searchSubject search
blocks in the sources.xml have been switched?  In grouper 1.1 I could
rectify this by editing the searches so that:

searchSubjectByIdentifier = select * from Subject where
(subjectId='%TERM%') or (name='%TERM%')

and

searchSubject = select * from Subject where (subjectId='%TERM%') or
(name='%TERM%')

But if I do the equivalent in Grouper 1.2, so:

searchSubjectByIdentifier = select * from Subject where (name=?) or
(subjectId=?)

and

searchSubject = select * from Subject where (subjectId=?) or (name=?)

Neither logging in with the subjectId attribute nor the name attribute
works.

Looking at the query logs, the queries with "or" in them don't seem to
get executed at all.  Similarly, if I make no changes at all to the
sources and login with the GrouperSystem user and try to do a search,
with working Subject and SubjectAttribute entries in the database, I get
no results and it looks as though the search query has not been
executed.  This only happens in Grouper 1.2.

Can anyone shed any light?  I'm using MySQL 5 if this helps?

Thanks in advance,

Chris Franks
Newcastle University