Date: Sat, 27 May 2023 19:58:51 +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: <CAAdA2WO7VNPLwqX06a-eoSpqxROezysy-vDT7zKcW1QYkM1xPw@mail.gmail.com> In-Reply-To: <CAGBxaXmKoYJS-giea7v5F39hZ5G06XnhMuQA0YNARQHJ4md=gw@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>
next in thread | previous in thread | raw e-mail | index | archive | help
[-- Attachment #1 --] On Sat, May 27, 2023 at 7:44 PM Aryeh Friedman <aryeh.friedman@gmail.com> wrote: > On Sat, May 27, 2023 at 12:22 PM Odhiambo Washington <odhiambo@gmail.com> > wrote: > > > > > > > > On Sat, May 27, 2023 at 6:51 PM 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 while > >> 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=/usr/local/etc/mysql/my.cnf --basedir=/usr/local > --datadir=/var/db/mysql --mysqld-file=/usr/local/libexec/mysqld > --user=mysql > 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 installed > 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 = Fully Qualified Domain Name) That file will tell you why msql is not able to start. PS: If this is a new machine, then: rm -rf /var/db/mysql Then try starting MySQL service again. Check if the directory is recreated and read the contents of the file with .err extension. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html] [-- Attachment #2 --] <div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Sat, May 27, 2023 at 7:44 PM Aryeh Friedman <<a href="mailto:aryeh.friedman@gmail.com">aryeh.friedman@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">On Sat, May 27, 2023 at 12:22 PM Odhiambo Washington <<a href="mailto:odhiambo@gmail.com" target="_blank">odhiambo@gmail.com</a>> wrote:<br> ><br> ><br> ><br> > On Sat, May 27, 2023 at 6:51 PM Aryeh Friedman <<a href="mailto:aryeh.friedman@gmail.com" target="_blank">aryeh.friedman@gmail.com</a>> wrote:<br> >><br> >> I accidentally erased the above file and now no matter what 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 attempt to<br> >> start the service<br> >><br> >> So the question is how on earth do I make this file... spent 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.<br> > 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=/usr/local/etc/mysql/my.cnf --basedir=/usr/local<br> --datadir=/var/db/mysql --mysqld-file=/usr/local/libexec/mysqld<br> --user=mysql<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 through 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 installed<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<br> May 27 05:34:48 sarek1024 pkg-static[99839]: tk-wrapper-1.1_3 installed<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 installed<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 installed<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 installed<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<br> May 27 07:20:44 sarek1024 aryeh[88442]:<br> /usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine for<br> mysql<br> May 27 07:22:38 sarek1024 aryeh[88484]:<br> /usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine for<br> mysql<br> May 27 07:27:13 sarek1024 aryeh[88574]:<br> /usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine for<br> mysql<br> May 27 07:33:42 sarek1024 aryeh[89279]:<br> /usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine for<br> mysql<br> May 27 07:34:42 sarek1024 aryeh[89290]:<br> /usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine for<br> mysql<br> May 27 07:35:28 sarek1024 aryeh[89303]:<br> /usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine for </blockquote><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"> mysql<br></blockquote><div></div></div><div><br></div>cd /var/db/mysql/<div><br></div><div>less FQDN.err (FQDN = Fully Qualified Domain Name)</div><div>That file will tell you why msql is not able to start.</div><div><br></div><div>PS: If this is a new machine, then:</div><div><br></div><div>rm -rf /var/db/mysql</div><div><br></div><div>Then try starting MySQL service again.</div><div>Check if the directory is recreated and read the contents of the file with .err extension.<br clear="all"><div><br></div><span class="gmail_signature_prefix">-- </span><br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div dir="ltr"><div>Best regards,<br>Odhiambo WASHINGTON,<br>Nairobi,KE<br>+254 7 3200 0004/+254 7 2274 3223<br>"<span style="font-size:12.8px">Oh, the cruft.</span><span style="font-size:12.8px">", </span><span style="font-size:12.8px">egrep -v '^$|^.*#' </span><span style="background-color:rgb(34,34,34);color:rgb(238,238,238);font-family:"Lucida Console",Consolas,"Courier New",monospace;font-size:13.6px">¯\_(ツ)_/¯</span><span style="font-size:12.8px"> :-)</span></div><div><span style="font-size:12.8px">[How to ask smart questions: </span><span style="font-size:12.8px"><a href="http://www.catb.org/~esr/faqs/smart-questions.html" target="_blank">http://www.catb.org/~esr/faqs/smart-questions.html</a>]</span></div></div></div></div></div></div>;
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CAAdA2WO7VNPLwqX06a-eoSpqxROezysy-vDT7zKcW1QYkM1xPw>