@Rohit,
On CentOS 7 I get
[root@localhost ~]# yum install libmysql-java
Loaded plugins: fastestmirror
base
| 3.6 kB 00:00:00
epel/x86_64/metalink
| 25 kB 00:00:00
epel
| 4.3 kB 00:00:00
extras
| 3.4 kB 00:00:00
updates
| 3.4 kB 00:00:00
(1/3): epel/x86_64/group_gz
| 170 kB 00:00:00
(2/3): epel/x86_64/updateinfo
| 555 kB 00:00:00
(3/3): epel/x86_64/primary_db
| 4.1 MB 00:00:00
Loading mirror speeds from cached hostfile
* base: mirrors.clouvider.net
* epel: epel.mirrors.ovh.net
* extras: centos.serverspace.co.uk
* updates: mirror.as29550.net
No package libmysql-java available.
Error: Nothing to do
[root@localhost ~]#
Kind regards,
Paul Angus
[email protected]
www.shapeblue.com
53 Chandos Place, Covent Garden, London WC2N 4HSUK
@shapeblue
-----Original Message-----
From: Rohit Yadav [mailto:[email protected]]
Sent: 17 May 2016 18:15
To: [email protected]
Subject: Re: MySQL : No suitable driver found for jdbc:mysql
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 <[email protected]>
Sent: 17 May 2016 18:34:38
To: [email protected]
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
[email protected]
www.shapeblue.com
53 Chandos Place, Covent Garden, London WC2N 4HSUK @shapeblue
