<div dir="ltr">Hi,<div><br></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Jun 13, 2014 at 12:12 PM, Leszek Master <span dir="ltr"><<a href="mailto:keksior@gmail.com" target="_blank">keksior@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div dir="ltr">I found it in db at table vm_pool, but can't find xml inside body column. Could you tell me where it is exaclly ?</div>
</blockquote><div><br></div><div>The body columns should be an string containing xml:</div><div><br></div><div>> select body from vm_pool;</div><div><VM><ID>0</ID><UID>0</UID>...........</VM> </div>
<div><div dir="ltr"><br></div><div>Regards</div><div dir="ltr">--<br><div>Carlos Martín, MSc<br>Project Engineer</div><div>OpenNebula - Flexible Enterprise Cloud Made Simple<br><div><span style="border-collapse:collapse;color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px"><a href="http://www.opennebula.org/" target="_blank">www.OpenNebula.org</a> | <a href="mailto:cmartin@opennebula.org" target="_blank">cmartin@opennebula.org</a> | <a href="http://twitter.com/opennebula" target="_blank">@OpenNebula</a></span><span style="border-collapse:collapse;color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px"><a href="mailto:cmartin@opennebula.org" target="_blank" style="color:rgb(42,93,176)"></a></span></div>
</div></div></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div class="gmail_extra"><br>
<div class="gmail_quote">2014-06-12 11:12 GMT+02:00 Carlos Martín Sánchez <span dir="ltr"><<a href="mailto:cmartin@opennebula.org" target="_blank">cmartin@opennebula.org</a>></span>:<div><div class="h5"><br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div dir="ltr">Hi,<br><div class="gmail_extra"><br><div class="gmail_quote">
<div>On Mon, Jun 9, 2014 at 8:44 AM, Leszek Master <span dir="ltr"><<a href="mailto:keksior@gmail.com" target="_blank">keksior@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div dir="ltr">Isn't there any way to change this ? In DB for example?<div>
<br></div><div> I can't recreate this VM it's in production state.</div></div></blockquote><div><br></div></div><div>Well, yes, you can force the state in the DB, but that may lead to some inconsistencies.</div><div>
<br>
</div><div>If you want to give it a try, do the following:</div><div>- stop opennebula, and do a db backup [1]</div><div>- change the vm state to: state 3, lcm_state 3 [2]. This needs to be done in the db table columns, and the xml inside the body column.</div>
<div>- run onedb fsck [3] to fix host allocation and usage quota numbers</div><div><br></div><div>Regards,</div><div>Carlos</div><div><br></div><div>[1] <a href="http://docs.opennebula.org/4.6/administration/references/onedb.html#onedb-backup" target="_blank">http://docs.opennebula.org/4.6/administration/references/onedb.html#onedb-backup</a><br>
</div><div>[2] <a href="http://docs.opennebula.org/4.6/integration/system_interfaces/api.html#schemas-for-virtual-machine" target="_blank">http://docs.opennebula.org/4.6/integration/system_interfaces/api.html#schemas-for-virtual-machine</a><br>
</div><div>[3] <a href="http://docs.opennebula.org/4.6/administration/references/onedb.html#onedb-fsck" target="_blank">http://docs.opennebula.org/4.6/administration/references/onedb.html#onedb-fsck</a><br></div><div>
<div><br></div><div><div dir="ltr">
--<br><div>Carlos Martín, MSc<br>Project Engineer</div><div>OpenNebula - Flexible Enterprise Cloud Made Simple<br><div><span style="border-collapse:collapse;color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px"><a href="http://www.opennebula.org/" target="_blank">www.OpenNebula.org</a> | <a href="mailto:cmartin@opennebula.org" target="_blank">cmartin@opennebula.org</a> | <a href="http://twitter.com/opennebula" target="_blank">@OpenNebula</a></span><span style="border-collapse:collapse;color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px"><a href="mailto:cmartin@opennebula.org" style="color:rgb(42,93,176)" target="_blank"></a></span></div>
</div></div></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div class="gmail_extra"><br>
<div class="gmail_quote">
2014-06-02 10:56 GMT+02:00 Carlos Martín Sánchez <span dir="ltr"><<a href="mailto:cmartin@opennebula.org" target="_blank">cmartin@opennebula.org</a>></span>:<div><div><br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div dir="ltr">Hi,<div><br></div><div class="gmail_extra"><div class="gmail_quote"><div>On Fri, May 23, 2014 at 2:02 PM, Leszek Master <span dir="ltr"><<a href="mailto:keksior@gmail.com" target="_blank">keksior@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div dir="ltr">I've got 1 VM that is in the FAILED state. I've manually got it working and can't get it in the OpenNebula to the running state. How can i do that manually, from cli or db maybe?</div>
</blockquote><div><br></div></div><div>Forcing a VM state is not supported. The only option is to delete --recreate it, but that will clear the current vm disks.</div><div><br></div><div>Regards</div><div>--<br><div>Carlos Martín, MSc<br>
Project Engineer</div><div>OpenNebula - Flexible Enterprise Cloud Made Simple<br><div><span style="border-collapse:collapse;color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px"><a href="http://www.opennebula.org/" target="_blank">www.OpenNebula.org</a> | <a href="mailto:cmartin@opennebula.org" target="_blank">cmartin@opennebula.org</a> | <a href="http://twitter.com/opennebula" target="_blank">@OpenNebula</a></span></div>
</div></div></div></div></div>
</blockquote></div></div></div><br></div>
</blockquote></div></div><br></div></div>
</blockquote></div></div></div><br></div>
</blockquote></div><br></div></div>