Typo:
cas.audit.jdbc.ddlAuto=create-drop

2018-02-02 12:23 GMT-03:00 Man H <info.ings...@gmail.com>:

> 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 <fazlarabby043...@gmail.com>
> :
>
>> 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 <
>> cas-user@apereo.org> 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 cas-user+unsubscr...@apereo.org.
>>> 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 cas-user+unsubscr...@apereo.org.
>> 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 cas-user+unsubscr...@apereo.org.
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.

Reply via email to