Sateesh Chodapuneedi created CLOUDSTACK-9654:
------------------------------------------------
Summary: Incorrect hypervisor mapping of various SUSE Linux guest
os versions on VMware
Key: CLOUDSTACK-9654
URL: https://issues.apache.org/jira/browse/CLOUDSTACK-9654
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: ACS 4.9
VMware 5.1
Reporter: Sateesh Chodapuneedi
Assignee: Sateesh Chodapuneedi
Fix For: 4.9.1.0
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 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)
mysql> select o.id,o.display_name, h.guest_os_name 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 |
+-----+----------------------------------+---------------+
| 96 | SUSE Linux Enterprise 8(32-bit) | suseGuest |
| 97 | SUSE Linux Enterprise 8(64-bit) | suse64Guest |
| 107 | SUSE Linux Enterprise 9(32-bit) | suseGuest |
| 108 | SUSE Linux Enterprise 9(64-bit) | suse64Guest |
| 109 | SUSE Linux Enterprise 10(32-bit) | suseGuest |
| 110 | SUSE Linux Enterprise 10(64-bit) | suse64Guest |
| 202 | Other SUSE Linux(32-bit) | suseGuest |
| 203 | Other SUSE Linux(64-bit) | suse64Guest |
+-----+----------------------------------+---------------+
8 rows in set (0.00 sec)
mysql> select * from version;
+----+---------+---------------------+----------+
| id | version | updated | step |
+----+---------+---------------------+----------+
| 1 | 4.0.0 | 2016-12-05 17:35:27 | Complete |
| 2 | 4.1.0 | 2016-12-05 12:05:57 | Complete |
| 3 | 4.2.0 | 2016-12-05 12:05:58 | Complete |
| 4 | 4.2.1 | 2016-12-05 12:05:58 | Complete |
| 5 | 4.3.0 | 2016-12-05 12:05:58 | Complete |
| 6 | 4.4.0 | 2016-12-05 12:05:58 | Complete |
| 7 | 4.4.1 | 2016-12-05 12:05:58 | Complete |
| 8 | 4.4.2 | 2016-12-05 12:05:58 | Complete |
| 9 | 4.5.0 | 2016-12-05 12:05:58 | Complete |
| 10 | 4.5.1 | 2016-12-05 12:05:58 | Complete |
| 11 | 4.5.2 | 2016-12-05 12:05:58 | Complete |
| 12 | 4.6.0 | 2016-12-05 12:05:58 | Complete |
| 13 | 4.6.1 | 2016-12-05 12:05:58 | Complete |
| 14 | 4.7.0 | 2016-12-05 12:05:58 | Complete |
| 15 | 4.7.1 | 2016-12-05 12:05:58 | Complete |
| 16 | 4.8.0 | 2016-12-05 12:05:58 | Complete |
| 17 | 4.8.1 | 2016-12-05 12:05:58 | Complete |
| 18 | 4.9.0 | 2016-12-05 12:05:58 | Complete |
| 19 | 4.9.1.0 | 2016-12-05 12:05:58 | Complete |
+----+---------+---------------------+----------+
19 rows in set (0.00 sec)
{noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
