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 [email protected]. 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.
