For Micetro Central running on Windows, the preferences.cfg file located
in the data directory contains, in addition to the fingerprint of Central (the
password preference), four other preferences:
databasetype, databaseserver,
databaseusername, and databasepassword.
The database connection section of the preferences.cfg file for
standard user/password authentication should look like this:
<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 database section of the
preferences.cfg file would look like this:
<database value="postgresql"/>
<databaseserver value="<name or ip of the PostgreSQL server>\<instance name, for example, PSQLDB>@<database name, for example, mmsuite"/>
<databaseusername value=""/>
Note: The
databaseusername preference must be included and its value
attribute should be an empty string.Setting up a PostgreSQL database
Micetro requires the creation of a new database on the database server with the UTF-8 encoding.