From owner-freebsd-questions@FreeBSD.ORG Sat Apr 17 10:56:47 2004 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 4F12316A4CE for ; Sat, 17 Apr 2004 10:56:47 -0700 (PDT) Received: from ns1.tiadon.com (SMTP.tiadon.com [69.27.132.161]) by mx1.FreeBSD.org (Postfix) with ESMTP id 07D1A43D3F for ; Sat, 17 Apr 2004 10:56:47 -0700 (PDT) (envelope-from kdk@daleco.biz) Received: from daleco.biz ([69.27.131.0]) by ns1.tiadon.com with Microsoft SMTPSVC(6.0.3790.0); Sat, 17 Apr 2004 12:57:33 -0500 Message-ID: <40816FDB.1070604@daleco.biz> Date: Sat, 17 Apr 2004 12:56:43 -0500 From: "Kevin D. Kinsey, DaleCo, S.P." User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.6) Gecko/20040406 X-Accept-Language: en-us, en MIME-Version: 1.0 To: chip References: <40816CA3.8070708@wiegand.org> In-Reply-To: <40816CA3.8070708@wiegand.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 17 Apr 2004 17:57:33.0734 (UTC) FILETIME=[75C62460:01C424A5] cc: questions@freebsd.org Subject: Re: installed mysql/php/apache but there's no mysql.sock file X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 17 Apr 2004 17:56:47 -0000 Hi chip, Please wrap your characters at 80 columns of so for some of the people who use text based email. Thanks! Read on.. chip wrote: > Yesterday I installed, from pkg_add, mysql/php/apache and apache and php > work fine, mysql did not create the /tmp/mysql.sock file. I have searched > the drive looking for it in another location but it does not exist > anywhere. mysql.sock is a UNIX socket, created by the mysql process itself. If it does not exist, then it's likely that either the mysql daemon is not running, or it is running without adequate permissions to create the socket. If the last is true, then it's possible that mysql is configured to make the socket somewhere other than /tmp, because the permissions for /tmp should be such as to allow the creation of the socket .... > I then created a file in /tmp called mysql.sock That won't work, I'm afraid ... a socket isn't exactly a file... > but mysql still gives the same error -[error 2002] > cannot connect to local mysql server through /tmp/mysql.sock (2). This is the same message you would receive if mysqld were not running. Have you tried this: % ps -auxv | grep mysql mysql 645 0.0 0.1 31276 268 ?? S 9Apr04 0:10.55 /usr/local/libex 5 127 3851 - 2624 root 63441 0.0 0.1 356 156 p2 D+ 12:54PM 0:00.00 grep mysql 0 0 1 - 52 This shows that /usr/local/libexec/mysqld is running as process 645. > I read the section in the mysql manual about the socket but > don't see anything about creating this file. Because mysql does it ;-) > How do I fix this? > Thanks, > Chip Check the mysqld is running, first. You may have to start it yourself (although you shouldn't really, but that's another issue). Also check for error messages in /var/log/messages, etc. Do any messages appear during the init phase of bootup re: mysql? Kevin Kinsey DaleCo, S.P.