Def. Quota James Hogarth <[email protected]>:
2010/8/25 Benedetto Vassallo <[email protected]>:
Def. Quota James Hogarth <[email protected]>:
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
[email protected]
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.
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
