You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cloudstack.apache.org by Prakash Rao Banuka <pr...@simplifydc.com> on 2014/05/12 19:47:40 UTC

List Usage Records using Cloud Monkey

Hi:

I installed and configured cloud usage, The records are getting created and are stored in tables (Cloud_usage Database)

I'm issuing the following command in cloud monkey environment.

                >list usagerecords startdate=yyyy-mm-dd enddate=yyyy-mm-dd <enter>

The result is showing as None, but If I check in the Mysql database (cloud_usage) and the table (cloud_usage) , records does exists.

Any Idea Please

Thank you
Prakash


Re: List Usage Records using Cloud Monkey

Posted by Sam Schmit <sa...@appcore.com>.
Prakash,

If you don't have the very latest 4.3, there is a known issue with NPEs
being thrown with usage records.  If a resource was created, generated
usage records, then was destroyed, a NPE would throw if usage records were
requested.

This didn't occur in 4.2, however, so if you're seeing it there it may be a
more involved issue - we have seen issues in the past where we would get
exceptions if service offerings or templates had been removed from the
"cloud" database, if there were any usage entries for those.

Sam



On Tue, May 13, 2014 at 2:51 PM, Prakash Rao Banuka <
prakash.b@simplifydc.com> wrote:

> Hi Sam
>
> We are using 4.3 and 4.2
>
> Thank you
> Prakash
>
>
>
> -----Original Message-----
> From: Sam Schmit [mailto:sam.schmit@appcore.com]
> Sent: Tuesday, May 13, 2014 6:43 PM
> To: dev@cloudstack.apache.org
> Cc: Venkata Suneel Babu Mallela
> Subject: Re: List Usage Records using Cloud Monkey
>
> Prakash,
>
> What version of CS are you using?  We have seen issues with NPEs being
> thrown in 4.3 onward (prior to a fix I have submitted) when there were
> removed VMs.
>
> Sam
>
>
>
> On Mon, May 12, 2014 at 12:47 PM, Prakash Rao Banuka <
> prakash.b@simplifydc.com> wrote:
>
> > Hi:
> >
> > I installed and configured cloud usage, The records are getting
> > created and are stored in tables (Cloud_usage Database)
> >
> > I'm issuing the following command in cloud monkey environment.
> >
> >                 >list usagerecords startdate=yyyy-mm-dd
> > enddate=yyyy-mm-dd <enter>
> >
> > The result is showing as None, but If I check in the Mysql database
> > (cloud_usage) and the table (cloud_usage) , records does exists.
> >
> > Any Idea Please
> >
> > Thank you
> > Prakash
> >
> >
>

Re: List Usage Records using Cloud Monkey

Posted by Venkata Suneel Babu Mallela <su...@simplifydc.com>.
Yes, cloudmonkey is working fine. We are able to list the zones, hosts, apis, etc...

We are using root admin api&secret keys.

We didn't call api using any other methods to get the usagerecords.

Thank you,
Suneel Mallela
Sent from my Sony Xperia™ smartphone

sebgoa <ru...@gmail.com> wrote:


On May 13, 2014, at 9:51 PM, Prakash Rao Banuka <pr...@simplifydc.com> wrote:

> Hi Sam
>
> We are using 4.3 and 4.2
>
> Thank you
> Prakash
>

Couple more questions:

-Does cloudmonkey work for any other command: list zones ? list templates ?
-Are you using keys from a root user ?
-Can you call the listusagerecords api with something else than cloudmonkey and get the expected results ?

>
>
> -----Original Message-----
> From: Sam Schmit [mailto:sam.schmit@appcore.com]
> Sent: Tuesday, May 13, 2014 6:43 PM
> To: dev@cloudstack.apache.org
> Cc: Venkata Suneel Babu Mallela
> Subject: Re: List Usage Records using Cloud Monkey
>
> Prakash,
>
> What version of CS are you using?  We have seen issues with NPEs being thrown in 4.3 onward (prior to a fix I have submitted) when there were removed VMs.
>
> Sam
>
>
>
> On Mon, May 12, 2014 at 12:47 PM, Prakash Rao Banuka < prakash.b@simplifydc.com> wrote:
>
>> Hi:
>>
>> I installed and configured cloud usage, The records are getting
>> created and are stored in tables (Cloud_usage Database)
>>
>> I'm issuing the following command in cloud monkey environment.
>>
>>> list usagerecords startdate=yyyy-mm-dd
>> enddate=yyyy-mm-dd <enter>
>>
>> The result is showing as None, but If I check in the Mysql database
>> (cloud_usage) and the table (cloud_usage) , records does exists.
>>
>> Any Idea Please
>>
>> Thank you
>> Prakash
>>
>>


