[ https://issues.apache.org/jira/browse/CLOUDSTACK-6361?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rayees Namathponnan updated CLOUDSTACK-6361: -------------------------------------------- Fix Version/s: 4.4.0 > Mysql connector jar is not available in usage server classpath > -------------------------------------------------------------- > > Key: CLOUDSTACK-6361 > URL: https://issues.apache.org/jira/browse/CLOUDSTACK-6361 > Project: CloudStack > Issue Type: Bug > Security Level: Public(Anyone can view this level - this is the > default.) > Components: Install and Setup > Reporter: Rayees Namathponnan > Priority: Critical > Fix For: 4.4.0 > > > Failed to start cloudstack-usage due to mysql-connector jar is not loaded > Mysql connector jar is not available in usage server classpath as a result > usage server doesn't runs and gets following exception : > (Caused by: java.sql.SQLException: No suitable driver found for > jdbc:mysql://localhost:3306/cloud?autoReconnect=true&prepStmtCacheSize=517&cachePrepStmts=true) > com.cloud.utils.exception.CloudRuntimeException: DB Exception on: null > at > com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:421) > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_6216aeb7.CGLIB$searchIncludingRemoved$50(<generated> > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_6216aeb7_FastClassByCloudStack_a8961dbb.invoke(<generated> > at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228) > at > com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125) > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_6216aeb7.searchIncludingRemoved(<generated> > at > com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:356) > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_6216aeb7.CGLIB$searchIncludingRemoved$49(<generated> > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_6216aeb7_FastClassByCloudStack_a8961dbb.invoke(<generated> > at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228) > at > com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125) > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_6216aeb7.searchIncludingRemoved(<generated> > at > com.cloud.utils.db.GenericDaoBase.listIncludingRemovedBy(GenericDaoBase.java:911) > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_6216aeb7.CGLIB$listIncludingRemovedBy$77(<generated> > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_6216aeb7_FastClassByCloudStack_a8961dbb.invoke(<generated> > at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228) > at > com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125) > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_6216aeb7.listIncludingRemovedBy(<generated> > at > com.cloud.utils.db.GenericDaoBase.listIncludingRemovedBy(GenericDaoBase.java:916) > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_6216aeb7.CGLIB$listIncludingRemovedBy$78(<generated> > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_6216aeb7_FastClassByCloudStack_a8961dbb.invoke(<generated> > at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228) > at > com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125) > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_6216aeb7.listIncludingRemovedBy(<generated> > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl.getConfiguration(ConfigurationDaoImpl.java:82) > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_6216aeb7.CGLIB$getConfiguration$7(<generated> > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_6216aeb7_FastClassByCloudStack_a8961dbb.invoke(<generated> > at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228) > at > com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125) > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_6216aeb7.getConfiguration(<generated> > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl.getConfiguration(ConfigurationDaoImpl.java:110) > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_6216aeb7.CGLIB$getConfiguration$8(<generated> > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_6216aeb7_FastClassByCloudStack_a8961dbb.invoke(<generated> > at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228) > at > com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125) > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_6216aeb7.getConfiguration(<generated> > at com.cloud.usage.UsageManagerImpl.configure(UsageManagerImpl.java:173) > at > com.cloud.utils.component.ComponentContext.initComponentsLifeCycle(ComponentContext.java:114) > at com.cloud.usage.UsageServer.start(UsageServer.java:60) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:616) > at org.apache.commons.daemon.support.DaemonLoader.start(DaemonLoader.java:243) > Caused by: 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:640) > at java.sql.DriverManager.getConnection(DriverManager.java:200) > at > org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:75) > 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.getConnection(TransactionLegacy.java:556) > at > com.cloud.utils.db.TransactionLegacy.prepareStatement(TransactionLegacy.java:467) > at > com.cloud.utils.db.TransactionLegacy.prepareAutoCloseStatement(TransactionLegacy.java:460) > at > com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:394) > ... 43 more > We need to add mysql-connnector.jar in cloud-usage.rc -- This message was sent by Atlassian JIRA (v6.2#6252)