CORE | MariaDB 10 jail config

Apps and Virtualization
1

Hi,

I’m working through some teething problems with MariaDB and wanted to ask for a second opinion :slight_smile:

I have installed mariadb106-server-10.6.20 & dependencies in a fresh jail (13.4) to troubleshoot a separate nextcloud jail. MariaDB won’t start and I feel I have been going in circles.

root@cloud:/sqltmp # service mysql-server start

Starting mysql.

root@cloud:/sqltmp # service mysql-server status

mysql is not running.

The config path I’m aware of is /usr/local/etc/mysql/my.cnf and I made it point to a socket as follows:

# This group is read both by the client and the server
# use it for options that affect everything, see
# https://mariadb.com/kb/en/configuring-mariadb-with-option-files/#option-groups
#
[client-server]
port    = 3306                                             
#socket = /var/run/mysql/mysql.sock                        
socket  = /sqltmp/mysql.sock                               
                                                           
#                                                          
# include *.cnf from the config directory                  
#                                                          
#!includedir /usr/local/etc/mysql/conf.d/  #originally this line was NOT commented out

I used touch /sqltmp/mysql.sock to create the socket and then made mysql the owner (recursively).

drwxr-xr-x 2 mysql mysql 3 Jan 23 22:08 sqltmp

Looking at the error log it seems my config is being ignored and is looking at /tmp instead. Is there anything I can do?

2025-01-23 22:43:23 0 [Note] InnoDB: Compressed tables use zlib 1.3.1
2025-01-23 22:43:23 0 [Note] InnoDB: Number of pools: 1
2025-01-23 22:43:23 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2025-01-23 22:43:23 0 [ERROR] mariadbd: Can't create/write to file '/tmp/ibGL0o7T' (Errcode: 13 "Permission denied")
2025-01-23 22:43:23 0 [ERROR] InnoDB: Unable to create temporary file; errno: 13
2025-01-23 22:43:23 0 [ERROR] mariadbd: Can't create/write to file '/tmp/ibwilGum' (Errcode: 13 "Permission denied")
2025-01-23 22:43:23 0 [ERROR] InnoDB: Unable to create temporary file; errno: 13
2025-01-23 22:43:23 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2025-01-23 22:43:23 0 [Note] InnoDB: Starting shutdown...
2025-01-23 22:43:23 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2025-01-23 22:43:23 0 [Note] Plugin 'FEEDBACK' is disabled.
2025-01-23 22:43:23 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2025-01-23 22:43:23 0 [ERROR] Aborting

I also tried a fresh jail w/o touching the config file in any way and the error log reads similar.

Appreciate any thoughts :slight_smile:

2

Welcome.

Not sure I’ll be much help (I’m just getting into setting all this stuff up manually again, myself) but I’d check against some resources like below and see if you missed a step first.

FreeBSD 14 : MariaDB : Install : Server World

I do have a series of setup scripts, and I have some MariaDB stuff in there already, but I have zero tests for it so far, so it probably won’t help (we can keep that in the back pocket as an “if all else fails!” for now).

3

thanks for your reply. I wasn’t able to get the MariaDB service back and running.
I went with postgreSQL instead and was up and running < 30min.

1 Like