RE: Feature requests and a feature request: userid field in the vm_instance table
That's great, thanks very much Rohit! Dave >-Original Message- >From: Rohit Yadav [mailto:rohit.ya...@shapeblue.com] >Sent: Monday, February 16, 2015 10:23 >To: users@cloudstack.apache.org >Subject: Re: Feature requests and a feature request: userid field in the >vm_instance table > >Hi Dave, > >I've implemented this feature. Starting from 4.6, the list VM API will >accept "userid" field to list VMs created by a user. In vm_instance >table, a new columen user_id will hold this information. > >More information here: >https://cwiki.apache.org/confluence/display/CLOUDSTACK/Allow+VM+listing+by+ >User+ID > > >On Thursday 13 November 2014 05:06 PM, David Williams wrote: >> Hi all, >> >> Is this mailing list the right place to raise feature requests? If so, I >have a small one. >> >> I think it would be handy if the userid of the user that created a VM was >recorded in the database in the vm_instance table. Currently, the only way >I know of to find the user that deployed a VM is by checking the logs. >There's an owner field in the vm_instance table but this seems to be the >account ID of the account the user belongs to. >> >> By being able to find the user that deployed a VM, it makes VM cleanups >much easier since you know who to contact for each VM. A similar thing in >the other tables for the other resources would be useful too when trying to >cleanup networks and volumes, etc. Also, if this change went ahead, then >the API and GUI could be changed also to show the user details for the VM >when listing the VM's details. >> >> Thanks, >> >> Dave > >-- >Regards, >Rohit Yadav >Software Architect, ShapeBlue >M. +91 8826230892 | rohit.ya...@shapeblue.com >Blog: bhaisaab.org | Twitter: @_bhaisaab >PS. If you see any footer below, I did not add it :) >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 Software Engineering<http://shapeblue.com/cloudstack-software- >engineering/> >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 SA Pty Ltd is >a company registered by The Republic of South Africa and is traded under >license from Shape Blue Ltd. ShapeBlue is a registered trademark.
RE: How to reduce the size of the cloud_usage database
Hi Rohit, Our cloud_usage database dumps are getting large and take quite a while. The cloud_usage database is around 25 GB with more than 86 million rows. I don't know if there are currently performance issues affecting the application. Having a global configuration option which causes the application to delete usage related records that are older than a specifed value would be great. An API would be great too. Thanks, Dave _ From: Rohit Yadav [mailto:rohit.ya...@shapeblue.com] Sent: Tuesday, January 06, 2015 11:22 To: users@cloudstack.apache.org Subject: Re: How to reduce the size of the cloud_usage database Hi David, There is no official way to reduce the size of the cloud_usage database as it gets populated from the cloud database. Can you share why you want to reduce it? Are you're facing any MySQL performance issues? If your DB size is causing problems we could work with you to develop a new (global) configuration option to limit size or an API to limit past/historic data. On Tuesday 06 January 2015 03:36 PM, David Williams wrote: > Hi all, > > Is there an "official" procedure on how to reduce the size of the cloud_usage database? > > Thanks, > > Dave Regards, Rohit Yadav Software Architect, ShapeBlue M. +91 8826230892 | rohit.ya...@shapeblue.com<mailto:rohit.ya...@shapeblue.com> Blog: bhaisaab.org | Twitter: @_bhaisaab PS. If you see any footer below, I did not add it :) 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 Software Engineering<http://shapeblue.com/cloudstack-software-engineering/> 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 SA Pty Ltd is a company registered by The Republic of South Africa and is traded under license from Shape Blue Ltd. ShapeBlue is a registered trademark.
Global setting resourcecount.check.interval default of 0
Hi all, We have noticed that the global setting resourcecount.check.interval has a default of 0 which according to the description, means never run: | category | name | value | description | Advanced | resourcecount.check.interval | 0 | Time (in seconds) to wait before retrying resource count check task. Default is 0 which is to never run the task Does anyone know why this global setting is needed? I mean, why does cloudstack not keep the counts up to date and correct anyway. Does anyone know why the default value is 0 (never run)? Can the default be set to something like 3600 instead of 0 in future releases? Thanks, Dave
How to reduce the size of the cloud_usage database
Hi all, Is there an "official" procedure on how to reduce the size of the cloud_usage database? Thanks, Dave
RE: Feature requests and a feature request: userid field in the vm_instance table
Will do. Thanks, Dave PS we're on 4.3.0. >-Original Message- >From: Nux! [mailto:n...@li.nux.ro] >Sent: Thursday, November 13, 2014 11:42 >To: users@cloudstack.apache.org >Subject: Re: Feature requests and a feature request: userid field in the >vm_instance table > >+1 this, but you may want to send it to the dev list. :-) > >Lucian > >-- >Sent from the Delta quadrant using Borg technology! > >Nux! >www.nux.ro > >- Original Message - >> From: "David Williams" >> To: users@cloudstack.apache.org >> Sent: Thursday, 13 November, 2014 11:36:22 >> Subject: Feature requests and a feature request: userid field in the >vm_instance table > >> Hi all, >> >> Is this mailing list the right place to raise feature requests? If so, I >have a >> small one. >> >> I think it would be handy if the userid of the user that created a VM was >> recorded in the database in the vm_instance table. Currently, the only >way I >> know of to find the user that deployed a VM is by checking the logs. >There's an >> owner field in the vm_instance table but this seems to be the account ID >of the >> account the user belongs to. >> >> By being able to find the user that deployed a VM, it makes VM cleanups >much >> easier since you know who to contact for each VM. A similar thing in the >other >> tables for the other resources would be useful too when trying to cleanup >> networks and volumes, etc. Also, if this change went ahead, then the API >and >> GUI could be changed also to show the user details for the VM when >listing the >> VM's details. >> >> Thanks, >> >> Dave
Feature requests and a feature request: userid field in the vm_instance table
Hi all, Is this mailing list the right place to raise feature requests? If so, I have a small one. I think it would be handy if the userid of the user that created a VM was recorded in the database in the vm_instance table. Currently, the only way I know of to find the user that deployed a VM is by checking the logs. There's an owner field in the vm_instance table but this seems to be the account ID of the account the user belongs to. By being able to find the user that deployed a VM, it makes VM cleanups much easier since you know who to contact for each VM. A similar thing in the other tables for the other resources would be useful too when trying to cleanup networks and volumes, etc. Also, if this change went ahead, then the API and GUI could be changed also to show the user details for the VM when listing the VM's details. Thanks, Dave
Re: cloudmonkey ASCII Characters
Have you tried disabling colors in your cloudmonkey config file. - Original Message - From: Ivan Rodriguez [mailto:ivan...@gmail.com] Sent: Friday, September 19, 2014 03:10 AM Central Europe Standard Time To: cloudstack-us...@incubator.apache.org Subject: cloudmonkey ASCII Characters Hi CloudstackUsers, I'm trying to do a bash script using some of the output coming out from cloudmonkey 5.2 which is coming with a bunch of control characters, does anybody knows if we can set the display to ascii ?? (I've tried ascii doesnt work) or something like that so I can use normal bash to extract data coming from cloudmonkey ? Cheers
