Setting up the database backend on Linux

Micetro can be used with the following databases on Linux:

Note

  • High Availability for the database is only available for PostgreSQL.

  • Deploying Micetro using the Azure Marketplace configures the environment automatically for Azure SQL. Refer to Installing Micetro in Azure for details.

SQLite

Micetro Central comes with a built-in SQLite database, which is used if there is no configuration for an external database. There are no customization options for SQLite. Micetro Central will use the default configuration.

PostgreSQL

For Micetro Central running on Linux, edit the configuration file for Micetro Central:

nano /var/mmsuite/mmcentral/preferences.cfg

Find (or add) the following entries and configure them accordingly:

<database value="postgresql"/>
<databaseserver value="HOSTNAME@DATABASE"/>
<databaseusername value="USERNAME" />
<databasepassword value="plaintext:PASSWORD" />

Definitions:

  • HOSTNAME and DATABASE: The hostname of the server running the PostgreSQL service and the system user on the server.

  • USERNAME: The user with read and write permissions for the PostgreSQL database.

  • PASSWORD: The password for the database user.

Note

After Micetro Central starts and processes the configuration file, it automatically converts the plaintext password into a hashed format to increase security.

To restart Micetro Central and check its status:

systemctl restart mmcentral
systemctl status mmcentral

If there are any database connection issues, the service will fail to start. Check the Micetro Central startup log for errors. The log is located in the Micetro Central data directory at /var/mmsuite/mmcentral/logs.

Setting Up a PostgreSQL database

Micetro requires the creation of a new database on the database server with the UTF-8 encoding.