PostgreSQL

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 Central starts and processes the configuration file, it will automatically convert the plaintext password into a hashed format to increase security.

To restart Central and check its status:

systemctl restart mmcentral
systemctl status mmcentral

If the database connection fails, the service will not start and an error message will be displayed.

Micetro Central Running on Windows

The preferences.cfg file located in the data directory contains, in addition to the fingerprint of Central (the “password” XML-tag), four other XML tags: database, databaseserver, databaseusername and databasepassword.

The preferences.cfg file for standard user/password authentication should look like this:

<password value="the fingerprint hash"/>
<database value="postgresql"/>
<databaseserver value="<name or IP of the PostgreSQL server>\<instance name, for example, PSQLDB>@<database name, for example, mmsuite"/>
<databaseusername value="mmSuiteDBUser"/>
<databasepassword value="password hash"/>

For the Windows Authentication method, an example preferences.cfg file would look like this (the databaseusername tag must be included and its value attribute should be an empty string):

<password value="the fingerprint hash"/>
<database value="postgresql"/>
<databaseserver value="<name or ip of the PostgreSQL server>\<instance name, for example, PSQLDB>@<database name, for example, mmsuite"/>
<databaseusername value=""/>

Setting Up a PostgreSQL Database

Micetro requires the creation of a new database on the database server with the UTF8 encoding.