RE: List Usage Records using Cloud Monkey

Posted by Tariq Iqbal <ta...@shapeblue.com>.
Hi Prakash,

You could try using the CloudStack API (authenticated or unauthenticated) to request the usage records.

For example an unauthenticated API request:

http://<CS_HOST_IP>:8096/client/api?command=listUsageRecords&startdate=YYYY-MM-DD&enddate=YYYY-MM-DD

Best Regards,

Tariq Iqbal

S: +44 20 3603 0540 | M: +447909911600

tariq.iqbal@shapeblue.com | Twitter: @TariqIqbal_

-----Original Message-----
From: sebgoa [mailto:runseb@gmail.com]
Sent: 14 May 2014 08:57
To: dev@cloudstack.apache.org
Cc: Venkata Suneel Babu Mallela
Subject: Re: List Usage Records using Cloud Monkey


On May 13, 2014, at 9:51 PM, Prakash Rao Banuka <pr...@simplifydc.com> wrote:

> Hi Sam
>
> We are using 4.3 and 4.2
>
> Thank you
> Prakash
>

Couple more questions:

-Does cloudmonkey work for any other command: list zones ? list templates ?
-Are you using keys from a root user ?
-Can you call the listusagerecords api with something else than cloudmonkey and get the expected results ?

>
>
> -----Original Message-----
> From: Sam Schmit [mailto:sam.schmit@appcore.com]
> Sent: Tuesday, May 13, 2014 6:43 PM
> To: dev@cloudstack.apache.org
> Cc: Venkata Suneel Babu Mallela
> Subject: Re: List Usage Records using Cloud Monkey
>
> Prakash,
>
> What version of CS are you using?  We have seen issues with NPEs being thrown in 4.3 onward (prior to a fix I have submitted) when there were removed VMs.
>
> Sam
>
>
>
> On Mon, May 12, 2014 at 12:47 PM, Prakash Rao Banuka < prakash.b@simplifydc.com> wrote:
>
>> Hi:
>>
>> I installed and configured cloud usage, The records are getting
>> created and are stored in tables (Cloud_usage Database)
>>
>> I'm issuing the following command in cloud monkey environment.
>>
>>> list usagerecords startdate=yyyy-mm-dd
>> enddate=yyyy-mm-dd <enter>
>>
>> The result is showing as None, but If I check in the Mysql database
>> (cloud_usage) and the table (cloud_usage) , records does exists.
>>
>> Any Idea Please
>>
>> Thank you
>> Prakash
>>
>>

Find out more about ShapeBlue and our range of CloudStack related services

IaaS Cloud Design & Build<http://shapeblue.com/iaas-cloud-design-and-build//>
CSForge – rapid IaaS deployment framework<http://shapeblue.com/csforge/>
CloudStack Consulting<http://shapeblue.com/cloudstack-consultancy/>
CloudStack Infrastructure Support<http://shapeblue.com/cloudstack-infrastructure-support/>
CloudStack Bootcamp Training Courses<http://shapeblue.com/cloudstack-training/>

This email and any attachments to it may be confidential and are intended solely for the use of the individual to whom it is addressed. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Shape Blue Ltd or related companies. If you are not the intended recipient of this email, you must neither take any action based upon its contents, nor copy or show it to anyone. Please contact the sender if you believe you have received this email in error. Shape Blue Ltd is a company incorporated in England & Wales. ShapeBlue Services India LLP is a company incorporated in India and is operated under license from Shape Blue Ltd. Shape Blue Brasil Consultoria Ltda is a company incorporated in Brasil and is operated under license from Shape Blue Ltd. ShapeBlue is a registered trademark.

Re: List Usage Records using Cloud Monkey

Posted by sebgoa <ru...@gmail.com>.
On May 13, 2014, at 9:51 PM, Prakash Rao Banuka <pr...@simplifydc.com> wrote:

> Hi Sam
> 
> We are using 4.3 and 4.2
> 
> Thank you
> Prakash
> 

Couple more questions:

-Does cloudmonkey work for any other command: list zones ? list templates ?
-Are you using keys from a root user ?
-Can you call the listusagerecords api with something else than cloudmonkey and get the expected results ?

