From owner-freebsd-questions@FreeBSD.ORG Sat Jan 14 18:43:46 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 508D01065670 for ; Sat, 14 Jan 2012 18:43:46 +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 137818FC13 for ; Sat, 14 Jan 2012 18:43:45 +0000 (UTC) Received: by iagz16 with SMTP id z16so2039892iag.13 for ; Sat, 14 Jan 2012 10:43:45 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=from:content-type:subject:date:message-id:to:mime-version:x-mailer; bh=Qii8Xf1X0kYWmai8TiPEex3pxDwkPUEFgSUlTs2FNeQ=; b=k7XWFuukJ54d9ygu/LpsqSYGUO6FinGmb3l9gJPMJLafeJS6Uj8c9ju7n//0xMjJz+ wGuwBhbEBgwN5oshyS65PGXfVoanxDYj3a4zC9jAE1r2gxFcy5nqWeFjkX56Cl58gspL 52AcWnuDjpvcB0kwNFREecJkeGRYzhzVySCvw= Received: by 10.50.6.137 with SMTP id b9mr2267146iga.16.1326565042380; Sat, 14 Jan 2012 10:17:22 -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 b20sm43520507ibj.7.2012.01.14.10.17.18 (version=TLSv1/SSLv3 cipher=OTHER); Sat, 14 Jan 2012 10:17:19 -0800 (PST) From: Paul Beard Content-Type: multipart/signed; boundary="Apple-Mail=_06C920D9-9B96-4E43-A145-392E1A78F2A5"; protocol="application/pkcs7-signature"; micalg=sha1 Date: Sat, 14 Jan 2012 10:17:17 -0800 Message-Id: <0F82362E-2694-4EBC-B019-DE2F2C160D45@gmail.com> To: FreeBSD-questions Mime-Version: 1.0 (Apple Message framework v1251.1) X-Mailer: Apple Mail (2.1251.1) X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: Subject: 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 18:43:46 -0000 --Apple-Mail=_06C920D9-9B96-4E43-A145-392E1A78F2A5 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Woke up to a screenful of error messages about failed mysql backups and = found that for some reason, mysql was refusing to run at all. The issue = was not just a missing mysql.sock but an inability to create one. I = could do it by hand or at least create a file with the same name and = permissions but it would be removed on the next attempt and then not = replaced. Turns out the permissions on /tmp were not right. I didn't = note them beforehand but setting them 1777 solved it.=20 I would be interested in knowing how those permissions got changed. I = rebooted the system early on in the process as I kept seeing messages = like this: 120114 9:39:04 [ERROR] Can't start server : Bind on unix socket: = Permission denied 120114 9:39:04 [ERROR] Do you already have another mysqld server = running on socket: /tmp/mysql.sock ? Those are rubbish as error messages as they don't say the file can't be = created or give any indication of the actual problem.=20 This is all more a problem for the mysql developers than FreeBSD but I = am posting it to the list in case anyone else gets bitten by it.=20 -- Paul Beard Are you trying to win an argument or solve a problem?=20 --Apple-Mail=_06C920D9-9B96-4E43-A145-392E1A78F2A5--