[
https://issues.apache.org/jira/browse/CLOUDSTACK-9624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15701601#comment-15701601
]
ASF GitHub Bot commented on CLOUDSTACK-9624:
--------------------------------------------
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 <[email protected]>
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.
----
> 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)