> 
> 
> -----Original Message-----
> From: Sam Schmit [mailto:sam.schmit@appcore.com] 
> Sent: Tuesday, May 13, 2014 6:43 PM
> To: dev@cloudstack.apache.org
> Cc: Venkata Suneel Babu Mallela
> Subject: Re: List Usage Records using Cloud Monkey
> 
> Prakash,
> 
> What version of CS are you using?  We have seen issues with NPEs being thrown in 4.3 onward (prior to a fix I have submitted) when there were removed VMs.
> 
> Sam
> 
> 
> 
> On Mon, May 12, 2014 at 12:47 PM, Prakash Rao Banuka < prakash.b@simplifydc.com> wrote:
> 
>> Hi:
>> 
>> I installed and configured cloud usage, The records are getting 
>> created and are stored in tables (Cloud_usage Database)
>> 
>> I'm issuing the following command in cloud monkey environment.
>> 
>>> list usagerecords startdate=yyyy-mm-dd 
>> enddate=yyyy-mm-dd <enter>
>> 
>> The result is showing as None, but If I check in the Mysql database
>> (cloud_usage) and the table (cloud_usage) , records does exists.
>> 
>> Any Idea Please
>> 
>> Thank you
>> Prakash
>> 
>> 


RE: List Usage Records using Cloud Monkey

Posted by Tariq Iqbal <ta...@shapeblue.com>.
Hi Prakash,

You could try using the CloudStack API (authenticated or unauthenticated) to request the usage records.

For example an unauthenticated API request:

http://<CS_HOST_IP>:8096/client/api?command=listUsageRecords&startdate=YYYY-MM-DD&enddate=YYYY-MM-DD

Best Regards,

Tariq Iqbal

S: +44 20 3603 0540 | M: +447909911600

tariq.iqbal@shapeblue.com | Twitter: @TariqIqbal_

-----Original Message-----
From: Prakash Rao Banuka [mailto:prakash.b@simplifydc.com]
Sent: 13 May 2014 20:51
To: dev@cloudstack.apache.org
Cc: Venkata Suneel Babu Mallela
Subject: RE: List Usage Records using Cloud Monkey

Hi Sam

We are using 4.3 and 4.2

Thank you
Prakash



-----Original Message-----
From: Sam Schmit [mailto:sam.schmit@appcore.com]
Sent: Tuesday, May 13, 2014 6:43 PM
To: dev@cloudstack.apache.org
Cc: Venkata Suneel Babu Mallela
Subject: Re: List Usage Records using Cloud Monkey

Prakash,

What version of CS are you using?  We have seen issues with NPEs being thrown in 4.3 onward (prior to a fix I have submitted) when there were removed VMs.

Sam



On Mon, May 12, 2014 at 12:47 PM, Prakash Rao Banuka < prakash.b@simplifydc.com> wrote:

> Hi:
>
> I installed and configured cloud usage, The records are getting
> created and are stored in tables (Cloud_usage Database)
>
> I'm issuing the following command in cloud monkey environment.
>
>                 >list usagerecords startdate=yyyy-mm-dd
> enddate=yyyy-mm-dd <enter>
>
> The result is showing as None, but If I check in the Mysql database
> (cloud_usage) and the table (cloud_usage) , records does exists.
>
> Any Idea Please
>
> Thank you
> Prakash
>
>
Find out more about ShapeBlue and our range of CloudStack related services

IaaS Cloud Design & Build<http://shapeblue.com/iaas-cloud-design-and-build//>
CSForge – rapid IaaS deployment framework<http://shapeblue.com/csforge/>
CloudStack Consulting<http://shapeblue.com/cloudstack-consultancy/>
CloudStack Infrastructure Support<http://shapeblue.com/cloudstack-infrastructure-support/>
CloudStack Bootcamp Training Courses<http://shapeblue.com/cloudstack-training/>

This email and any attachments to it may be confidential and are intended solely for the use of the individual to whom it is addressed. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Shape Blue Ltd or related companies. If you are not the intended recipient of this email, you must neither take any action based upon its contents, nor copy or show it to anyone. Please contact the sender if you believe you have received this email in error. Shape Blue Ltd is a company incorporated in England & Wales. ShapeBlue Services India LLP is a company incorporated in India and is operated under license from Shape Blue Ltd. Shape Blue Brasil Consultoria Ltda is a company incorporated in Brasil and is operated under license from Shape Blue Ltd. ShapeBlue is a registered trademark.

