From nobody Sun May 28 02:17:14 2023 X-Original-To: freebsd-questions@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4QTMkK1kmnz4X8yf for ; Sun, 28 May 2023 02:17:29 +0000 (UTC) (envelope-from pprocacci@gmail.com) Received: from mail-oa1-x2a.google.com (mail-oa1-x2a.google.com [IPv6:2001:4860:4864:20::2a]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (2048 bits) client-digest SHA256) (Client CN "smtp.gmail.com", Issuer "GTS CA 1D4" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4QTMkH1sXRz4KcN for ; Sun, 28 May 2023 02:17:27 +0000 (UTC) (envelope-from pprocacci@gmail.com) Authentication-Results: mx1.freebsd.org; dkim=pass header.d=gmail.com header.s=20221208 header.b=FL8BkElp; spf=pass (mx1.freebsd.org: domain of pprocacci@gmail.com designates 2001:4860:4864:20::2a as permitted sender) smtp.mailfrom=pprocacci@gmail.com; dmarc=pass (policy=none) header.from=gmail.com Received: by mail-oa1-x2a.google.com with SMTP id 586e51a60fabf-19eb96bffd4so2136749fac.3 for ; Sat, 27 May 2023 19:17:27 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1685240246; x=1687832246; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=0tOf9ktox7A0nHP3MY69o4nyiVAlMOsg6G7gFUIYQ1E=; b=FL8BkElpgm0Tr7Fgm6UBKWXEc7Jgzu/2uqL7h+W9gXy4nEvIPGSs85qWG0WjTexPeM pyyUSWploBFPZiEFNpMTGQgzmE9oPxVuGC+1YNBcoHiogI6yn7vDrv5C2oHfHXkc2K7O bxnrJufJky851OLejGfPYOYa1lHQjGWS81InYgH5EPvVv68W72YpeOsMIPTAa7O6b/AF LUImgD8K8APWd3WWHPrC7BkjDO4SKNoKOgY11OOPUfM842pVSQsUOmUB49Dwx33y9m+6 A90VOM9SBL55tzuyDgc2Xyg9D9pRASEI1IxW5j0obZad7za6fCqibk21ZDcDp2OlskBe /Myw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1685240246; x=1687832246; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=0tOf9ktox7A0nHP3MY69o4nyiVAlMOsg6G7gFUIYQ1E=; b=aOdD+bwpvXoR4taAWtxIFodYojilRQSgJOSD+oLxFuV25GVkR8iGZsoQpRIut8bIOz wuuET50ptEK7sDbOBqPzyutrGcBp0WBhZitvO1ODAgcFj5yYSEkEzMP3zpbsENBjxmNr C9tqbRWdHmakdqDSYXQ8oA+LLMKZfpzq2ogBJK7DjQdkODe03eiFti7XiDkTuNXeRV+V FzNzUWgT97IUnPb6BG9fgQ7c2/S5BulNpzDrk1hEKq+p5SCnrUHMVU9PfDhw6iqPh5CP gn9h78JihdNBGvI1js8irkVb84ch76iO0oCCooy8wytwmgIMBU9pT62+fe/2TANBjq93 Jd7g== X-Gm-Message-State: AC+VfDyozPCDdShhlVReZbDkmrT0sS7F01nZgtuKgTVZ2kb1ghY+lnS7 g5xy1bkvaMTHH9oCgNNQJAT1FaPSvyUzPs0trw== X-Google-Smtp-Source: ACHHUZ4YbIisK11h2ma4tv2nLFb+OQJ9bhuVBOzC4mey6tpTDuwBNHaYEkkcpWEgKshmNe7pyD/ay0Gh9sJ8heSEEws= X-Received: by 2002:a05:6870:d4c3:b0:195:c537:14f1 with SMTP id l3-20020a056870d4c300b00195c53714f1mr3197535oai.36.1685240245759; Sat, 27 May 2023 19:17:25 -0700 (PDT) List-Id: User questions List-Archive: https://lists.freebsd.org/archives/freebsd-questions List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-questions@freebsd.org X-BeenThere: freebsd-questions@freebsd.org MIME-Version: 1.0 References: In-Reply-To: From: Paul Procacci Date: Sat, 27 May 2023 22:17:14 -0400 Message-ID: Subject: Re: What happened to my /tmp/mysql.sock ?!!??! To: Aryeh Friedman Cc: Odhiambo Washington , FreeBSD Mailing List Content-Type: multipart/alternative; boundary="00000000000035b1c605fcb79231" X-Spamd-Result: default: False [-3.65 / 15.00]; NEURAL_HAM_LONG(-1.00)[-1.000]; NEURAL_HAM_MEDIUM(-0.84)[-0.844]; NEURAL_HAM_SHORT(-0.81)[-0.808]; DMARC_POLICY_ALLOW(-0.50)[gmail.com,none]; R_DKIM_ALLOW(-0.20)[gmail.com:s=20221208]; R_SPF_ALLOW(-0.20)[+ip6:2001:4860:4000::/36]; MIME_GOOD(-0.10)[multipart/alternative,text/plain]; RCPT_COUNT_THREE(0.00)[3]; FROM_HAS_DN(0.00)[]; TAGGED_RCPT(0.00)[]; FREEMAIL_FROM(0.00)[gmail.com]; TO_MATCH_ENVRCPT_SOME(0.00)[]; PREVIOUSLY_DELIVERED(0.00)[freebsd-questions@freebsd.org]; MLMMJ_DEST(0.00)[freebsd-questions@freebsd.org]; RCVD_IN_DNSWL_NONE(0.00)[2001:4860:4864:20::2a:from]; ARC_NA(0.00)[]; SUBJECT_HAS_QUESTION(0.00)[]; FREEMAIL_CC(0.00)[gmail.com,freebsd.org]; DKIM_TRACE(0.00)[gmail.com:+]; SUBJECT_ENDS_EXCLAIM(0.00)[]; TO_DN_ALL(0.00)[]; MID_RHS_MATCH_FROMTLD(0.00)[]; DWL_DNSWL_NONE(0.00)[gmail.com:dkim]; FREEMAIL_TO(0.00)[gmail.com]; RCVD_TLS_LAST(0.00)[]; ASN(0.00)[asn:15169, ipnet:2001:4860:4864::/48, country:US]; FROM_EQ_ENVFROM(0.00)[]; FREEMAIL_ENVFROM(0.00)[gmail.com]; MIME_TRACE(0.00)[0:+,1:+,2:~]; RCVD_COUNT_TWO(0.00)[2] X-Rspamd-Queue-Id: 4QTMkH1sXRz4KcN X-Spamd-Bar: --- X-ThisMailContainsUnwantedMimeParts: N --00000000000035b1c605fcb79231 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Sat, May 27, 2023 at 8:14=E2=80=AFPM Aryeh Friedman wrote: > On Sat, May 27, 2023 at 1:21=E2=80=AFPM Paul Procacci wrote: > > > > > > > > On Sat, May 27, 2023 at 1:13=E2=80=AFPM Aryeh Friedman > wrote: > >> > >> On Sat, May 27, 2023 at 1:09=E2=80=AFPM Odhiambo Washington > wrote: > >> > 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 > >> > > >> > > >> > 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 mysqld > 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 referenced 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 tank/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:" ~Paul --=20 __________________ :(){ :|:& };: --00000000000035b1c605fcb79231 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


On Sat, May 27, 2023= at 8:14=E2=80=AFPM Aryeh Friedman <aryeh.friedman@gmail.com> wrote:
=
On Sat, May 27, 2023 at 1= :21=E2=80=AFPM Paul Procacci <pprocacci@gmail.com> 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 lock privilege tables: Table 'mysql.user' doesn't exis= t
>> > 2023-05-27T12:40:12.835637Z 0 [ERROR] Fatal error: Failed to = initialize ACL/grant/time zones structures or failed to remove temporary ta= ble files.
>> > 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 !?!?!?=C2=A0 Literally installe= d 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 opt= ion
>> --
>> 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 mysqld in later versions of mysql.=C2=A0 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_bu= g.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 OP= S original post (or I had to search for referenced in the provided logs)
The mysql version is 5.7.41.
He's using latest.=C2=A0 N= ot quarterly.

Series of commands that I've done t= o create an mysql 5.7.41 environment:
zfs send tank/jails/templates/13.1= -RELEASE-stripped@initial | zfs recv tank/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 go= t 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> =C2=A0 NOTICE:

This port i= s deprecated; you may wish to reconsider installing it:"

=
~Paul
-- <= br>
__________________

:()= { :|:& };:
--00000000000035b1c605fcb79231--