I got the point analyzing db.properties file till the end. There are several database connection configurations and I have changed only the first one (# CloudStack database settings).
If you scroll down this file till the end there are more user/password-s like # usage database settings, # awsapi database settings. These lines must also be changed. So it was my mistake not to mention these settings. No I got raw in usage_job table Thanks, Vadim From: Nikolay Kabadjov [mailto:niki...@yahoo.com] Sent: Friday, September 20, 2013 9:47 AM To: Vadim Kimlaychuk; users@cloudstack.apache.org Subject: Re: Usage Server is running but DB is empty Hello Vadim, do you have the usage_job table empty as well? What I did in addition to setting DB properties is changing the following global usage.sanity.check.interval = 1 according to http://www.mail-archive.com/users@cloudstack.apache.org/msg01342.html Best Regards, Niki ________________________________ From: Vadim Kimlaychuk <vadim.kimlayc...@elion.ee<mailto:vadim.kimlayc...@elion.ee>> To: "users@cloudstack.apache.org<mailto:users@cloudstack.apache.org>" <users@cloudstack.apache.org<mailto:users@cloudstack.apache.org>>; Nikolay Kabadjov <niki...@yahoo.com<mailto:niki...@yahoo.com>> Sent: Friday, September 20, 2013 8:53 AM Subject: RE: Usage Server is running but DB is empty The same issue for me. Usage server installed without errors, I have checked /etc/cloudstack/usage/db.properties file and it has correct connection properties, but database is empty. No errors in error log either. Actually I have no log files under /var/log/cloudstack/usage. It is strange isn't it? Vadim -----Original Message----- From: Steven Liang [mailto:stevenliang2...@gmail.com<mailto:stevenliang2...@gmail.com>] Sent: Thursday, September 19, 2013 5:57 PM To: users@cloudstack.apache.org<mailto:users@cloudstack.apache.org>; Nikolay Kabadjov Subject: Re: Usage Server is running but DB is empty Hi Niki, I have the same issue. Could you share how to solve it? Thank you. Steven On Thu, Sep 19, 2013 at 8:24 AM, Nikolay Kabadjov <niki...@yahoo.com<mailto:niki...@yahoo.com>> wrote: > Thanks Stanislav! > The issue is solved. > > It was a matter of missing DB properties configuration. > > Regards, > Niki > > > ________________________________ > From: Stanislav Petrov > <devilfighter1...@gmail.com<mailto:devilfighter1...@gmail.com>> > To: users@cloudstack.apache.org<mailto:users@cloudstack.apache.org> > Cc: Nikolay Kabadjov <niki...@yahoo.com<mailto:niki...@yahoo.com>> > Sent: Thursday, September 19, 2013 2:44 PM > Subject: Re: Usage Server is running but DB is empty > > > Hi, > > Check your db.properties file for access user credentials. This file > is located at /etc/cloudstack/usage/db.properties. > > > On Thu, Sep 19, 2013 at 1:48 PM, Harikrishna Patnala < > harikrishna.patn...@citrix.com<mailto:harikrishna.patn...@citrix.com>> wrote: > > > Hi, > > Did you set the global configuration parameters related to this. > > Link: > > > http://cloudstack.apache.org/docs/en-US/Apache_CloudStack/4.0.2/html/A > dmin_Guide/configure-usage-server.html > > > > -Harikrishna > > > > On 19-Sep-2013, at 12:10 PM, Nikolay Kabadjov > > <niki...@yahoo.com<mailto:niki...@yahoo.com>> wrote: > > > > > Hello, > > > we've built a deb package for the usage server > > cloudstack-usage_4.1.1-0.0.snapshot_all.deb, > > > installed it and started the cloudstack-usage service. > > > But it seems it is not working, I mean there are no logs in > > /var/log/cloudstack/usage, all the tables in cloud_usage are empty.b > > > > > > Any ideas, how to troubleshoot it? > > > > > > Thanks and best regards, > > > Niki > > > > > > > -- > Поздрави, > Станислав Петров >