I completely understand the motivation and need to get stuff running. We just have to make sure that #cloudstackworks
Kind regards, Paul Angus paul.an...@shapeblue.comĀ www.shapeblue.com 53 Chandos Place, Covent Garden, London WC2N 4HSUK @shapeblue -----Original Message----- From: williamstev...@gmail.com [mailto:williamstev...@gmail.com] On Behalf Of Will Stevens Sent: 17 May 2016 20:10 To: dev@cloudstack.apache.org Subject: Re: MySQL : No suitable driver found for jdbc:mysql Fair enough. I only pointed out what I was successfully using to help guide him. I have not reviewed what the documented dependencies are, I just had to get something working so I could actually do the RM role and that is basically what I got from SBP (the previous RMs). I am not claiming that what I have is perfect, I am only trying to help him get his environment working... *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:10 PM, Paul Angus <paul.an...@shapeblue.com> wrote: > 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.an...@shapeblue.com > www.shapeblue.com > 53 Chandos Place, Covent Garden, London WC2N 4HSUK @shapeblue > > > > -----Original Message----- > From: williamstev...@gmail.com [mailto:williamstev...@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.an...@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.an...@shapeblue.com > > www.shapeblue.com > > 53 Chandos Place, Covent Garden, London WC2N 4HSUK @shapeblue > > > > > > > > -----Original Message----- > > From: Rohit Yadav [mailto:rohit.ya...@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.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 > > > > > > >