Hello,
I'm trying to upgrade from 6.2 to 6.4.
I have two authentications handler : 1 : jdbc mysql , 2 : ADFS-wsfed.
ADFS is working, but not mysql.
In the debug Log, 6.2, I can see :
oct. 22 17:47:15 campus-sso-01 cas.war[104218]: 2021-10-22 17:47:15,947
DEBUG [org.apereo.cas.authentication.PolicyBasedAuthenticationManager] -
<Candidate resolved authentication handlers for this transaction are
[[org.apereo.cas.authentication.handler.support.HttpBasedServiceCredentialsAuthenticationHandler@6a878778,
*org.apereo.cas.adaptors.jdbc.QueryDatabaseAuthenticationHandler*@6e612122,
org.apereo.cas.support.wsfederation.authentication.handler.support.WsFederationAuthenticationHandler@69d61a6f]]>
In the 6.4 log, there is no jdbc handler detected.
Any clue or log to enable in log4j to debug that ?
cas.properties section :
cas.authn.jdbc.query[0].sql=SELECT * FROM users WHERE email=?
cas.authn.jdbc.query[0].field-password=password
cas.authn.jdbc.query[0].url=jdbc:mysql://1.2.3.4/cas_recette?useLegacyDatetimeCode=false&serverTimezone=Europe/Paris
#cas.authn.jdbc.query[0].dialect=org.hibernate.dialect.MySQLDialect
cas.authn.jdbc.query[0].user=cas_recette
cas.authn.jdbc.query[0].password=xxxxxxx
cas.authn.jdbc.query[0].driver-class=com.mysql.cj.jdbc.Driver
cas.authn.jdbc.query[0].principal-transformation.case-conversion=LOWERCASE
cas.authn.jdbc.query[0].password-encoder.type=BCRYPT
cas.authn.jdbc.query[0].password-encoder.secret=xxxxxxxxx
cas.authn.jdbc.query[0].password-encoder.strength=10
cas.authn.jdbc.query[0].principal-attribute-list=email,firstname,lastname,cas_admin
cas.authn.attribute-repository.core.default-attributes-to-release=email,firstname,lastname,cas_admin
Thanks in advance,
Marc
--
- 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/52428882-6822-0ee0-2d33-825d03ade756%40clever-age.com.
