JDBC (Postgres) com_audit_trail table stays empty

20 views

Skip to first unread message

Frédéric Lohier

unread,

Nov 30, 2020, 1:04:56 PM11/30/20

to CAS Community

Hello,

I am trying to send the audit logs to a Postgres database with the following configuration :

cas.audit.enabled=true
cas.audit.number-of-days-in-history=30
cas.audit.jdbc.driver-class=org.postgresql.Driver
cas.audit.jdbc.dialect=org.hibernate.dialect.PostgreSQL95Dialect
cas.audit.jdbc.url=jdbc:postgresql://x.x.x.x/cas
cas.audit.jdbc.user=cas_user
cas.audit.jdbc.password=dbpassword

The com_audit_trail table was created by CAS server, which means the jdbc connnector configuration is OK, but this table stays empty.

I still get the audit log in the audit_log.log files with the kind of content you can see below :

2020-11-30 18:34:08,691 INFO [org.apereo.inspektr.audit.support.Slf4jLoggingAuditTrailManager] - Audit trail record BEGIN

=============================================================
WHO: user
WHAT: TGT-3-*****JDU4T-sqCA-
ACTION: TICKET_GRANTING_TICKET_CREATED
APPLICATION: CAS
WHEN: Mon Nov 30 18:34:08 CET 2020
CLIENT IP ADDRESS: x.x.x.x
SERVER IP ADDRESS: x.x.x.x
=============================================================

I also get the following log lines every 30s in both the cas.log and cas_audit.log :

2020-11-30 18:34:18,041 INFO [org.apereo.inspektr.audit.support.JdbcAuditTrailManager] - Cleaning audit records with query DELETE FROM COM_AUDIT_TRAIL WHERE AUD_DATE < ?
2020-11-30 18:34:18,042 INFO [org.apereo.inspektr.audit.support.JdbcAuditTrailManager] - 0 records deleted.
2020-11-30 18:34:48,044 INFO [org.apereo.inspektr.audit.support.JdbcAuditTrailManager] - Cleaning audit records with query DELETE FROM COM_AUDIT_TRAIL WHERE AUD_DATE < ?
2020-11-30 18:34:48,045 INFO [org.apereo.inspektr.audit.support.JdbcAuditTrailManager] - 0 records deleted.

Am I missing something in my configuration to send the audit log to the Postgres Database ?