From nobody Sat May 27 17:09:08 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 4QT7ZL6GHxz4V3LQ for ; Sat, 27 May 2023 17:09:46 +0000 (UTC) (envelope-from odhiambo@gmail.com) Received: from mail-lf1-x12c.google.com (mail-lf1-x12c.google.com [IPv6:2a00:1450:4864:20::12c]) (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 4QT7ZL0rQJz3qwK for ; Sat, 27 May 2023 17:09:46 +0000 (UTC) (envelope-from odhiambo@gmail.com) Authentication-Results: mx1.freebsd.org; dkim=pass header.d=gmail.com header.s=20221208 header.b=ffnwEkZb; spf=pass (mx1.freebsd.org: domain of odhiambo@gmail.com designates 2a00:1450:4864:20::12c as permitted sender) smtp.mailfrom=odhiambo@gmail.com; dmarc=pass (policy=none) header.from=gmail.com Received: by mail-lf1-x12c.google.com with SMTP id 2adb3069b0e04-4f4f3ac389eso511719e87.1 for ; Sat, 27 May 2023 10:09:46 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1685207384; x=1687799384; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=J5hd9dYCUSgchkIQcj8eXZ3hl67lWC4z/hfPg6oHpy0=; b=ffnwEkZb91icSWJzq5xcXdRZIesIsxe/6KrrhWXAfZKdKLF96srYwg8Ck8EwEWgEyt 3nWwWW8/ohRHUJtvcPldc1DosluormXVHkSjGUejKkrH4ZUnIMUcSKqRZaZ7LS05BQ9N 7B7mguNSQskYNbjMLoQ75NWlUIwjFJire7DM95/A2tIupD89VyUCdqiT+ynYtEgQI6Ip V/B8CmCCUbfqr0x9Wm1NpgEJzfLm+Cl9BZlr33BSV7KyhGDUnvoJoV9RaRpOYrwfRsyF FiI0jFjxEMvBcpgE45vFzB3MB7Z4xIw5ZlJG9WLABFOmWIVQcwRk4p3Ye6OA7nojt+1G 7YGw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1685207384; x=1687799384; 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=J5hd9dYCUSgchkIQcj8eXZ3hl67lWC4z/hfPg6oHpy0=; b=ZXfG2+AFUzjEGliL8CbgSgbgfhFmJzWh0bsU53hO0uJWOIHH4rRMuNyn5Wdb6jFX8w 0WNvNvJBvbxzHkyLuuXtTdXtwmz7z6VsLAs/eRJ5jw2Z6tY6rvPCl/XXAbQ8jyEgng8a jJvS+gz0f/ohWSYEjbxMqRQcOZToRo6MOlAqTGw+c+M8KGnTzbuZ14RrBxqp0kKFAF2k jU6vGHmhyPb/0k2PUOy7zFilEL4YjosNX6+4uHpIgdDwX/4tnNDVHy2FW84m3/mb8RkU T7/nvppUCbyld+n+oCpU/fAQk5j5IhQl0t6kVhc9daeZd4w2CKRJu+7Np7xRbpMEerPZ WRRg== X-Gm-Message-State: AC+VfDxgENNHXFNPQgusIK1XScQ/DeJ1PpqVlYNPcjGa/8+lbKhQZWxT F9mposIjf02k6KUthdEvi1Dl5YdHfBcVJmkduYk= X-Google-Smtp-Source: ACHHUZ7RHIdlLTsmEb842AU3iDH5cRbJJxt+5WYyXQWhVNdbL08Qq16LSje8zw035a5ljx9cstjgwG0ZMp2r7gURu+g= X-Received: by 2002:a2e:2410:0:b0:2ad:dab5:fe8e with SMTP id k16-20020a2e2410000000b002addab5fe8emr1753174ljk.47.1685207383946; Sat, 27 May 2023 10:09:43 -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: Odhiambo Washington Date: Sat, 27 May 2023 20:09:08 +0300 Message-ID: Subject: Re: What happened to my /tmp/mysql.sock ?!!??! To: Aryeh Friedman Cc: FreeBSD Mailing List Content-Type: multipart/alternative; boundary="0000000000007e3b5105fcafeb09" X-Spamd-Result: default: False [-3.02 / 15.00]; NEURAL_HAM_LONG(-1.00)[-1.000]; NEURAL_HAM_SHORT(-0.70)[-0.700]; DMARC_POLICY_ALLOW(-0.50)[gmail.com,none]; NEURAL_HAM_MEDIUM(-0.32)[-0.322]; R_DKIM_ALLOW(-0.20)[gmail.com:s=20221208]; R_SPF_ALLOW(-0.20)[+ip6:2a00:1450:4000::/36]; MIME_GOOD(-0.10)[multipart/alternative,text/plain]; FROM_HAS_DN(0.00)[]; TAGGED_RCPT(0.00)[]; FREEMAIL_FROM(0.00)[gmail.com]; ARC_NA(0.00)[]; RCVD_IN_DNSWL_NONE(0.00)[2a00:1450:4864:20::12c:from]; PREVIOUSLY_DELIVERED(0.00)[freebsd-questions@freebsd.org]; BLOCKLISTDE_FAIL(0.00)[2a00:1450:4864:20::12c:server fail]; TO_MATCH_ENVRCPT_SOME(0.00)[]; DWL_DNSWL_NONE(0.00)[gmail.com:dkim]; ASN(0.00)[asn:15169, ipnet:2a00:1450::/32, country:US]; MLMMJ_DEST(0.00)[freebsd-questions@freebsd.org]; DKIM_TRACE(0.00)[gmail.com:+]; RCPT_COUNT_TWO(0.00)[2]; TO_DN_ALL(0.00)[]; MID_RHS_MATCH_FROMTLD(0.00)[]; SUBJECT_HAS_QUESTION(0.00)[]; SUBJECT_ENDS_EXCLAIM(0.00)[]; FROM_EQ_ENVFROM(0.00)[]; FREEMAIL_ENVFROM(0.00)[gmail.com]; FREEMAIL_TO(0.00)[gmail.com]; MIME_TRACE(0.00)[0:+,1:+,2:~]; RCVD_TLS_LAST(0.00)[]; RCVD_COUNT_TWO(0.00)[2] X-Rspamd-Queue-Id: 4QT7ZL0rQJz3qwK X-Spamd-Bar: --- X-ThisMailContainsUnwantedMimeParts: N --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 wrote: > On Sat, May 27, 2023 at 12:59=E2=80=AFPM Odhiambo Washington > wrote: > > > > > > > > On Sat, May 27, 2023 at 7:44=E2=80=AFPM Aryeh Friedman > 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] 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. 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


