Date: Fri, 22 Dec 2023 17:24:18 -0800 From: paul beard <paulbeard@gmail.com> To: Waitman Gobble <gobble.wa@gmail.com> Cc: FreeBSD Questions List <questions@freebsd.org> Subject: Re: MariaDB startup issue Message-ID: <CAMtcK2pk%2BZkG=Bx8GHHzyx7CDY3cshTSHokqkxq6FbcqFHcirQ@mail.gmail.com> In-Reply-To: <CAFuo_fzP%2Bbmfa_b_SxE1yKAbJ_15jS-EFmRzeB26tzZweyMSvQ@mail.gmail.com> References: <CAFuo_fzP%2Bbmfa_b_SxE1yKAbJ_15jS-EFmRzeB26tzZweyMSvQ@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
--000000000000c26c48060d233164 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable editing the RC script seems like the wrong answer. I have had this problem a few times. Does mysqld_safe run? The couple of issues I have had deal with the pid file being where the RC script doesn't expect it so stop/start/status don't work. Also, the ib* files in /var/db/mysql are often an issue. The logs usually point them out. On Fri, Dec 22, 2023 at 5:13=E2=80=AFPM 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=3D/usr/local/etc/my.cnf --user=3Dmysql > --datadir=3D/var/db/mysql --pid-file=3D/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 > \\ > > --=20 Paul Beard / www.paulbeard.org/ --000000000000c26c48060d233164 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable <div dir=3D"ltr">editing the RC script seems like the=C2=A0wrong answer. I = have had this problem a few times. Does mysqld_safe run? The couple of issu= es=C2=A0I have had deal with the pid file being where the RC script doesn&#= 39;t expect it so stop/start/status don't work. Also, the ib* files in = /var/db/mysql are often an issue. The logs usually=C2=A0point them out.=C2= =A0</div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_att= r">On Fri, Dec 22, 2023 at 5:13=E2=80=AFPM Waitman Gobble <<a href=3D"ma= ilto:gobble.wa@gmail.com">gobble.wa@gmail.com</a>> wrote:<br></div><bloc= kquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-= width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);paddin= g-left:1ex">I upgraded a server from FreeBSD 13.2-RELEASE to FreeBSD 14.0-R= ELEASE<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=3D/usr/local/etc/my.cnf --user=3Dmysql<br> --datadir=3D/var/db/mysql --pid-file=3D/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<b= r> missing something? Any ideas?<br> <br> TIA and HH<br> <br> -- <br> Waitman Gobble<br> \\<br> <br> </blockquote></div><br clear=3D"all"><div><br></div><span class=3D"gmail_si= gnature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature">Pa= ul Beard / <a href=3D"http://www.paulbeard.org/" target=3D"_blank">www.paul= beard.org/</a><br></div> --000000000000c26c48060d233164--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CAMtcK2pk%2BZkG=Bx8GHHzyx7CDY3cshTSHokqkxq6FbcqFHcirQ>