Typo: cas.audit.jdbc.ddlAuto=create-drop 2018-02-02 12:23 GMT-03:00 Man H <[email protected]>:
> Just create table > > run with > cas.jdbc.showSql=true > cas.jdbc.genDdl=true > > cas.audit.jdbc.ddlAuto=create-none > > See you output, if it isnt beeing created you could use log output to > crete it. > > 2018-02-01 23:25 GMT-03:00 matrix development <[email protected]> > : > >> Try creating the table and change the ddlAuto to update >> *cas.authn.throttle.jdbc.**ddlAuto=update* >> >> _Fazla >> >> >> On Sat, Jan 27, 2018 at 12:33 AM, 'Mallory, Erik' via CAS Community < >> [email protected]> wrote: >> >>> Inspektr or jdbc does not seem to be working properly. The database >>> tables are not getting created on start, so there is nothing for Inspektr >>> to write to. >>> >>> The error: >>> >>> PreparedStatementCallback; bad SQL grammar [SELECT AUD_DATE FROM >>> COM_AUDIT_TRAIL WHERE AUD_CLIENT_IP = ? AND AUD_USER = ? AND AUD_ACTION = ? >>> AND APPLIC_CD = ? AND AUD_DATE >= ? ORDER BY AUD_DATE DESC]; nested >>> exception is java.sql.SQLSyntaxErrorException: Table >>> 'casdb.COM_AUDIT_TRAIL' doesn't exist]> >>> >>> org.springframework.jdbc.BadSqlGrammarException: >>> PreparedStatementCallback; bad SQL grammar [SELECT AUD_DATE FROM >>> COM_AUDIT_TRAIL WHERE AUD_CLIENT_IP = ? AND AUD_USER = ? AND AUD_ACTION = ? >>> AND APPLIC_CD = ? AND AUD_DATE >= ? ORDER BY AUD_DATE DESC]; nested >>> exception is java.sql.SQLSyntaxErrorException: Table >>> 'casdb.COM_AUDIT_TRAIL' doesn't exist >>> >>> >>> >>> Relevant configuration information. >>> >>> >>> >>> cas.authn.throttle.jdbc.ddlAuto=create-drop >>> >>> cas.authn.throttle.jdbc.driverClass=com.mysql.jdbc.Driver >>> >>> cas.authn.throttle.jdbc.dialect=org.hibernate.dialect.MySQL5Dialect >>> >>> >>> >>> I am able to create a table as the cas user in the database. >>> >>> >>> >>> Any help would be appreciated. >>> >>> Thanks, >>> >>> Erik Mallory >>> >>> Server Analyst >>> >>> Wichita State University >>> >>> 316.978.3502 <(316)%20978-3502> >>> >>> >>> >>> -- >>> - 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/AFDFBB13-AD53-4CB2-9002-99B33069D4 >>> 7C%40wichita.edu >>> <https://groups.google.com/a/apereo.org/d/msgid/cas-user/AFDFBB13-AD53-4CB2-9002-99B33069D47C%40wichita.edu?utm_medium=email&utm_source=footer> >>> . >>> >> >> >> >> -- >> -Fazla. >> >> -- >> - 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/CAG9J-Y0VSOGiwLaJk_hTpzqcdYydbS0X7 >> G0%2BFt62yhmTi8dVKw%40mail.gmail.com >> <https://groups.google.com/a/apereo.org/d/msgid/cas-user/CAG9J-Y0VSOGiwLaJk_hTpzqcdYydbS0X7G0%2BFt62yhmTi8dVKw%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/CAMY5mifmJe7hSRO%2BQ7Of983MBy3oTechXZiNN9RU_g%2BfU3cZZw%40mail.gmail.com.
