Hello all,
Running CAS 6.1.3, OpenJDK 11.0.4, CAS Oracle driver (ojdbc10-19.3.0.0.jar)
on Ubuntu 18.04.
In 5.3.x we never needed to set a value for the
*cas.authn.pm.jdbc.sqlFindPhone*. In fact, we do not use it.
It seems in 6.1.3 there must be a query set. Otherwise you get the
following:
Error: Exception thrown executing
org.apereo.cas.pm.web.flow.actions.SendPasswordResetInstructionsAction@6b941a59
in state 'sendPasswordResetInstructions' of flow 'login' -- action execution
attributes were 'map[[empty]]'
Further down in the stack trace:
Caused by: java.lang.IllegalArgumentException: *SQL must not be null*
at org.springframework.util.Assert.notNull(Assert.java:198)
at
org.springframework.jdbc.core.JdbcTemplate$SimplePreparedStatementCreator.<init>(JdbcTemplate.java:1550)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:700)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:712)
at
org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:783)
at
org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:809)
at
*org.apereo.cas.pm.jdbc.JdbcPasswordManagementService.findPhone*(JdbcPasswordManagementService.java:72)
If I set the *cas.authn.pm.jdbc.sqlFindPhone* to be the same query as for
email, it is successful. It is annoying, but I can live with it for the
moment.
Just wanted others to know this seems be a bug.
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/5db93b04-6123-4efa-9025-01cc40f64891%40apereo.org.
