[jira] [Commented] (CLOUDSTACK-9624) Incorrect hypervisor mapping of guest os Windows 2008 Server R2 (64-bit) on VMware
[ https://issues.apache.org/jira/browse/CLOUDSTACK-9624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15705084#comment-15705084 ] ASF GitHub Bot commented on CLOUDSTACK-9624: Github user sateesh-chodapuneedi commented on the issue: https://github.com/apache/cloudstack/pull/1793 Thanks @rhtyd > 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)
[jira] [Commented] (CLOUDSTACK-9624) Incorrect hypervisor mapping of guest os Windows 2008 Server R2 (64-bit) on VMware
[ https://issues.apache.org/jira/browse/CLOUDSTACK-9624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15705076#comment-15705076 ] ASF subversion and git services commented on CLOUDSTACK-9624: - Commit bef2236d33007e5ca3527bce144200a5ed525a34 in cloudstack's branch refs/heads/master from [~rohit.ya...@shapeblue.com] [ https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;h=bef2236 ] 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> 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
[jira] [Commented] (CLOUDSTACK-9624) Incorrect hypervisor mapping of guest os Windows 2008 Server R2 (64-bit) on VMware
[ https://issues.apache.org/jira/browse/CLOUDSTACK-9624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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 |
[jira] [Commented] (CLOUDSTACK-9624) Incorrect hypervisor mapping of guest os Windows 2008 Server R2 (64-bit) on VMware
[ https://issues.apache.org/jira/browse/CLOUDSTACK-9624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15705075#comment-15705075 ] ASF subversion and git services commented on CLOUDSTACK-9624: - Commit bef2236d33007e5ca3527bce144200a5ed525a34 in cloudstack's branch refs/heads/master from [~rohit.ya...@shapeblue.com] [ https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;h=bef2236 ] 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> 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
[jira] [Commented] (CLOUDSTACK-9624) Incorrect hypervisor mapping of guest os Windows 2008 Server R2 (64-bit) on VMware
[ https://issues.apache.org/jira/browse/CLOUDSTACK-9624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15705077#comment-15705077 ] ASF subversion and git services commented on CLOUDSTACK-9624: - Commit bef2236d33007e5ca3527bce144200a5ed525a34 in cloudstack's branch refs/heads/master from [~rohit.ya...@shapeblue.com] [ https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;h=bef2236 ] 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> 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
[jira] [Commented] (CLOUDSTACK-9624) Incorrect hypervisor mapping of guest os Windows 2008 Server R2 (64-bit) on VMware
[ https://issues.apache.org/jira/browse/CLOUDSTACK-9624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15705070#comment-15705070 ] ASF subversion and git services commented on CLOUDSTACK-9624: - Commit bef2236d33007e5ca3527bce144200a5ed525a34 in cloudstack's branch refs/heads/4.9 from [~rohit.ya...@shapeblue.com] [ https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;h=bef2236 ] 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> 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
[jira] [Commented] (CLOUDSTACK-9624) Incorrect hypervisor mapping of guest os Windows 2008 Server R2 (64-bit) on VMware
[ https://issues.apache.org/jira/browse/CLOUDSTACK-9624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15705069#comment-15705069 ] ASF subversion and git services commented on CLOUDSTACK-9624: - Commit bef2236d33007e5ca3527bce144200a5ed525a34 in cloudstack's branch refs/heads/4.9 from [~rohit.ya...@shapeblue.com] [ https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;h=bef2236 ] 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> 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
[jira] [Commented] (CLOUDSTACK-9624) Incorrect hypervisor mapping of guest os Windows 2008 Server R2 (64-bit) on VMware
[ https://issues.apache.org/jira/browse/CLOUDSTACK-9624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15705067#comment-15705067 ] ASF subversion and git services commented on CLOUDSTACK-9624: - Commit d7ff6b75f0e89bcfc0f9f51cb2677eeb157b429f in cloudstack's branch refs/heads/4.9 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 |
[jira] [Commented] (CLOUDSTACK-9624) Incorrect hypervisor mapping of guest os Windows 2008 Server R2 (64-bit) on VMware
[ https://issues.apache.org/jira/browse/CLOUDSTACK-9624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15705068#comment-15705068 ] ASF subversion and git services commented on CLOUDSTACK-9624: - Commit bef2236d33007e5ca3527bce144200a5ed525a34 in cloudstack's branch refs/heads/4.9 from [~rohit.ya...@shapeblue.com] [ https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;h=bef2236 ] 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> 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
[jira] [Commented] (CLOUDSTACK-9624) Incorrect hypervisor mapping of guest os Windows 2008 Server R2 (64-bit) on VMware
[ https://issues.apache.org/jira/browse/CLOUDSTACK-9624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15705073#comment-15705073 ] ASF GitHub Bot commented on CLOUDSTACK-9624: Github user asfgit closed the pull request at: https://github.com/apache/cloudstack/pull/1793 > 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)
[jira] [Commented] (CLOUDSTACK-9624) Incorrect hypervisor mapping of guest os Windows 2008 Server R2 (64-bit) on VMware
[ https://issues.apache.org/jira/browse/CLOUDSTACK-9624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15705062#comment-15705062 ] ASF GitHub Bot commented on CLOUDSTACK-9624: Github user rhtyd commented on the issue: https://github.com/apache/cloudstack/pull/1793 Thanks @sateesh-chodapuneedi I'll merge this now. > 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)
[jira] [Commented] (CLOUDSTACK-9624) Incorrect hypervisor mapping of guest os Windows 2008 Server R2 (64-bit) on VMware
[ https://issues.apache.org/jira/browse/CLOUDSTACK-9624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15704899#comment-15704899 ] ASF GitHub Bot commented on CLOUDSTACK-9624: Github user sateesh-chodapuneedi commented on the issue: https://github.com/apache/cloudstack/pull/1793 @rhtyd Yes, that's correct. The guest_os_name `windows7Server64Guest` is supported since vSphere 4.0 onwards. I've verified this in 5.0 as well as 6.0 setup. > 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)
[jira] [Commented] (CLOUDSTACK-9624) Incorrect hypervisor mapping of guest os Windows 2008 Server R2 (64-bit) on VMware
[ https://issues.apache.org/jira/browse/CLOUDSTACK-9624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15704615#comment-15704615 ] ASF GitHub Bot commented on CLOUDSTACK-9624: Github user rhtyd commented on the issue: https://github.com/apache/cloudstack/pull/1793 @sateesh-chodapuneedi is the guest_os_name `windows7Server64Guest` known by vmware versions 4.x, 5.x? The sql update will change guest_os_name for vmware versions 4.0, 4.1, 5.0, 5.1, 5.5 and 6.0. > 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)
[jira] [Commented] (CLOUDSTACK-9624) Incorrect hypervisor mapping of guest os Windows 2008 Server R2 (64-bit) on VMware
[ https://issues.apache.org/jira/browse/CLOUDSTACK-9624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15704604#comment-15704604 ] ASF GitHub Bot commented on CLOUDSTACK-9624: Github user rhtyd commented on the issue: https://github.com/apache/cloudstack/pull/1793 Test LGTM. One of the travis jobs took time while uploading the cache, but it passed all component tests: https://travis-ci.org/apache/cloudstack/jobs/179401939 Since, it's a simple fix and all regression tests pass, I'll merge this. > 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)
[jira] [Commented] (CLOUDSTACK-9624) Incorrect hypervisor mapping of guest os Windows 2008 Server R2 (64-bit) on VMware
[ https://issues.apache.org/jira/browse/CLOUDSTACK-9624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15703367#comment-15703367 ] ASF GitHub Bot commented on CLOUDSTACK-9624: Github user blueorangutan commented on the issue: https://github.com/apache/cloudstack/pull/1793 Trillian test result (tid-476) Environment: vmware-55u3 (x2), Advanced Networking with Mgmt server 7 Total time taken: 37204 seconds Marvin logs: https://github.com/blueorangutan/acs-prs/releases/download/trillian/pr1793-t476-vmware-55u3.zip Test completed. 44 look ok, 4 have error(s) Test | Result | Time (s) | Test File --- | --- | --- | --- test_router_dhcp_opts | `Failure` | 21.20 | test_router_dhcphosts.py test_01_vpc_site2site_vpn | `Error` | 537.56 | test_vpc_vpn.py test_01_redundant_vpc_site2site_vpn | `Error` | 739.82 | test_vpc_vpn.py test_03_create_redundant_VPC_1tier_2VMs_2IPs_2PF_ACL_reboot_routers | `Error` | 628.04 | test_vpc_redundant.py test_09_reboot_router | `Error` | 191.29 | test_routers.py test_01_vpc_remote_access_vpn | Success | 217.83 | test_vpc_vpn.py test_02_VPC_default_routes | Success | 367.90 | test_vpc_router_nics.py test_01_VPC_nics_after_destroy | Success | 760.10 | test_vpc_router_nics.py test_05_rvpc_multi_tiers | Success | 693.21 | test_vpc_redundant.py test_04_rvpc_network_garbage_collector_nics | Success | 1545.51 | test_vpc_redundant.py test_02_redundant_VPC_default_routes | Success | 762.69 | test_vpc_redundant.py test_01_create_redundant_VPC_2tiers_4VMs_4IPs_4PF_ACL | Success | 1452.53 | test_vpc_redundant.py test_09_delete_detached_volume | Success | 26.25 | test_volumes.py test_06_download_detached_volume | Success | 55.55 | test_volumes.py test_05_detach_volume | Success | 105.30 | test_volumes.py test_04_delete_attached_volume | Success | 10.21 | test_volumes.py test_03_download_attached_volume | Success | 20.73 | test_volumes.py test_02_attach_volume | Success | 63.84 | test_volumes.py test_01_create_volume | Success | 525.28 | test_volumes.py test_03_delete_vm_snapshots | Success | 275.26 | test_vm_snapshots.py test_02_revert_vm_snapshots | Success | 237.31 | test_vm_snapshots.py test_01_test_vm_volume_snapshot | Success | 151.40 | test_vm_snapshots.py test_01_create_vm_snapshots | Success | 161.71 | test_vm_snapshots.py test_deploy_vm_multiple | Success | 203.59 | test_vm_life_cycle.py test_deploy_vm | Success | 0.03 | test_vm_life_cycle.py test_advZoneVirtualRouter | Success | 0.02 | test_vm_life_cycle.py test_10_attachAndDetach_iso | Success | 26.82 | test_vm_life_cycle.py test_09_expunge_vm | Success | 125.22 | test_vm_life_cycle.py test_08_migrate_vm | Success | 136.60 | test_vm_life_cycle.py test_07_restore_vm | Success | 0.10 | test_vm_life_cycle.py test_06_destroy_vm | Success | 10.16 | test_vm_life_cycle.py test_03_reboot_vm | Success | 5.16 | test_vm_life_cycle.py test_02_start_vm | Success | 20.25 | test_vm_life_cycle.py test_01_stop_vm | Success | 10.19 | test_vm_life_cycle.py test_CreateTemplateWithDuplicateName | Success | 267.13 | test_templates.py test_08_list_system_templates | Success | 0.03 | test_templates.py test_07_list_public_templates | Success | 0.04 | test_templates.py test_05_template_permissions | Success | 0.06 | test_templates.py test_04_extract_template | Success | 25.41 | test_templates.py test_03_delete_template | Success | 5.14 | test_templates.py test_02_edit_template | Success | 90.21 | test_templates.py test_01_create_template | Success | 146.19 | test_templates.py test_10_destroy_cpvm | Success | 211.92 | test_ssvm.py test_09_destroy_ssvm | Success | 208.90 | test_ssvm.py test_08_reboot_cpvm | Success | 156.65 | test_ssvm.py test_07_reboot_ssvm | Success | 218.70 | test_ssvm.py test_06_stop_cpvm | Success | 166.86 | test_ssvm.py test_05_stop_ssvm | Success | 173.94 | test_ssvm.py test_04_cpvm_internals | Success | 1.23 | test_ssvm.py test_03_ssvm_internals | Success | 3.45 | test_ssvm.py test_02_list_cpvm_vm | Success | 0.14 | test_ssvm.py test_01_list_sec_storage_vm | Success | 0.16 | test_ssvm.py test_01_snapshot_root_disk | Success | 26.48 | test_snapshots.py test_04_change_offering_small | Success | 97.02 | test_service_offerings.py test_03_delete_service_offering | Success | 0.04 | test_service_offerings.py test_02_edit_service_offering | Success | 0.09 | test_service_offerings.py test_01_create_service_offering | Success | 0.13 | test_service_offerings.py test_02_sys_template_ready | Success | 0.14 | test_secondary_storage.py test_01_sys_vm_start | Success | 0.22 | test_secondary_storage.py test_08_start_router | Success | 120.88 | test_routers.py test_07_stop_router | Success |
[jira] [Commented] (CLOUDSTACK-9624) Incorrect hypervisor mapping of guest os Windows 2008 Server R2 (64-bit) on VMware
[ https://issues.apache.org/jira/browse/CLOUDSTACK-9624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15701837#comment-15701837 ] ASF GitHub Bot commented on CLOUDSTACK-9624: Github user blueorangutan commented on the issue: https://github.com/apache/cloudstack/pull/1793 @rhtyd a Trillian-Jenkins test job (centos7 mgmt + vmware-55u3) has been kicked to run smoke tests > 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)
[jira] [Commented] (CLOUDSTACK-9624) Incorrect hypervisor mapping of guest os Windows 2008 Server R2 (64-bit) on VMware
[ https://issues.apache.org/jira/browse/CLOUDSTACK-9624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15701835#comment-15701835 ] ASF GitHub Bot commented on CLOUDSTACK-9624: Github user rhtyd commented on the issue: https://github.com/apache/cloudstack/pull/1793 @blueorangutan test centos7 vmware-55u3 > 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)
[jira] [Commented] (CLOUDSTACK-9624) Incorrect hypervisor mapping of guest os Windows 2008 Server R2 (64-bit) on VMware
[ https://issues.apache.org/jira/browse/CLOUDSTACK-9624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15701819#comment-15701819 ] ASF GitHub Bot commented on CLOUDSTACK-9624: Github user blueorangutan commented on the issue: https://github.com/apache/cloudstack/pull/1793 Packaging result: ✔centos6 ✔centos7 ✔debian. JID-273 > 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)
[jira] [Commented] (CLOUDSTACK-9624) Incorrect hypervisor mapping of guest os Windows 2008 Server R2 (64-bit) on VMware
[ https://issues.apache.org/jira/browse/CLOUDSTACK-9624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15701701#comment-15701701 ] ASF GitHub Bot commented on CLOUDSTACK-9624: Github user blueorangutan commented on the issue: https://github.com/apache/cloudstack/pull/1793 @rhtyd a Jenkins job has been kicked to build packages. I'll keep you posted as I make progress. > 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)
[jira] [Commented] (CLOUDSTACK-9624) Incorrect hypervisor mapping of guest os Windows 2008 Server R2 (64-bit) on VMware
[ https://issues.apache.org/jira/browse/CLOUDSTACK-9624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15701693#comment-15701693 ] ASF GitHub Bot commented on CLOUDSTACK-9624: Github user rhtyd commented on the issue: https://github.com/apache/cloudstack/pull/1793 Thanks @sateesh-chodapuneedi @blueorangutan package > 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)
[jira] [Commented] (CLOUDSTACK-9624) Incorrect hypervisor mapping of guest os Windows 2008 Server R2 (64-bit) on VMware
[ https://issues.apache.org/jira/browse/CLOUDSTACK-9624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15701671#comment-15701671 ] ASF GitHub Bot commented on CLOUDSTACK-9624: Github user sateesh-chodapuneedi commented on the issue: https://github.com/apache/cloudstack/pull/1793 Thanks @rhtyd Rebased the commit over 4.9, and updated base branch to 4.9. > 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)
[jira] [Commented] (CLOUDSTACK-9624) Incorrect hypervisor mapping of guest os Windows 2008 Server R2 (64-bit) on VMware
[ https://issues.apache.org/jira/browse/CLOUDSTACK-9624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15701612#comment-15701612 ] ASF GitHub Bot commented on CLOUDSTACK-9624: Github user rhtyd commented on the issue: https://github.com/apache/cloudstack/pull/1793 @sateesh-chodapuneedi thanks, this looks useful. Can you rebase against 4.9, and change the PR's base branch to 4.9? > 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)
[jira] [Commented] (CLOUDSTACK-9624) Incorrect hypervisor mapping of guest os Windows 2008 Server R2 (64-bit) on VMware
[ https://issues.apache.org/jira/browse/CLOUDSTACK-9624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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 ChodapuneediDate: 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
[jira] [Commented] (CLOUDSTACK-9624) Incorrect hypervisor mapping of guest os Windows 2008 Server R2 (64-bit) on VMware
[ https://issues.apache.org/jira/browse/CLOUDSTACK-9624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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 | >