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.liv...@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.ya...@shapeblue.com
www.shapeblue.com
53 Chandos Place, Covent Garden, London WC2N 4HSUK
@shapeblue
