VMmanager Knowledge Base
Documentation
/
VMmanager Knowledge Base
/
Troubleshooting
/
A standard operating system template is missing

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:

  1. Connect to the server with the platform via SSH.

  2. Connect to the database:

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

  3. Check the status of the OS template with a query:

    select id,name,os_group,file_name,state,repository from vm_os where name LIKE '%Debian%';
    Comment
    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)
    output example comment

  4. Change the status of the OS template with a query:

    update vm_os set state="active" where id=36;
    Comment

  5. Check that the status has been successfully changed:

    select id,name,os_group,file_name,state,repository from vm_os where name LIKE '%Debian%';
    Comment
    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)

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