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 <[email protected]>
734-973-3478
On Tue, Sep 2, 2014 at 1:29 PM, Rex Roof <[email protected]> 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 <[email protected]>
>
>
> On Thu, Aug 28, 2014 at 2:39 PM, Dmitriy Kopylenko <
> [email protected]> 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 <[email protected]> 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 <[email protected]>
>> 734-973-3478
>>
>>
>> On Thu, Aug 28, 2014 at 11:28 AM, Dmitriy Kopylenko <
>> [email protected]> 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 <[email protected]> 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 <[email protected]>
>>>
>>> --
>>> 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
>>>
>>>
>> --
>> 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
>>
>>
>
--
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
