Also please do keep in mind that you’d need pre-create this table in order for this impl to work:
CREATE TABLE COM_AUDIT_TRAIL ( AUD_USER VARCHAR2(100) NOT NULL, AUD_CLIENT_IP VARCHAR(15) NOT NULL, AUD_SERVER_IP VARCHAR(15) NOT NULL, AUD_RESOURCE VARCHAR2(100) NOT NULL, AUD_ACTION VARCHAR2(100) NOT NULL, APPLIC_CD VARCHAR2(5) NOT NULL, AUD_DATE TIMESTAMP NOT NULL ) On Sep 2, 2014, at 4:13 PM, Dmitriy Kopylenko <dkopyle...@unicon.net> wrote: > Just have this one bean definition (in your deployerConfigContext and get rid > of that ‘auditManager’ bean def): > > <bean id="auditTrailManager" > class="com.github.inspektr.audit.support.JdbcAuditTrailManager"> > <constructor-arg index="0" ref="inspektrTransactionTemplate" /> > <property name="dataSource" ref="dataSource" /> > </bean> > > Cheers, > D. > > On Sep 2, 2014, at 4:02 PM, Rex Roof <r...@wccnet.edu> wrote: > >> I'm looking at this wiki page: >> https://wiki.jasig.org/display/CASUM/Auditing+and+Statistics+Via+Inspektr >> but it looks a little out of date for 3.5. >> >> I made these updates to my deployerConfigContext.xml: >> <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" >> destroy-method="close"> >> <property name="driverClass" value="com.mysql.jdbc.Driver"/> >> <property name="jdbcUrl" >> value="jdbc:mysql://mysql.server.edu:3306/dbname"/> >> <property name="user" value="username"/> >> <property name="password" value="Passw0rd"/> >> <property name="maxPoolSize" value="10"/> >> <property name="initialPoolSize" value="3"/> >> <property name="maxStatements" value="50"/> >> <property name="minPoolSize" value="3"/> >> <property name="idleConnectionTestPeriod" value="100"/> >> <property name="maxIdleTime" value="200"/> >> <property name="acquireIncrement" value="1"/> >> </bean> >> <bean id="auditTrailManager" >> class="com.github.inspektr.audit.support.JdbcAuditTrailManager"/> >> >> I also added these things to my spring-configuration/auditTrailContext.xml: >> >> <bean id="inspektrTransactionManager" >> class="org.springframework.jdbc.datasource.DataSourceTransactionManager" >> p:dataSource-ref="dataSource" >> /> >> >> <bean id="inspektrTransactionTemplate" >> class="org.springframework.transaction.support.TransactionTemplate" >> p:transactionManager-ref="inspektrTransactionManager" >> p:isolationLevelName="ISOLATION_READ_COMMITTED" >> p:propagationBehaviorName="PROPAGATION_REQUIRED" >> /> >> >> <bean id="auditManager" >> class="com.github.inspektr.audit.support.JdbcAuditTrailManager"> >> <constructor-arg index="0" ref="inspektrTransactionTemplate" /> >> <property name="dataSource" ref="dataSource" /> >> </bean> >> >> I also made sure put the mysql-connector-java, c3p0 and mchange-commons jar >> files in my classpath. >> >> I'm now getting and error like this: >> But for our having caught this error, the web application context would not >> have initialized.> >> org.springframework.beans.factory.BeanCreationException: Error creating bean >> with name 'auditTrailManager' defined in ServletContext re >> source [/WEB-INF/deployerConfigContext.xml]: Instantiation of bean failed; >> nested exception is org.springframework.beans.BeanInstantiat >> ionException: Could not instantiate bean class >> [com.github.inspektr.audit.support.JdbcAuditTrailManager]: No default >> constructor found; >> nested exception is java.lang.NoSuchMethodException: >> com.github.inspektr.audit.support.JdbcAuditTrailManager.<init>() >> But for our having caught this error, the web application context would not >> have initialized. >> org.springframework.beans.factory.BeanCreationException: Error creating bean >> with name 'auditTrailManager' defined in ServletContext re >> source [/WEB-INF/deployerConfigContext.xml]: Instantiation of bean failed; >> nested exception is org.springframework.beans.BeanInstantiat >> ionException: Could not instantiate bean class >> [com.github.inspektr.audit.support.JdbcAuditTrailManager]: No default >> constructor found; >> nested exception is java.lang.NoSuchMethodException: >> com.github.inspektr.audit.support.JdbcAuditTrailManager.<init>() >> >> >> Any pointers? >> >> >> >> >> - Rex Roof >> WCC Systems Engineer <r...@wccnet.edu> >> 734-973-3478 >> >> >> On Tue, Sep 2, 2014 at 1:29 PM, Rex Roof <r...@wccnet.edu> wrote: >> I'm sorry, I hate to be obtuse, but which bean are you talking about? and >> where do I find docs about what the bean's properties need to be? >> >> Your earlier link goes to java code and I'm not sure how it correlates to >> the bean definition. >> >> >> >> - Rex Roof >> WCC Systems Engineer <r...@wccnet.edu> >> >> >> On Thu, Aug 28, 2014 at 2:39 PM, Dmitriy Kopylenko >> <dmitriy.kopyle...@gmail.com> wrote: >> Just define this bean in the deployer config context instead of slf4j one - >> just like any other CAS components. >> >> Cheers, >> D. >> >> Sent from my iPhone >> >> On Aug 28, 2014, at 10:36, Rex Roof <r...@wccnet.edu> wrote: >> >>> do I need to edit java and recompile CAS to make this change? >>> All of the modifications we've done so far have been just XML and html/css >>> changes to CAS. >>> >>> >>> >>> - Rex Roof >>> WCC Systems Engineer <r...@wccnet.edu> >>> 734-973-3478 >>> >>> >>> On Thu, Aug 28, 2014 at 11:28 AM, Dmitriy Kopylenko >>> <dmitriy.kopyle...@gmail.com> wrote: >>> There is an opinionated AuditTrailManager impl for database audit events >>> recording with a specific table and column names requirement that you could >>> use: >>> >>> https://github.com/dima767/inspektr/blob/master/inspektr-support-spring/src/main/java/com/github/inspektr/audit/support/JdbcAuditTrailManager.java >>> >>> Best, >>> Dmitriy. >>> >>> Sent from my iPhone >>> >>> On Aug 28, 2014, at 10:11, Rex Roof <r...@wccnet.edu> wrote: >>> >>>> how do I go about moving the >>>> com.github.inspektr.audit.support.Slf4jLoggingAuditTrailManager into a >>>> mysql database? >>>> >>>> Is this possible? are there docs on it? >>>> >>>> I'm using CAS 3.5.2 under tomcat 6.0.24 running on RHEL6. >>>> My google searches have come up short. >>>> >>>> - Rex Roof >>>> WCC Systems Engineer <r...@wccnet.edu> >>>> >>>> -- >>>> You are currently subscribed to cas-user@lists.jasig.org as: >>>> dmitriy.kopyle...@gmail.com >>>> To unsubscribe, change settings or access archives, see >>>> http://www.ja-sig.org/wiki/display/JSG/cas-user >>> -- >>> You are currently subscribed to cas-user@lists.jasig.org as: r...@wccnet.edu >>> To unsubscribe, change settings or access archives, see >>> http://www.ja-sig.org/wiki/display/JSG/cas-user >>> >>> -- >>> You are currently subscribed to cas-user@lists.jasig.org as: >>> dmitriy.kopyle...@gmail.com >>> To unsubscribe, change settings or access archives, see >>> http://www.ja-sig.org/wiki/display/JSG/cas-user >> -- >> You are currently subscribed to cas-user@lists.jasig.org as: r...@wccnet.edu >> To unsubscribe, change settings or access archives, see >> http://www.ja-sig.org/wiki/display/JSG/cas-user >> >> >> -- >> You are currently subscribed to cas-user@lists.jasig.org as: >> dkopyle...@unicon.net >> To unsubscribe, change settings or access archives, see >> http://www.ja-sig.org/wiki/display/JSG/cas-user > > -- > You are currently subscribed to cas-user@lists.jasig.org as: > dkopyle...@unicon.net > To unsubscribe, change settings or access archives, see > http://www.ja-sig.org/wiki/display/JSG/cas-user -- You are currently subscribed to cas-user@lists.jasig.org as: arch...@mail-archive.com To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/cas-user
