Date: Fri, 22 Dec 2023 20:18:26 -0500 From: Paul Procacci <pprocacci@gmail.com> To: Waitman Gobble <gobble.wa@gmail.com> Cc: FreeBSD Questions List <questions@freebsd.org> Subject: Re: MariaDB startup issue Message-ID: <CAFbbPuh07rMULkK=o%2BbEeMSSizLTEyKDViTgUss3TYyVLruwEg@mail.gmail.com> In-Reply-To: <CAFuo_fzP%2Bbmfa_b_SxE1yKAbJ_15jS-EFmRzeB26tzZweyMSvQ@mail.gmail.com>
index | next in thread | previous in thread | raw e-mail
[-- Attachment #1 --]
On Fri, Dec 22, 2023 at 8:13 PM Waitman Gobble <gobble.wa@gmail.com> wrote:
> I upgraded a server from FreeBSD 13.2-RELEASE to FreeBSD 14.0-RELEASE
>
> During pkg upgrade it removed mariadb 10.4. I installed mariadb 10.6
> no biggie. Except I seem to be in a chicken and egg paradox. When I
> start the message 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
>
> So it's a loop. I guess I need to edit the rc script but i think i am
> missing something? Any ideas?
>
> TIA and HH
>
> --
> Waitman Gobble
> \\
>
>
Try a symlink that takes /usr/local/etc/my.cnf and points it to
/usr/local/etc/mysql/conf.d/server.cnf
~Paul
--
__________________
:(){ :|:& };:
[-- Attachment #2 --]
<div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Dec 22, 2023 at 8:13 PM Waitman Gobble <<a href="mailto:gobble.wa@gmail.com">gobble.wa@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">I upgraded a server from FreeBSD 13.2-RELEASE to FreeBSD 14.0-RELEASE<br>
<br>
During pkg upgrade it removed mariadb 10.4. I installed mariadb 10.6<br>
no biggie. Except I seem to be in a chicken and egg paradox. When I<br>
start the message is:<br>
<br>
Please merge existing /usr/local/etc/my.cnf file with<br>
/usr/local/etc/mysql/conf.d/server.cnf<br>
<br>
OK I did that. I renamed the file to /usr/local/etc/my.cnf.x<br>
<br>
service mysql-server start says it's starting but actually never<br>
starts the server. no error in the logs I can find. I'm obviously<br>
missing something?<br>
<br>
If I use the same command the rc script is executing (WITHOUT<br>
'/usr/sbin/daemon' that the rc script uses) I see the error finally!<br>
<br>
/usr/local/bin/mariadbd-safe<br>
--defaults-extra-file=/usr/local/etc/my.cnf --user=mysql<br>
--datadir=/var/db/mysql --pid-file=/var/db/mysql/mysql.pid<br>
Could not open required defaults file: /usr/local/etc/my.cnf<br>
Fatal error in defaults handling. Program aborted<br>
<br>
OK so i made a blank /usr/local/etc/my.cnf and get this message:<br>
<br>
Please merge existing /usr/local/etc/my.cnf file with<br>
/usr/local/etc/mysql/conf.d/server.cnf<br>
<br>
So it's a loop. I guess I need to edit the rc script but i think i am<br>
missing something? Any ideas?<br>
<br>
TIA and HH<br>
<br>
-- <br>
Waitman Gobble<br>
\\<br>
<br>
</blockquote></div><br clear="all"><div>
Try a symlink that takes /usr/local/etc/my.cnf and points it to /usr/local/etc/mysql/conf.d/server.cnf <br></div><div><br></div><div>~Paul<br></div><br><span class="gmail_signature_prefix">-- </span><br><div dir="ltr" class="gmail_signature">__________________<br><br>:(){ :|:& };:</div></div>
help
Want to link to this message? Use this
URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CAFbbPuh07rMULkK=o%2BbEeMSSizLTEyKDViTgUss3TYyVLruwEg>