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 <[email protected]>
Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo
Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/bef2236d
Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/bef2236d
Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/bef2236d
Branch: refs/heads/4.9
Commit: bef2236d33007e5ca3527bce144200a5ed525a34
Parents: a5d5784 d7ff6b7
Author: Rohit Yadav <[email protected]>
Authored: Tue Nov 29 17:19:04 2016 +0530
Committer: Rohit Yadav <[email protected]>
Committed: Tue Nov 29 17:19:06 2016 +0530
----------------------------------------------------------------------
setup/db/db/schema-490to4910.sql | 2 ++
1 file changed, 2 insertions(+)
----------------------------------------------------------------------
