Skip site navigation (1)Skip section navigation (2)
Date:      Sat, 14 Jan 2012 10:17:17 -0800
From:      Paul Beard <paulbeard@gmail.com>
To:        FreeBSD-questions <questions@Freebsd.org>
Subject:   Solution: mysqld fails to run, can't create/find mysql.sock 
Message-ID:  <0F82362E-2694-4EBC-B019-DE2F2C160D45@gmail.com>

Next in thread | Raw E-Mail | Index | Archive | Help

--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--



Want to link to this message? Use this URL: <http://docs.FreeBSD.org/cgi/mid.cgi?0F82362E-2694-4EBC-B019-DE2F2C160D45>