Database support

Network Olympus uses a database to store information.

The following DBMSes are supported:

PostgreSQL
MySQL

Database access can be provided 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 DBMS 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.

Uninstalling Network Olympus will lead to the deletion of the Olympus database and uninstallation of PostgreSQL. In order to be able to preserve and then restore your database on a new installation, create a backup before uninstallation.

MySQL

An ODBC driver (specifically, version 5.3.6 32-bit) is required for a successful installation. It can be downloaded from the official archive.
We hope to alter the version requirement to the latest or most appropriate version in the future.

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.

Uninstalling Network Olympus will lead to the deletion of the Olympus database in MySQL. See MySQL documentation on how to back up the database.