GitHub user weizhouapache added a comment to the discussion: [Feature] Add
latest OS versions to guest OS list
@la-wu
if you are not comfortable with the APIs (suggested by @DaanHoogland ), you can
use the SQL procedure.
Please note, if you use another hypervisor (not KVM) or mixed hypervisors , do
NOT run it !
for example, your SQL below is good for KVM I think,
```
-- Add Rocky Linux 10 guest OS mapping
CALL ADD_GUEST_OS_AND_HYPERVISOR_MAPPING (
(SELECT id FROM cloud.guest_os_category WHERE name = 'Rocky Linux'),
'Rocky Linux 10', 'KVM', 'default', 'Rocky Linux 10'
);
```
run results
```
mysql> CALL ADD_GUEST_OS_AND_HYPERVISOR_MAPPING (
-> (SELECT id FROM cloud.guest_os_category WHERE name = 'Rocky Linux'),
-> 'Rocky Linux 10', 'KVM', 'default', 'Rocky Linux 10'
-> );
Query OK, 1 row affected (0.07 sec)
mysql> select * from guest_os where display_name='Rocky Linux 10';
+-----+-------------+------+--------------------------------------+----------------+---------------------+---------+-----------------+---------+
| id | category_id | name | uuid |
display_name | created | removed | is_user_defined | display |
+-----+-------------+------+--------------------------------------+----------------+---------------------+---------+-----------------+---------+
| 383 | 13 | NULL | 77057b34-e003-11f1-8271-1e00b5000454 | Rocky Linux
10 | 2026-11-14 08:14:51 | NULL | 0 | 1 |
+-----+-------------+------+--------------------------------------+----------------+---------------------+---------+-----------------+---------+
1 row in set (0.01 sec)
mysql> select * from guest_os_hypervisor where guest_os_id=383;
+-------+-----------------+----------------+-------------+--------------------+--------------------------------------+---------------------+---------+-----------------+
| id | hypervisor_type | guest_os_name | guest_os_id | hypervisor_version |
uuid | created | removed |
is_user_defined |
+-------+-----------------+----------------+-------------+--------------------+--------------------------------------+---------------------+---------+-----------------+
| 10717 | KVM | Rocky Linux 10 | 383 | default |
77067148-e003-11f1-8271-1e00b5000454 | 2026-11-14 08:14:51 | NULL |
0 |
+-------+-----------------+----------------+-------------+--------------------+--------------------------------------+---------------------+---------+-----------------+
1 row in set (0.00 sec)
```
fyi, known guest os categories on my testing env (checked on other envs too):
```
mysql> select * from guest_os_category;
+----+-------------+--------------------------------------+----------+----------+---------+---------------------+
| id | name | uuid | featured | sort_key
| created | removed |
+----+-------------+--------------------------------------+----------+----------+---------+---------------------+
| 1 | CentOS | e7186252-53fc-11f0-a953-1e0029000433 | 1 | 4
| NULL | NULL |
| 2 | Debian | e718b6bb-53fc-11f0-a953-1e0029000433 | 1 | 2
| NULL | NULL |
| 3 | Oracle | e7191940-53fc-11f0-a953-1e0029000433 | 1 | 7
| NULL | NULL |
| 4 | RedHat | e7196099-53fc-11f0-a953-1e0029000433 | 1 | 8
| NULL | NULL |
| 5 | SUSE | e719d809-53fc-11f0-a953-1e0029000433 | 1 | 9
| NULL | NULL |
| 6 | Windows | e71a1dfa-53fc-11f0-a953-1e0029000433 | 1 | 10
| NULL | NULL |
| 7 | Other | e71a6388-53fc-11f0-a953-1e0029000433 | 1 | 11
| NULL | NULL |
| 8 | Novel | e71ab196-53fc-11f0-a953-1e0029000433 | 1 | 0
| NULL | 2025-08-22 15:22:32 |
| 9 | Unix | e71af971-53fc-11f0-a953-1e0029000433 | 1 | 0
| NULL | 2025-08-22 15:22:32 |
| 10 | Ubuntu | e71b4a7c-53fc-11f0-a953-1e0029000433 | 1 | 1
| NULL | NULL |
| 11 | None | e71ba2b9-53fc-11f0-a953-1e0029000433 | 1 | 0
| NULL | 2025-08-22 15:22:32 |
| 12 | Fedora | d2beae8d-7f6b-11f0-a953-1e0029000433 | 1 | 3
| NULL | NULL |
| 13 | Rocky Linux | d2bf79c0-7f6b-11f0-a953-1e0029000433 | 1 | 5
| NULL | NULL |
| 14 | AlmaLinux | d2bfdf82-7f6b-11f0-a953-1e0029000433 | 1 | 6
| NULL | NULL |
+----+-------------+--------------------------------------+----------+----------+---------+---------------------+
14 rows in set (0.01 sec)
```
GitHub link:
https://github.com/apache/cloudstack/discussions/14617#discussioncomment-19608923
----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: [email protected]