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/ > apereo.org/d/msgid/cas-user/CAG9J-Y0VSOGiwLaJk_hTpzqcdYydbS0X7G0% > 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/CAMY5mifMqh-mncOCBMxpgnNGb1MRBRpA9t%2BncNQaLUpMCPg5ig%40mail.gmail.com.
