Re: User Deleted Recover templates and isos

2014-09-22 Thread Nitin Mehta
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

2014-09-19 Thread Geoff Higginbottom
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

2014-09-19 Thread Ivan Rodriguez
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

2014-09-19 Thread Geoff Higginbottom
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

2014-09-19 Thread ilya musayev
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