Aaron, If you decide to stick with mySQL... although you added the driver to the lib directory it looks like you are somehow missing it. Are you sure permissions are correct for that file, and that you have the correct version?
On Tue, Sep 24, 2013 at 10:38 AM, Aaron Bennett <abenn...@clarku.edu> 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 cas-user@lists.jasig.org as: apcau...@vcu.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: arch...@mail-archive.com To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/cas-user
