From owner-freebsd-questions@FreeBSD.ORG Sat Jan 14 20:05:36 2012 Return-Path: Delivered-To: questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 2C37C106564A for ; Sat, 14 Jan 2012 20:05:36 +0000 (UTC) (envelope-from paulbeard@gmail.com) Received: from mail-iy0-f182.google.com (mail-iy0-f182.google.com [209.85.210.182]) by mx1.freebsd.org (Postfix) with ESMTP id DD9B78FC13 for ; Sat, 14 Jan 2012 20:05:35 +0000 (UTC) Received: by iagz16 with SMTP id z16so2150566iag.13 for ; Sat, 14 Jan 2012 12:05:35 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=subject:mime-version:content-type:from:in-reply-to:date:cc :message-id:references:to:x-mailer; bh=DPGfIt5ZZ5jSPGcO979WrooVALZzMaQ7xqAtlfdAFG0=; b=dxxj0vvAixRdEZdQ7TjbM2YCHX72DXkIvmLn4m6/WG/Uu9VD8gtVOJpYMtX79HK2QI hGbRG/SAnnoKdrZ/gt3Ys1XsvG0L1/bP3xwpYtTRwMQlrJi3AlAwyMbJwxD5k0qvSs4m ekG/izIJCMpRdXeGb3I0/l05CkIcJ+izRP6Y0= Received: by 10.50.173.98 with SMTP id bj2mr3468387igc.27.1326571535186; Sat, 14 Jan 2012 12:05:35 -0800 (PST) Received: from ivoire.paulbeard.org (174-21-126-117.tukw.qwest.net. [174.21.126.117]) by mx.google.com with ESMTPS id r5sm22476951igl.3.2012.01.14.12.05.31 (version=TLSv1/SSLv3 cipher=OTHER); Sat, 14 Jan 2012 12:05:32 -0800 (PST) Mime-Version: 1.0 (Apple Message framework v1251.1) Content-Type: multipart/signed; boundary="Apple-Mail=_48C249F0-27D6-4933-AE32-6C39CDE0D865"; protocol="application/pkcs7-signature"; micalg=sha1 From: Paul Beard In-Reply-To: <7325D262-C6EB-42DB-870D-D3E2FAC9D0C1@mac.com> Date: Sat, 14 Jan 2012 12:05:30 -0800 Message-Id: <483F5D6D-ED7C-4739-9579-E2AC4B7EDF7C@gmail.com> References: <0F82362E-2694-4EBC-B019-DE2F2C160D45@gmail.com> <7325D262-C6EB-42DB-870D-D3E2FAC9D0C1@mac.com> To: Chuck Swiger X-Mailer: Apple Mail (2.1251.1) X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: FreeBSD-questions Subject: Re: Solution: mysqld fails to run, can't create/find mysql.sock X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 14 Jan 2012 20:05:36 -0000 --Apple-Mail=_48C249F0-27D6-4933-AE32-6C39CDE0D865 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii On Jan 14, 2012, at 11:15 AM, Chuck Swiger wrote: > The meaning seems obvious enough; mysqld was unable to bind to the = socket, which is what perror() meant with "Permission denied": Really? I read this:=20 > 120114 9:39:04 [ERROR] Do you already have another mysqld server = running on socket: /tmp/mysql.sock ? as "there is an existing socket that seems to be in use: what's up with = that?" The message references a file that does not exist (but that mysql will = cheerfully remove if found). There was no existing socket. Those two = lines, taken together, tell me that a. mysql can't run without a socket = and b. it thinks another process is running, bound to a socket that = doesn't exist. Clear as mud.=20 How about=20 [ERROR] socket: /tmp/mysql.sock not found=20 and/or=20 [ERROR] socket:/tmp/mysql.sock could not be created perhaps with a helpful hint about permissions.=20 If this was unusual, that would be one thing but I found quite a few = references to the problem before I found the solution.=20 Maybe it's a housekeeping thing but why would mysql need to destroy the = file it uses for a socket and then recreate it when it could simply = examine it and reuse it?=20 > Anyway, doesn't the mysql port want to keep the socket under = /var/run/mysql/mysqld.sock or some such, to avoid issues with /tmp? Apparently not, as I commented out any reference to it in my.cnf and = still saw the same messages about /tmp/mysql.sock. It seems to work if = spelled out explicitly.=20 =20 -- Paul Beard Are you trying to win an argument or solve a problem?=20 --Apple-Mail=_48C249F0-27D6-4933-AE32-6C39CDE0D865--