Re: Usage Server in 4.3
On May 30, 2014, at 1:07 PM, Fabrice Brazier fabrice.braz...@apalia.net wrote: Thanks Sébastien. Fabrice -Message d'origine- De : sebgoa [mailto:run...@gmail.com] Envoyé : vendredi 30 mai 2014 18:37 À : users@cloudstack.apache.org Objet : Re: Usage Server in 4.3 On May 30, 2014, at 5:02 PM, Fabrice Brazier fabrice.braz...@apalia.net wrote: Hi David, There was an issue with mysql connector. Starting 4.3 mysql connector is no longer bundled with ACS. I created a symbolic link to make it available to usage server: ln -s /usr/share/java/mysql-connector-java.jar /usr/share/cloudstack-usage/lib/mysql-connector-java.jar This issue is being added to 4.3 release docs. I will do that today, and FWIW this issue is fixed in 4.4 and master. Let me know if there are further issues: http://docs.cloudstack.apache.org/projects/cloudstack-installation/en/latest/installation.html#install-on-ubuntu Usage server is working fine now. Regards, Fabrice -Message d'origine- De : David Matteson [mailto:dmatte...@a2hosting.com] Envoyé : vendredi 30 mai 2014 16:52 À : users@cloudstack.apache.org Objet : Usage Server in 4.3 Hey all, We upgraded to 4.3 yesterday and now the usage server gives the following error: java.sql.SQLException: No suitable driver found for jdbc:mysql://127.0.0.1:3306/cloud?autoReconnect=trueprepStmtCacheSize =517 cachePrepStmts=true Anyone else run into this or have a solution? Thanks!
Usage Server in 4.3
Hey all, We upgraded to 4.3 yesterday and now the usage server gives the following error: java.sql.SQLException: No suitable driver found for jdbc:mysql://127.0.0.1:3306/cloud?autoReconnect=trueprepStmtCacheSize=517cachePrepStmts=true Anyone else run into this or have a solution? Thanks!
RE: Usage Server in 4.3
Hi David, There was an issue with mysql connector. Starting 4.3 mysql connector is no longer bundled with ACS. I created a symbolic link to make it available to usage server: ln -s /usr/share/java/mysql-connector-java.jar /usr/share/cloudstack-usage/lib/mysql-connector-java.jar This issue is being added to 4.3 release docs. Usage server is working fine now. Regards, Fabrice -Message d'origine- De : David Matteson [mailto:dmatte...@a2hosting.com] Envoyé : vendredi 30 mai 2014 16:52 À : users@cloudstack.apache.org Objet : Usage Server in 4.3 Hey all, We upgraded to 4.3 yesterday and now the usage server gives the following error: java.sql.SQLException: No suitable driver found for jdbc:mysql://127.0.0.1:3306/cloud?autoReconnect=trueprepStmtCacheSize=517 cachePrepStmts=true Anyone else run into this or have a solution? Thanks!
Re: Usage Server in 4.3
On May 30, 2014, at 5:02 PM, Fabrice Brazier fabrice.braz...@apalia.net wrote: Hi David, There was an issue with mysql connector. Starting 4.3 mysql connector is no longer bundled with ACS. I created a symbolic link to make it available to usage server: ln -s /usr/share/java/mysql-connector-java.jar /usr/share/cloudstack-usage/lib/mysql-connector-java.jar This issue is being added to 4.3 release docs. I will do that today, and FWIW this issue is fixed in 4.4 and master. Usage server is working fine now. Regards, Fabrice -Message d'origine- De : David Matteson [mailto:dmatte...@a2hosting.com] Envoyé : vendredi 30 mai 2014 16:52 À : users@cloudstack.apache.org Objet : Usage Server in 4.3 Hey all, We upgraded to 4.3 yesterday and now the usage server gives the following error: java.sql.SQLException: No suitable driver found for jdbc:mysql://127.0.0.1:3306/cloud?autoReconnect=trueprepStmtCacheSize=517 cachePrepStmts=true Anyone else run into this or have a solution? Thanks!
RE: Usage Server in 4.3
Thanks Sébastien. Fabrice -Message d'origine- De : sebgoa [mailto:run...@gmail.com] Envoyé : vendredi 30 mai 2014 18:37 À : users@cloudstack.apache.org Objet : Re: Usage Server in 4.3 On May 30, 2014, at 5:02 PM, Fabrice Brazier fabrice.braz...@apalia.net wrote: Hi David, There was an issue with mysql connector. Starting 4.3 mysql connector is no longer bundled with ACS. I created a symbolic link to make it available to usage server: ln -s /usr/share/java/mysql-connector-java.jar /usr/share/cloudstack-usage/lib/mysql-connector-java.jar This issue is being added to 4.3 release docs. I will do that today, and FWIW this issue is fixed in 4.4 and master. Usage server is working fine now. Regards, Fabrice -Message d'origine- De : David Matteson [mailto:dmatte...@a2hosting.com] Envoyé : vendredi 30 mai 2014 16:52 À : users@cloudstack.apache.org Objet : Usage Server in 4.3 Hey all, We upgraded to 4.3 yesterday and now the usage server gives the following error: java.sql.SQLException: No suitable driver found for jdbc:mysql://127.0.0.1:3306/cloud?autoReconnect=trueprepStmtCacheSize =517 cachePrepStmts=true Anyone else run into this or have a solution? Thanks!
RE: Trouble with Usage server on 4.3.
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.netmailto: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
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.netmailto: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.java:421) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_964f5759.CGLIB$searchIncludingRemoved$48(generated) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_964f5759_FastClassByCloudStack_bb80d0f6.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_964f5759.searchIncludingRemoved(generated) at com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:356) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_964f5759.CGLIB$searchIncludingRemoved$49(generated) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_964f5759_FastClassByCloudStack_bb80d0f6.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_964f5759.searchIncludingRemoved(generated) at com.cloud.utils.db.GenericDaoBase.listIncludingRemovedBy(GenericDaoBase.java:911) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_964f5759.CGLIB$listIncludingRemovedBy$78(generated) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_964f5759_FastClassByCloudStack_bb80d0f6.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_964f5759.listIncludingRemovedBy(generated) at com.cloud.utils.db.GenericDaoBase.listIncludingRemovedBy(GenericDaoBase.java:916) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_964f5759.CGLIB$listIncludingRemovedBy$76(generated) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_964f5759_FastClassByCloudStack_bb80d0f6.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_964f5759.listIncludingRemovedBy(generated) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl.getConfiguration(ConfigurationDaoImpl.java:82) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_964f5759.CGLIB$getConfiguration$8(generated) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_964f5759_FastClassByCloudStack_bb80d0f6.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_964f5759.getConfiguration(generated) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl.getConfiguration(ConfigurationDaoImpl.java:110) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_964f5759.CGLIB$getConfiguration$9(generated) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_964f5759_FastClassByCloudStack_bb80d0f6.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_964f5759.getConfiguration(generated) at com.cloud.usage.UsageManagerImpl.configure(UsageManagerImpl.java:173) at com.cloud.utils.component.ComponentContext.initComponentsLifeCycle(ComponentContext.java:114) at
Trouble with Usage server on 4.3.
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.java:421) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_964f5759.CGLIB$searchIncludingRemoved$48(generated) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_964f5759_FastClassByCloudStack_bb80d0f6.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_964f5759.searchIncludingRemoved(generated) at com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:356) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_964f5759.CGLIB$searchIncludingRemoved$49(generated) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_964f5759_FastClassByCloudStack_bb80d0f6.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_964f5759.searchIncludingRemoved(generated) at com.cloud.utils.db.GenericDaoBase.listIncludingRemovedBy(GenericDaoBase.java:911) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_964f5759.CGLIB$listIncludingRemovedBy$78(generated) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_964f5759_FastClassByCloudStack_bb80d0f6.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_964f5759.listIncludingRemovedBy(generated) at com.cloud.utils.db.GenericDaoBase.listIncludingRemovedBy(GenericDaoBase.java:916) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_964f5759.CGLIB$listIncludingRemovedBy$76(generated) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_964f5759_FastClassByCloudStack_bb80d0f6.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_964f5759.listIncludingRemovedBy(generated) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl.getConfiguration(ConfigurationDaoImpl.java:82) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_964f5759.CGLIB$getConfiguration$8(generated) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_964f5759_FastClassByCloudStack_bb80d0f6.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_964f5759.getConfiguration(generated) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl.getConfiguration(ConfigurationDaoImpl.java:110) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_964f5759.CGLIB$getConfiguration$9(generated) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_964f5759_FastClassByCloudStack_bb80d0f6.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_964f5759.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