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