Sorry for perhaps not quite the right place — wanted to ask forum.freebsd.org, yet still waiting for new user approval.
I have made a fresh install of MariaDB server v10.5.12_1 with mariadb105-client-10.5.12_1 — no errors, yet can not start to configure it as a back-end for Textpattern CMS.
I did not get caught up in what went wrong, all the executables look in their places:
@mysqlalias and many others seems to be OK;
/usr/local/libexec/mariadbd- the daemon with its alias
/usr/local/etc/rc.d/mysql-serverto start (restart, stop, atatus) – OK;
./mysql-server enable– OK;
/etc/my.cnf– do not exist, that is OK;
/usr/local/etc/mysql/my.cnf– both files with the same content, OK;
/usr/local/etc/mysql/conf.d/server.cnf– the main configuration file, OK.
/usr/local/etc/rc.d/mysqld/– no such directory, is that OK?
/var/run/mysql/– no such directory for
/usr/local/share/mysql/my-*.cnf– files do not exist in the directory.
2021-09-28 20:25:27 0 [Note] ./mariadbd (mysqld 10.5.12-MariaDB) starting as process 33927 …
root@NomadBSD:/usr/local/libexec# service mariadb status
mariadb does not exist in /etc/rc.d or the local startup directories (/usr/local/etc/rc.d), or is not executable
root@NomadBSD:/usr/local/etc/rc.d# service mysql-server start
Please merge existing /var/db/mysql/my.cnf file with /usr/local/etc/mysql/conf.d/server.cnf
/usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine for mysql
root@NomadBSD:/usr/local/etc/rc.d# service mysql-server status
mysql is not running.
What the warning means? Why and how to merge
/usr/local/etc/mysql/conf.d/server.cnf while the same
my.cnf already exists in
/usr/local/etc/mysql/ with the link to
# 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 # # include *.cnf from the config directory # !includedir /usr/local/etc/mysql/conf.d/
What to do, should I manually create the missing files and directories?