Skip site navigation (1)Skip section navigation (2)
Date:      Sun, 15 Jan 2012 08:43:13 -0800
From:      Paul Beard <paulbeard@gmail.com>
Cc:        FreeBSD-questions <questions@Freebsd.org>
Subject:   Re: database apps that ignore sockets? [was: Solution: mysqld fails to run, can't create/find mysql.sock]
Message-ID:  <3720E228-67EE-4F44-B828-AFA0125D2A54@gmail.com>
In-Reply-To: <3D14230E-7E8A-4E35-8161-F5F9CB74C83C@mac.com>
References:  <0F82362E-2694-4EBC-B019-DE2F2C160D45@gmail.com> <7325D262-C6EB-42DB-870D-D3E2FAC9D0C1@mac.com> <1954AA20-BE6F-4F04-A770-49ECFA405B5D@gmail.com> <3D14230E-7E8A-4E35-8161-F5F9CB74C83C@mac.com>

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

--Apple-Mail=_1A9368C4-68C9-4584-902C-472BB9ECDF93
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=windows-1252


On Jan 15, 2012, at 8:17 AM, Chuck Swiger wrote:

> Something looking for a network location specified as a host and port =
(ie, localhost:3306) is using a TCP socket.  Something looking for =
/tmp/mysqld.sock is using a UNIX domain socket.
>=20
> Changing the path to the UNIX domain socket will have no effect upon =
the port used by the TCP socket, or vice versa.
>=20


Useful clarification but a UNIX domain socket sounds less like =
networking and more like interprocess communication, i.e., something =
explicitly tied to a single host. There is a "skip networking" option =
for MySQL that references the domain socket for use by processes on the =
same host but doesn't accept connections on port 3306. There's no =
indication that using localhost will default to a domain socket which =
will explicitly be looked for in /tmp and if you put it anywhere else, =
you must specify a hostname to access the TCP socket.=20

I'll quote your definition in the bug report as it seems crystal clear.=20=

--
Paul Beard

Are you trying to win an argument or solve a problem?=20


--Apple-Mail=_1A9368C4-68C9-4584-902C-472BB9ECDF93--



Want to link to this message? Use this URL: <http://docs.FreeBSD.org/cgi/mid.cgi?3720E228-67EE-4F44-B828-AFA0125D2A54>