<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
We have changed resources names (images, networks, clusters,
templates) and datastores location correctly using a MySQL editor
with opennebula stopped.<br>
<br>
Thank you very much for your help,<br>
Best Regards,<br>
Alberto Picón<br>
<br>
<blockquote cite="mid:512406F3.2050907@picon-networks.com"
type="cite"> <br>
El 19/02/2013 14:51, Carlos Martín Sánchez escribió:
<blockquote
cite="mid:CAEPYvFJxLRqcn2OgY=sUk=soZUZqwcQh85EcvHK7XaWpS353UA@mail.gmail.com"
type="cite">All the information is read from the DB, so yes,
it's possible to change anything you want.
<div>But there are lots of connections between different
resources. For example a VM stores in its xml body not only
the host id, but also the hostname, VMM driver...</div>
<div><br>
</div>
<div>I wouldn't edit the DB, but if you do, make sure you keep a
backup and use onedb fsck tool [1] to fix *some*
inconsistencies.</div>
<div><br>
</div>
<div>I wonder why do you need to change the IDs, is it something
we should support for some reason?</div>
<div><br>
</div>
<div>Regards</div>
<div><br>
</div>
<div>[1] <a moz-do-not-send="true"
href="http://opennebula.org/documentation:rel3.8:onedb">http://opennebula.org/documentation:rel3.8:onedb</a><br
clear="all">
<div>--<br>
Carlos Martín, MSc<br>
Project Engineer<br>
OpenNebula - The Open-source Solution for Data Center
Virtualization
<div><span
style="border-collapse:collapse;color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px"><a
moz-do-not-send="true"
href="http://www.OpenNebula.org" target="_blank">www.OpenNebula.org</a>
| <a moz-do-not-send="true"
href="mailto:cmartin@opennebula.org" target="_blank">cmartin@opennebula.org</a>
| <a moz-do-not-send="true"
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"></span></div>
</div>
<br>
<br>
<div class="gmail_quote">On Tue, Feb 19, 2013 at 2:25 PM,
Vassilis Vatikiotis <span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:vatikiot@iit.demokritos.gr" target="_blank">vatikiot@iit.demokritos.gr</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex"> Hello,<br>
<br>
regarding your answer, is it possible to also change, in
the DB,<br>
resources IDs? Of course, within the DB, the IDs have to
be consistent<br>
so that relationships do not break. Assuming that DB
consistency is<br>
maintained, would this be possilbe?<br>
<div class="HOEnZb">
<div class="h5"><br>
On Tue, Feb 19, 2013 at 2:30 PM, Carlos Martín Sánchez<br>
<<a moz-do-not-send="true"
href="mailto:cmartin@opennebula.org">cmartin@opennebula.org</a>>
wrote:<br>
> Did you stop opennebula before touching the DB?<br>
> Otherwise, you will get the list output from the
DB, and the individual info<br>
> from the cache. This cached information will
eventually replace the data in<br>
> the DB.<br>
><br>
> Regards<br>
> --<br>
> Carlos Martín, MSc<br>
> Project Engineer<br>
> OpenNebula - The Open-source Solution for Data
Center Virtualization<br>
> <a moz-do-not-send="true"
href="http://www.OpenNebula.org" target="_blank">www.OpenNebula.org</a>
| <a moz-do-not-send="true"
href="mailto:cmartin@opennebula.org">cmartin@opennebula.org</a>
| @OpenNebula<br>
><br>
><br>
> On Tue, Feb 19, 2013 at 12:27 PM, Alberto Picón
Couselo <<a moz-do-not-send="true"
href="mailto:alpicon1@gmail.com">alpicon1@gmail.com</a>><br>
> wrote:<br>
>><br>
>> Hi, there.<br>
>><br>
>> We would like to change names of resources,
for instance, image names<br>
>> or cluster names.<br>
>><br>
>> For example, we have changed image name
information directly in MySQL<br>
>> database, changing NAME column and BODY
column from image_pool table.<br>
>> However, SunStone shows the changes
partially. Image data seems to be<br>
>> changed in row view, but when we click over
it, image details shows<br>
>> older information.<br>
>><br>
>> We have similar results if we try to change
image datastore<br>
>> information. We need to change an image from
one datastore to another<br>
>> without reregistering it. If we change
image_pool, datastore<br>
>> information, SOURCE, DATASTORE_ID, DATASTORE,
tags, Sunstone updates<br>
>> the information partially...<br>
>><br>
>> Please, can you give us any clue to rename
resources?<br>
>><br>
>> Best Regards,<br>
>> Alberto Picón<br>
>>
_______________________________________________<br>
>> Users mailing list<br>
>> <a moz-do-not-send="true"
href="mailto:Users@lists.opennebula.org">Users@lists.opennebula.org</a><br>
>> <a moz-do-not-send="true"
href="http://lists.opennebula.org/listinfo.cgi/users-opennebula.org"
target="_blank">http://lists.opennebula.org/listinfo.cgi/users-opennebula.org</a><br>
><br>
><br>
><br>
> _______________________________________________<br>
> Users mailing list<br>
> <a moz-do-not-send="true"
href="mailto:Users@lists.opennebula.org">Users@lists.opennebula.org</a><br>
> <a moz-do-not-send="true"
href="http://lists.opennebula.org/listinfo.cgi/users-opennebula.org"
target="_blank">http://lists.opennebula.org/listinfo.cgi/users-opennebula.org</a><br>
><br>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
</blockquote>
</body>
</html>