From owner-freebsd-questions@FreeBSD.ORG Mon Feb 1 03:54:59 2010 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 2F351106566B for ; Mon, 1 Feb 2010 03:54:58 +0000 (UTC) (envelope-from dan@dan.emsphone.com) Received: from email1.allantgroup.com (email1.emsphone.com [199.67.51.115]) by mx1.freebsd.org (Postfix) with ESMTP id AFB138FC0A for ; Mon, 1 Feb 2010 03:54:58 +0000 (UTC) Received: from dan.emsphone.com (dan.emsphone.com [199.67.51.101]) by email1.allantgroup.com (8.14.0/8.14.0) with ESMTP id o113steJ021597 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Sun, 31 Jan 2010 21:54:55 -0600 (CST) (envelope-from dan@dan.emsphone.com) Received: from dan.emsphone.com (smmsp@localhost [127.0.0.1]) by dan.emsphone.com (8.14.4/8.14.3) with ESMTP id o113ss97062836 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Sun, 31 Jan 2010 21:54:54 -0600 (CST) (envelope-from dan@dan.emsphone.com) Received: (from dan@localhost) by dan.emsphone.com (8.14.4/8.14.3/Submit) id o113ssjK062834; Sun, 31 Jan 2010 21:54:54 -0600 (CST) (envelope-from dan) Date: Sun, 31 Jan 2010 21:54:54 -0600 From: Dan Nelson To: John Message-ID: <20100201035454.GA50360@dan.emsphone.com> References: <20100131213415.A39592@starfire.mn.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20100131213415.A39592@starfire.mn.org> X-OS: FreeBSD 7.2-STABLE User-Agent: Mutt/1.5.20 (2009-06-14) X-Virus-Scanned: clamav-milter 0.95.3 at email1.allantgroup.com X-Virus-Status: Clean X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-2.0.2 (email1.allantgroup.com [199.67.51.78]); Sun, 31 Jan 2010 21:54:55 -0600 (CST) X-Scanned-By: MIMEDefang 2.45 Cc: freebsd-questions@freebsd.org Subject: Re: mysql silently failing to start - suggestions? 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: Mon, 01 Feb 2010 03:54:59 -0000 In the last episode (Jan 31), John said: > If this isn't the right list - if I should try another let me know - but > since this is the mysql-server-5.4.2 package, and since you folks have > been so helpful, I thought I'd give it a go. > > Anyway, the system is 8.0-RELEASE and that package is installed, and I > can't start the server. Not only can I not start the server, but it's not > giving me a clue. I can't find anything anywhere. Not in > /var/log/messages, not anywhere. When I run > /usr/local/etc/rc.d/mysqlserver start > it says "Starting mysql.", pauses for several seconds (I don't see > anything go by in "top") and then the script exits. At that point, one > would expect, there's no /tmp/mysql.sock, there's nothing in messages or > anywhere else. With nothing to go on, well, I don't know where to start. > Any suggestions? /var/db/mysql/.err should contain more information. The rc.d/mysql-server script was recently changed to wait up to 15 seconds for the server to become ready, which is the cause of the long delay. It doesn't check to see if the pid file has disappeared (which indicates the server has exited). -- Dan Nelson dnelson@allantgroup.com