This is an automated email from the ASF dual-hosted git repository.
andrijapanic pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/cloudstack.git
The following commit(s) were added to refs/heads/master by this push:
new 0d92b92 Fix OS category for some OS-es added in 4.13 (#3746)
0d92b92 is described below
commit 0d92b929359de4b6cae408c6fe5a47504840ecac
Author: Andrija Panic <45762285+andrijapani...@users.noreply.github.com>
AuthorDate: Wed Dec 11 19:02:06 2019 +0100
Fix OS category for some OS-es added in 4.13 (#3746)
---
.../src/main/resources/META-INF/db/schema-41300to41400.sql | 13 +++++++++++++
1 file changed, 13 insertions(+)
diff --git
a/engine/schema/src/main/resources/META-INF/db/schema-41300to41400.sql
b/engine/schema/src/main/resources/META-INF/db/schema-41300to41400.sql
index 43e282d..137dd2c 100644
--- a/engine/schema/src/main/resources/META-INF/db/schema-41300to41400.sql
+++ b/engine/schema/src/main/resources/META-INF/db/schema-41300to41400.sql
@@ -21,3 +21,16 @@
-- KVM: enable storage data motion on KVM hypervisor_capabilities
UPDATE `cloud`.`hypervisor_capabilities` SET `storage_motion_supported` = 1
WHERE `hypervisor_capabilities`.`hypervisor_type` = 'KVM';
+
+-- Fix OS category for some Ubuntu and RedHat OS-es
+UPDATE `cloud`.`guest_os` SET `category_id`='10' WHERE `id`=277 AND
display_name="Ubuntu 17.04";
+UPDATE `cloud`.`guest_os` SET `category_id`='10' WHERE `id`=278 AND
display_name="Ubuntu 17.10";
+UPDATE `cloud`.`guest_os` SET `category_id`='10' WHERE `id`=279 AND
display_name="Ubuntu 18.04 LTS";
+UPDATE `cloud`.`guest_os` SET `category_id`='10' WHERE `id`=280 AND
display_name="Ubuntu 18.10";
+UPDATE `cloud`.`guest_os` SET `category_id`='10' WHERE `id`=281 AND
display_name="Ubuntu 19.04";
+UPDATE `cloud`.`guest_os` SET `category_id`='4' WHERE `id`=282 AND
display_name="Red Hat Enterprise Linux 7.3";
+UPDATE `cloud`.`guest_os` SET `category_id`='4' WHERE `id`=283 AND
display_name="Red Hat Enterprise Linux 7.4";
+UPDATE `cloud`.`guest_os` SET `category_id`='4' WHERE `id`=284 AND
display_name="Red Hat Enterprise Linux 7.5";
+UPDATE `cloud`.`guest_os` SET `category_id`='4' WHERE `id`=285 AND
display_name="Red Hat Enterprise Linux 7.6";
+UPDATE `cloud`.`guest_os` SET `category_id`='4' WHERE `id`=286 AND
display_name="Red Hat Enterprise Linux 8.0";
+
