send cas startup log 2018-02-26 21:04 GMT-03:00 <[email protected]>:
> 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. > > On Feb 26, 2018, at 7:59 AM, Man H <[email protected]> wrote: > > Cas is not reading your properties. Check where they are fetched > > El lunes, 26 de febrero de 2018, William Jojo <[email protected]> > escribió: > >> 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 >> >> On Saturday, February 24, 2018 at 3:28:23 PM UTC-5, Manfredo Hopp wrote: >>> >>> Send the same with hibernate debug >>> >>> El sábado, 24 de febrero de 2018, William Jojo <[email protected]> >>> escribió: >>> >>>> 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 >>>> >>>> -- >>>> - 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/ap >>>> ereo.org/d/msgid/cas-user/6a6e6fab-f5c3-4c98-8a92-72079c0cc4 >>>> 12%40apereo.org >>>> <https://groups.google.com/a/apereo.org/d/msgid/cas-user/6a6e6fab-f5c3-4c98-8a92-72079c0cc412%40apereo.org?utm_medium=email&utm_source=footer> >>>> . >>>> >>> -- >> - 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/ap >> ereo.org/d/msgid/cas-user/32e639e7-28d9-436e-a744-416287d154 >> 89%40apereo.org >> <https://groups.google.com/a/apereo.org/d/msgid/cas-user/32e639e7-28d9-436e-a744-416287d15489%40apereo.org?utm_medium=email&utm_source=footer> >> . >> > -- > - 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/CAMY5mieayDoG-izYMLMp%3D1VGM8YZioM%3Dko_ > MOoGXgAz9XZmV-g%40mail.gmail.com > <https://groups.google.com/a/apereo.org/d/msgid/cas-user/CAMY5mieayDoG-izYMLMp%3D1VGM8YZioM%3Dko_MOoGXgAz9XZmV-g%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > > -- > - 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/C9ED0691-9EA4-49B8-85BD- > 063298179729%40gmail.com > <https://groups.google.com/a/apereo.org/d/msgid/cas-user/C9ED0691-9EA4-49B8-85BD-063298179729%40gmail.com?utm_medium=email&utm_source=footer> > . > -- - 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/CAMY5mic008WBgAKbZDPa3YZ7AG%2BAkNRG36tW6rK7bpYddzVVhw%40mail.gmail.com.
