I went digging into CLOUDSTACK-1842, and I see the following:
In looking at the SQL scripts, I see that the guest_os and
guest_os_hypervisor tables are typically populated via the upgrade
scripts during an upgrade.
I also see that templates.sql has the data to populate these tables:
INSERT INTO `cloud`.`guest_os` (id, uuid, category_id, display_name) VALUES
(163, UUID(), 10, 'Ubuntu 12.04 (32-bit)');
INSERT INTO `cloud`.`guest_os` (id, uuid, category_id, display_name) VALUES
(164, UUID(), 10, 'Ubuntu 12.04 (64-bit)');
and for VMware:
INSERT INTO `cloud`.`guest_os_hypervisor` (hypervisor_type, guest_os_name,
guest_os_id) VALUES ("VmWare", 'Ubuntu 12.04 (32-bit)', 162);
INSERT INTO `cloud`.`guest_os_hypervisor` (hypervisor_type, guest_os_name,
guest_os_id) VALUES ("VmWare", 'Ubuntu 12.04 (64-bit)', 163);
Nothing is in templates.sql for Ubuntu 12.04 on KVM, and no Ubuntu
(any version) for XenServer. Is this right? Also, should we
populate Ubuntu 12.04 into guest_os and guest_os_hypervisor via the
40to41 upgrade script?
-chip