Date: Sat, 27 May 2023 22:33:42 -0400 From: Aryeh Friedman <aryeh.friedman@gmail.com> To: Paul Procacci <pprocacci@gmail.com> Cc: Odhiambo Washington <odhiambo@gmail.com>, FreeBSD Mailing List <freebsd-questions@freebsd.org> Subject: Re: What happened to my /tmp/mysql.sock ?!!??! Message-ID: <CAGBxaXm%2BzwtN707Lp4CP0Ee-UuVchOEyJfnUDkbeb9R9u5UGKw@mail.gmail.com> In-Reply-To: <CAFbbPuh9vHaUyxznq4gqdPQQDdyhTprS54Yu=P6rwFX0f7crdQ@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> <CAAdA2WNLUEG8CYSkNXLZ8Re=F2sJyqGooD3mqBf8fDo%2By-sGug@mail.gmail.com> <CAGBxaX=UV=dXKO=qn7=KS=dip3rUG3=LT=qVRu2eKg%2BTsckaRA@mail.gmail.com> <CAFbbPugb3YkqXWsPGR%2B_2F1eHA_vwcKKz6=Fy5fgDhUjo0P%2B-A@mail.gmail.com> <CAGBxaXn9spaKrBxJ5Pq7LjFeotjAy0ZVZ3=N3jyQZAMcVKbPkw@mail.gmail.com> <CAFbbPuh9vHaUyxznq4gqdPQQDdyhTprS54Yu=P6rwFX0f7crdQ@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On Sat, May 27, 2023 at 10:17=E2=80=AFPM Paul Procacci <pprocacci@gmail.com= > wrote: > > > > On Sat, May 27, 2023 at 8:14=E2=80=AFPM Aryeh Friedman <aryeh.friedman@gm= ail.com> wrote: >> >> On Sat, May 27, 2023 at 1:21=E2=80=AFPM Paul Procacci <pprocacci@gmail.c= om> wrote: >> > >> > >> > >> > On Sat, May 27, 2023 at 1:13=E2=80=AFPM Aryeh Friedman <aryeh.friedman= @gmail.com> wrote: >> >> >> >> On Sat, May 27, 2023 at 1:09=E2=80=AFPM Odhiambo Washington <odhiambo= @gmail.com> wrote: >> >> > 2023-05-27T12:40:12.835631Z 0 [ERROR] Fatal error: Can't open and l= ock privilege tables: Table 'mysql.user' doesn't exist >> >> > 2023-05-27T12:40:12.835637Z 0 [ERROR] Fatal error: Failed to initia= lize ACL/grant/time zones structures or failed to remove temporary table fi= les. >> >> > 2023-05-27T12:40:12.835752Z 0 [ERROR] Aborting >> >> > </quote> >> >> > >> >> > Please completely uninstall Mysql and reinstall afresh and it will = start. >> >> >> >> This *IS* a completely new install !?!?!? Literally installed 5 mins >> >> before I posted on a complete fresh VM >> >> > >> >> > Even better, install MariaDB :-) >> >> >> >> Since I need to debug a mysql DB on a production server not an option >> >> -- >> >> Aryeh M. Friedman, Lead Developer, http://www.PetiteCloud.org >> >> >> > >> > I didn't catch the version of mysql you were attempting to run but one= of two commands will solve your problem. >> > The first is potentially mysql_install_db. >> > >> > It's possible this command doesn't exist due to it being part of mysql= d in later versions of mysql. If that's the case then the following should= initialize the databases. >> > >> > mysqld --initialize >> Already tried both this seems to be related to a series of bugs all up >> and down the mysql food chain in the last few weeks: >> https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D270807 >> >> >> > >> > Once one of the two are completed, then you can try the things that Mr= . Washington was suggesting and repost an new error messages. >> > >> > ~Paul >> > >> > -- >> > __________________ >> > >> > :(){ :|:& };: >> >> >> >> -- >> Aryeh M. Friedman, Lead Developer, http://www.PetiteCloud.org > > > Some things excluded from the OPS original post (or I had to search for r= eferenced in the provided logs) > The mysql version is 5.7.41. > He's using latest. Not quarterly. > > Series of commands that I've done to create an mysql 5.7.41 environment: > zfs send tank/jails/templates/13.1-RELEASE-stripped@initial | zfs recv ta= nk/jails/hosts/mysql-test > zfs set mountpoint=3D/jails/hosts/mysql-test tank/jails/hosts/mysql-test > pkg -r /jails/hosts/mysql-test install -y mysql57-server-5.7.41 > /etc/rc.d/jail onestart mysql-test > > *To follow along the jail id that got created has a numeric identifier of= 17. > From there: > > jexec -u root 17 /usr/local/etc/rc.d/mysql-server onestart > # pgrep -j 17 -l mysqld > 58398 mysqld > > I cannot replicate the OPs problem. > > Note the installation from the port: > > "=3D=3D=3D> NOTICE: > > This port is deprecated; you may wish to reconsider installing it:" It is the newest version of mysql that will not barf on the DB I am attempting debug which a 5.1 with some really insane errors in it like foreign-keys that are constraints but point to non-existent records. And this is on a VM so need for fancy jailing. I am also on 13.2. > > ~Paul > -- > __________________ > > :(){ :|:& };: --=20 Aryeh M. Friedman, Lead Developer, http://www.PetiteCloud.org
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CAGBxaXm%2BzwtN707Lp4CP0Ee-UuVchOEyJfnUDkbeb9R9u5UGKw>