Aaron, Depending where you're at with your proof-of-concept, maybe you'd like to try the JSON-file-backed services registry instead? I've found that not having a runtime dependency on a database can save some trouble.
https://github.com/Unicon/cas-addons https://github.com/Unicon/cas-addons/wiki/Configuring%20JSON%20Service%20Registry Kind regards, Andrew On Tue, Sep 24, 2013 at 10:38 AM, Aaron Bennett <[email protected]> wrote: > Hi,**** > > ** ** > > I have CAS 3.5.2 basically working (proof of concept wise) with AD > Authentication, but I’m stymied getting the services management app to work > with MySQL. I’ve followed the instructions at:**** > > ** ** > > https://wiki.jasig.org/display/CASUM/Configuring**** > > ** ** > > But I keep getting this error:**** > > ** ** > > Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC > driver of class 'com.mysql.jdbc.Driver' for connect URL > 'jdbc:mysql:://localhost/cas_services?autoReconnect=true'**** > > at > org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1452) > **** > > at > org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371) > **** > > at > org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) > **** > > at > org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:71) > **** > > at > org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446) > **** > > ... 64 more**** > > Caused by: java.sql.SQLException: No suitable driver**** > > ** ** > > ( see http://pastebin.com/vegVPaQ8 for the full cas.log )**** > > ** ** > > Here’s what I’ve got in pom.xml – **** > > ** ** > > <!-- Apache Commons DBCP -->**** > > <dependency>**** > > <groupId>commons-dbcp</groupId>**** > > <artifactId>commons-dbcp</artifactId>**** > > <version>1.4</version>**** > > <scope>runtime</scope>**** > > </dependency>**** > > <!-- Hibernate Core and Entity Manager -->**** > > <dependency>**** > > <groupId>org.hibernate</groupId>**** > > <artifactId>hibernate-core</artifactId>**** > > <scope>compile</scope>**** > > <version>3.5.0-CR-2</version>**** > > </dependency>**** > > <dependency>**** > > <groupId>org.hibernate</groupId>**** > > <artifactId>hibernate-entitymanager</artifactId>**** > > <version>3.5.0-CR-2</version>**** > > </dependency>**** > > <!--- jdbc -->**** > > <dependency>**** > > <groupId>org.jasig.cas</groupId>**** > > <artifactId>cas-server-support-jdbc</artifactId>**** > > <version>${cas.version}</version>**** > > </dependency>**** > > <!-- MySQL Connector -->**** > > <dependency>**** > > <groupId>mysql</groupId>**** > > <artifactId>mysql-connector-java</artifactId>**** > > <version>5.1.26</version>**** > > </dependency>**** > > </dependencies>**** > > ** ** > > And here’s the relevant snippets from deployerConfigContext.xml:**** > > ** ** > > <bean id="serviceRegistryDao" > class="org.jasig.cas.services.JpaServiceRegistryDaoImpl"**** > > p:entityManagerFactory-ref="entityManagerFactory" />**** > > <!-- This is the EntityMangerFactory configuration for Hibernate -->**** > > <bean id="entityManagerFactory" > class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean"> > **** > > <property name="dataSource" ref="dataSource"/>**** > > <property name="jpaVendorAdapter">**** > > <bean > class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">**** > > <property name="generateDdl" > value="true"/>**** > > <property name="showSql" value="true" />* > *** > > </bean>**** > > </property>**** > > <property name="jpaProperties">**** > > <props>**** > > <prop > key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>**** > > <prop > key="hibernate.hbm2ddl.auto">update</prop>**** > > </props>**** > > </property>**** > > </bean>**** > > ** ** > > ** ** > > <bean id="transactionManager" > class="org.springframework.orm.jpa.JpaTransactionManager">**** > > <property name="entityManagerFactory" > ref="entityManagerFactory"/>**** > > </bean>**** > > ** ** > > <tx:annotation-driven transaction-manager="transactionManager"/>** > ** > > ** ** > > ** ** > > <bean**** > > id="dataSource"**** > > class="org.apache.commons.dbcp.BasicDataSource"**** > > p:driverClassName="com.mysql.jdbc.Driver"**** > > > p:url="jdbc:mysql:://localhost/cas_services?autoReconnect=true"**** > > p:password="snipped "**** > > p:username="user" />**** > > ** ** > > I have verified that I can connect using that username and password with > CLI mysql.**** > > ** ** > > I have also placed mysql-connector-java-5.1.26-bin.jar in > $TOMCAT_HOME/lib. I’m using tomcat 7.0.42.**** > > ** ** > > Thanks for your time,**** > > ** ** > > Aaron Bennett**** > > ** ** > > ** ** > > ---**** > > Aaron Bennett**** > > Manager of Systems Administration**** > > Clark University ITS**** > > W:508.793.7315**** > > ** ** > > -- > 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
