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,

Re: Cloudstack:: cloud_usage table empty

I did procedure again and work fine. Thanks Fabrice! -- *Saulo Zimbaro* Mobile ) (+55) 21 99800-0100 *saulozimb...@gmail.com *sa...@zimbaro.com 2014-05-26 12:10 GMT-03:00 Saulo Zimbaro sa...@zimbaro.com: Fabrice, Doesnt work. Strange that pid on usage_job table is different that on OS.

Re: Cloudstack:: cloud_usage table empty

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

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:

Re: Cloudstack:: cloud_usage table empty

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, -

Re: Cloudstack:: cloud_usage table empty

On 22.05.2014 23:19, Fabrice Brazier 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

Re: Cloudstack:: cloud_usage table empty

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.

Re: Cloudstack:: cloud_usage table empty

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,

Re: Cloudstack:: cloud_usage table empty

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

Cloudstack:: cloud_usage table empty

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

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

Re: Cloudstack:: cloud_usage table empty

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.netmailto:fabrice.braz...@apalia.net wrote: Hi Saulo, There was an issue with mysql connector. Starting 4.3 mysql