From nobody Sun May 28 02:33:42 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 4QTN5K2k1Cz4X9jd for ; Sun, 28 May 2023 02:33:57 +0000 (UTC) (envelope-from aryeh.friedman@gmail.com) Received: from mail-ej1-x633.google.com (mail-ej1-x633.google.com [IPv6:2a00:1450:4864:20::633]) (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 4QTN5J6r1Tz4MVB for ; Sun, 28 May 2023 02:33:56 +0000 (UTC) (envelope-from aryeh.friedman@gmail.com) Authentication-Results: mx1.freebsd.org; none Received: by mail-ej1-x633.google.com with SMTP id a640c23a62f3a-96fbc74fbf1so389710666b.1 for ; Sat, 27 May 2023 19:33:56 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1685241233; x=1687833233; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=Efw8RcVb9LwFJ5JXVSw7cFwUnFEYL4EtCqP6mx5W+Jo=; b=s05bigbKGLHeRg4IZCXqFN0xkYjhzV23eavEOAECkhuqfl9CbUA5/MYlv366/YfKmC H8axW4gjW4BI9kGS9llF4/F7iMf/mFTT3AE7lR6xMV4/pcqoUmuG6DWBlelqu0wL0wHr bhOCyCAnEIFewphI422jV4qJCXUEa1Jipuo3qqSQUviUr/BzNQBwi4ZadyoCpvKuLGl7 2JzKHT16Gx6lRMWcDkr52WNWkOx0D5MIiQZUoPBo+ExUeALiom5OjIif0ZxKmwF9NSeD NuhBxrx8at49sb7G8octOXnmlxof23r82o+dzwgLWKZZ4UyWr3C8HLKTj8nPLWf3zqyI WgBQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1685241233; x=1687833233; h=content-transfer-encoding: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=Efw8RcVb9LwFJ5JXVSw7cFwUnFEYL4EtCqP6mx5W+Jo=; b=E+1DHth4s3Sv7F5pyj3wCZRdIixoeiYZsQdCqd/HJCbEzVuAhHfj+UV5SsIvJYH51N wt1gaeBt/V6iDpsvYjZa1sEZctbIRK4XsO6ptJwiL8ua271GO2NengzEqzirM5rGcoYj PT49gBRyDct5twxIPS45esNvDMG45ErqfQN5GEh8pMDQPAVtPk/nWa6e2obHLO1D5ixf zUW74m2NTyLR8pl/BTPeSA76qOd9y5xtIW8yFtOqzwuEWa8bO2Er6d0Hz4NLv5YltOyx YjHjiszPHcgWc6skX2J/VSM1VYuTQFvk3Jx0oSrhKN6LuJadAFUj0IPTTmME3rf7f2pO 11ag== X-Gm-Message-State: AC+VfDxhZCGU4csfQJShR601hCj+slCpjMJb5fybhdPwdKuaKNpqiX7p XNpE7bDueJZh+jp+kgm2tJ0y5rwGmz86fK+AvdpBqy8N X-Google-Smtp-Source: ACHHUZ6SlEWMdf5VeX+GvyF8R+NVrU2wCgdq71GH1Y5NNOb9Ci4AfijbcJV3u/KAo5SCxZ6OIjmyd/IpeYBR8R/pRUE= X-Received: by 2002:a17:907:80b:b0:94a:58a5:2300 with SMTP id wv11-20020a170907080b00b0094a58a52300mr6704235ejb.27.1685241233222; Sat, 27 May 2023 19:33:53 -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: Aryeh Friedman Date: Sat, 27 May 2023 22:33:42 -0400 Message-ID: Subject: Re: What happened to my /tmp/mysql.sock ?!!??! To: Paul Procacci Cc: Odhiambo Washington , FreeBSD Mailing List Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Rspamd-Queue-Id: 4QTN5J6r1Tz4MVB X-Spamd-Bar: ---- X-Spamd-Result: default: False [-4.00 / 15.00]; REPLY(-4.00)[]; ASN(0.00)[asn:15169, ipnet:2a00:1450::/32, country:US]; TAGGED_FROM(0.00)[] X-Rspamd-Pre-Result: action=no action; module=replies; Message is reply to one we originated X-ThisMailContainsUnwantedMimeParts: N On Sat, May 27, 2023 at 10:17=E2=80=AFPM Paul Procacci wrote: > > > > 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 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 >> >> > >> >> > >> >> > 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