It worked !
Thanks for the tip Sam.
Le 12/11/2021 à 11:57, Marc MAURICE a écrit :
Hello Sam,
Thanks. I will try that later, but that must be it..
Before migration I had :
implementation
"org.apereo.cas:cas-server-support-jdbc:${project.'cas.version'}"
I replaced it with :
https://apereo.github.io/cas/6.4.x/installation/JDBC-Drivers.html#jdbc-drivers
implementation "org.apereo.cas:cas-server-support-jdbc-drivers"
I will try by using : cas-server-support-jdbc
Marc
Le 09/11/2021 à 10:43, Sam Hough a écrit :
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
<http://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/abac9164-e614-3d0b-a4c0-d5c13d470bc1%40clever-age.com.
