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 ? -Frederic -- - 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/bc087ffb-1aee-42a7-8fe5-90dd36e3b500n%40apereo.org.
