None of the out of the box configurations for Inspektr used a database. They all use one that writes to the console.
You need to take your previous JdbcAuditTrailManager config (and Datasource, etc.) and replace the ConsoleAuditTrailManager. Cheers, Scott On Tue, Jul 6, 2010 at 6:50 PM, Xuejin Ruan <[email protected]> wrote: > > I once used CAS 3.3 and had no problem logging all login attemps to > database > using Inspektr. Now I switched to CAS 3.4.2 and could not get Inspektr > database logging working. > > I have a SQL dataSource defined in deployConfigContext.xml: > <!-- Data source definition--> > <bean id="dataSource" destroy-method="close" > class="org.apache.commons.dbcp.BasicDataSource"> > <property name="driverClassName" > value="net.sourceforge.jtds.jdbc.Driver" > /> > <property name="url" > value="jdbc:jtds:sqlserver://xx.xx.xx.xxx:1433/CF_Portal_Mngr" /> > <property name="username" value="xxx" /> > <property name="password" value="xxx" /> > </bean> > > And I have put auditTrailContext.xml in [cas context > path]\WEB-INF\spring-configuration\ , which is a exact copy from > https://wiki.jasig.org/display/CASUM/Auditing+and+Statistics+Via+Inspektr > https://wiki.jasig.org/display/CASUM/Auditing+and+Statistics+Via+Inspektr > (configuragion for CAS 3.4 section) > > In the log file, I could see all the Audit trail record such as > Audit trail record BEGIN > ============================================================= > WHO: audit:unknown > WHAT: ST-5-ZOMtKtfy1OuRacGxAEHi-cas > ACTION: SERVICE_TICKET_VALIDATED > APPLICATION: CAS > WHEN: Tue Jul 06 15:28:06 PDT 2010 > CLIENT IP ADDRESS: xx.xx.xx.xx > SERVER IP ADDRESS: xx.xx.xx.xx > ============================================================= > > And I have created the audit tables in my database, but I could not see any > audit trail record going to the database. And I didn't get any error > message > from the log file either. > > I do notice that in the new auditTrailContext.xml file (targetted for CAS > 3.4), it doesn't mentioned any about dataSource definition, and I assume by > default it looks for a bean named "dataSource" in the context file. > > What did I miss? > > Thanks, > > Xuejin > -- > View this message in context: > http://jasig.275507.n4.nabble.com/Inspektr-database-logging-tp2280292p2280292.html > Sent from the CAS Users mailing list archive at Nabble.com. > > -- > 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
