CAS PM JDBC 5.1.5 double query

[William Jojo]

My question is very simple. Why on Earth are there two separate calls for validating PM questions? There is a query to get the question(s) followed by what seems like another query to get the answer(s). The format requires the query to be in the form of:

select question, answer from table name where user=?

Fine. But if you are trying to randomly select a question with say a view or procedure, the functionality is effective broken because you cannot guarantee the question/answer pair will match. See below:

2018-02-24 12:26:56,529 DEBUG [org.springframework.jdbc.datasource.DataSourceUtils] - <Fetching JDBC Connection from DataSource>

2018-02-24 12:26:56,546 TRACE [org.springframework.jdbc.core.StatementCreatorUtils] - <Setting SQL statement parameter value: column index 1, parameter value [THEUSER], value class [java.lang.String], SQL type unknown>

2018-02-24 12:26:56,562 DEBUG [org.springframework.jdbc.datasource.DataSourceUtils] - <Returning JDBC Connection to DataSource>

2018-02-24 12:26:56,563 DEBUG [org.apereo.cas.pm.jdbc.JdbcPasswordManagementService] - <Found [1] security questions for [THEUSER]>

2018-02-24 12:26:59,489 DEBUG [org.springframework.jdbc.core.JdbcTemplate] - <Executing prepared SQL query>

2018-02-24 12:26:59,490 DEBUG [org.springframework.jdbc.core.JdbcTemplate] - <Executing prepared SQL statement [SELECT question,answer from GENERAL.vTestQA where userid=?]>

2018-02-24 12:26:59,490 DEBUG [org.springframework.jdbc.datasource.DataSourceUtils] - <Fetching JDBC Connection from DataSource>

2018-02-24 12:26:59,506 TRACE [org.springframework.jdbc.core.StatementCreatorUtils] - <Setting SQL statement parameter value: column index 1, parameter value [THEUSER], value class [java.lang.String], SQL type unknown>

2018-02-24 12:26:59,523 DEBUG [org.springframework.jdbc.datasource.DataSourceUtils] - <Returning JDBC Connection to DataSource>

2018-02-24 12:26:59,523 DEBUG [org.apereo.cas.pm.jdbc.JdbcPasswordManagementService] - <Found [1] security questions for [THEUSER]>

There is also the concern that the database is not required to return the values in the same order every time.

Bill

[Man H]

Send the same with hibernate debug

--
- 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+unsubscribe@apereo.org.
To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/6a6e6fab-f5c3-4c98-8a92-72079c0cc412%40apereo.org.

[William Jojo]

Manfredo,

Hibernate is not posting to my logs. Turned on cas.jdbc.showSql and cas.jdbc.genDdl. Also added org.hibernate, org.hibernate.SQL and org.hibernate.type.descriptor.sql to the log4j2.xml for both debug and trace. Nothing.

This is built using Maven and our own Tomcat server.

Bill

To unsubscribe from this group and stop receiving emails from it, send an email to cas-user+u...@apereo.org.

[Man H]

Cas is not reading your properties. Check where they are fetched

To unsubscribe from this group and stop receiving emails from it, send an email to cas-user+unsubscribe@apereo.org.
To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/32e639e7-28d9-436e-a744-416287d15489%40apereo.org.

[joj...@gmail.com]

It has to be reading my properties or else I could never switch  between MySQL and Oracle which I do all day long. It has to be something else.

Bill

Sent from a device.

To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/CAMY5mieayDoG-izYMLMp%3D1VGM8YZioM%3Dko_MOoGXgAz9XZmV-g%40mail.gmail.com.

[Man H]

send cas startup log

To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/32e639e7-28d9-436e-a744-416287d15489%40apereo.org.

--
- 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+unsubscribe@apereo.org.

To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/CAMY5mieayDoG-izYMLMp%3D1VGM8YZioM%3Dko_MOoGXgAz9XZmV-g%40mail.gmail.com.

--
- 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+unsubscribe@apereo.org.

To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/C9ED0691-9EA4-49B8-85BD-063298179729%40gmail.com.

[William Jojo]

Log attached. Simply started and stopped the CAS service.

send cas startup log

To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/CAMY5mieayDoG-izYMLMp%3D1VGM8YZioM%3Dko_MOoGXgAz9XZmV-g%40mail.gmail.com.

--
- 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+u...@apereo.org.

To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/C9ED0691-9EA4-49B8-85BD-063298179729%40gmail.com.