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/14caed25-8b57-4f6d-98dc-c0b7e20b234c%40apereo.org.
