Database support

Network Olympus uses a database to store information.

The following DBMSes are supported:

PostgreSQL
MySQL

You can configure the application's access to a database during the installation of Network Olympus.

To setup the connection to an external database, you must provide an account username and password.

PostgreSQL

Comes bundled with Network Olympus.

Suitable in most cases. Installation doesn't require any additional actions from the user.

The Network Olympus installer will prompt you to set the administrator account parameters for the installed database cluster. This data may be needed later if migrating to another database becomes necessary.

The PostgreSQL server uses TCP port 5432. Before installing, make sure that this port is not taken by any other application.

Windows Firewall rules will be created automatically.

MySQL

An ODBC driver is required for a successful installation. It can be downloaded from the official website.
The driver's bitness must match the application bitness (at the moment, only the 32-bit version of Network Olympus exists).

The installer will need the username and password of the account that will be used for database configuration. This account must have the rights for creating the database, authenticating over the TCP connection (remote authentication is disabled by default) and configuring the database schema.