Re: Cloudstack:: cloud_usage table empty

2014-05-28 Thread Saulo Zimbaro
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 : > Fabrice, > > Doesnt work. Strange that pid on usage_job table is different that on OS. > > pid on tabl

Re: Cloudstack:: cloud_usage table empty

2014-05-28 Thread Fabrice Brazier
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, skippi

Re: Cloudstack:: cloud_usage table empty

2014-05-26 Thread Nux!
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 /usr/share/cloudstack-usage/

Re: Cloudstack:: cloud_usage table empty

2014-05-26 Thread Saulo Zimbaro
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 : > Hi Saulo, > > - save mysqldumps of both c

Re: Cloudstack:: cloud_usage table empty

2014-05-26 Thread Fabrice Brazier
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 wrote: > Fabrice, > > Afte

Re: Cloudstack:: cloud_usage table empty

2014-05-26 Thread Saulo Zimbaro
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

2014-05-25 Thread Diego Spinola Castro
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 : > 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. a > écrit : > >

Re: Cloudstack:: cloud_usage table empty

2014-05-23 Thread Pierre-Luc Dion
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. 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/ru

Re: Cloudstack:: cloud_usage table empty

2014-05-23 Thread Hollman Enciso R.
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, R

Re: Cloudstack:: cloud_usage table empty

2014-05-22 Thread Rajani Karuturi
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 mailto:fabrice.braz...@apalia.net>> wrote: Hi Saulo, There was an issue with mysql connector. Starting 4.3 mysql connector is no longer bundl

Re: Cloudstack:: cloud_usage table empty

2014-05-22 Thread Fabrice Brazier
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 bein

Cloudstack:: cloud_usage table empty

2014-05-22 Thread Saulo Zimbaro
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=true&prepStmtCacheSize=517&cachePrepStmts=true at java.sql.DriverManager.getConnection(DriverM