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.

Reply via email to