Repository: cloudstack Updated Branches: refs/heads/4.9 a5d578485 -> bef2236d3
CLOUDSTACK-9624 Incorrect hypervisor mapping of guest os Windows 2008 Server R2 (64-bit) for VMware Issue Guest OS Windows Server 2008 R2 (64-bit) is being mapped to incorrect guest os at hypervisor, which is winLonghorn64Guest, same as that of Windows Server 2008 (64-bit). Due to this the VM's guest os type was set to "Other (64-bit)", which would not represent the guest OS accurately on hypervisor. Solution Fix is to update incorrect guest_os_name field value in DB table cloud.guest_os_hypervisor. Th query is, UPDATE IGNORE cloud.guest_os_hypervisor SET guest_os_name = 'windows7Server64Guest' WHERE guest_os_id IN (SELECT id FROM guest_os WHERE display_name LIKE 'windows%2008%r2%64%') AND hypervisor_type = 'VMware' AND hypervisor_version != 'default'; Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/d7ff6b75 Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/d7ff6b75 Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/d7ff6b75 Branch: refs/heads/4.9 Commit: d7ff6b75f0e89bcfc0f9f51cb2677eeb157b429f Parents: fd6833b Author: Sateesh Chodapuneedi <[email protected]> Authored: Mon Nov 28 03:50:53 2016 +0530 Committer: Sateesh Chodapuneedi <[email protected]> Committed: Mon Nov 28 03:50:53 2016 +0530 ---------------------------------------------------------------------- setup/db/db/schema-490to4910.sql | 2 ++ 1 file changed, 2 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/cloudstack/blob/d7ff6b75/setup/db/db/schema-490to4910.sql ---------------------------------------------------------------------- diff --git a/setup/db/db/schema-490to4910.sql b/setup/db/db/schema-490to4910.sql index 4ac7bf2..0cb977b 100644 --- a/setup/db/db/schema-490to4910.sql +++ b/setup/db/db/schema-490to4910.sql @@ -50,3 +50,5 @@ INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid,hypervisor_type, hypervis -- Ubuntu 16.04 XenServer guest os mapping INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid,hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(),'Xenserver', '6.5.0', 'Ubuntu Trusty Tahr 14.04', 255, utc_timestamp(), 0); INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid,hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(),'Xenserver', '6.5.0', 'Ubuntu Trusty Tahr 14.04', 256, utc_timestamp(), 0); +-- Ensure correct guest_os_name for guest OS type 'Windows Server 2008 R2 64-bit' for VMware +UPDATE IGNORE `cloud`.`guest_os_hypervisor` SET guest_os_name = 'windows7Server64Guest' WHERE guest_os_id IN (SELECT id FROM guest_os WHERE display_name LIKE 'windows%2008%r2%64%') AND hypervisor_type = 'VMware' AND hypervisor_version != 'default';
