From owner-freebsd-questions@FreeBSD.ORG Sun Apr 18 03:01:13 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 AD0F916A4CE for ; Sun, 18 Apr 2004 03:01:13 -0700 (PDT) Received: from tpa2.isomedia.com (tpa2.isomedia.com [207.115.64.113]) by mx1.FreeBSD.org (Postfix) with ESMTP id 74AA443D45 for ; Sun, 18 Apr 2004 03:01:11 -0700 (PDT) (envelope-from chip@wiegand.org) Received: from tpa2.isomedia.com (tpa2.isomedia.com [127.0.0.1]) by tpa2.isomedia.com (Postfix) with ESMTP id E78AA70111; Sun, 18 Apr 2004 03:01:26 -0700 (PDT) Received: from tpa2.isomedia.com ([127.0.0.1])port 10024) with ESMTP id 24709-02; Sun, 18 Apr 2004 03:01:26 -0700 (PDT) Received: from pioneernet.net (mail.pioneernet.net [207.115.64.224]) by tpa2.isomedia.com (Postfix) with ESMTP id 416167010E; Sun, 18 Apr 2004 03:01:26 -0700 (PDT) Received: from wiegand.org [66.114.152.128] by pioneernet.net with ESMTP (SMTPD32-6.06) id A2C0126300B2; Sun, 18 Apr 2004 03:04:48 -0700 Message-ID: <4082521B.6050202@wiegand.org> Date: Sun, 18 Apr 2004 03:02:03 -0700 From: chip User-Agent: Mozilla/5.0 (X11; U; Linux i386; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Kevin D. Kinsey, DaleCo, S.P." References: <40816CA3.8070708@wiegand.org> <40816FDB.1070604@daleco.biz> In-Reply-To: <40816FDB.1070604@daleco.biz> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at isomedia.com X-Spam-Status: No, hits=1.1 tagged_above=-999.0 required=999.0 tests=BAYES_01, J_CHICKENPOX_54, J_LWT_SET06, MY_HDR_PDS_2P4, MY_HDR_PDS_4P4 X-Spam-Level: * X-MailScanner-SpamCheck: LEVEL= * 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: Sun, 18 Apr 2004 10:01:13 -0000 Kevin D. Kinsey, DaleCo, S.P. wrote: > Hi chip, > > Please wrap your characters at 80 columns > of so for some of the people who use text > based email. Thanks! Sorry about that. My email client is set to wrap lines at 72 chars. > Read on.. > > 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 .... The mysql daemon is started during boot up along with samba and apache. There are no error messages, it appears to start fine. > This is the same message you would receive if > mysqld were not running. Have you tried this: > > % ps -auxv | grep mysql Did that and got a response that mysqld is running. Then about 10 minutes later did it again and the server was not running. When I tried this to start it manually I resulted in the unable to connect to socket error. Now this is weird, just after I typed the above paragraph I opened another term and ran the ps command. I wish I could copy/paste from either eterm or aterm, but it doesn't work. What's really weird is in aterm I do ps -aux | grep mysqld and it returns nothing. In eterm I do the same command and it returns the pid of the mysqd server meaning it is running. So, it may be running, maybe not, either way, when I try to run mysql from the command line I get the cannot connect to socket error every time. The permissions on the /temp directory are 777 with the sticky bit set. > Do any messages appear during the > init phase of bootup re: mysql? No messages about mysql in any startup logs or on the screen. It appears to start normally. -- Chip