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]

Reply via email to