Grouper Users - Open Discussion List

[Scott Koranda <>]

Hi,

> I was looking into the stack you sent, and it looks like the
> subject is retrieved, but then it cant find the value of the
> loginid attribute and match that to the eppn searched by.
> 
> I don't remember if this is fixed or not, but attributes are
> read from JDBC metadata which is uppercased, so maybe try
> doing this:
> 
> FROM:
> 
> <init-param> <param-name>identifierAttributes</param-name>
> <param-value>loginid</param-value> </init-param>
> 
> TO:
> 
> <init-param> <param-name>identifierAttributes</param-name>
> <param-value>LOGINID</param-value> </init-param>

Unfortunately that did not help.

> 
> If not, then retrieve the subject by id, and print out all
> attributes so you can look at them:
> 
> subject.getAttributes()   (returns Map)

gsh 3% s.getAttributes()
edu.internet2.middleware.subject.SubjectCaseInsensitiveMapImpl:
{lfname=[Koranda, Scott], mail=[null],
identifier=[]}

That isn't what I expected based on my sources.xml. For
example I don't see "description" anywhere.

Note that configured MySQL so that I can see the queries
going in and I have verified that the Grouper API is sending
in the right query and receiving a row in return.

Thanks,

Scott

> 
> or
> 
> subject.getAttributes.keySet()   (returns Set of String
> attribute names)
> 
> you should be loginid or LOGINID
> 
> At some point we should make the attribute case insensitive
> to make this easier (if this is the problem).  Or have the
> attributes specified in the sources.xml so the case is
> known.
> 
> Thanks, Chris
> 
> 
> 
> -----Original Message----- From:
> 
> [mailto:]
>  On Behalf Of
> Scott Koranda Sent: Thursday, August 30, 2012 10:13 AM To:
> grouper-users Subject: [grouper-users] sources.xml with JDBC
> source
> 
> Hi,
> 
> Attached is the sources.xml I am attempting to use to
> retrieve subjects from a relational database.
> 
> I can retrieve subjects using the appropriate id:
> 
> gsh 0% GrouperSession.startRootSession();
> edu.internet2.middleware.grouper.GrouperSession:
> fa94c2ea90cb45e4890dfa0b6d9d1ad1,'GrouperSystem','application'
> gsh 1% findSubject("1") subject: id='1' type='person'
> source='jdbc' name='Scott Koranda' gsh 2% findSubject("2")
> subject: id='2' type='person' source='jdbc' name='Stewie
> Anderson' 
> 
> I cannot, however, retrieve subjects by identifier:
> 
> gsh 3% 
> findSubject("")
>  // Error:
> unable to evaluate command: Sourced file: inline evaluation
> of: 
> ``findSubject("");''
>  : Error
> invoking compiled command: : Error in compiled command:
> edu.internet2.middleware.subject.InvalidQueryException: Why
> is this subject not able to be referenced by id or
> identifier (do you need to add identifierAttributes to your
> sources.xml???) Subject id: 1, sourceId: jdbc gsh 4%
> findSubject("")
>  // Error: unable to
> evaluate command: Sourced file: inline evaluation of:
> ``findSubject("");''
>  : Error
> invoking compiled command: : Error in compiled command:
> edu.internet2.middleware.subject.InvalidQueryException: Why
> is this subject not able to be referenced by id or
> identifier (do you need to add identifierAttributes to your
> sources.xml???) Subject id: 2, sourceId: jdbc
> 
> The data is available in the tables. Here is what I get when
> I copy the SQL from sources.xml and substitute the search
> string by hand:
> 
> mysql> SELECT ->     cm_co_people.id as id, ->
> CONCAT(cm_names.given, ' ',cm_names.family) as name, ->
> CONCAT(cm_names.given, ' ',cm_names.family, '(',
> cm_cos.description, ')') as description, ->
> CONCAT(cm_names.family, ', ',cm_names.given) as lfname, ->
> cm_email_addresses.mail as email, ->
> cm_identifiers.identifier as loginid -> FROM ->
> cm_co_people ->     JOIN cm_names ON cm_co_people.id =
> cm_names.co_person_id ->     JOIN cm_cos ON
> cm_co_people.co_id = cm_cos.id ->     LEFT JOIN
> cm_email_addresses ON cm_co_people.id =
> cm_email_addresses.co_person_id ->     LEFT JOIN
> cm_identifiers ON cm_co_people.id =
> cm_identifiers.co_person_id -> WHERE ->
> cm_identifiers.identifier = 
> ''\G
> *************************** 1. row
> *************************** id: 1 name: Scott Koranda
> description: Scott Koranda(COmanage Gears Internal CO)
> lfname: Koranda, Scott email: NULL loginid:
> 
> 
> mysql> SELECT ->     cm_co_people.id as id, ->
> CONCAT(cm_names.given, ' ',cm_names.family) as name, ->
> CONCAT(cm_names.given, ' ',cm_names.family, '(',
> cm_cos.description, ')') as description, ->
> CONCAT(cm_names.family, ', ',cm_names.given) as lfname, ->
> cm_email_addresses.mail as email, ->
> cm_identifiers.identifier as loginid -> FROM ->
> cm_co_people ->     JOIN cm_names ON cm_co_people.id =
> cm_names.co_person_id ->     JOIN cm_cos ON
> cm_co_people.co_id = cm_cos.id ->     LEFT JOIN
> cm_email_addresses ON cm_co_people.id =
> cm_email_addresses.co_person_id ->     LEFT JOIN
> cm_identifiers ON cm_co_people.id =
> cm_identifiers.co_person_id -> WHERE ->
> cm_identifiers.identifier = 
> ''\G
> *************************** 1. row
> *************************** id: 2 name: Stewie Anderson
> description: Stewie Anderson(LIGO Laboratory) lfname:
> Anderson, Stewie email: 
> 
>  loginid:
> 
> 
> I appreciate any input anybody has on what I am doing wrong
> in my sources.xml file.
> 
> Thanks,
> 
> Scott
>