A standard operating system template is missing

In the VMmanager 6 web interface, OS templates are displayed under Templates → Operating Systems. If a template from the standard repository is missing from the list of operating systems, retrieve it using the instructions in this article. For a list of standard templates, see Operating systems in the VMmanager documentation.

There are potential risks involved in altering a database. We do not recommend making manual edits to the database, as it can disrupt the correct operation of the platform.

Create a backup of the platform before performing any actions with the database.

For the template to be displayed in the interface, check its status in the database table. If the template is in the "Deleted" state (state=deleted), change the state to "Active" (state=active). To do this:

Connect to the server with the platform via SSH.

Connect to the database:

docker exec -it mysql bash -c "mysql isp -p\$MYSQL_ROOT_PASSWORD"

CODE

Check the status of the OS template with a query:

mysql> select id,name,os_group,file_name,state,repository from vm_os where name LIKE '%Debian%';

CODE

Comment

'%Debian%' – part of the OS template name, in this example it is part of the Debian 11 template name

output example

+----+-----------+----------+---------------------------------+---------+------------+
| id | name | os_group | file_name | state | repository |
+----+-----------+----------+---------------------------------+---------+------------+
| 6 | Debian 9 | 3 | Debian-9-amd64-20210315.tar.gz | active | 2 |
| 7 | Debian 10 | 3 | Debian-10-amd64-20220329.tar.gz | active | 2 |
| 11 | Debian 11 | 3 | Debian-11-amd64-20220329.tar.gz | active | 2 |
| 14 | Debian 10 | 3 | debian-10-20230502.xz | active | 3 |
| 15 | Debian 9 | 3 | debian-9-20230329.xz | active | 3 |
| 36 | Debian 11 | 3 | debian-11-20230502.xz | deleted | 3 |
+----+-----------+----------+---------------------------------+---------+------------+
6 rows in set (0.00 sec)

CODE

output example comment

the template with ID 36 is in the "Deleted" state (state = deleted)

Change the status of the OS template with a query:
```
mysql> update vm_os set state="active" where id=36;
```
CODE
Comment
id=36 — ID of the deleted template from the previous query

Check that the status has been successfully changed:

mysql> select id,name,os_group,file_name,state,repository from vm_os where name LIKE '%Debian%';

CODE

Comment

'%Debian%' – part of the OS template name, in this example it is part of the Debian 11 template name

output example

+----+-----------+----------+---------------------------------+--------+------------+
| id | name | os_group | file_name | state | repository |
+----+-----------+----------+---------------------------------+--------+------------+
| 6 | Debian 9 | 3 | Debian-9-amd64-20210315.tar.gz | active | 2 |
| 7 | Debian 10 | 3 | Debian-10-amd64-20220329.tar.gz | active | 2 |
| 11 | Debian 11 | 3 | Debian-11-amd64-20220329.tar.gz | active | 2 |
| 14 | Debian 10 | 3 | debian-10-20230502.xz | active | 3 |
| 15 | Debian 9 | 3 | debian-9-20230329.xz | active | 3 |
| 36 | Debian 11 | 3 | debian-11-20230502.xz | active | 3 |
+----+-----------+----------+---------------------------------+--------+------------+
6 rows in set (0.00 sec)

CODE

After a successful state change, the OS template will be displayed in the web interface under Templates → Operating Systems.

Cookie Notice