MySQl attribute Mapping in Shibboleth IDP

[Yasser Afifi]

Hello,
I am new to Shibboleth and trying to configure Shibboleth IDP. I am using
mysql connector to connect to my test database. My test database has 2
tables. User and Role. User table has only two columns: id and userName, as
well as a foreign key column for the RoleId. The Role table has two columns
as well roleId and roleName. There is a Many to One relationship between
the two table where a user can have only one role but a role can be used by
many users.

 I am defining attributes to be sent to the SP in my attribute-resolver.xml
file. I want to send the roleName of the user to the SP. My question is: In
the attribute-resolver.xml, how can I get the roleName from the role table
that correspond to the userID ?

Thanks a lot
Kind Regards,
Yasser
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://shibboleth.net/pipermail/users/attachments/20151217/ef43ccc2/attachment.html>