cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Paul Angus <paul.an...@shapeblue.com>
Subject RE: MySQL : No suitable driver found for jdbc:mysql
Date Tue, 17 May 2016 18:10:15 GMT
My personal opinion is that a mgmt. server being 'tested' should not have any packages or configuration
on it which is not in the setup guide.
This is a prime example of why.

'something' is installed in the test harness which is unlikely to be in a user's system, hiding
a dependency.


Kind regards,

Paul Angus

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



-----Original Message-----
From: williamstevens@gmail.com [mailto:williamstevens@gmail.com] On Behalf Of Will Stevens
Sent: 17 May 2016 19:04
To: dev@cloudstack.apache.org
Subject: Re: MySQL : No suitable driver found for jdbc:mysql

On CentOS7, this is what I am using without problems:

https://github.com/MissionCriticalCloud/bubble-toolkit/blob/9134cf8be930d0b982829da216471feaf214621f/deploy/firstboot/centos7-cloudstack-java7.sh

*Will STEVENS*
Lead Developer

*CloudOps* *| *Cloud Solutions Experts
420 rue Guy *|* Montreal *|* Quebec *|* H3J 1S6 w cloudops.com *|* tw @CloudOps_

On Tue, May 17, 2016 at 2:03 PM, Paul Angus <paul.angus@shapeblue.com>
wrote:

> @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
>
> paul.angus@shapeblue.com
> www.shapeblue.com
> 53 Chandos Place, Covent Garden, London  WC2N 4HSUK @shapeblue
>
>
>
> -----Original Message-----
> From: Rohit Yadav [mailto:rohit.yadav@shapeblue.com]
> Sent: 17 May 2016 18:15
> To: dev@cloudstack.apache.org
> 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 <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