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:
HOSTNAMEandDATABASE: 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.