that finally got CAS to come back up! I'm not yet getting Mysql logs, but it's another step.
Now I have this error: Exception in thread "pool-3-thread-1" org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database! I have confirmed that my mysql user can connect to the mysql server on the proper port from my CAS server. thanks dmitriy, I appreciate all of your feedback. - Rex Roof WCC Systems Engineer <[email protected]> 734-973-3478 On Tue, Sep 2, 2014 at 4:13 PM, Dmitriy Kopylenko <[email protected]> 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 <[email protected]> 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 <[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 > > > -- > 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
