Re: User Deleted Recover templates and isos
I would also recommend altering template_zone_ref (removed field to null) and making the state in vm_template as 'Active'. Last but not the least even if they are gone from secondary storage you can recover the templates from the vms created from templates. On 19/09/14 4:23 PM, ilya musayev ilya.mailing.li...@gmail.com wrote: Assuming the data still resides (you need to check you secondary store), you can alter the removed field for that record and it will bring it back in the UI. Review: SELECT * FROM cloud.vm_template; - alter removed field to null SELECT * FROM cloud.template_store_ref; - local_path for location of the template/iso and alter destroyed field to 0 On 9/19/14, 12:15 AM, Ivan Rodriguez wrote: Hi CloudStack Users, Is there any chance to UNdelete an user and recover all the previous ISOS and templates ? Cheers
Re: User Deleted Recover templates and isos
How long ago were they deleted and what are your expunge intervals Regards Geoff Higginbottom CTO / Cloud Architect D: +44 20 3603 0542tel:+442036030542 | S: +44 20 3603 0540tel:+442036030540 | M: +447968161581tel:+447968161581 geoff.higginbot...@shapeblue.commailto:geoff.higginbot...@shapeblue.com | www.shapeblue.comhtp://www.shapeblue.com/ | Twitter:@cloudstackguruhttps://twitter.com/#!/cloudstackguru ShapeBlue Ltd, 53 Chandos Place, Covent Garden, London, WC2N 4HSx-apple-data-detectors://5 On 19 Sep 2014, at 08:16, Ivan Rodriguez ivan...@gmail.commailto:ivan...@gmail.com wrote: Hi CloudStack Users, Is there any chance to UNdelete an user and recover all the previous ISOS and templates ? Cheers Find out more about ShapeBlue and our range of CloudStack related services IaaS Cloud Design Buildhttp://shapeblue.com/iaas-cloud-design-and-build// CSForge - rapid IaaS deployment frameworkhttp://shapeblue.com/csforge/ CloudStack Consultinghttp://shapeblue.com/cloudstack-consultancy/ CloudStack Infrastructure Supporthttp://shapeblue.com/cloudstack-infrastructure-support/ CloudStack Bootcamp Training Courseshttp://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: User Deleted Recover templates and isos
Like 10 hours ago we have backups but I can see the templates are gonne from secondary storage On Sep 19, 2014 5:33 PM, Geoff Higginbottom geoff.higginbot...@shapeblue.com wrote: How long ago were they deleted and what are your expunge intervals Regards Geoff Higginbottom CTO / Cloud Architect D: +44 20 3603 0542tel:+442036030542 | S: +44 20 3603 0540tel: +442036030540 | M: +447968161581tel:+447968161581 geoff.higginbot...@shapeblue.commailto:geoff.higginbot...@shapeblue.com | www.shapeblue.comhtp://www.shapeblue.com/ | Twitter:@cloudstackguru https://twitter.com/#!/cloudstackguru ShapeBlue Ltd, 53 Chandos Place, Covent Garden, London, WC2N 4HSx-apple-data-detectors://5 On 19 Sep 2014, at 08:16, Ivan Rodriguez ivan...@gmail.commailto: ivan...@gmail.com wrote: Hi CloudStack Users, Is there any chance to UNdelete an user and recover all the previous ISOS and templates ? Cheers 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 frameworkhttp://shapeblue.com/csforge/ CloudStack Consultinghttp://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 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: User Deleted Recover templates and isos
You should be able to restore the templates to sec storage and revert the deletion in the DB by removing the entries from the 'removed' column in the various tables such as account, domain, template etc. Regards Geoff Higginbottom CTO / Cloud Architect D: +44 20 3603 0542tel:+442036030542 | S: +44 20 3603 0540tel:+442036030540 | M: +447968161581tel:+447968161581 geoff.higginbot...@shapeblue.commailto:geoff.higginbot...@shapeblue.com | www.shapeblue.comhtp://www.shapeblue.com/ | Twitter:@cloudstackguruhttps://twitter.com/#!/cloudstackguru ShapeBlue Ltd, 53 Chandos Place, Covent Garden, London, WC2N 4HSx-apple-data-detectors://5 On 19 Sep 2014, at 08:44, Ivan Rodriguez ivan...@gmail.commailto:ivan...@gmail.com wrote: Like 10 hours ago we have backups but I can see the templates are gonne from secondary storage On Sep 19, 2014 5:33 PM, Geoff Higginbottom geoff.higginbot...@shapeblue.commailto:geoff.higginbot...@shapeblue.com wrote: How long ago were they deleted and what are your expunge intervals Regards Geoff Higginbottom CTO / Cloud Architect D: +44 20 3603 0542tel:+442036030542 | S: +44 20 3603 0540tel: +442036030540 | M: +447968161581tel:+447968161581 geoff.higginbot...@shapeblue.commailto:geoff.higginbot...@shapeblue.commailto:geoff.higginbot...@shapeblue.com | www.shapeblue.comhttp://www.shapeblue.comhtp://www.shapeblue.com/ | Twitter:@cloudstackguru https://twitter.com/#!/cloudstackguru ShapeBlue Ltd, 53 Chandos Place, Covent Garden, London, WC2N 4HSx-apple-data-detectors://5 On 19 Sep 2014, at 08:16, Ivan Rodriguez ivan...@gmail.commailto:ivan...@gmail.commailto: ivan...@gmail.commailto:ivan...@gmail.com wrote: Hi CloudStack Users, Is there any chance to UNdelete an user and recover all the previous ISOS and templates ? Cheers 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 frameworkhttp://shapeblue.com/csforge/ CloudStack Consultinghttp://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 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. Find out more about ShapeBlue and our range of CloudStack related services IaaS Cloud Design Buildhttp://shapeblue.com/iaas-cloud-design-and-build// CSForge - rapid IaaS deployment frameworkhttp://shapeblue.com/csforge/ CloudStack Consultinghttp://shapeblue.com/cloudstack-consultancy/ CloudStack Infrastructure Supporthttp://shapeblue.com/cloudstack-infrastructure-support/ CloudStack Bootcamp Training Courseshttp://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: User Deleted Recover templates and isos
Assuming the data still resides (you need to check you secondary store), you can alter the removed field for that record and it will bring it back in the UI. Review: SELECT * FROM cloud.vm_template; - alter removed field to null SELECT * FROM cloud.template_store_ref; - local_path for location of the template/iso and alter destroyed field to 0 On 9/19/14, 12:15 AM, Ivan Rodriguez wrote: Hi CloudStack Users, Is there any chance to UNdelete an user and recover all the previous ISOS and templates ? Cheers