Hi, since I am just getting acquainted with CAS I am certain that my issue is configuration or concept related, so first of all I would like to seek the guidance of the community on how to properly configure the stack the way I thought so, if that is possible at all.
I started out with CAS 5.0.0 using the Maven overlay and configured the
Trusted authentication webflow, since Apache handles the authentication in
a standardized way throughout the company. The username gets resolved, the
login works on the /cas-login page.
Next I wanted to extend the platform with attribute resolution, but
apparently this part is not working.
I created a simple MySQL *users *table in the *cas* database like the
following:
+--------+------------+-----------+----------------------------+
| uid | first_name | last_name | email |
+--------+------------+-----------+----------------------------+
| mgabri | Mate | Gabri | mate.gabri@[obscured] |
+--------+------------+-----------+----------------------------+
The relecant cas.properties settings are the following, which may be the
first source of error:
cas.authn.attributeRepository.jdbc.singleRow=true
cas.authn.attributeRepository.jdbc.requireAllAttributes=true
cas.authn.attributeRepository.jdbc.sql=SELECT * FROM users WHERE {0}
cas.authn.attributeRepository.jdbc.username=uid
cas.authn.attributeRepository.jdbc.url=[obscured]
cas.authn.attributeRepository.jdbc.driverClass=com.mysql.cj.jdbc.Driver
cas.authn.attributeRepository.jdbc.user=[obscured]
cas.authn.attributeRepository.jdbc.password=[obscured]
In the logs I can catch the following lines:
Dec 5 11:06:31 [obscured] CAS:
PrincipalBearingCredentialsAuthenticationHandler successfully authenticated
mgabri
Dec 5 11:06:31 [obscured] CAS: Executing prepared SQL query
Dec 5 11:06:31 [obscured] CAS: Executing prepared SQL statement [SELECT *
FROM users WHERE uid = ?]
Dec 5 11:06:31 [obscured] CAS: Fetching JDBC Connection from DataSource
Dec 5 11:06:32 [obscured] CAS: Recovering From Exception thrown by
'org.apereo.services.persondir.support.jdbc.SingleRowJdbcPersonAttributeDao@431b08dc'
Dec 5 11:06:32 [obscured] CAS: Authenticated principal [mgabri] and
attributes {} with credentials [mgabri].
As you can see the *SingleRowJdbcPersonAttributeDao *is recovering from an
exception, but I was not able to figure out a way to have more insight in
what is really happening. Unfortunately I am not familiar with Java
applications at all so it is a bit hard for me to even start to look for
solution.
I would like to humbly ask the community to provide me some guidance on how
to proceed or enlighten me that what I want to achieve is possible at all.
I have attached the pom.xml since that is a bit long.
Kind regards,
Mate
--
- CAS gitter chatroom: https://gitter.im/apereo/cas
- CAS mailing list guidelines: https://apereo.github.io/cas/Mailing-Lists.html
- CAS documentation website: https://apereo.github.io/cas
- CAS project website: https://github.com/apereo/cas
---
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/9408df7b-c44c-492b-8abb-66b5ba6c3050%40apereo.org.
pom.xml
Description: XML document
