Steve, Mysql connector (mysql-connector-java.jar) is no longer bundled with CS installation. You need to make it available to CS usage lib path (under /usr/share/cloudstack-usage/lib/).
> -----Original Message----- > From: Steve Searles [mailto:ssear...@zimcom.net] > Sent: Monday, 7 April 2014 10:09 PM > To: <users@cloudstack.apache.org> > Subject: Re: Trouble with Usage server on 4.3. > > Anyone? > > Steven Searles > Zimcom Internet > > > On Apr 4, 2014, at 6:04 PM, Steve Searles > <ssear...@zimcom.net<mailto:ssear...@zimcom.net>> wrote: > > On 4.3 I am having a problem getting my usage server to start. CS works fine > and db.properties appears to be correct. The cloudstack_usage DB has been > created and credentials work. I am getting the following in the cloudstack- > usage.err log > > com.cloud.utils.exception.CloudRuntimeException: DB Exception on: null at > com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.j > ava:421) > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerB > yCloudStack_964f5759.CGLIB$searchIncludingRemoved$48(<generated>) > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerB > yCloudStack_964f5759_FastClassByCloudStack_bb80d0f6.invoke(<generated>) > at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228) > at > com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorD > ispatcher.intercept(ComponentInstantiationPostProcessor.java:125) > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerB > yCloudStack_964f5759.searchIncludingRemoved(<generated>) > at > com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.j > ava:356) > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerB > yCloudStack_964f5759.CGLIB$searchIncludingRemoved$49(<generated>) > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerB > yCloudStack_964f5759_FastClassByCloudStack_bb80d0f6.invoke(<generated>) > at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228) > at > com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorD > ispatcher.intercept(ComponentInstantiationPostProcessor.java:125) > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerB > yCloudStack_964f5759.searchIncludingRemoved(<generated>) > at > com.cloud.utils.db.GenericDaoBase.listIncludingRemovedBy(GenericDaoBase.ja > va:911) > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerB > yCloudStack_964f5759.CGLIB$listIncludingRemovedBy$78(<generated>) > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerB > yCloudStack_964f5759_FastClassByCloudStack_bb80d0f6.invoke(<generated>) > at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228) > at > com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorD > ispatcher.intercept(ComponentInstantiationPostProcessor.java:125) > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerB > yCloudStack_964f5759.listIncludingRemovedBy(<generated>) > at > com.cloud.utils.db.GenericDaoBase.listIncludingRemovedBy(GenericDaoBase.ja > va:916) > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerB > yCloudStack_964f5759.CGLIB$listIncludingRemovedBy$76(<generated>) > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerB > yCloudStack_964f5759_FastClassByCloudStack_bb80d0f6.invoke(<generated>) > at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228) > at > com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorD > ispatcher.intercept(ComponentInstantiationPostProcessor.java:125) > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerB > yCloudStack_964f5759.listIncludingRemovedBy(<generated>) > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl.getConfigu > ration(ConfigurationDaoImpl.java:82) > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerB > yCloudStack_964f5759.CGLIB$getConfiguration$8(<generated>) > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerB > yCloudStack_964f5759_FastClassByCloudStack_bb80d0f6.invoke(<generated>) > at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228) > at > com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorD > ispatcher.intercept(ComponentInstantiationPostProcessor.java:125) > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerB > yCloudStack_964f5759.getConfiguration(<generated>) > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl.getConfigu > ration(ConfigurationDaoImpl.java:110) > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerB > yCloudStack_964f5759.CGLIB$getConfiguration$9(<generated>) > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerB > yCloudStack_964f5759_FastClassByCloudStack_bb80d0f6.invoke(<generated>) > at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228) > at > com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorD > ispatcher.intercept(ComponentInstantiationPostProcessor.java:125) > at > org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerB > yCloudStack_964f5759.getConfiguration(<generated>) > at com.cloud.usage.UsageManagerImpl.configure(UsageManagerImpl.java:173) > at > com.cloud.utils.component.ComponentContext.initComponentsLifeCycle(Comp > onentContext.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(DelegatingMethodAccessorI > mpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:622) > at > org.apache.commons.daemon.support.DaemonLoader.start(DaemonLoader.jav > a:243) > Caused by: java.sql.SQLException: No suitable driver found for > jdbc:mysql://localhost:3306/cloud?autoReconnect=true&prepStmtCacheSize=51 > 7&cachePrepStmts=true > at java.sql.DriverManager.getConnection(DriverManager.java:635) > at java.sql.DriverManager.getConnection(DriverManager.java:195) > at > org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnectio > n(DriverManagerConnectionFactory.java:75) > at > org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableCo > nnectionFactory.java:582) > at > org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjec > tPool.java:1188) > at > org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSour > ce.java:106) > at > com.cloud.utils.db.TransactionLegacy.getConnection(TransactionLegacy.java:55 > 6) > at > com.cloud.utils.db.TransactionLegacy.prepareStatement(TransactionLegacy.jav > a:467) > at > com.cloud.utils.db.TransactionLegacy.prepareAutoCloseStatement(TransactionL > egacy.java:460) > at > com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.j > ava:394) > > > I read a post that this was a problem on 4.2 with tomcat version. 6.0.25. I > have > already checked this and have 6.0.24 installed. > > [root@csmgmt43 usage]# rpm -qa |grep tomcat tomcat6-servlet-2.5-api- > 6.0.24-62.el6.noarch > tomcat6-lib-6.0.24-62.el6.noarch > tomcat6-jsp-2.1-api-6.0.24-62.el6.noarch > tomcat6-el-2.1-api-6.0.24-62.el6.noarch > apache-tomcat-apis-0.1-1.el6.noarch > tomcat6-6.0.24-62.el6.noarch > [root@csmgmt43 usage]# > > Any help would be appreciated. > > > Steven Searles > Zimcom Internet
