JDBC User Attributes Table Relation

[Fahmi L. Ramdhani]

Hi,

I use JDBC as database authentication. I want to retrieve user attributes based on ID (int, not uid login ex: us...@example.com), after logging in with us...@example.com, I hope CAS takes the user id (int).

With the following relationships:

users (table)
 - id (PK, int)
 - email
 - password


id    email            password
==============================================
1     one@example.com  **************
2     two@example.com  **************


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.

[Tepe, Dirk]

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

--
- 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 cas-user+u...@apereo.org.
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.

[Jon Anderson]

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: cas-...@apereo.org [cas-...@apereo.org] on behalf of Tepe, Dirk [tep...@miamioh.edu]
Sent: Sunday, October 14, 2018 8:50 AM
To: cas-...@apereo.org
Subject: Re: [cas-user] JDBC User Attributes Table Relation

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.