GitHub user sateesh-chodapuneedi opened a pull request:
https://github.com/apache/cloudstack/pull/1793
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.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/sateesh-chodapuneedi/cloudstack pr-cs-9624
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/cloudstack/pull/1793.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #1793
----
commit b025fa34739f7bd2d197adb1f531572ba6d6bb9e
Author: Sateesh Chodapuneedi <sateesh.chodapune...@accelerite.com>
Date: 2016-11-27T21:54:17Z
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.
----
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---
