From owner-freebsd-questions@FreeBSD.ORG Sun Jan 15 16:18:01 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 7DB95106566C for ; Sun, 15 Jan 2012 16:18:01 +0000 (UTC) (envelope-from cswiger@mac.com) Received: from asmtpout019.mac.com (asmtpout019.mac.com [17.148.16.94]) by mx1.freebsd.org (Postfix) with ESMTP id 61C888FC08 for ; Sun, 15 Jan 2012 16:18:01 +0000 (UTC) MIME-version: 1.0 Content-type: text/plain; charset=windows-1252 Received: from [10.1.2.144] (unknown [173.200.178.70]) by asmtp019.mac.com (Oracle Communications Messaging Server 7u4-23.01 (7.0.4.23.0) 64bit (built Aug 10 2011)) with ESMTPSA id <0LXU006ZFL9YLJ50@asmtp019.mac.com> for questions@Freebsd.org; Sun, 15 Jan 2012 16:17:59 +0000 (GMT) X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10432:5.5.7110,1.0.211,0.0.0000 definitions=2012-01-15_03:2012-01-13, 2012-01-15, 1970-01-01 signatures=0 X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 spamscore=0 ipscore=0 suspectscore=0 phishscore=0 bulkscore=0 adultscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=6.0.2-1012030000 definitions=main-1201150155 From: Chuck Swiger In-reply-to: <1954AA20-BE6F-4F04-A770-49ECFA405B5D@gmail.com> Date: Sun, 15 Jan 2012 08:17:58 -0800 Content-transfer-encoding: quoted-printable Message-id: <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> To: Paul Beard X-Mailer: Apple Mail (2.1084) 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:18:01 -0000 On Jan 14, 2012, at 5:18 PM, Paul Beard wrote: > Turns out some applications won't work if you move the socket if they = are configured to access localhost. Seems like a misunderstanding of = networking if you can specify a port number in a configuration file but = the application looks to the filesystem for the socket. There is no way = to specify a file location so it seems doomed to fail =97 as it did.=20 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. Changing the path to the UNIX domain socket will have no effect upon the = port used by the TCP socket, or vice versa. Regards, --=20 -Chuck