Hello,

 

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

-- 
- 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/f0fe0876-b8c6-4b44-8e16-85ea72574d5a%40apereo.org.

Reply via email to