Dear Lars, Glad it at least work. That autocommit = true setting is a very old setting in my server, it does run on prod no issue.
Thanks for mentioning the potential issue with autocommit, I will also look into it and see if I can figure out another way to fix this issue without resulting to changing authcommit. In the meantime, I am keeping my setting as it does work for a very long time and I think is safe to keep it as is for a while still. If you find any solution later on, please share them to this discussion :) I am also very interested on any more elegant solution! Cheers! - Andy On Wednesday, 3 March 2021 at 15:36:54 UTC+8 Lars Feistner wrote: > Dear Andy, > > thank you very much that did the trick. But to be honest running a > production server with autocommit = true is not really something you want > to have. > > So it looks like there is a bug with the transaction management in 5.3.x? > Or is there another jdbc parameter that I have to tweak to make it work > with autocommit = false? > > Best regards, > Lars > > On 01.03.21 05:39, Andy Ng wrote: > > Dear Lars, > > I have not encountered your issue, but I encountered a similar issue > before (Not able to insert row to JDBC in another component) > > I found that setting *autocommit *to *true *seems to fix my issue, not > sure about the root cause since JDBC is not my strong suit. > > https://apereo.github.io/cas/6.3.x/configuration/Configuration-Properties-Common.html#database-settings > > Might not fix you issue, but you can try see if it helps. > > Cheers. > - Andy > > On Thursday, 25 February 2021 at 22:06:15 UTC+8 Lars Feistner wrote: > >> Dear all, >> >> I am experirncing something weird. I set up Password Management, >> pm-webflow and pm-jdbc. I turned off security questions. >> >> Everything works as expected. I can reset my password, get the email, >> setting my new password after clicking the link in the email. But after a >> successful message that I changed my password the value in the column in >> the database is still the old one. >> >> I debugged the code, the update count was 1. I turned on debug logging >> for spring. The log files says 'SQL update affected 1 rows'. >> >> I attached the log. >> >> It seems as if some kind of transaction is not commited or rolled back >> but nothing appears in the log file. Can anyone think of anything that I >> missed? >> >> I am using cas version 5.3.16. >> >> 2021-02-25 14:59:19,007 DEBUG >> [org.springframework.beans.factory.support.DefaultListableBeanFactory] - >> <Returning cached instance of singleton bean 'passwordChangeAction'> >> 2021-02-25 14:59:19,007 DEBUG >> [org.apereo.cas.pm.web.flow.actions.PasswordChangeAction] - <Retrieved the >> current credential from webflow [UsernamePasswordCredential(username=ucan)]> >> 2021-02-25 14:59:19,007 DEBUG >> [org.apereo.cas.pm.web.flow.actions.PasswordChangeAction] - <Attempting to >> validate the provided password> >> 2021-02-25 14:59:19,008 DEBUG >> [org.apereo.cas.pm.web.flow.actions.PasswordChangeAction] - <Attempting to >> update the password> >> 2021-02-25 14:59:19,008 DEBUG >> [org.apereo.cas.authentication.support.password.PasswordEncoderUtils] - >> <Creating BCRYPT password encoder given the strength [14] and secret in the >> configuration> >> 2021-02-25 14:59:19,008 DEBUG >> [org.apereo.cas.authentication.support.password.PasswordEncoderUtils] - >> <Creating BCRYPT encoder without secret> >> 2021-02-25 14:59:19,560 DEBUG >> [org.springframework.core.env.PropertySourcesPropertyResolver] - <Could not >> find key 'config.client.state' in any property source> >> 2021-02-25 14:59:19,931 DEBUG >> [org.springframework.jdbc.core.JdbcTemplate] - <Executing prepared SQL >> update> >> 2021-02-25 14:59:19,932 DEBUG >> [org.springframework.jdbc.core.JdbcTemplate] - <Executing prepared SQL >> statement [UPDATE cus_auth_method SET password=? WHERE account_id=(SELECT >> id from cus_account where login = ?)]> >> 2021-02-25 14:59:19,932 DEBUG >> [org.springframework.jdbc.datasource.DataSourceUtils] - <Fetching JDBC >> Connection from DataSource> >> 2021-02-25 14:59:19,934 DEBUG >> [org.springframework.jdbc.core.JdbcTemplate] - <SQL update affected 1 rows> >> 2021-02-25 14:59:19,935 INFO >> [org.apereo.inspektr.audit.support.Slf4jLoggingAuditTrailManager] - <Audit >> trail record BEGIN >> ============================================================= >> WHO: audit:unknown >> WHAT: UsernamePasswordCredential(username=ucan) >> ACTION: CHANGE_PASSWORD_SUCCESS >> APPLICATION: CAS >> WHEN: Thu Feb 25 14:59:19 CET 2021 >> CLIENT IP ADDRESS: 192.168.1.125 >> SERVER IP ADDRESS: 192.168.1.199 >> ============================================================= >> >> Best regards, >> Lars >> -- >> *Lars Feistner* >> Entwicklungsleitung >> Phone: +49 6221/186749-5 >> Mail: l.fei...@cares.institute >> *Institut für Kommunikations- und Prüfungsforschung gGmbH* >> Institute for Communication and Assessment Research >> Wieblinger Weg 92a >> 69123 Heidelberg, Germany >> Web: www.ucan-assess.org >> > -- > - 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+u...@apereo.org. > To view this discussion on the web visit > https://groups.google.com/a/apereo.org/d/msgid/cas-user/dd8f1038-b331-412b-a57f-df3f3c7fff9fn%40apereo.org > > <https://groups.google.com/a/apereo.org/d/msgid/cas-user/dd8f1038-b331-412b-a57f-df3f3c7fff9fn%40apereo.org?utm_medium=email&utm_source=footer> > . > > > -- > *Lars Feistner* > Entwicklungsleitung > Phone: +49 6221/186749-5 > Mail: l.fei...@cares.institute > *Institut für Kommunikations- und Prüfungsforschung gGmbH* > Institute for Communication and Assessment Research > Wieblinger Weg 92a > 69123 Heidelberg, Germany > Web: www.ucan-assess.org > -- - 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/08ea8d4b-5b6e-426f-81be-33cb91f258adn%40apereo.org.
