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:[email protected]] Sent: Friday, September 20, 2013 9:47 AM To: Vadim Kimlaychuk; [email protected] 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/[email protected]/msg01342.html Best Regards, Niki ________________________________ From: Vadim Kimlaychuk <[email protected]<mailto:[email protected]>> To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>>; Nikolay Kabadjov <[email protected]<mailto:[email protected]>> 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:[email protected]<mailto:[email protected]>] Sent: Thursday, September 19, 2013 5:57 PM To: [email protected]<mailto:[email protected]>; 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 <[email protected]<mailto:[email protected]>> wrote: > Thanks Stanislav! > The issue is solved. > > It was a matter of missing DB properties configuration. > > Regards, > Niki > > > ________________________________ > From: Stanislav Petrov > <[email protected]<mailto:[email protected]>> > To: [email protected]<mailto:[email protected]> > Cc: Nikolay Kabadjov <[email protected]<mailto:[email protected]>> > 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 < > [email protected]<mailto:[email protected]>> 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 > > <[email protected]<mailto:[email protected]>> 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 > > > > > > > -- > Поздрави, > Станислав Петров >
