Mariadb options file

Apps and Virtualization
1

Hi,

I have mariadb up and running on TrueNAS Scale 25.04.01, but I’d like to modify some options normally found in /etc/my.cnf.
Is there any file outside the container, that is mapped into it, so that one can persistently set some options?

TIA.
By.
Michael.

2

If you’re using hostpath for storage then yes, if you’re using iXVolume no since iXVolume is mapped to a hidden dataset called .ix-apps

3

I’m using hostpath. Where can I find or create a configfile then?

4

for my mariadb from nextcloud i’ve created a dataset and used it in my compose file and i can browse to that folder and find the conf file. If you’re using the official app, i can’t tell you if the creator mapped it to something else.

5

Ok, thx, I’m using the official app.
But as you mention nextcloud - I installed mariadb for use with nextcloud.
Do I understand you correctly, that I’d need a special mariadb container delivered for/with nextcloud?

6

Usually, if you use the ix-apps the “nextcloud” app should include all nessessary container, e.g. nextcloud, the database container and redis. You shouldn’t have to manually deploy mariadb.

Edit: Took a look at the apps github and the official app uses postgres as db not mariadb

7

Thx a lot.

8

Inside the container I have a mount point for the hostpath to /var/lib/mysql, so I’ve put a my.cnf file there. But it is not used:

mariadb --verbose --help | grep -A 1 "Default options"
Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf ~/.my.cnf
9

for my app, all i did was bind the /config folder inside the container to a hostpath on my truenas, but compose file i use is from linuxserver.io, so i don’t know if they’ve modified the paths…