From owner-freebsd-questions@FreeBSD.ORG Sun Jan 15 16:43:23 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 B8471106564A for ; Sun, 15 Jan 2012 16:43:23 +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 778CA8FC13 for ; Sun, 15 Jan 2012 16:43:23 +0000 (UTC) Received: by iagz16 with SMTP id z16so3547358iag.13 for ; Sun, 15 Jan 2012 08:43:22 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=from:mime-version:content-type:subject:date:in-reply-to:cc :references:message-id:x-mailer; bh=iZ0/aBl3Si7wjsR3TljJVnczAsrG2W2CdyEOgNKKV+Q=; b=ryAZkgLVUzS0mLW+AxiYDpi0vqGifAfkNqzRg4cjLTYgSELtEyYM/9jjLTmlIffJWy qyatcAXtngbjjawbl3TErwrvFZ//rbaNEblRb6YPgk9iMviGZzw7nhIrLSEGiSYYkmJO yWy+Cpqx7xBEojTkjQfTN9EJIirXsV/96dGAs= Received: by 10.50.217.168 with SMTP id oz8mr9449415igc.9.1326645802887; Sun, 15 Jan 2012 08:43:22 -0800 (PST) Received: from ivoire.paulbeard.org (174-21-117-199.tukw.qwest.net. [174.21.117.199]) by mx.google.com with ESMTPS id l28sm55236075ibc.3.2012.01.15.08.43.17 (version=TLSv1/SSLv3 cipher=OTHER); Sun, 15 Jan 2012 08:43:18 -0800 (PST) From: Paul Beard Mime-Version: 1.0 (Apple Message framework v1251.1) Content-Type: multipart/signed; boundary="Apple-Mail=_1A9368C4-68C9-4584-902C-472BB9ECDF93"; protocol="application/pkcs7-signature"; micalg=sha1 Date: Sun, 15 Jan 2012 08:43:13 -0800 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> Message-Id: <3720E228-67EE-4F44-B828-AFA0125D2A54@gmail.com> X-Mailer: Apple Mail (2.1251.1) X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: FreeBSD-questions Subject: Re: database apps that ignore sockets? [was: 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: Sun, 15 Jan 2012 16:43:23 -0000 --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--