[CLOUDSTACK-9654] Missing hypervisor mapping of various SUSE Linux guest os versions on VMware 6.0

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.9.0
• Fix Version/s: 4.9.1.0
• Component/s: Management Server
• Security Level: Public (Anyone can view this level - this is the default.)
• Environment: ACS 4.9; VMware 5.1
• Assignee: Sateesh Chodapuneedi
• Reporter: Sateesh Chodapuneedi
• Created: 06/Dec/16 02:14
• Updated: 09/Dec/16 02:55
• Resolved: 09/Dec/16 02:54

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,

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)

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.

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)

Issue Links

• links to: GitHub Pull Request #1817