MySQL with TLS encryption

[afunix]

Hello.

I’m trying to install LibreNMS to migrate from Observium. The plan is to use my existing MySQL cluster which requires TLS for communication.
The installation guide asks to go through online install (http[s]://<instance/install) to generate configuration. However the installer does not have any fields to configure TLS and it fails with “SQLSTATE[HY000] [2026] SSL connection error: SSL is required from client”.

I’ve tried to update .env file with:
DB_SSLMODE=require
MYSQL_ATTR_SSL_CA=
But it doesn’t look like installer picks up this configuration.

So first of all, is MySQL with TLS supported at all?
Secondly how do I configure it? Do I skip the installer (what to configure manually then?)? Or how do I convince the installer to use the encryption?

[laf]

I don’t think the install supports SSL mode.

It’s been a while since I tried a manual install but you could try:

cp config.php.default config.php

Set these in .env

DB_HOST=localhost
DB_DATABASE=DATABASE
DB_USERNAME=USERNAME
DB_PASSWORD=PASSWORD

#APP_URL=
NODE_ID=RANDOM STRING 12 CHARS OR MORE

Then run:

php artisan key:generate

Add your config to .env for SSL (I’m assuming you know the right values and it works in Laravel).

Then try and run php artisan migrate to populate the database.