Hi, No help but I think I've hit this too. Did you get anywhere? I'll start looking again Monday.
Cheers Sam On Friday, 22 October 2021 at 17:22:41 UTC+1 Marc Maurice wrote: > 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/f43d6b26-7d96-427a-af87-ec8ffe1cb597n%40apereo.org.
