Some FreeBSD 14.0-RELEASE weirdness.
I upgraded this server from FreeBSD 13.2-RELEASE to FreeBSD 14.0-RELEASE, when i updated the packages it removed MariaDB 10.4. So I had to install MariaDB 10.6. no biggie. (sidebar, i tried 10.11 and it says it doesn't know what InnoDB is - is that going away?)
So the chicken and egg weirdness is
Please merge existing /usr/local/etc/my.cnf file with
/usr/local/etc/mysql/conf.d/server.cnf
OK I did that. I renamed the file to /usr/local/etc/my.cnf.x
service mysql-server start says it's starting but actually never
starts the server. no error in the logs I can find. I'm obviously
missing something?
If I use the same command the rc script is executing (WITHOUT
'/usr/sbin/daemon' that the rc script uses) I see the error finally!
/usr/local/bin/mariadbd-safe
--defaults-extra-file=/usr/local/etc/my.cnf --user=mysql
--datadir=/var/db/mysql --pid-file=/var/db/mysql/mysql.pid
Could not open required defaults file: /usr/local/etc/my.cnf
Fatal error in defaults handling. Program aborted
OK so i made a blank /usr/local/etc/my.cnf and get this message:
Please merge existing /usr/local/etc/my.cnf file with
/usr/local/etc/mysql/conf.d/server.cnf
mysql_prestart()
{
local dir
for dir in /etc /usr/local/etc /etc/mysql /var/db/mysql; do
if [ -f "${dir}/my.cnf" ]; then
echo "Please merge existing ${dir}/my.cnf file
with /usr/local/etc/mysql/conf.d/server.cnf"
# return 1
fi
done
commenting out return 1 solves it for me. starts and runs just fine with a blank /usr/local/etc/my.cnf file
Obviously I missed something like a note right? I'm sure other people are upgrading and it's working fine right?
/cdn.vox-cdn.com/uploads/chorus_asset/file/24774110/STK156_Instagram_threads_1.jpg "Image/photo")
;