[
https://issues.apache.org/jira/browse/CLOUDSTACK-9624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15701193#comment-15701193
]
Sateesh Chodapuneedi commented on CLOUDSTACK-9624:
--------------------------------------------------
*+Solution+*
Fix is to update incorrect guest_os_name field value in DB table
cloud.guest_os_hypervisor.
Query is
{noformat}
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';
{noformat}
After running above query, the 6 updated rows looks like
{noformat}
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)
{noformat}
> 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)
