Oh, but I do need the option to rename my resources via the one* CLI commands. I'll go with GUI sql tool for now.
On Tue, Feb 19, 2013 at 3:59 PM, Vassilis Vatikiotis <vatik...@iit.demokritos.gr> wrote: > On Tue, Feb 19, 2013 at 3:51 PM, Carlos Martín Sánchez > <cmar...@opennebula.org> wrote: >> All the information is read from the DB, so yes, it's possible to change >> anything you want. >> 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... >> >> 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. >> > >> I wonder why do you need to change the IDs, is it something we should >> support for some reason? > Not really, I just needed to confirm that indeed all the resources > info is stored in the DB backed *only*. The other non-reason is that > when I'm feeling pedantic I want, e.g. host3 to have the ID 3. As far > as I'm concerned, I don't need this to be supported. > >> >> Regards >> >> [1] http://opennebula.org/documentation:rel3.8:onedb >> >> -- >> Carlos Martín, MSc >> Project Engineer >> OpenNebula - The Open-source Solution for Data Center Virtualization >> www.OpenNebula.org | cmar...@opennebula.org | @OpenNebula >> >> >> On Tue, Feb 19, 2013 at 2:25 PM, Vassilis Vatikiotis >> <vatik...@iit.demokritos.gr> wrote: >>> >>> Hello, >>> >>> regarding your answer, is it possible to also change, in the DB, >>> resources IDs? Of course, within the DB, the IDs have to be consistent >>> so that relationships do not break. Assuming that DB consistency is >>> maintained, would this be possilbe? >>> >>> On Tue, Feb 19, 2013 at 2:30 PM, Carlos Martín Sánchez >>> <cmar...@opennebula.org> wrote: >>> > Did you stop opennebula before touching the DB? >>> > Otherwise, you will get the list output from the DB, and the individual >>> > info >>> > from the cache. This cached information will eventually replace the data >>> > in >>> > the DB. >>> > >>> > Regards >>> > -- >>> > Carlos Martín, MSc >>> > Project Engineer >>> > OpenNebula - The Open-source Solution for Data Center Virtualization >>> > www.OpenNebula.org | cmar...@opennebula.org | @OpenNebula >>> > >>> > >>> > On Tue, Feb 19, 2013 at 12:27 PM, Alberto Picón Couselo >>> > <alpic...@gmail.com> >>> > wrote: >>> >> >>> >> Hi, there. >>> >> >>> >> We would like to change names of resources, for instance, image names >>> >> or cluster names. >>> >> >>> >> For example, we have changed image name information directly in MySQL >>> >> database, changing NAME column and BODY column from image_pool table. >>> >> However, SunStone shows the changes partially. Image data seems to be >>> >> changed in row view, but when we click over it, image details shows >>> >> older information. >>> >> >>> >> We have similar results if we try to change image datastore >>> >> information. We need to change an image from one datastore to another >>> >> without reregistering it. If we change image_pool, datastore >>> >> information, SOURCE, DATASTORE_ID, DATASTORE, tags, Sunstone updates >>> >> the information partially... >>> >> >>> >> Please, can you give us any clue to rename resources? >>> >> >>> >> Best Regards, >>> >> Alberto Picón >>> >> _______________________________________________ >>> >> Users mailing list >>> >> Users@lists.opennebula.org >>> >> http://lists.opennebula.org/listinfo.cgi/users-opennebula.org >>> > >>> > >>> > >>> > _______________________________________________ >>> > Users mailing list >>> > Users@lists.opennebula.org >>> > http://lists.opennebula.org/listinfo.cgi/users-opennebula.org >>> > >> >> _______________________________________________ Users mailing list Users@lists.opennebula.org http://lists.opennebula.org/listinfo.cgi/users-opennebula.org