From nobody Sat May 27 16:44:38 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 4QT71d4XrCz4V21k for ; Sat, 27 May 2023 16:44:53 +0000 (UTC) (envelope-from aryeh.friedman@gmail.com) Received: from mail-ed1-x52d.google.com (mail-ed1-x52d.google.com [IPv6:2a00:1450:4864:20::52d]) (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 4QT71d15Wcz3mNt for ; Sat, 27 May 2023 16:44:53 +0000 (UTC) (envelope-from aryeh.friedman@gmail.com) Authentication-Results: mx1.freebsd.org; none Received: by mail-ed1-x52d.google.com with SMTP id 4fb4d7f45d1cf-51456392cbbso3517145a12.0 for ; Sat, 27 May 2023 09:44:53 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1685205889; x=1687797889; 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=RwAwTEXTXFS22p1xSbSGC1prii7Q+TwgHTqL4mY2D2c=; b=UXE+mdgevvbUpVnu04trFQ7xmL+KwqPK4fxqsjrvkMVacLRqCxEVCD1/X8McKSGioR x5+c2rQII65zcWQOOZV1Q17Qjt6jHFLihCfRn2leZF1pVcPj8B4mT+XnvG5oFYlCfs+r o4hpCev+UbACKRAsKpwRCNG8w/NLjEHsDrYIPVaUfrL/iBrJQDr/fXyQZpWMt8HmjRvL /VqgaLpqR6WAM30on5S52p1pc/UAi9hbZDfoznm6pOYJgMkqPqkOQXGicINfEnQza5/5 CZbjHmmqEtn5IBBs2JPlf5XYFvdmSRnb5OHa6AGTYL1JKO4QEFm5c/OmWnIOxwx5FbuN lz6A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1685205889; x=1687797889; 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=RwAwTEXTXFS22p1xSbSGC1prii7Q+TwgHTqL4mY2D2c=; b=b1SxXb94etxsVyLommcjY4BEXoec684ZKdDL3Hwu0qKHdFA4rNz6X/wfpUn0h1L9IC zQxu7kOwSeFpU1kUF7rdLVLfmh8dmssyW8349ZdRzSQdijcOvwF5Uf+36r5hiN8bRdbH /ThMAl9jNqHoe8oplhCYjrJkA4bQgz4fg1sxMSXM4AaPCWxBjmN323sRnYbTjSdvOvyJ gNd0+9hpvErwFN15PU339Ki8a8DcaDnG7BDEl7c0RfbtiK7NS1Txgq+e2HRmbCBecM18 eXzyjPgpl9DpcGW30zsz3qzi6DVafQjctwzZ1HdCVkHCU1OmTrKCu2t/ULOKMRfenLTi SbIw== X-Gm-Message-State: AC+VfDyc+AqoFuqY1l9uH0Lg4eIMfcNbn6nj04543gP9PSu1cUk1/q1u gBvaXjX7bh20/eA8SNHdufRQkMUXWNJELij4dza78kLt8co= X-Google-Smtp-Source: ACHHUZ4bFIWR+UOk/GI6mfADbderCzysWqu2hTlKNl9rrn2/DZEgLonvIAcHyxyYyc6vwVysCUo9IOQkgvGnnuXhaYk= X-Received: by 2002:a17:907:72cb:b0:94e:4b26:233c with SMTP id du11-20020a17090772cb00b0094e4b26233cmr2609774ejc.16.1685205889180; Sat, 27 May 2023 09:44:49 -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 12:44:38 -0400 Message-ID: Subject: Re: What happened to my /tmp/mysql.sock ?!!??! To: Odhiambo Washington Cc: FreeBSD Mailing List Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Rspamd-Queue-Id: 4QT71d15Wcz3mNt X-Spamd-Bar: ---- X-Spamd-Result: default: False [-4.00 / 15.00]; REPLY(-4.00)[]; TAGGED_FROM(0.00)[]; ASN(0.00)[asn:15169, ipnet:2a00:1450::/32, country:US] 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 12:22=E2=80=AFPM Odhiambo Washington wrote: > > > > On Sat, May 27, 2023 at 6:51=E2=80=AFPM Aryeh Friedman 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 so= cket. > 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/local --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 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 installe= d 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 > > -- > 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-question= s.html] --=20 Aryeh M. Friedman, Lead Developer, http://www.PetiteCloud.org