Hi Marc, What dependency do you have? The "overlay war" generator thing seems to spit out 'implementation "org.apereo.cas:cas-server-support-jdbc-authentication"' which is what I was using but the documentation and what works for me is 'implementation "org.apereo.cas:cas-server-support-jdbc"'
I'd raise a bug but I don't think they want bug reports!? Cheers Sam On Friday, 5 November 2021 at 15:05:25 UTC Sam Hough wrote: > 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/a79e4717-d187-4fef-878a-8aa4eeded8b2n%40apereo.org.
