[ https://issues.apache.org/jira/browse/CLOUDSTACK-9624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15705068#comment-15705068 ]
ASF subversion and git services commented on CLOUDSTACK-9624: ------------------------------------------------------------- Commit bef2236d33007e5ca3527bce144200a5ed525a34 in cloudstack's branch refs/heads/4.9 from [~rohit.ya...@shapeblue.com] [ https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;h=bef2236 ] Merge pull request #1793 from sateesh-chodapuneedi/pr-cs-9624 CLOUDSTACK-9624 Incorrect hypervisor mapping of guest os Windows 2008 Server R2 (64-bit) for VMware**JIRA ticket** 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'; After running above query, the 6 updated rows looks like 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'; Query OK, 6 rows affected (0.01 sec) Rows matched: 6 Changed: 6 Warnings: 0 mysql> select * from guest_os_hypervisor 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'; +------+-----------------+-----------------------+-------------+--------------------+--------------------------------------+---------------------+---------+-----------------+ | id | hypervisor_type | guest_os_name | guest_os_id | hypervisor_version | uuid | created | removed | is_user_defined | +------+-----------------+-----------------------+-------------+--------------------+--------------------------------------+---------------------+---------+-----------------+ | 1307 | VMware | windows7Server64Guest | 54 | 4.0 | 98fce372-b271-11e6-b56b-4e61adb7c6b1 | 2016-11-24 23:42:44 | NULL | 0 | | 1448 | VMware | windows7Server64Guest | 54 | 4.1 | 990abdcc-b271-11e6-b56b-4e61adb7c6b1 | 2016-11-24 23:42:45 | NULL | 0 | | 1589 | VMware | windows7Server64Guest | 54 | 5.0 | 99166f75-b271-11e6-b56b-4e61adb7c6b1 | 2016-11-24 23:42:45 | NULL | 0 | | 1730 | VMware | windows7Server64Guest | 54 | 5.1 | 9930ff30-b271-11e6-b56b-4e61adb7c6b1 | 2016-11-24 23:42:45 | NULL | 0 | | 1871 | VMware | windows7Server64Guest | 54 | 5.5 | 993acb18-b271-11e6-b56b-4e61adb7c6b1 | 2016-11-24 23:42:45 | NULL | 0 | | 2381 | VMware | windows7Server64Guest | 54 | 6.0 | 9cb53675-b271-11e6-b56b-4e61adb7c6b1 | 2016-11-24 18:12:51 | NULL | 0 | +------+-----------------+-----------------------+-------------+--------------------+--------------------------------------+---------------------+---------+-----------------+ 6 rows in set (0.01 sec) **Tests** Registered a template with Windows 2008 R2 (64-bit) guest OS and deployed an instance from the template. Found that the VM appeared in vCenter with valid guest OS type instead of "Other (64-bit)" shown up before the fix. * pr/1793: CLOUDSTACK-9624 Incorrect hypervisor mapping of guest os Windows 2008 Server R2 (64-bit) for VMware Signed-off-by: Rohit Yadav <rohit.ya...@shapeblue.com> > Incorrect hypervisor mapping of guest os Windows 2008 Server R2 (64-bit) on > VMware > ---------------------------------------------------------------------------------- > > Key: CLOUDSTACK-9624 > URL: https://issues.apache.org/jira/browse/CLOUDSTACK-9624 > Project: CloudStack > Issue Type: Bug > Security Level: Public(Anyone can view this level - this is the > default.) > Components: Management Server > Affects Versions: 4.9.0 > Environment: VMware 6.0, > ACS master commit c6bb8c6f415edae8073f5d28b3a81a2eef372fed > Reporter: Sateesh Chodapuneedi > Assignee: Sateesh Chodapuneedi > Fix For: 4.10.0.0 > > > 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. > The current (4.9) mappings in database looks as below, > {noformat} > mysql> select * from guest_os where display_name like 'windows%2008%r2%64%'; > +----+-------------+------+--------------------------------------+---------------------------------+---------------------+---------+-----------------+ > | id | category_id | name | uuid | > display_name | created | removed | > is_user_defined | > +----+-------------+------+--------------------------------------+---------------------------------+---------------------+---------+-----------------+ > | 54 | 6 | NULL | 94b8ab90-b271-11e6-b56b-4e61adb7c6b1 | Windows > Server 2008 R2 (64-bit) | 2016-11-24 23:42:43 | NULL | 0 | > +----+-------------+------+--------------------------------------+---------------------------------+---------------------+---------+-----------------+ > 1 row in set (0.00 sec) > mysql> select * from guest_os_hypervisor 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'; > +------+-----------------+--------------------+-------------+--------------------+--------------------------------------+---------------------+---------+-----------------+ > | id | hypervisor_type | guest_os_name | guest_os_id | > hypervisor_version | uuid | created > | removed | is_user_defined | > +------+-----------------+--------------------+-------------+--------------------+--------------------------------------+---------------------+---------+-----------------+ > | 1307 | VMware | winLonghorn64Guest | 54 | 4.0 > | 98fce372-b271-11e6-b56b-4e61adb7c6b1 | 2016-11-24 23:42:44 | NULL | > 0 | > | 1448 | VMware | winLonghorn64Guest | 54 | 4.1 > | 990abdcc-b271-11e6-b56b-4e61adb7c6b1 | 2016-11-24 23:42:45 | NULL | > 0 | > | 1589 | VMware | winLonghorn64Guest | 54 | 5.0 > | 99166f75-b271-11e6-b56b-4e61adb7c6b1 | 2016-11-24 23:42:45 | NULL | > 0 | > | 1730 | VMware | winLonghorn64Guest | 54 | 5.1 > | 9930ff30-b271-11e6-b56b-4e61adb7c6b1 | 2016-11-24 23:42:45 | NULL | > 0 | > | 1871 | VMware | winLonghorn64Guest | 54 | 5.5 > | 993acb18-b271-11e6-b56b-4e61adb7c6b1 | 2016-11-24 23:42:45 | NULL | > 0 | > | 2381 | VMware | winLonghorn64Guest | 54 | 6.0 > | 9cb53675-b271-11e6-b56b-4e61adb7c6b1 | 2016-11-24 18:12:51 | NULL | > 0 | > +------+-----------------+--------------------+-------------+--------------------+--------------------------------------+---------------------+---------+-----------------+ > 6 rows in set (0.01 sec) > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)