Date: Sat, 27 May 2023 20:09:08 +0300 From: Odhiambo Washington <odhiambo@gmail.com> To: Aryeh Friedman <aryeh.friedman@gmail.com> Cc: FreeBSD Mailing List <freebsd-questions@freebsd.org> Subject: Re: What happened to my /tmp/mysql.sock ?!!??! Message-ID: <CAAdA2WNLUEG8CYSkNXLZ8Re=F2sJyqGooD3mqBf8fDo%2By-sGug@mail.gmail.com> In-Reply-To: <CAGBxaXnDVHZ0%2BUS3j0deDXOEVQFznMV7GNHi6jaD%2B6RVws4uYg@mail.gmail.com> References: <CAGBxaXkGMdp7sev9=UnE1sMQA9ni6-sBKfdE78-T28VPM2Hd%2BA@mail.gmail.com> <CAAdA2WNY9MH1fFrfF=25%2BquxeUvLR1B71QpUo9v-fyi4egv25g@mail.gmail.com> <CAGBxaXmKoYJS-giea7v5F39hZ5G06XnhMuQA0YNARQHJ4md=gw@mail.gmail.com> <CAAdA2WO7VNPLwqX06a-eoSpqxROezysy-vDT7zKcW1QYkM1xPw@mail.gmail.com> <CAGBxaXnDVHZ0%2BUS3j0deDXOEVQFznMV7GNHi6jaD%2B6RVws4uYg@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
--0000000000007e3b5105fcafeb09 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Sat, May 27, 2023 at 8:04=E2=80=AFPM Aryeh Friedman <aryeh.friedman@gmai= l.com> wrote: > On Sat, May 27, 2023 at 12:59=E2=80=AFPM Odhiambo Washington <odhiambo@gm= ail.com> > wrote: > > > > > > > > On Sat, May 27, 2023 at 7:44=E2=80=AFPM Aryeh Friedman <aryeh.friedman@= gmail.com> > wrote: > >> > >> On Sat, May 27, 2023 at 12:22=E2=80=AFPM Odhiambo Washington < > odhiambo@gmail.com> wrote: > >> > > >> > > >> > > >> > On Sat, May 27, 2023 at 6:51=E2=80=AFPM Aryeh Friedman < > aryeh.friedman@gmail.com> wrote: > >> >> > >> >> I accidentally erased the above file and now no matter what I try > >> >> (even a complete fresh install of the OS!?!?!) I can not get it > made.. > >> >> It appears it comes prebroken actually due to manually attempt to > >> >> start the service > >> >> > >> >> So the question is how on earth do I make this file... spent a whil= e > >> >> searching the web and fighting with chatGPT to no avail. > >> > > >> > > >> > That file is created automatically when MySQL is started. It is a > Unix socket. > >> > You do not need a complete reinstall of the OS to solve this problem= . > >> > Just find out what is stopping MySQL service from starting. > >> > You do not even need to reinstall MySQL! > >> > >> root@sarek1024:~ # ls /tmp/m* > >> ls: No match. > >> root@sarek1024:~ # service mysql-server onestart > >> // modified rc.d file to echo command as well as do it > >> /usr/local/bin/mysqld_safe --initialize > >> --defaults-extra-file=3D/usr/local/etc/mysql/my.cnf --basedir=3D/usr/l= ocal > >> --datadir=3D/var/db/mysql --mysqld-file=3D/usr/local/libexec/mysqld > >> --user=3Dmysql > >> Starting mysql. > >> root@sarek1024:~ # !ls > >> ls /tmp/m* > >> ls: No match. > >> root@sarek1024:~ # mysql > >> ERROR 2002 (HY000): Can't connect to local MySQL server through socket > >> '/tmp/mysql.sock' (2) > >> root@sarek1024:~ # tail -20 /var/log/messages > >> May 27 05:32:01 sarek1024 pkg-static[82552]: libXScrnSaver-1.2.4 > installed > >> May 27 05:32:09 sarek1024 pkg-static[88080]: tk86-8.6.13 installed > >> May 27 05:34:47 sarek1024 pkg-static[99500]: shc-4.0.3 installed > >> May 27 05:34:48 sarek1024 pkg-static[99839]: tk-wrapper-1.1_3 installe= d > >> May 27 05:34:48 sarek1024 pkg-static[99963]: tkdiff-5.0 installed > >> May 27 05:34:48 sarek1024 pkg-static[160]: aegis-4.25_14 installed > >> May 27 05:35:00 sarek1024 pkg-static[5372]: gsed-4.9 installed > >> May 27 05:35:59 sarek1024 pkg-static[81263]: lsof-4.97.0,8 installed > >> May 27 05:36:00 sarek1024 pkg-static[81390]: libexplain-1.3.D012_6 > installed > >> May 27 05:36:04 sarek1024 pkg-static[83063]: fhist-1.21_6 installed > >> May 27 05:36:23 sarek1024 pkg-static[86662]: cook-2.30_3 installed > >> May 27 05:36:24 sarek1024 pkg-static[87421]: log4j-1.2.17 installed > >> May 27 05:36:24 sarek1024 pkg-static[87556]: > >> mysql-connector-java51-5.1.49 installed > >> May 27 07:18:39 sarek1024 su[87745]: aryeh to root on /dev/pts/0 > >> May 27 07:20:44 sarek1024 aryeh[88442]: > >> /usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine for > >> mysql > >> May 27 07:22:38 sarek1024 aryeh[88484]: > >> /usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine for > >> mysql > >> May 27 07:27:13 sarek1024 aryeh[88574]: > >> /usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine for > >> mysql > >> May 27 07:33:42 sarek1024 aryeh[89279]: > >> /usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine for > >> mysql > >> May 27 07:34:42 sarek1024 aryeh[89290]: > >> /usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine for > >> mysql > >> May 27 07:35:28 sarek1024 aryeh[89303]: > >> /usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine for > >> > >> mysql > > > > > > cd /var/db/mysql/ > > > > less FQDN.err (FQDN =3D Fully Qualified Domain Name) > > That file will tell you why msql is not able to start. > > No errors I can see > Really?????? [snip] <quote> 2023-05-27T12:40:12.835631Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist 2023-05-27T12:40:12.835637Z 0 [ERROR] Fatal error: Failed to initialize ACL/grant/time zones structures or failed to remove temporary table files. 2023-05-27T12:40:12.835752Z 0 [ERROR] Aborting </quote> Please completely uninstall Mysql and reinstall afresh and it will start. Even better, install MariaDB :-) --=20 Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' =C2=AF\_(=E3=83=84)_/=C2=AF :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html] --0000000000007e3b5105fcafeb09 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable <div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote">= <div dir=3D"ltr" class=3D"gmail_attr">On Sat, May 27, 2023 at 8:04=E2=80=AF= PM Aryeh Friedman <<a href=3D"mailto:aryeh.friedman@gmail.com">aryeh.fri= edman@gmail.com</a>> wrote:<br></div><blockquote class=3D"gmail_quote" s= tyle=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);pad= ding-left:1ex">On Sat, May 27, 2023 at 12:59=E2=80=AFPM Odhiambo Washington= <<a href=3D"mailto:odhiambo@gmail.com" target=3D"_blank">odhiambo@gmail= .com</a>> wrote:<br> ><br> ><br> ><br> > On Sat, May 27, 2023 at 7:44=E2=80=AFPM Aryeh Friedman <<a href=3D"= mailto:aryeh.friedman@gmail.com" target=3D"_blank">aryeh.friedman@gmail.com= </a>> wrote:<br> >><br> >> On Sat, May 27, 2023 at 12:22=E2=80=AFPM Odhiambo Washington <<= a href=3D"mailto:odhiambo@gmail.com" target=3D"_blank">odhiambo@gmail.com</= a>> wrote:<br> >> ><br> >> ><br> >> ><br> >> > On Sat, May 27, 2023 at 6:51=E2=80=AFPM Aryeh Friedman <<a= href=3D"mailto:aryeh.friedman@gmail.com" target=3D"_blank">aryeh.friedman@= gmail.com</a>> wrote:<br> >> >><br> >> >> I accidentally erased the above file and now no matter wh= at I try<br> >> >> (even a complete fresh install of the OS!?!?!) I can not = get it made..<br> >> >> It appears it comes prebroken actually due to manually at= tempt to<br> >> >> start the service<br> >> >><br> >> >> So the question is how on earth do I make this file... sp= ent a while<br> >> >> searching the web and fighting with chatGPT to no avail.<= br> >> ><br> >> ><br> >> > That file is created automatically when MySQL is started. It = is a Unix socket.<br> >> > You do not need a complete reinstall of the OS to solve this = problem.<br> >> > Just find out what is stopping MySQL service from starting.<b= r> >> > You do not even need to reinstall MySQL!<br> >><br> >> root@sarek1024:~ # ls /tmp/m*<br> >> ls: No match.<br> >> root@sarek1024:~ # service mysql-server onestart<br> >> // modified rc.d file to echo command as well as do it<br> >> /usr/local/bin/mysqld_safe --initialize<br> >> --defaults-extra-file=3D/usr/local/etc/mysql/my.cnf --basedir=3D/u= sr/local<br> >> --datadir=3D/var/db/mysql --mysqld-file=3D/usr/local/libexec/mysql= d<br> >> --user=3Dmysql<br> >> Starting mysql.<br> >> root@sarek1024:~ # !ls<br> >> ls /tmp/m*<br> >> ls: No match.<br> >> root@sarek1024:~ # mysql<br> >> ERROR 2002 (HY000): Can't connect to local MySQL server throug= h socket<br> >> '/tmp/mysql.sock' (2)<br> >> root@sarek1024:~ # tail -20 /var/log/messages<br> >> May 27 05:32:01 sarek1024 pkg-static[82552]: libXScrnSaver-1.2.4 i= nstalled<br> >> May 27 05:32:09 sarek1024 pkg-static[88080]: tk86-8.6.13 installed= <br> >> May 27 05:34:47 sarek1024 pkg-static[99500]: shc-4.0.3 installed<b= r> >> May 27 05:34:48 sarek1024 pkg-static[99839]: tk-wrapper-1.1_3 inst= alled<br> >> May 27 05:34:48 sarek1024 pkg-static[99963]: tkdiff-5.0 installed<= br> >> May 27 05:34:48 sarek1024 pkg-static[160]: aegis-4.25_14 installed= <br> >> May 27 05:35:00 sarek1024 pkg-static[5372]: gsed-4.9 installed<br> >> May 27 05:35:59 sarek1024 pkg-static[81263]: lsof-4.97.0,8 install= ed<br> >> May 27 05:36:00 sarek1024 pkg-static[81390]: libexplain-1.3.D012_6= installed<br> >> May 27 05:36:04 sarek1024 pkg-static[83063]: fhist-1.21_6 installe= d<br> >> May 27 05:36:23 sarek1024 pkg-static[86662]: cook-2.30_3 installed= <br> >> May 27 05:36:24 sarek1024 pkg-static[87421]: log4j-1.2.17 installe= d<br> >> May 27 05:36:24 sarek1024 pkg-static[87556]:<br> >> mysql-connector-java51-5.1.49 installed<br> >> May 27 07:18:39 sarek1024 su[87745]: aryeh to root on /dev/pts/0<b= r> >> May 27 07:20:44 sarek1024 aryeh[88442]:<br> >> /usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine f= or<br> >> mysql<br> >> May 27 07:22:38 sarek1024 aryeh[88484]:<br> >> /usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine f= or<br> >> mysql<br> >> May 27 07:27:13 sarek1024 aryeh[88574]:<br> >> /usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine f= or<br> >> mysql<br> >> May 27 07:33:42 sarek1024 aryeh[89279]:<br> >> /usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine f= or<br> >> mysql<br> >> May 27 07:34:42 sarek1024 aryeh[89290]:<br> >> /usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine f= or<br> >> mysql<br> >> May 27 07:35:28 sarek1024 aryeh[89303]:<br> >> /usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine f= or<br> >><br> >> mysql<br> ><br> ><br> > cd=C2=A0 /var/db/mysql/<br> ><br> > less FQDN.err (FQDN =3D Fully Qualified Domain Name)<br> > That file will tell you why msql is not able to start.<br> <br> No errors I can see<br></blockquote><div><br></div><div>Really??????</div><= div><br></div><div>[snip]=C2=A0</div><div><br></div><div><quote><br> 2023-05-27T12:40:12.835631Z 0 [ERROR] Fatal error: Can't open and lock= =C2=A0privilege tables: Table 'mysql.user' doesn't exist<br> 2023-05-27T12:40:12.835637Z 0 [ERROR] Fatal error: Failed to=C2=A0initializ= e ACL/grant/time zones structures or failed to remove=C2=A0temporary table = files.<br> 2023-05-27T12:40:12.835752Z 0 [ERROR] Aborting</div><div></quote></di= v><div><br></div><div>Please completely uninstall Mysql and reinstall afres= h and it will start.</div><div><br></div><div>Even better, install MariaDB = :-)</div><div><br></div><div> </div></div><div><br></div><br clear=3D"all"><div><br></div><span class=3D"= gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signa= ture"><div dir=3D"ltr"><div dir=3D"ltr"><div>Best regards,<br>Odhiambo WASH= INGTON,<br>Nairobi,KE<br>+254 7 3200 0004/+254 7 2274 3223<br>"<span s= tyle=3D"font-size:12.8px">Oh, the cruft.</span><span style=3D"font-size:12.= 8px">",=C2=A0</span><span style=3D"font-size:12.8px">egrep -v '^$|= ^.*#'=C2=A0</span><span style=3D"background-color:rgb(34,34,34);color:r= gb(238,238,238);font-family:"Lucida Console",Consolas,"Couri= er New",monospace;font-size:13.6px">=C2=AF\_(=E3=83=84)_/=C2=AF</span>= <span style=3D"font-size:12.8px">=C2=A0:-)</span></div><div><span style=3D"= font-size:12.8px">[How to ask smart questions:=C2=A0</span><span style=3D"f= ont-size:12.8px"><a href=3D"http://www.catb.org/~esr/faqs/smart-questions.h= tml" target=3D"_blank">http://www.catb.org/~esr/faqs/smart-questions.html</= a>]</span></div></div></div></div></div> --0000000000007e3b5105fcafeb09--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CAAdA2WNLUEG8CYSkNXLZ8Re=F2sJyqGooD3mqBf8fDo%2By-sGug>