=
On Sat, May 27, 2023 at 8:04=E2=80=AF= PM Aryeh Friedman <aryeh.fri= edman@gmail.com> wrote:
On Sat, May 27, 2023 at 12:59=E2=80=AFPM Odhiambo Washington= <odhiambo@gmail= .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 <<= a href=3D"mailto:odhiambo@gmail.com" target=3D"_blank">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 wh= at 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 at= tempt to
>> >> start the service
>> >>
>> >> So the question is how on earth do I make this file... sp= ent a while
>> >> searching the web and fighting with chatGPT to no avail.<= br> >> >
>> >
>> > 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/u= sr/local
>> --datadir=3D/var/db/mysql --mysqld-file=3D/usr/local/libexec/mysql= d
>> --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 throug= h 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 i= nstalled
>> 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 inst= alled
>> 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=
>> 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 install= ed
>> 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 installe= d
>> 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 installe= d
>> 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 f= or
>> mysql
>> May 27 07:22:38 sarek1024 aryeh[88484]:
>> /usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine f= or
>> mysql
>> May 27 07:27:13 sarek1024 aryeh[88574]:
>> /usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine f= or
>> mysql
>> May 27 07:33:42 sarek1024 aryeh[89279]:
>> /usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine f= or
>> mysql
>> May 27 07:34:42 sarek1024 aryeh[89290]:
>> /usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine f= or
>> mysql
>> May 27 07:35:28 sarek1024 aryeh[89303]:
>> /usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine f= or
>>
>> mysql
>
>
> cd=C2=A0 /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??????
<= div>
[snip]=C2=A0

<quote>
2023-05-27T12:40:12.835631Z 0 [ERROR] Fatal error: Can't open and lock= =C2=A0privilege tables: Table 'mysql.user' doesn't exist
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.
2023-05-27T12:40:12.835752Z 0 [ERROR] Aborting
</quote>

Please completely uninstall Mysql and reinstall afres= h and it will start.

Even better, install MariaDB = :-)




--
Best regards,
Odhiambo WASH= INGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.",=C2=A0egrep -v '^$|= ^.*#'=C2=A0=C2=AF\_(=E3=83=84)_/=C2=AF= =C2=A0:-)
[How to ask smart questions:=C2=A0http://www.catb.org/~esr/faqs/smart-questions.html]
--0000000000007e3b5105fcafeb09--