Supported Databases & Encryption for Mideye

The database is not included in the Mideye Server installation package and must be created before installation. For step-by-step setup instructions, see Database Configuration.

The database can be installed locally on the same server or remotely on another server or in a cluster.

---

Supported databases

• Microsoft SQL Server 2014*
• Microsoft SQL Server 2016*
• Microsoft SQL Server 2017*
• Microsoft SQL Server 2019*
• Microsoft SQL Server 2022*
• MariaDB 5.5.63+ or 10.0+
• MySQL 5.5.3 or greater

* The Express edition is also supported and is most common in multiple single-server setups.

Installation Guide

For complete database installation and configuration instructions, see Database Configuration.

---

Database encryption

Since Mideye Server 6, the server encrypts the RADIUS Shared Secrets stored in the database. The encryption occurs in one of two situations:

• When an administrator saves a new RADIUS Shared Secret via the Web Admin GUI.
• When connecting a Mideye Server 6 to an existing Mideye Server 5 database.

Caution

When connecting Mideye Server 6 to a Mideye Server 5 database, all RADIUS Shared Secrets are encrypted. After this, the Mideye Server 5 instance can no longer authenticate users.

Information to back up

Two components are essential for database encryption. Keep backups of both:

1. Keystore file (keystore.pfx)
2. Keystore password (stored in application-prod.yml)

Default keystore paths:

OS	Path
Linux	/opt/mideyeserver6/config/keystore.pfx
Windows	C:\Program Files (x86)\Mideye Server 6\config\keystore.pfx

Default application-prod.yml paths:

OS	Path
Linux	/opt/mideyeserver6/config/application-prod.yml
Windows	C:\Program Files (x86)\Mideye Server 6\config\application-prod.yml

Example keystore configuration in application-prod.yml:

server:
    port: 443
    ssl:
        key-store: C:\Program Files (x86)\Mideye Server 6\config\keystore.pfx
        key-store-password: "EXamplePASSword"
        enabled: true

---

Shared database

Several Mideye Servers can connect to a database cluster or share a single database. This requires:

• One server must be designated as Cluster Leader.
• The keystore and keystore password must be replicated to all Mideye Servers, since RADIUS Shared Secrets are encrypted.

For detailed configuration, see Shared Database Clusters.

---

Database configuration

For detailed database configuration instructions, connection strings, examples, and troubleshooting, see Database Configuration.

This includes:

• Complete configuration examples for MSSQL and MySQL/MariaDB
• SSL configuration for MySQL 8
• Connection string formats
• Manual configuration steps
• Troubleshooting common issues