Mailing-List: contact issues-help@cloudstack.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cloudstack.apache.org
Date: Tue, 29 Nov 2016 11:50:58 +0000 (UTC)
From: "ASF subversion and git services (JIRA)" <jira@apache.org>
To: cloudstack-issues@incubator.apache.org
Message-ID: <JIRA.13023645.1480316301000.388389.1480420258683@Atlassian.JIRA>
In-Reply-To: <JIRA.13023645.1480316301000@Atlassian.JIRA>
References: <JIRA.13023645.1480316301000@Atlassian.JIRA> <JIRA.13023645.1480316301519@arcas>
Subject: [jira] [Commented] (CLOUDSTACK-9624) Incorrect hypervisor mapping
 of guest os Windows 2008 Server R2 (64-bit) on VMware
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Tue, 29 Nov 2016 11:51:00 -0000


    [ https://issues.apache.org/jira/browse/CLOUDSTACK-9624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15705074#comment-15705074 ] 

ASF subversion and git services commented on CLOUDSTACK-9624:
-------------------------------------------------------------

Commit d7ff6b75f0e89bcfc0f9f51cb2677eeb157b429f in cloudstack's branch refs/heads/master from [~sateeshc]
[ https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;h=d7ff6b7 ]

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';


> 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)