RE: List Usage Records using Cloud Monkey

Posted by Prakash Rao Banuka <pr...@simplifydc.com>.
Hi Sam

We are using 4.3 and 4.2

Thank you
Prakash



-----Original Message-----
From: Sam Schmit [mailto:sam.schmit@appcore.com] 
Sent: Tuesday, May 13, 2014 6:43 PM
To: dev@cloudstack.apache.org
Cc: Venkata Suneel Babu Mallela
Subject: Re: List Usage Records using Cloud Monkey

Prakash,

What version of CS are you using?  We have seen issues with NPEs being thrown in 4.3 onward (prior to a fix I have submitted) when there were removed VMs.

Sam



On Mon, May 12, 2014 at 12:47 PM, Prakash Rao Banuka < prakash.b@simplifydc.com> wrote:

> Hi:
>
> I installed and configured cloud usage, The records are getting 
> created and are stored in tables (Cloud_usage Database)
>
> I'm issuing the following command in cloud monkey environment.
>
>                 >list usagerecords startdate=yyyy-mm-dd 
> enddate=yyyy-mm-dd <enter>
>
> The result is showing as None, but If I check in the Mysql database
> (cloud_usage) and the table (cloud_usage) , records does exists.
>
> Any Idea Please
>
> Thank you
> Prakash
>
>

Re: List Usage Records using Cloud Monkey

Posted by Sam Schmit <sa...@appcore.com>.
Prakash,

What version of CS are you using?  We have seen issues with NPEs being
thrown in 4.3 onward (prior to a fix I have submitted) when there were
removed VMs.

Sam



On Mon, May 12, 2014 at 12:47 PM, Prakash Rao Banuka <
prakash.b@simplifydc.com> wrote:

> Hi:
>
> I installed and configured cloud usage, The records are getting created
> and are stored in tables (Cloud_usage Database)
>
> I'm issuing the following command in cloud monkey environment.
>
>                 >list usagerecords startdate=yyyy-mm-dd enddate=yyyy-mm-dd
> <enter>
>
> The result is showing as None, but If I check in the Mysql database
> (cloud_usage) and the table (cloud_usage) , records does exists.
>
> Any Idea Please
>
> Thank you
> Prakash
>
>

RE: List Usage Records using Cloud Monkey

Posted by Prakash Rao Banuka <pr...@simplifydc.com>.
Hi 


Which version of cloud monkey is this ? And which version of CloudStack are you using ?

Cloud Monkey version 	: 5.0.0
	
CloudStack			: 4.2 and 4.3

Thank you
Pakash
		

-----Original Message-----
From: sebgoa [mailto:runseb@gmail.com] 
Sent: Tuesday, May 13, 2014 2:06 PM
To: dev@cloudstack.apache.org
Subject: Re: List Usage Records using Cloud Monkey


On May 12, 2014, at 7:47 PM, Prakash Rao Banuka <pr...@simplifydc.com> wrote:

> Hi:
> 
> I installed and configured cloud usage, The records are getting created and are stored in tables (Cloud_usage Database)
> 
> I'm issuing the following command in cloud monkey environment.
> 
>> list usagerecords startdate=yyyy-mm-dd enddate=yyyy-mm-dd <enter>
> 
> The result is showing as None, but If I check in the Mysql database (cloud_usage) and the table (cloud_usage) , records does exists.
> 
> Any Idea Please
> 

Which version of cloud monkey is this ? And which version of CloudStack are you using ?

> Thank you
> Prakash
> 


Re: List Usage Records using Cloud Monkey

Posted by sebgoa <ru...@gmail.com>.
On May 12, 2014, at 7:47 PM, Prakash Rao Banuka <pr...@simplifydc.com> wrote:

> Hi:
> 
> I installed and configured cloud usage, The records are getting created and are stored in tables (Cloud_usage Database)
> 
> I'm issuing the following command in cloud monkey environment.
> 
>> list usagerecords startdate=yyyy-mm-dd enddate=yyyy-mm-dd <enter>
> 
> The result is showing as None, but If I check in the Mysql database (cloud_usage) and the table (cloud_usage) , records does exists.
> 
> Any Idea Please
> 

Which version of cloud monkey is this ? And which version of CloudStack are you using ?

> Thank you
> Prakash
>