Issue installing MariaDB (multiple versions) on FreeBSD 13.x (TrueNAS) within a jail

[almostunix]

I am installing NextCloud and have Apache24 and PHP83 operating as expected, reachable, and serving up info pages.

I thought the MySQL setup would be the easiest part of the install, but alas, I cannot get it to start, and I have tried multiple versions of MariaDB.

I am using FreeBSD 13.5 in a jail... pkg was used to install. set enable in sysrc, executed service mysql-server start, and it fails to start... error log is completely empty. error is below.

Any advice appreciated...

 

[sko]

1. don't post pictures of text; copy the text and use the 'code' tags so everyone can read and quote it properly.

2. https://forums.freebsd.org/threads/ghostbsd-pfsense-truenas-and-all-other-freebsd-derivatives.7290/

TrueNAS is not FreeBSD and it is (was) based on 13.1-RELEASE which has been EOL for 3 1/2 years. Its as dead as it can get - don't use it and migrate to FreeBSD.

 

[Espionage724]

I did this on 15.0-STABLE about a week ago:

pkg install 'mariadb118-server'

sysrc mysql_enable="YES"

service 'mysql-server' start

mariadb-secure-installation

I'm not sure if it affects the initial start, but all my MariaDB installs I use a .cnf (before installing the pkg) for stuff like UTF8 so the initial DBs are created like that:

ee '/usr/local/etc/mysql/conf.d/custom.cnf'

[client]
default-character-set = 'utf8mb4'

[mariadb-client]
default-character-set = 'utf8mb4'

[mariadbd]
character-set-client-handshake = 'FALSE'
character-set-server = 'utf8mb4'
collation-server = 'utf8mb4_unicode_ci'
init-connect='SET NAMES utf8mb4'
expire_logs_days = '7'
max_binlog_size = '100M'
#skip-networking = 'On'
table_definition_cache = '1400'

(I'm not sure what skip-networking is about but I guess I needed it not set on FreeBSD; I'll look into that later )

 

[almostunix]

I did this on 15.0-STABLE about a week ago:

pkg install 'mariadb118-server'

sysrc mysql_enable="YES"

service 'mysql-server' start

mariadb-secure-installation

I'm not sure if it affects the initial start, but all my MariaDB installs I use a .cnf (before installing the pkg) for stuff like UTF8 so the initial DBs are created like that:

ee '/usr/local/etc/mysql/conf.d/custom.cnf'

[client]
default-character-set = 'utf8mb4'

[mariadb-client]
default-character-set = 'utf8mb4'

[mariadbd]
character-set-client-handshake = 'FALSE'
character-set-server = 'utf8mb4'
collation-server = 'utf8mb4_unicode_ci'
init-connect='SET NAMES utf8mb4'
expire_logs_days = '7'
max_binlog_size = '100M'
#skip-networking = 'On'
table_definition_cache = '1400'

(I'm not sure what skip-networking is about but I guess I needed it not set on FreeBSD; I'll look into that later )

I get stuck at the mysql-server start... I'll give a try on one of my FreeBSD VMs running FreeBSD 15 and see if my problem is isolated to the older version of FreeBSD (13.5)