[jira] [Updated] (CLOUDSTACK-9654) Incorrect hypervisor mapping of various SUSE Linux guest os versions on VMware

2016-12-05 Thread Sateesh Chodapuneedi (JIRA)

 [ 
https://issues.apache.org/jira/browse/CLOUDSTACK-9654?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Sateesh Chodapuneedi updated CLOUDSTACK-9654:
-
Description: 
Currently many versions of SUSE Linux does not have any hypervisor mapping 
entry in guest_os_hypervisor table in cloud database for VMware 6.0. Also 
observed that the guest_os_name field is incorrect for some SUSE Linux 
variants, which results in deployed instance (with SUSE Linux) set to guest OS 
type as "Other (64-bit)" on vCenter, which would not represent the guest OS 
accurately on hypervisor.
The current (4.9) list of SUSE Linux guest os in database looks as below,
{noformat}
mysql> select id,display_name from guest_os where display_name like '%suse%';
+-+--+
| id  | display_name |
+-+--+
|  40 | SUSE Linux Enterprise Server 9 SP4 (32-bit)  |
|  41 | SUSE Linux Enterprise Server 10 SP1 (32-bit) |
|  42 | SUSE Linux Enterprise Server 10 SP1 (64-bit) |
|  43 | SUSE Linux Enterprise Server 10 SP2 (32-bit) |
|  44 | SUSE Linux Enterprise Server 10 SP2 (64-bit) |
|  45 | SUSE Linux Enterprise Server 10 SP3 (64-bit) |
|  46 | SUSE Linux Enterprise Server 11 (32-bit) |
|  47 | SUSE Linux Enterprise Server 11 (64-bit) |
|  96 | SUSE Linux Enterprise 8(32-bit)  |
|  97 | SUSE Linux Enterprise 8(64-bit)  |
| 107 | SUSE Linux Enterprise 9(32-bit)  |
| 108 | SUSE Linux Enterprise 9(64-bit)  |
| 109 | SUSE Linux Enterprise 10(32-bit) |
| 110 | SUSE Linux Enterprise 10(64-bit) |
| 151 | SUSE Linux Enterprise Server 10 SP3 (32-bit) |
| 152 | SUSE Linux Enterprise Server 10 SP4 (64-bit) |
| 153 | SUSE Linux Enterprise Server 10 SP4 (32-bit) |
| 154 | SUSE Linux Enterprise Server 11 SP1 (64-bit) |
| 155 | SUSE Linux Enterprise Server 11 SP1 (32-bit) |
| 185 | SUSE Linux Enterprise Server 11 SP2 (64-bit) |
| 186 | SUSE Linux Enterprise Server 11 SP2 (32-bit) |
| 187 | SUSE Linux Enterprise Server 11 SP3 (64-bit) |
| 188 | SUSE Linux Enterprise Server 11 SP3 (32-bit) |
| 202 | Other SUSE Linux(32-bit) |
| 203 | Other SUSE Linux(64-bit) |
| 244 | SUSE Linux Enterprise Server 12 (64-bit) |
+-+--+
26 rows in set (0.00 sec)
{noformat}
The current (4.9) hypervisor mappings for SUSE Linux guest os over VMware 6.0 
in database looks as below. We can observe in the below query result, which 
lists all hypervisor mappings for SUSE Linux guest OS over VMware 6.0, many 
guest os listed in above query result are missing their mappings for VMware 
6.0. Hence the need to add the missing hypervisor mappings.
{noformat}
mysql> select o.id,o.display_name, h.guest_os_name, h.hypervisor_version from 
guest_os as o, guest_os_hypervisor as h where o.id=h.guest_os_id and 
h.hypervisor_version='6.0' and h.hypervisor_type='vmware' and o.display_name 
like '%SUSE%';
+-+--+---++
| id  | display_name | guest_os_name | hypervisor_version |
+-+--+---++
|  96 | SUSE Linux Enterprise 8(32-bit)  | suseGuest | 6.0|
|  97 | SUSE Linux Enterprise 8(64-bit)  | suse64Guest   | 6.0|
| 107 | SUSE Linux Enterprise 9(32-bit)  | suseGuest | 6.0|
| 108 | SUSE Linux Enterprise 9(64-bit)  | suse64Guest   | 6.0|
| 109 | SUSE Linux Enterprise 10(32-bit) | suseGuest | 6.0|
| 110 | SUSE Linux Enterprise 10(64-bit) | suse64Guest   | 6.0|
| 202 | Other SUSE Linux(32-bit) | suseGuest | 6.0|
| 203 | Other SUSE Linux(64-bit) | suse64Guest   | 6.0|
+-+--+---++
8 rows in set (0.00 sec)
{noformat}


  was:
Currently many versions of SUSE Linux does not have any hypervisor mapping 
entry in guest_os_hypervisor table in cloud database for VMware 6.0. Also 
observed that the guest_os_name field is incorrect for some SUSE Linux 
variants, which results in deployed instance (with SUSE Linux) set to guest OS 
type as "Other (64-bit)" on vCenter, which would not represent the guest OS 
accurately on hypervisor.
The current (4.9) list of SUSE Linux guest os in database looks as below,
{noformat}
mysql> select id,display_name from guest_os where display_name like '%suse%';
+-+--+
| id  | display_name |
+-+--+
|  40 | SUSE Linux Enterprise Server 9 SP4 (32-bit)  |
|  41 | SUSE Linux Enterprise Server 10 SP1 (32-bit) |
|  42 | SUSE Linux 

[jira] [Updated] (CLOUDSTACK-9654) Incorrect hypervisor mapping of various SUSE Linux guest os versions on VMware

2016-12-05 Thread Sateesh Chodapuneedi (JIRA)

 [ 
https://issues.apache.org/jira/browse/CLOUDSTACK-9654?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Sateesh Chodapuneedi updated CLOUDSTACK-9654:
-
Description: 
Currently many versions of SUSE Linux does not have any hypervisor mapping 
entry in guest_os_hypervisor table in cloud database for VMware 6.0. Also 
observed that the guest_os_name field is incorrect for some SUSE Linux 
variants, which results in deployed instance (with SUSE Linux) set to guest OS 
type as "Other (64-bit)" on vCenter, which would not represent the guest OS 
accurately on hypervisor.
The current (4.9) list of SUSE Linux guest os in database looks as below,
{noformat}
mysql> select id,display_name from guest_os where display_name like '%suse%';
+-+--+
| id  | display_name |
+-+--+
|  40 | SUSE Linux Enterprise Server 9 SP4 (32-bit)  |
|  41 | SUSE Linux Enterprise Server 10 SP1 (32-bit) |
|  42 | SUSE Linux Enterprise Server 10 SP1 (64-bit) |
|  43 | SUSE Linux Enterprise Server 10 SP2 (32-bit) |
|  44 | SUSE Linux Enterprise Server 10 SP2 (64-bit) |
|  45 | SUSE Linux Enterprise Server 10 SP3 (64-bit) |
|  46 | SUSE Linux Enterprise Server 11 (32-bit) |
|  47 | SUSE Linux Enterprise Server 11 (64-bit) |
|  96 | SUSE Linux Enterprise 8(32-bit)  |
|  97 | SUSE Linux Enterprise 8(64-bit)  |
| 107 | SUSE Linux Enterprise 9(32-bit)  |
| 108 | SUSE Linux Enterprise 9(64-bit)  |
| 109 | SUSE Linux Enterprise 10(32-bit) |
| 110 | SUSE Linux Enterprise 10(64-bit) |
| 151 | SUSE Linux Enterprise Server 10 SP3 (32-bit) |
| 152 | SUSE Linux Enterprise Server 10 SP4 (64-bit) |
| 153 | SUSE Linux Enterprise Server 10 SP4 (32-bit) |
| 154 | SUSE Linux Enterprise Server 11 SP1 (64-bit) |
| 155 | SUSE Linux Enterprise Server 11 SP1 (32-bit) |
| 185 | SUSE Linux Enterprise Server 11 SP2 (64-bit) |
| 186 | SUSE Linux Enterprise Server 11 SP2 (32-bit) |
| 187 | SUSE Linux Enterprise Server 11 SP3 (64-bit) |
| 188 | SUSE Linux Enterprise Server 11 SP3 (32-bit) |
| 202 | Other SUSE Linux(32-bit) |
| 203 | Other SUSE Linux(64-bit) |
| 244 | SUSE Linux Enterprise Server 12 (64-bit) |
+-+--+
26 rows in set (0.00 sec)
{noformat}
The current (4.9) hypervisor mappings for SUSE Linux guest os over VMware 6.0 
in database looks as below. We can observe in the below query result, which 
lists all hypervisor mappings for SUSE Linux many guest OS over VMware 6.0, 
many guest os listed in above query result are missing. Hence the need to add 
the missing hypervisor mappings.
{noformat}
mysql> select o.id,o.display_name, h.guest_os_name, h.hypervisor_version from 
guest_os as o, guest_os_hypervisor as h where o.id=h.guest_os_id and 
h.hypervisor_version='6.0' and h.hypervisor_type='vmware' and o.display_name 
like '%SUSE%';
+-+--+---++
| id  | display_name | guest_os_name | hypervisor_version |
+-+--+---++
|  96 | SUSE Linux Enterprise 8(32-bit)  | suseGuest | 6.0|
|  97 | SUSE Linux Enterprise 8(64-bit)  | suse64Guest   | 6.0|
| 107 | SUSE Linux Enterprise 9(32-bit)  | suseGuest | 6.0|
| 108 | SUSE Linux Enterprise 9(64-bit)  | suse64Guest   | 6.0|
| 109 | SUSE Linux Enterprise 10(32-bit) | suseGuest | 6.0|
| 110 | SUSE Linux Enterprise 10(64-bit) | suse64Guest   | 6.0|
| 202 | Other SUSE Linux(32-bit) | suseGuest | 6.0|
| 203 | Other SUSE Linux(64-bit) | suse64Guest   | 6.0|
+-+--+---++
8 rows in set (0.00 sec)
{noformat}


  was:
Currently many versions of SUSE Linux does not have any hypervisor mapping 
entry in guest_os_hypervisor table in cloud database for VMware 6.0. Also 
observed that the guest_os_name field is incorrect for some SUSE Linux 
variants, which results in deployed instance (with SUSE Linux) set to guest OS 
type as "Other (64-bit)" on vCenter, which would not represent the guest OS 
accurately on hypervisor.
The current (4.9) mappings in database looks as below,
{noformat}
mysql> select id,display_name from guest_os where display_name like '%suse%';
+-+--+
| id  | display_name |
+-+--+
|  40 | SUSE Linux Enterprise Server 9 SP4 (32-bit)  |
|  41 | SUSE Linux Enterprise Server 10 SP1 (32-bit) |
|  42 | SUSE Linux Enterprise Server 10 SP1 (64-bit) |
|  43 | SUSE