Hello, I have followed the instructions at https://wiki.jasig.org/display/CASUM/Auditing+and+Statistics+Via+Inspektrto implement database auditing on my CAS 3.4.8 installation. Naturally, I have some questions...
- The xsi:schemaLocation in the auditTrailContext.xml file in the wiki page is missing a URL; it should read: 'xsi:schemaLocation=" http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd";>' - Does Inspektr no longer handle statistics monitoring? I don't see any activity in the COM_STATISTICS table. I dropped said table and haven't encountered any apparent errors. - I'm using MySQL with the InnoDB storage engine and utf8_general_ci collation. Unfortunately, the primary key COM_AUDIT_TRAIL_PK exceeds 1000 bytes (just barely!) so MySQL can't handle it. I worked around this by removing the APPLIC_CD column from my primary key. Is this likely to cause issues down the road? - The AUD_SERVER_IP column is "unknown" for *all* rows in COM_AUDIT_TRAIL. The AUD_USER column is "audit:unknown" for all rows where AUD_ACTION = SERVICE_TICKET_VALIDATED. Is this expected behavior? Thanks, Nick -- You are currently subscribed to [email protected] as: [email protected] To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/cas-user
