On Thu, Feb 23, 2012 at 11:57 AM, Nick Legg III <[email protected]> wrote:
> 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";>' > > Apologies if that is out of date. We actually keep an up-to-date sample in the source code it self. > > - 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. > > We migrated to Perf4j for handling that type of data. I believe any information related to that is kept for older version of CAS. > - > - 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? > > It should probably be fine. > > - 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? > > The column will be unknown if it can't figure out your server's IP. probably not the end of the world. I think it may be unknown for the username in that case because we may no longer have the ticket to retrieve the user id from. Cheers, Scott > > > 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 > > -- 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
