I do something like this in my old cas installation (3.5), where I get an attribute from ldap and use that to query a database for another attribute.
As far as I can see, this feature was not included in the property based configuration system. (And the documentation for configuring the beans manually seems very sparse for any non-java programmers.) Jon ________________________________ From: [email protected] [[email protected]] on behalf of Tepe, Dirk [[email protected]] Sent: Sunday, October 14, 2018 8:50 AM To: [email protected] Subject: Re: [cas-user] JDBC User Attributes Table Relation CAS only knows the authenticated username. If you are only concerned with attribute resolution after authentication, isn't that just a matter of adding a join to your attribute query? -dirk On Sat, Oct 13, 2018 at 12:44 AM Fahmi L. Ramdhani <[email protected]<mailto:[email protected]>> wrote: Hi, I use JDBC as database authentication. I want to retrieve user attributes based on ID (int, not uid login ex: [email protected]<mailto:[email protected]>), after logging in with [email protected]<mailto:[email protected]>, I hope CAS takes the user id (int). With the following relationships: users (table) - id (PK, int) - email - password id email password ============================================== 1 [email protected] ************** 2 [email protected] ************** user_attributes (table) - id (PK, int) - user_id (FK, int) - attr_name - attr_value id user_id attr_name attr_value ============================================== 1 1 first_name One 2 1 last_name Example 3 2 first_name One 4 2 last_name Example How to solve this? Thank you. -- - Website: https://apereo.github.io/cas - Gitter Chatroom: https://gitter.im/apereo/cas - List Guidelines: https://goo.gl/1VRrw7 - Contributions: https://goo.gl/mh7qDG --- You received this message because you are subscribed to the Google Groups "CAS Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/0f66f6e7-fa85-4105-a4ca-db83d907f49d%40apereo.org<https://groups.google.com/a/apereo.org/d/msgid/cas-user/0f66f6e7-fa85-4105-a4ca-db83d907f49d%40apereo.org?utm_medium=email&utm_source=footer>. -- - Website: https://apereo.github.io/cas - Gitter Chatroom: https://gitter.im/apereo/cas - List Guidelines: https://goo.gl/1VRrw7 - Contributions: https://goo.gl/mh7qDG --- You received this message because you are subscribed to the Google Groups "CAS Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/CAJ%3D0EZz-UzEYgjmZXMaYcp-31uQizcx8m6j-6k_nDy3MuFrKUg%40mail.gmail.com<https://groups.google.com/a/apereo.org/d/msgid/cas-user/CAJ%3D0EZz-UzEYgjmZXMaYcp-31uQizcx8m6j-6k_nDy3MuFrKUg%40mail.gmail.com?utm_medium=email&utm_source=footer>. -- - Website: https://apereo.github.io/cas - Gitter Chatroom: https://gitter.im/apereo/cas - List Guidelines: https://goo.gl/1VRrw7 - Contributions: https://goo.gl/mh7qDG --- You received this message because you are subscribed to the Google Groups "CAS Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/0A9BC9099B13904AA1708A7F1B6C8404E6C0F111%40Ntsrv75.int.oru.edu.
