[Spacewalk-list] Child channel subscriptions of migrated KVM nodes

[Benedetto Vassallo]

Def. Quota James Hogarth <james.hogarth at gmail.com>:

> 2010/8/25 Benedetto Vassallo <vassallo at unipa.it>:
>>
>> Def. Quota James Hogarth <james.hogarth at gmail.com>:
>>
>>> I was the one who tweaked my DB - if you want the info I can post it
>>> (it is simple data changes to one table) and it is pretty easy to
>>> script with virsh/sqlplus/spacecmd all available....
>>>
>>> james
>>
>> Please I want to know how tweak the DB.
>> If you want you can send it on my e-mail address.
>> Thank you.
>>
>
> You need some way to interact with the Oracle database - either
> SQLPlus or via the web interface at http://youroracleserver:9000/apex
>
> The table that you need to alter is RHNVIRTUALINSTANCE
>
> You should carry out a rhn-profile-sync on the virtual host before
> modifiying/viewing this.
>
> Host System ID is the spacewalk ID of your virtual host servers -
> lookup the correct one from your systems page.
> Virtual System ID and UUID are the two entries you are interested in.
> Check the UUID for the guest that is not mapped correctly:
> virsh domuuid <guestname>
> You then need to edit (or in SQL terms UPDATE) the matching record in
> the RHNVIRTUALINSTANCE table.
> At this point the relevant UUID should have '-' for the Virtual System
> ID if that guest is not recognised as fully virtualised yet.
> Verify that the Host System ID matches the server you expect.
> Change the '-' to the Spacewalk System ID of the guest system.
> Check your guest now in Spacewalk and it should show as fully
> virtualised and on the virtualisation tab of the host should have a
> clickable link showing your guest.
>
> Not too tricky and knowing the above (if you have a lot of systems)
> you should be able to script fairly easily to create a list of UUIDs
> versus Spacewalk System IDs to create an appropriate SQL statement...
>
> The above info is supplied without warranty and YMMV ... all I can say
> is worked for me on 50 odd guests over 8 hosts ;)
>
> James
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>

Thank you for the tip, but my problem was a little different becouse  
when I issued

SELECT ID,HOST_SYSTEM_ID,VIRTUAL_SYSTEM_ID,UUID FROM  
RHNVIRTUALINSTANCE WHERE UUID='<my-system-uuid>';

I saw there was the right UUID but no VIRTUAL_SYSTEM_ID set, so I  
picked the system ID from the spacewalk web interface and issued

UPDATE RHNVIRTUALINSTANCE SET VIRTUAL_SYSTEM_ID=<spacewalk-system-id>  
WHERE ID=<id>;

COMMIT;

and now I have the system correctly displayed as a fully-virtualized  
system in the right host system.

If someone have the same problem (a virtualized guest system displayed  
as a real system) this is another way to correct it.

-- 
Benedetto Vassallo
Sistema Informativo di Ateneo
Settore Gestione Reti Hardware e Software
U.O. Sviluppo e manutenzione dei sistemi
Università degli studi di Palermo

Red Hat Certified Engineer Certificate Number: 804007793324656

Phone: +3909123860056
Fax: +390916529124

---------------------------------------------------------------------------
Il tuo 5x1000 all'Università degli Studi di Palermo
Per informazioni: http://portale.unipa.it/home/5x1000/

---------------------------------------------------------------------------
AVVERTENZE AI SENSI DEL DLGS 196/2003

Le informazioni contenute in questo messaggio di posta elettronica e/o
nel/i file/s allegato/i, sono da considerarsi strettamente riservate. Il
loro utilizzo è consentito  esclusivamente al destinatario del messaggio,
per le finalità indicate nel messaggio stesso. Qualora riceveste questo
messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
darcene notizia via e-mail e di  procedere alla distruzione del messaggio
stesso, cancellandolo dal Vostro sistema;
costituisce comportamento contrario ai principi dettati dal Dlgs. 196/2003
il  trattenere il messaggio stesso, divulgarlo anche in parte, distribuirlo
ad altri  soggetti, copiarlo, od utilizzarlo per finalità diverse.
Un corretto comportamento da parte di tutti contribuirà a realizzare
una società più civile. Grazie.
-------------------------------------------------------------------------
This message was sent using the University of Palermo web mail interface.