[cas-user] Re: 6.2 to 6.4 upgrade : no jdbc Handler
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]
-
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=xxx
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=x
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 cas-user+unsubscr...@apereo.org.
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.
[cas-user] Re: 6.2 to 6.4 upgrade : no jdbc Handler
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]
-
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=xxx
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=x
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 cas-user+unsubscr...@apereo.org.
To view this discussion on the web visit
https://groups.google.com/a/apereo.org/d/msgid/cas-user/485c4eae-f43e-b0be-e825-a0ed79971195%40clever-age.com.
[cas-user] 6.2 to 6.4 upgrade : no jdbc Handler
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] - [[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=xxx 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=x 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 cas-user+unsubscr...@apereo.org. 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.
Re: [EXTERNAL SENDER] [cas-user] Overlay template 6.4 build failed
Yes, as said in my last email. It was the gradle daemon.
Thanks a lot.
Le 20/10/2021 à 13:42, King, Robert a écrit :
Try “gradlew –stop” to make sure that the gradle build daemon does not
stay resident. Past that I think it might be a different issue then
what we ran into locally.
And just to confirm, we are running the same openjdk, just on RHEL.
cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.9 (Maipo)
rpm -qa | grep openjdk
java-11-openjdk-11.0.12.0.7-0.el7_9.x86_64
java-11-openjdk-devel-11.0.12.0.7-0.el7_9.x86_64
java-11-openjdk-headless-11.0.12.0.7-0.el7_9.x86_64
*From:*cas-user@apereo.org *On Behalf Of *Marc
MAURICE
*Sent:* Tuesday, October 19, 2021 11:52 AM
*To:* cas-user@apereo.org
*Subject:* Re: [EXTERNAL SENDER] [cas-user] Overlay template 6.4 build
failed
Hello,
Thanks a lot Robert.
I was missing the package. Unfortunately the error is still there.
(also tried with an overlay from initializer : same error)
[root@15871ceb6a09 initializer]# cat /etc/redhat-release
CentOS Linux release 7.5.1804 (Core)
[root@15871ceb6a09 initializer]# rpm -qa| grep openjdk
java-11-openjdk-11.0.12.0.7-0.el7_9.x86_64
java-11-openjdk-headless-11.0.12.0.7-0.el7_9.x86_64
java-11-openjdk-devel-11.0.12.0.7-0.el7_9.x86_64
Le 19/10/2021 à 15:59, King, Robert a écrit :
You need the openjdk development packages.
For instance on RHEL7:
> yum install java-11-openjdk-devel
*From:*cas-user@apereo.org <mailto:cas-user@apereo.org>
<mailto:cas-user@apereo.org> *On Behalf Of
*Marc Maurice
*Sent:* Tuesday, October 19, 2021 11:25 AM
*To:* CAS Community <mailto:cas-user@apereo.org>
*Subject:* [EXTERNAL SENDER] [cas-user] Overlay template 6.4 build
failed
Hello,
I'm trying to upgrade from cas 6.2 to 6.4.
As explained in the doc I want to start with a clean 6.4 overlay
then reapply all my patches.
I cloned a fresh 6.4 overlay branch from the github project.
Openjdk 11 installed:
[root@15871ceb6a09 myclone]# java -version
openjdk version "11.0.12" 2021-07-20 LTS
OpenJDK Runtime Environment 18.9 (build 11.0.12+7-LTS)
OpenJDK 64-Bit Server VM 18.9 (build 11.0.12+7-LTS, mixed mode,
sharing)
I'm getting the following error. Tried to run gradle in debug
mode, and googling the error with no success.
gradle is not giving me any clue why it doesn't like my java
version...
[root@15871ceb6a09 myclone]# ./gradlew clean build
> Task :compileJava FAILED
FAILURE: Build failed with an exception.
* What went wrong:
Execution failed for task ':compileJava'.
> error: release version 11 not supported
* Try:
Run with --stacktrace option to get the stack trace. Run with
--info or --debug option to get more log output. Run with --scan
to get full insights.
* Get more help at https://help.gradle.org <https://help.gradle.org>
Deprecated Gradle features were used in this build, making it
incompatible with Gradle 8.0.
You can use '--warning-mode all' to show the individual
deprecation warnings and determine if they come from your own
scripts or plugins.
See
https://docs.gradle.org/7.2/userguide/command_line_interface.html#sec:command_line_warnings
<https://docs.gradle.org/7.2/userguide/command_line_interface.html#sec:command_line_warnings>
BUILD FAILED in 4s
6 actionable tasks: 6 executed
--
- Website: https://apereo.github.io/cas <https://apereo.github.io/cas>
- Gitter Chatroom: https://gitter.im/apereo/cas
<https://gitter.im/apereo/cas>
- List Guidelines: https://goo.gl/1VRrw7 <https://goo.gl/1VRrw7>
- Contributions: https://goo.gl/mh7qDG <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 cas-user+unsubscr...@apereo.org
<mailto:cas-user+unsubscr...@apereo.org>.
To view this discussion on the web visit
https://groups.google.com/a/apereo.org/d/msgid/cas-user/ac396421-ebbb-4f9f-b9c8-58b141c110f0n%40apereo.org
<https://groups.google.com/a/apereo.org/d/msgid/cas-user/ac396421-ebbb-4f9f-b9c8-58b141c110f0n%40apereo.org?utm_medium=email&utm_source=footer>.
--
- Website: https://apereo.github.io/cas <https://apereo.github.io/cas>
- Gitter Chatroom: https://gitter.im/apereo/cas
<https://gitter.im/apereo/cas>
- List Guidelines: https://goo.gl/1VRrw7 <https://goo.gl/1VRrw7>
- Contributions: https://goo.gl/mh7qDG <https://goo.gl/mh7qDG>
---
You received this message because you are subscribed to a topic in
the Google Groups "CAS Community" group.
To unsubscribe from this topic, visit
Re: [EXTERNAL SENDER] [cas-user] Overlay template 6.4 build failed
Thanks. Tried to clone again this morning and it was magically working !!!
Why ? It took some time to figure it out.
It was working on my local PC (freshly booted) but not on the
preproduction (not rebooted).
*The Gradle Daemon !!*
After installing the java-11-openjdk-devel it did nothing unless I
restarted the Daemon.
pkill -f GradleDaemon
Anyway. Thanks guys.
Le 20/10/2021 à 05:23, He Vincent a écrit :
I think any JDK11 is OK. Did you re-download cas 6.4 from GITHUB?
Marc Maurice在 2021年10月19日星期二下午10:21:57 [UTC+8]寫道：
Hello,
Thanks a lot Robert.
I was missing the package. Unfortunately the error is still there.
(also tried with an overlay from initializer : same error)
[root@15871ceb6a09 initializer]# cat /etc/redhat-release
CentOS Linux release 7.5.1804 (Core)
[root@15871ceb6a09 initializer]# rpm -qa| grep openjdk
java-11-openjdk-11.0.12.0.7-0.el7_9.x86_64
java-11-openjdk-headless-11.0.12.0.7-0.el7_9.x86_64
java-11-openjdk-devel-11.0.12.0.7-0.el7_9.x86_64
Le 19/10/2021 à 15:59, King, Robert a écrit :
You need the openjdk development packages.
For instance on RHEL7:
> yum install java-11-openjdk-devel
*From:*cas-...@apereo.org *On Behalf Of
*Marc Maurice
*Sent:* Tuesday, October 19, 2021 11:25 AM
*To:* CAS Community
*Subject:* [EXTERNAL SENDER] [cas-user] Overlay template 6.4
build failed
Hello,
I'm trying to upgrade from cas 6.2 to 6.4.
As explained in the doc I want to start with a clean 6.4 overlay
then reapply all my patches.
I cloned a fresh 6.4 overlay branch from the github project.
Openjdk 11 installed:
[root@15871ceb6a09 myclone]# java -version
openjdk version "11.0.12" 2021-07-20 LTS
OpenJDK Runtime Environment 18.9 (build 11.0.12+7-LTS)
OpenJDK 64-Bit Server VM 18.9 (build 11.0.12+7-LTS, mixed mode,
sharing)
I'm getting the following error. Tried to run gradle in debug
mode, and googling the error with no success.
gradle is not giving me any clue why it doesn't like my java
version...
[root@15871ceb6a09 myclone]# ./gradlew clean build
> Task :compileJava FAILED
FAILURE: Build failed with an exception.
* What went wrong:
Execution failed for task ':compileJava'.
> error: release version 11 not supported
* Try:
Run with --stacktrace option to get the stack trace. Run with
--info or --debug option to get more log output. Run with --scan
to get full insights.
* Get more help at https://help.gradle.org <https://help.gradle.org>
Deprecated Gradle features were used in this build, making it
incompatible with Gradle 8.0.
You can use '--warning-mode all' to show the individual
deprecation warnings and determine if they come from your own
scripts or plugins.
See
https://docs.gradle.org/7.2/userguide/command_line_interface.html#sec:command_line_warnings
<https://docs.gradle.org/7.2/userguide/command_line_interface.html#sec:command_line_warnings>
BUILD FAILED in 4s
6 actionable tasks: 6 executed
--
- Website: https://apereo.github.io/cas
<https://apereo.github.io/cas>
- Gitter Chatroom: https://gitter.im/apereo/cas
<https://gitter.im/apereo/cas>
- List Guidelines: https://goo.gl/1VRrw7 <https://goo.gl/1VRrw7>
- Contributions: https://goo.gl/mh7qDG <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 cas-user+u...@apereo.org.
To view this discussion on the web visit
https://groups.google.com/a/apereo.org/d/msgid/cas-user/ac396421-ebbb-4f9f-b9c8-58b141c110f0n%40apereo.org
<https://groups.google.com/a/apereo.org/d/msgid/cas-user/ac396421-ebbb-4f9f-b9c8-58b141c110f0n%40apereo.org?utm_medium=email&utm_source=footer>.
--
- Website: https://apereo.github.io/cas
<https://apereo.github.io/cas>
- Gitter Chatroom: https://gitter.im/apereo/cas
<https://gitter.im/apereo/cas>
- List Guidelines: https://goo.gl/1VRrw7 <https://goo.gl/1VRrw7>
- Contributions: https://goo.gl/mh7qDG <https://goo.gl/mh7qDG>
---
You received this message because you are subscribed to a topic
in the Google Groups "CAS Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/a/apereo.org/d/topic/cas-user/HOiMGSumH5c/unsubscribe
<https://groups.google.com/a/apereo.org/d/topic/cas-user/HOiMGSumH5c/unsubscribe>.
To unsubscribe from this group and all its topics, send an email
to cas-user+u...@apereo.org.
To view this discussion on the web visit
https://groups.google.com/a/apereo.org/d/msgid/cas-user/2330c6
Re: [EXTERNAL SENDER] [cas-user] Overlay template 6.4 build failed
Hello, Thanks a lot Robert. I was missing the package. Unfortunately the error is still there. (also tried with an overlay from initializer : same error) [root@15871ceb6a09 initializer]# cat /etc/redhat-release CentOS Linux release 7.5.1804 (Core) [root@15871ceb6a09 initializer]# rpm -qa| grep openjdk java-11-openjdk-11.0.12.0.7-0.el7_9.x86_64 java-11-openjdk-headless-11.0.12.0.7-0.el7_9.x86_64 java-11-openjdk-devel-11.0.12.0.7-0.el7_9.x86_64 Le 19/10/2021 à 15:59, King, Robert a écrit : You need the openjdk development packages. For instance on RHEL7: > yum install java-11-openjdk-devel *From:*cas-user@apereo.org *On Behalf Of *Marc Maurice *Sent:* Tuesday, October 19, 2021 11:25 AM *To:* CAS Community *Subject:* [EXTERNAL SENDER] [cas-user] Overlay template 6.4 build failed Hello, I'm trying to upgrade from cas 6.2 to 6.4. As explained in the doc I want to start with a clean 6.4 overlay then reapply all my patches. I cloned a fresh 6.4 overlay branch from the github project. Openjdk 11 installed: [root@15871ceb6a09 myclone]# java -version openjdk version "11.0.12" 2021-07-20 LTS OpenJDK Runtime Environment 18.9 (build 11.0.12+7-LTS) OpenJDK 64-Bit Server VM 18.9 (build 11.0.12+7-LTS, mixed mode, sharing) I'm getting the following error. Tried to run gradle in debug mode, and googling the error with no success. gradle is not giving me any clue why it doesn't like my java version... [root@15871ceb6a09 myclone]# ./gradlew clean build > Task :compileJava FAILED FAILURE: Build failed with an exception. * What went wrong: Execution failed for task ':compileJava'. > error: release version 11 not supported * Try: Run with --stacktrace option to get the stack trace. Run with --info or --debug option to get more log output. Run with --scan to get full insights. * Get more help at https://help.gradle.org <https://help.gradle.org> Deprecated Gradle features were used in this build, making it incompatible with Gradle 8.0. You can use '--warning-mode all' to show the individual deprecation warnings and determine if they come from your own scripts or plugins. See https://docs.gradle.org/7.2/userguide/command_line_interface.html#sec:command_line_warnings <https://docs.gradle.org/7.2/userguide/command_line_interface.html#sec:command_line_warnings> BUILD FAILED in 4s 6 actionable tasks: 6 executed -- - Website: https://apereo.github.io/cas <https://apereo.github.io/cas> - Gitter Chatroom: https://gitter.im/apereo/cas <https://gitter.im/apereo/cas> - List Guidelines: https://goo.gl/1VRrw7 <https://goo.gl/1VRrw7> - Contributions: https://goo.gl/mh7qDG <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 cas-user+unsubscr...@apereo.org <mailto:cas-user+unsubscr...@apereo.org>. To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/ac396421-ebbb-4f9f-b9c8-58b141c110f0n%40apereo.org <https://groups.google.com/a/apereo.org/d/msgid/cas-user/ac396421-ebbb-4f9f-b9c8-58b141c110f0n%40apereo.org?utm_medium=email&utm_source=footer>. -- - Website: https://apereo.github.io/cas <https://apereo.github.io/cas> - Gitter Chatroom: https://gitter.im/apereo/cas <https://gitter.im/apereo/cas> - List Guidelines: https://goo.gl/1VRrw7 <https://goo.gl/1VRrw7> - Contributions: https://goo.gl/mh7qDG <https://goo.gl/mh7qDG> --- You received this message because you are subscribed to a topic in the Google Groups "CAS Community" group. To unsubscribe from this topic, visit https://groups.google.com/a/apereo.org/d/topic/cas-user/HOiMGSumH5c/unsubscribe <https://groups.google.com/a/apereo.org/d/topic/cas-user/HOiMGSumH5c/unsubscribe>. To unsubscribe from this group and all its topics, send an email to cas-user+unsubscr...@apereo.org <mailto:cas-user+unsubscr...@apereo.org>. To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/2330c621312a41cb9bc2ecd304c7e815%40mun.ca <https://groups.google.com/a/apereo.org/d/msgid/cas-user/2330c621312a41cb9bc2ecd304c7e815%40mun.ca?utm_medium=email&utm_source=footer>. -- - 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 cas-user+unsubscr...@apereo.org. To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/9eb7a122-63de-cda1-5fcf-2f25021879d3%40clever-age.com.
[cas-user] Overlay template 6.4 build failed
Hello, I'm trying to upgrade from cas 6.2 to 6.4. As explained in the doc I want to start with a clean 6.4 overlay then reapply all my patches. I cloned a fresh 6.4 overlay branch from the github project. Openjdk 11 installed: [root@15871ceb6a09 myclone]# java -version openjdk version "11.0.12" 2021-07-20 LTS OpenJDK Runtime Environment 18.9 (build 11.0.12+7-LTS) OpenJDK 64-Bit Server VM 18.9 (build 11.0.12+7-LTS, mixed mode, sharing) I'm getting the following error. Tried to run gradle in debug mode, and googling the error with no success. gradle is not giving me any clue why it doesn't like my java version... [root@15871ceb6a09 myclone]# ./gradlew clean build > Task :compileJava FAILED FAILURE: Build failed with an exception. * What went wrong: Execution failed for task ':compileJava'. > error: release version 11 not supported * Try: Run with --stacktrace option to get the stack trace. Run with --info or --debug option to get more log output. Run with --scan to get full insights. * Get more help at https://help.gradle.org Deprecated Gradle features were used in this build, making it incompatible with Gradle 8.0. You can use '--warning-mode all' to show the individual deprecation warnings and determine if they come from your own scripts or plugins. See https://docs.gradle.org/7.2/userguide/command_line_interface.html#sec:command_line_warnings BUILD FAILED in 4s 6 actionable tasks: 6 executed -- - 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 cas-user+unsubscr...@apereo.org. To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/ac396421-ebbb-4f9f-b9c8-58b141c110f0n%40apereo.org.
[cas-user] Re: Update a date database field on successful login
Thanks mike.
This may not be the cleanest solution, but it works and will be easy to
maintain accross CAS upgrades.
I just configured jdbc audit, and a trigger to update my users table.
delimiter //
CREATE TRIGGER COM_AUDIT_TRAIL_on_insert_update_users_datelastlogin
AFTER INSERT ON COM_AUDIT_TRAIL FOR EACH ROW
BEGIN
IF NEW.AUD_ACTION = 'AUTHENTICATION_SUCCESS' THEN
UPDATE users
SET date_lastloginsuccess = NEW.AUD_DATE
WHERE email = NEW.AUD_USER;
END IF;
END;//
In cas.properties :
cas.audit.enabled=true
cas.audit.number-of-days-in-history=30
#cas.audit.jdbc.max-age-days=30
cas.audit.jdbc.url=${cas.authn.jdbc.query[0].url}
cas.audit.jdbc.dialect=${cas.authn.jdbc.query[0].dialect}
cas.audit.jdbc.user=${cas.authn.jdbc.query[0].user}
cas.audit.jdbc.password=${cas.authn.jdbc.query[0].password}
cas.audit.jdbc.driver-class=${cas.authn.jdbc.query[0].driver-class}
I wonder what is the purpose of max-age-days. Is it the same as
nomber-of-days-in-history.
There is also a column-length=100 default property.
Anyone knowing whate those properties do ? If not I will review the
source code.
documentation link here
<https://apereo.github.io/cas/6.2.x/configuration/Configuration-Properties.html#database-audits>
Thanks in advance,
Marc
Le 23/09/2020 à 15:06, mbar...@scad.edu a écrit :
Marc,
I'd suggest taking a look at JDBC Audits -
https://apereo.github.io/cas/6.2.x/installation/Audits.html#database-audits
I won't do exactly what you want, but you'll be able to get a last
login date from the table it creates.
Good luck!
-Mike
On Wednesday, September 23, 2020 at 4:06:10 AM UTC-4 Marc Maurice wrote:
Hello,
I'm using jdbc/mysql to authenticate my users.
I have a simple need : I want to add a last_login_date field,
updated at
each successful login
I want to be able to know if some accounts have not been used from a
very long time.
I red carefully the doc and reviewed the list of properties, but I
see
nothing about that.
Do I need to write some custom code ? Do you know what code or
class I
should extend ?
note: just updated my overlay to 6.2 successfully.
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 cas-user+unsubscr...@apereo.org.
To view this discussion on the web visit
https://groups.google.com/a/apereo.org/d/msgid/cas-user/df59036b-06fb-f6ff-3282-450ad738e877%40clever-age.com.
[cas-user] Audit jdbc mysql : syntax error at COM_AUDIT_TRAIL creation
Hello all, I found what may be a bug (in a library). After configuring jdbc audit and starting cas for the first time, I got the following error (see full exception below). Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'type=MyISAM' at line 11 engine=MyISAM should be used instead. The workaround is easy : just run the SQL manually, replacing type= with engine= . Let me know if you have any advice on how to report that. It's not very clear to me how to report issues on CAS. Anyway, the workaround will be in mailing list archive. Marc 2020-09-25 15:22:17,380 WARN [org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl] - executing DDL " create table COM_AUDIT_TRAIL ( id bigint not null auto_increment, AUD_ACTION longtext, APPLIC_CD varchar(255), AUD_CLIENT_IP varchar(255), AUD_DATE datetime not null, AUD_RESOURCE longtext, AUD_SERVER_IP varchar(255), AUD_USER longtext, primary key (id) ) type=MyISAM" via JDBC Statement> org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL " create table COM_AUDIT_TRAIL ( id bigint not null auto_increment, AUD_ACTION longtext, APPLIC_CD varchar(255), AUD_CLIENT_IP varchar(255), AUD_DATE datetime not null, AUD_RESOURCE longtext, AUD_SERVER_IP varchar(255), AUD_USER longtext, primary key (id) ) type=MyISAM" via JDBC Statement at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67) ~[hibernate-core-5.4.16.Final.jar!/:5.4.16.Final] at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559) ~[hibernate-core-5.4.16.Final.jar!/:5.4.16.Final] at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504) ~[hibernate-core-5.4.16.Final.jar!/:5.4.16.Final] at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.createTable(AbstractSchemaMigrator.java:277) ~[hibernate-core-5.4.16.Final.jar!/:5.4.16.Final] at org.hibernate.tool.schema.internal.GroupedSchemaMigratorImpl.performTablesMigration(GroupedSchemaMigratorImpl.java:71) ~[hibernate-core-5.4.16.Final.jar!/:5.4.16.Final] at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:207) ~[hibernate-core-5.4.16.Final.jar!/:5.4.16.Final] at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114) ~[hibernate-core-5.4.16.Final.jar!/:5.4.16.Final] at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:184) ~[hibernate-core-5.4.16.Final.jar!/:5.4.16.Final] at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:73) ~[hibernate-core-5.4.16.Final.jar!/:5.4.16.Final] at org.hibernate.internal.SessionFactoryImpl.(SessionFactoryImpl.java:316) ~[hibernate-core-5.4.16.Final.jar!/:5.4.16.Final] at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:469) ~[hibernate-core-5.4.16.Final.jar!/:5.4.16.Final] at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1249) ~[hibernate-core-5.4.16.Final.jar!/:5.4.16.Final] at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:58) ~[spring-orm-5.2.6.RELEASE.jar!/:5.2.6.RELEASE] at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365) ~[spring-orm-5.2.6.RELEASE.jar!/:5.2.6.RELEASE] at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:391) ~[spring-orm-5.2.6.RELEASE.jar!/:5.2.6.RELEASE] at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:378) ~[spring-orm-5.2.6.RELEASE.jar!/:5.2.6.RELEASE] at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:341) ~[spring-orm-5.2.6.RELEASE.jar!/:5.2.6.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1855) ~[spring-beans-5.2.6.RELEASE.jar!/:5.2.6.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBean
Re: [cas-user] Unauthorized Service Access. Service [] is not found in service registry
You need that in build.gradle :
implementation
"org.apereo.cas:cas-server-support-json-service-registry:${casServerVersion}"
And that in cas.properties :
cas.service-registry.json.location=file:///etc/cas/services
Can you check?
--
- 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 cas-user+unsubscr...@apereo.org.
To view this discussion on the web visit
https://groups.google.com/a/apereo.org/d/msgid/cas-user/dd4ad469-8ca8-6cbc-f982-1bff0b5b3d25%40clever-age.com.
[cas-user] Update a date database field on successful login
Hello, I'm using jdbc/mysql to authenticate my users. I have a simple need : I want to add a last_login_date field, updated at each successful login I want to be able to know if some accounts have not been used from a very long time. I red carefully the doc and reviewed the list of properties, but I see nothing about that. Do I need to write some custom code ? Do you know what code or class I should extend ? note: just updated my overlay to 6.2 successfully. 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 cas-user+unsubscr...@apereo.org. To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/bfac33ad-186d-6250-8378-9330facb9388%40clever-age.com.
[cas-user] Send reset password email in html instead of plain text
Hello all, We need to send the reset password email in html instead of plain text (marketing demands). Looking at the source code it seems simple. It's just a matter of adding a "true" parameter to tell spring that the email is in html : https://github.com/apereo/cas/blob/5.2.x/core/cas-server-core-util/src/main/java/org/apereo/cas/util/io/CommunicationsManager.java#L102 https://docs.spring.io/spring/docs/3.0.0.M3/reference/html/ch26s03.html Do you know any simple way to patch the cas server core using the overlay way ? Or do we have to compile the entire stack ? We really would like to keep the overlay system, in order to ease future updates. 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 cas-user+unsubscr...@apereo.org. To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/02164d28-5769-4cde-9ac2-6e0f2bb18a00%40apereo.org.
[cas-user] Re: cas-overlay-template with cas 5.2.3 and default cas.properties
when running the cas server, do you have a message indicating that the server is ready ? What is the output of 'netstat -tlnp' after running the server ? Le mercredi 14 mars 2018 23:55:33 UTC+1, Jono Jono a écrit : > > I am following the instructions to bring this up here: > https://github.com/apereo/cas-overlay-template > > With the default setup if I run build.sh it does not come up and there are > no error messages. > > When visiting 8443, nothing is running there. > > Now if I delete the cas.properties file, it does come up at > https://localhost:8443, but not http://localhost:8080 as the > cas-overlay-template says. > > If I change the pom to use cas 5.2.2 I am able to bring up the service > while cas.propertes exists however. > > To be clear there are 2 issues: > 1. readme shows the use of localhost:8080, but the default setup does not > bring that up > 2. cas 5.2.3 does not work with cas.properties file in template > -- - 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 cas-user+unsubscr...@apereo.org. To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/71ca3d41-6ffb-413c-bf65-5ebe98f92a14%40apereo.org.
[cas-user] Re: Password Manager : exception on reset password
Solved after restarting the CAS server. -- - 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 cas-user+unsubscr...@apereo.org. To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/eb01b330-ab4e-4ee1-a19c-850aa39b2984%40apereo.org.
[cas-user] Password Manager : exception on reset password
Hello all, I'm using CAS v5.2.1. I'm currently trying to use the Password Manager to reset the password. Here is the Exception I get when clicking on the password reset link on the login page : org.springframework.webflow.engine.NoMatchingTransitionException: No transition found on occurence of event 'resetPassword' in state 'viewLoginForm' of flow 'login' -- valid transitional criteria are array< TransitionCriteria>[submit] -- likely programmer error, check the set of TransitionCriteria for this state at org.springframework.webflow.engine.TransitionableState. getRequiredTransition(TransitionableState.java:90) at org.springframework.webflow.engine.TransitionableState.handleEvent( TransitionableState.java:116) at org.springframework.webflow.engine.Flow.handleEvent(Flow.java:547) at org.springframework.webflow.engine.impl.FlowExecutionImpl.handleEvent (FlowExecutionImpl.java:390) at org.springframework.webflow.engine.impl.RequestControlContextImpl. handleEvent(RequestControlContextImpl.java:210) at org.springframework.webflow.engine.ViewState.handleEvent(ViewState. java:231) at org.springframework.webflow.engine.ViewState.resume(ViewState.java: 195) at org.springframework.webflow.engine.Flow.resume(Flow.java:537) at org.springframework.webflow.engine.impl.FlowExecutionImpl.resume( FlowExecutionImpl.java:259) at org.springframework.webflow.executor.FlowExecutorImpl.resumeExecution (FlowExecutorImpl.java:169) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke( DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.aop.support.AopUtils. invokeJoinpointUsingReflection(AopUtils.java:333) at org.springframework.aop.framework.ReflectiveMethodInvocation. invokeJoinpoint(ReflectiveMethodInvocation.java:190) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed( ReflectiveMethodInvocation.java:157) at org.springframework.aop.support.DelegatingIntroductionInterceptor. doProceed(DelegatingIntroductionInterceptor.java:133) at org.springframework.aop.support.DelegatingIntroductionInterceptor. invoke(DelegatingIntroductionInterceptor.java:121) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed( ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke( JdkDynamicAopProxy.java:213) at com.sun.proxy.$Proxy142.resumeExecution(Unknown Source) at org.springframework.webflow.mvc.servlet.FlowHandlerAdapter.handle( FlowHandlerAdapter.java:253) at org.springframework.web.servlet.DispatcherServlet.doDispatch( DispatcherServlet.java:967) at org.springframework.web.servlet.DispatcherServlet.doService( DispatcherServlet.java:901) at org.springframework.web.servlet.FrameworkServlet.processRequest( FrameworkServlet.java:970) at org.springframework.web.servlet.FrameworkServlet.doPost( FrameworkServlet.java:872) at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) at org.springframework.web.servlet.FrameworkServlet.service( FrameworkServlet.java:846) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter( ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52 ) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter( ApplicationFilterChain.java:166) at org.apereo.cas.web.support. AuthenticationCredentialsLocalBinderClearingFilter.doFilter( AuthenticationCredentialsLocalBinderClearingFilter.java:28) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter( ApplicationFilterChain.java:166) at org.apereo.cas.security.RequestParameterPolicyEnforcementFilter. doFilter(RequestParameterPolicyEnforcementFilter.java:261) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter( ApplicationFilterChain.java:166) at org.apereo.cas.security.ResponseHeadersEnforcementFilter.doFilter( ResponseHeadersEnforcementFilter.java:245) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter( ApplicationFilterChain.java:166) at org.springframework.boot.actuate.trace.WebRequestTraceFilter. doFilterInternal(WebRequestTraceFilter.java:110) at org.springframe
