RE: [cas-user] JDBC User Attributes Table Relation

[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-user@apereo.org [cas-user@apereo.org] on behalf of Tepe, Dirk 
[tep...@miamioh.edu]
Sent: Sunday, October 14, 2018 8:50 AM
To: cas-user@apereo.org
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 
mailto:fahmilestianramdh...@gmail.com>> wrote:
Hi,

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

With the following relationships:

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


idemailpassword
==
1 o...@example.com  **
2 t...@example.com  **


user_attributes (table)
 - id (PK, int)
 - user_id (FK, int)
 - attr_name
 - attr_value

iduser_idattr_nameattr_value
==
1 1  first_name   One
2 1  last_nameExample
3 2  first_name   One
4 2  last_nameExample

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 cas-user+unsubscr...@apereo.org<mailto:cas-user+unsubscr...@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<https://groups.google.com/a/apereo.org/d/msgid/cas-user/0f66f6e7-fa85-4105-a4ca-db83d907f49d%40apereo.org?utm_medium=email_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 cas-user+unsubscr...@apereo.org<mailto:cas-user+unsubscr...@apereo.org>.
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_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 cas-user+unsubscr...@apereo.org.
To view this discussion on the web visit 
https://groups.google.com/a/apereo.org/d/msgid/cas-user/0A9BC9099B13904AA1708A7F1B6C8404E6C0F111%40Ntsrv75.int.oru.edu.

Re: [cas-user] JDBC User Attributes Table Relation

[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

On Sat, Oct 13, 2018 at 12:44 AM Fahmi L. Ramdhani <
fahmilestianramdh...@gmail.com> wrote:

> Hi,
>
> I use JDBC as database authentication. I want to retrieve user attributes
> based on ID (int, not uid login ex: u...@example.com), after logging in
> with u...@example.com, I hope CAS takes the user id (int).
>
> With the following relationships:
>
> *users (table)*
>  - id (PK, int)
>  - email
>  - password
>
>
> idemailpassword
> ==
> *1* o...@example.com  **
> *2* t...@example.com  **
>
>
> *user_attributes** (table)*
>  - id (PK, int)
>  - user_id (FK, int)
>  - attr_name
>  - attr_value
>
> iduser_idattr_nameattr_value
> ==
> 1 *1*  first_name   One
> 2 *1*  last_nameExample
> 3 *2*  first_name   One
> 4 *2*  last_nameExample
>
> 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 cas-user+unsubscr...@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
> 
> .
>

-- 
- 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+unsubscr...@apereo.org.
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.

[cas-user] 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: u...@example.com), after logging in 
with u...@example.com, I hope CAS takes the user id (int).

With the following relationships:

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


idemailpassword
==
*1* o...@example.com  **
*2* t...@example.com  **


*user_attributes** (table)*
 - id (PK, int)
 - user_id (FK, int)
 - attr_name
 - attr_value
 
iduser_idattr_nameattr_value
==
1 *1*  first_name   One
2 *1*  last_nameExample
3 *2*  first_name   One
4 *2*  last_nameExample

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 cas-user+unsubscr...@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.