From owner-freebsd-questions@FreeBSD.ORG Mon Feb 1 04:35:46 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 B5642106566B for ; Mon, 1 Feb 2010 04:35:46 +0000 (UTC) (envelope-from freebsd-questions@m.gmane.org) Received: from lo.gmane.org (lo.gmane.org [80.91.229.12]) by mx1.freebsd.org (Postfix) with ESMTP id 41B188FC08 for ; Mon, 1 Feb 2010 04:35:46 +0000 (UTC) Received: from list by lo.gmane.org with local (Exim 4.69) (envelope-from ) id 1Nbo0l-0004rX-0O for freebsd-questions@freebsd.org; Mon, 01 Feb 2010 05:35:43 +0100 Received: from pool-71-166-134-45.washdc.east.verizon.net ([71.166.134.45]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 01 Feb 2010 05:35:42 +0100 Received: from nightrecon by pool-71-166-134-45.washdc.east.verizon.net with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 01 Feb 2010 05:35:42 +0100 X-Injected-Via-Gmane: http://gmane.org/ To: freebsd-questions@freebsd.org From: Michael Powell Followup-To: gmane.os.freebsd.questions Date: Sun, 31 Jan 2010 23:35:22 -0500 Lines: 46 Message-ID: References: <20100131213415.A39592@starfire.mn.org> Mime-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 7Bit X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: pool-71-166-134-45.washdc.east.verizon.net User-Agent: KNode/4.3.4 Sender: news 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 04:35:46 -0000 John wrote: > 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? First is there a mysql_enable="YES" line in /etc/rc.conf? The rc subr startup system requires it and also the complete path as you did type above. Although since it is mysql-server and you got a response I'll assume the above is just a typo here in this mail. If you have changed the location of the database files this variable will need setting in /etc/rc.conf as well. The default is /var/db/mysql. Notice this directory should be owned by the mysql:mysql user/group combo. This will allow for the writing of the .pid file. There will also be a .err file which is the log you need to look at. If these files are not present it is either not getting that far in the startup, or there is a permissions problem. The normal location of the socket is /tmp, which should be permissions 1777 (sticky bit set). You do have a line setting the hostname of the machine in /etc/rc.conf too, right? Such as hostname="testbed.test.zip" for my local dev server at home. This should be resolvable either by DNS or a hosts file. Also, be aware that the location of the my.cnf file is now /usr/local/etc, although should this be missing it should still look for it in /var/db/mysql as a fallback. If this file is world writable MySQL will ignore it. The establishment of the mysql user and group should have occurred as part of the port installation. I use ports and not packages, as well as the older version of 5.1.42 so I cannot speak to the efficacy of installing a package of 5.4.x. Perhaps a package problem? Try installing the 5.1.42 port using the ports system instead is one possibility if such may be the case. -Mike