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
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: Cloudstack:: cloud_usage table empty
Hi Saulo, I got the same issue on my side, here is the process I did to resolve: I have set both usage.aggregation.tiemzone to Europe/Paris and usage.execution.timezone to Europe/Paris And I have set usage.stats.job.aggregation.range to 10 In the logs I kept seeing Not owner of usage job, skipping... when execution time occur. However after waiting for about 30 min or so, usage data started populating and it started working. Please keep me posted. Regards, Fabrice On Mon, May 26, 2014 at 5:10 PM, Saulo Zimbaro sa...@zimbaro.com wrote: Fabrice, Doesnt work. Strange that pid on usage_job table is different that on OS. pid on table doesnt exist. -- *Saulo Zimbaro* Mobile ) (+55) 21 99800-0100 *saulozimb...@gmail.com *sa...@zimbaro.com 2014-05-26 10:22 GMT-03:00 Fabrice Brazier fabrice.braz...@apalia.net: Hi Saulo, - save mysqldumps of both cloud/cloud_usage Db in case you will have to revert - stop usage server - remove the record from usage_job table for the unprocessed job - start usage server again Regards, Fabrice On Mon, May 26, 2014 at 2:33 PM, Saulo Zimbaro sa...@zimbaro.com wrote: Fabrice, After create link I got another error: 2014-05-26 12:30:00,003 INFO [cloud.usage.UsageManagerImpl] (Usage-Job-1:null) starting usage job... 2014-05-26 12:30:00,009 DEBUG [cloud.usage.UsageManagerImpl] (Usage-Job-1:null) Not owner of usage job, skipping... 2014-05-26 12:30:00,010 INFO [cloud.usage.UsageManagerImpl] (Usage-Job-1:null) usage job complete How can I fix this? -- *Saulo Zimbaro* Mobile ) (+55) 21 99800-0100 *saulozimb...@gmail.com *sa...@zimbaro.com 2014-05-25 14:30 GMT-03:00 Diego Spinola Castro spinolacas...@gmail.com : i have a similar issue but only network usage is empty (types 4 and 5). does anybody have seen that? 2014-05-23 23:53 GMT-03:00 Pierre-Luc Dion pd...@cloudops.com: I've fixed this issue on centos by installing java-1.6.0 yum install java-1.6.0 Le vendredi 23 mai 2014, Hollman Enciso R. hollman.enc...@gmail.com a écrit : Any idea with this error ? Starting CloudStack Usage Monitor cloudstack-usage23/05/2014 15:15:22 7 jsvc error: Cannot locate Java Home cat: /var/run/cloudstack-usage.pid: No such file or directory [FAILED] It's show starting the daemon cloudstack-usage. On Thu, May 22, 2014 at 11:37 PM, Rajani Karuturi rajani.karut...@citrix.com javascript:; wrote: you might want to look at https://issues.apache.org/jira/browse/CLOUDSTACK-6360 and the commits. ~Rajani On 23-May-2014, at 3:49 am, Fabrice Brazier fabrice.braz...@apalia.netjavascript:; mailto:fabrice.braz...@apalia.net javascript:; wrote: Hi Saulo, 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 Brazier Le 23 mai 2014 00:14, Saulo Zimbaro saulozimb...@gmail.com javascript:; mailto: saulozimb...@gmail.com javascript:; a écrit : My cloud_usage table still empty. When I start cloudstack-usage I got error bellow: Caused by: java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/cloud?autoReconnect=trueprepStmtCacheSize=517cachePrepStmts=true at java.sql.DriverManager.getConnection(DriverManager.java:635) at java.sql.DriverManager.getConnection(DriverManager.java:195) 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
Re: Cloudstack:: cloud_usage table empty
Hi Saulo, - save mysqldumps of both cloud/cloud_usage Db in case you will have to revert - stop usage server - remove the record from usage_job table for the unprocessed job - start usage server again Regards, Fabrice On Mon, May 26, 2014 at 2:33 PM, Saulo Zimbaro sa...@zimbaro.com wrote: Fabrice, After create link I got another error: 2014-05-26 12:30:00,003 INFO [cloud.usage.UsageManagerImpl] (Usage-Job-1:null) starting usage job... 2014-05-26 12:30:00,009 DEBUG [cloud.usage.UsageManagerImpl] (Usage-Job-1:null) Not owner of usage job, skipping... 2014-05-26 12:30:00,010 INFO [cloud.usage.UsageManagerImpl] (Usage-Job-1:null) usage job complete How can I fix this? -- *Saulo Zimbaro* Mobile ) (+55) 21 99800-0100 *saulozimb...@gmail.com *sa...@zimbaro.com 2014-05-25 14:30 GMT-03:00 Diego Spinola Castro spinolacas...@gmail.com: i have a similar issue but only network usage is empty (types 4 and 5). does anybody have seen that? 2014-05-23 23:53 GMT-03:00 Pierre-Luc Dion pd...@cloudops.com: I've fixed this issue on centos by installing java-1.6.0 yum install java-1.6.0 Le vendredi 23 mai 2014, Hollman Enciso R. hollman.enc...@gmail.com a écrit : Any idea with this error ? Starting CloudStack Usage Monitor cloudstack-usage23/05/2014 15:15:22 7 jsvc error: Cannot locate Java Home cat: /var/run/cloudstack-usage.pid: No such file or directory [FAILED] It's show starting the daemon cloudstack-usage. On Thu, May 22, 2014 at 11:37 PM, Rajani Karuturi rajani.karut...@citrix.com javascript:; wrote: you might want to look at https://issues.apache.org/jira/browse/CLOUDSTACK-6360 and the commits. ~Rajani On 23-May-2014, at 3:49 am, Fabrice Brazier fabrice.braz...@apalia.netjavascript:; mailto:fabrice.braz...@apalia.net javascript:; wrote: Hi Saulo, 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 Brazier Le 23 mai 2014 00:14, Saulo Zimbaro saulozimb...@gmail.com javascript:; mailto: saulozimb...@gmail.com javascript:; a écrit : My cloud_usage table still empty. When I start cloudstack-usage I got error bellow: Caused by: java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/cloud?autoReconnect=trueprepStmtCacheSize=517cachePrepStmts=true at java.sql.DriverManager.getConnection(DriverManager.java:635) at java.sql.DriverManager.getConnection(DriverManager.java:195) 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) I use cloudstack 4.3 and works fine. -- *Saulo Zimbaro* Mobile ) (+55) 21 99800-0100 *saulozimb...@gmail.com javascript:;mailto: saulozimb...@gmail.com javascript:; *sa...@zimbaro.com javascript:;mailto:sa...@zimbaro.com javascript:; -- Hollman Eduardo Enciso R. http://nexxuz.com http://algolibre.com @hollman -- Pierre-Luc Dion Architecte de Solution Cloud | Cloud Solutions Architect 855-OK-CLOUD (855-652-5683) x1101 - - - *CloudOps*420 rue Guy Montréal QC H3J 1S6 www.cloudops.com @CloudOps_ -- Fabrice Brazier *Apalia*™ FR: +33-632-73-53-00 *http://www.apalia.net http://www.apalia.net fabrice.braz...@apalia.net fabrice.braz...@apalia.net*
Re: Cloudstack:: cloud_usage table empty
Hi Saulo, 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 Brazier Le 23 mai 2014 00:14, Saulo Zimbaro saulozimb...@gmail.com a écrit : My cloud_usage table still empty. When I start cloudstack-usage I got error bellow: Caused by: java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/cloud?autoReconnect=trueprepStmtCacheSize=517cachePrepStmts=true at java.sql.DriverManager.getConnection(DriverManager.java:635) at java.sql.DriverManager.getConnection(DriverManager.java:195) 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) I use cloudstack 4.3 and works fine. -- *Saulo Zimbaro* Mobile ) (+55) 21 99800-0100 *saulozimb...@gmail.com *sa...@zimbaro.com
RHEV with CloudStack
Hi Folks, Do you know if RedHat Enterprise Virtualization (RHEV) based on KVM is supported by CloudStack ? Thanks, Fabrice
Vmware - change virtual hardware version
Hi Folks, With VMware ESXi 5.1, CloudStack is provisioning all VMs with virtual hardware version “vmx-09”. Is there a way to use version 7 or 8? Even forcing the vSphere cluster to use the version 8, all VMs are deployed from CloudStack with the vmx-09 version. Thanks for your help, Fabrice
reopened - CS failed after changing vcenter password
Hi All, I'm using CloudStack 3.0.2. I need to update the vCenter password for every hosts in the zone. I tried using API updateHostPassword: http://download.cloud.com/releases/3.0.0/api_3.0.0/root_admin/updateHostPassword.html http://wiki.cloudstack.org/pages/viewpage.action?pageId=14322288 Everytime the same result: errorcode431/errorcode cserrorcode4490/cserrorcode errortextThis operation is not supported for this hypervisor type/errortext I tried to manually update the cluster_details table but the previous password is still used (I can see the old password first letter in the cloud-management log file after restarting cloud-management service). Does someone know the correct process for VMware ? Thanks, Fabrice -Message d'origine- De : Koushik Das [mailto:koushik@citrix.com] Envoyé : lundi 25 février 2013 18:54 À : cloudstack-us...@incubator.apache.org; 'asicando' Objet : RE: CS failed after changing vcenter password One way is to update the vcenter password stored in CS db. Check cluster_details table. -Original Message- From: Jerry Jiang [mailto:jerry.ji...@tyxtech.com] Sent: Monday, February 25, 2013 3:25 PM To: cloudstack-us...@incubator.apache.org; 'asicando' Subject: CS failed after changing vcenter password Hello all, Assumed I am using CS to manage vCenter host, if I changed vCenter password from vcenter's UI. I found CS have to delete and re-add the vcenter back into CS. But I can't operate the instances because UUID modified. How can I handle this situation? Thanks Jerry Jiang