cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rohit Yadav <rohit.ya...@shapeblue.com>
Subject Re: MySQL : No suitable driver found for jdbc:mysql
Date Tue, 17 May 2016 17:15:16 GMT

Nick, assuming it's a CentOS environment can you run cloudstack-setup-databases (again), make
sure that database IP and cluster node IP parameters in db.properties are correct, and finally
check that the jar is in the classpath in the initd/systemd script (check JAVA_HOME, jdk dirs
etc.). Also watchout for errors in the logs.

Oracle-java is not available from default repositories, in that case you may need to fix JAVA_HOME
and jdk paths in initd scripts.

Regards.
________________________________________
From: Nick LIVENS <nick.livens@nuagenetworks.net>
Sent: 17 May 2016 18:34:38
To: dev@cloudstack.apache.org
Subject: MySQL : No suitable driver found for jdbc:mysql

Hi all,

I'm facing the following issue when installing ACS 4.9.0 (current master).
java.sql.SQLException: No suitable driver found for
jdbc:mysql://localhost:3306/cloud?autoReconnect=true&prepStmtCacheSize=517&cachePrepStmts=true
        at java.sql.DriverManager.getConnection(DriverManager.java:596)
        at java.sql.DriverManager.getConnection(DriverManager.java:215)
        at
org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:75)
        at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
        at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1188)
        at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
        at
com.cloud.utils.db.TransactionLegacy.getStandaloneConnectionWithException(TransactionLegacy.java:202)
        at com.cloud.utils.db.Merovingian2.<init>(Merovingian2.java:68)
        at
com.cloud.utils.db.Merovingian2.createLockMaster(Merovingian2.java:88)

First, I thought that the mysql-connector-java.jar was not loaded /
installed correctly. But this jar is loaded :
[root@csc-1 java]# lsof -p 14064 | grep jar | grep mysql
java    14064 cloud  mem    REG              253,1    883899 134860304
/usr/share/java/mysql-connector-java.jar
java    14064 cloud   38r   REG              253,1    883899 134860304
/usr/share/java/mysql-connector-java.jar

Tomcat specifics :
[root@csc-1 java]# tomcat version
Server version: Apache Tomcat/7.0.54
Server built:   Mar 24 2015 07:49:05
Server number:  7.0.54.0
OS Name:        Linux
OS Version:     3.10.0-229.7.2.el7.x86_64
Architecture:   amd64
JVM Version:    1.7.0_85-mockbuild_2015_07_11_12_24-b00
JVM Vendor:     Oracle Corporation

Does anyone have an idea why I might be facing this issue?

Thanks!

Kind regards,
Nick Livens

rohit.yadav@shapeblue.comĀ 
www.shapeblue.com
53 Chandos Place, Covent Garden, London  WC2N 4HSUK
@shapeblue


Mime
View raw message