Ok, I fixed the update problem - it was the MySQL dialect I chose. However, the presentation of multiple questions and accepting multiple answers seems like a bug to me.
Bill On Wednesday, August 30, 2017 at 9:33:45 AM UTC-4, William Jojo wrote: > > Good day to you all! > > As the subject says, I am having two issues with JDBC Password Management. > The first involves the questions. > > 2017-08-29 20:42:15,243 DEBUG > [org.apereo.cas.pm.jdbc.JdbcPasswordManagementService] - <Found [3] > security questions for [w.jojo]> > > All three questions are found in the DB and the form presents all of the > questions, accepts the answer through form submission, but says "Password > Reset Failed - We are unable to process your password reset request at this > time". *If I use only one question, however, it proceeds to the point of > entering the new password.* > > --- > > The second problem is the JDBC pw update says it completed: > > ============================================================= > > WHO: audit:unknown > > WHAT: true > > ACTION: CHANGE_PASSWORD_SUCCESS > > APPLICATION: CAS > > WHEN: Tue Aug 29 21:53:05 EDT 2017 > > CLIENT IP ADDRESS: 151.103.188.47 > > SERVER IP ADDRESS: 151.103.18.216 > > ============================================================= > > > > > > 2017-08-29 21:53:05,864 INFO > [org.apereo.inspektr.audit.support.Slf4jLoggingAuditTrailManager] - <Audit > trail record BEGIN > > ============================================================= > > WHO: audit:unknown > > WHAT: true > > ACTION: CHANGE_PASSWORD_SUCCESS > > APPLICATION: CAS > > WHEN: Tue Aug 29 21:53:05 EDT 2017 > > CLIENT IP ADDRESS: 151.103.188.47 > > SERVER IP ADDRESS: 151.103.18.216 > > ============================================================= > > But the record is not actually updated in the DB table. I have tried: > > update pm_table_accounts set password=? where user=? > > as well as > > insert into pm_table_accounts values (password=?, userid=?) > > Some cas.properties of relevance: > > # JDBC/MySQL > > cas.authn.pm.jdbc.sqlSecurityQuestions=SELECT question, answer FROM > pm_table_questions WHERE userid=? > > cas.authn.pm.jdbc.sqlFindEmail=SELECT email FROM pm_table_accounts WHERE > userid=? > > cas.authn.pm.jdbc.sqlChangePassword=update pm_table_accounts set > password=? where userid=? > > cas.authn.pm.jdbc.dialect=org.hibernate.dialect.MySQL5Dialect > > cas.authn.pm.jdbc.driverClass=com.mysql.jdbc.Driver > > cas.authn.pm.jdbc.passwordEncoder.type=NONE > > > I feel like the latter problem is something rather silly that I am > missing... > > Thank you! > > Bill > > -- - 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/6c444d34-53ff-4c95-a326-cdfefb41d2f1%40apereo.org.
