From owner-freebsd-questions@FreeBSD.ORG  Wed Dec  8 20:48:38 2004
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
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 4CC0F16A4CE
	for <freebsd-questions@freebsd.org>;
	Wed,  8 Dec 2004 20:48:38 +0000 (GMT)
Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.207])
	by mx1.FreeBSD.org (Postfix) with ESMTP id C6DAF43D41
	for <freebsd-questions@freebsd.org>;
	Wed,  8 Dec 2004 20:48:37 +0000 (GMT)
	(envelope-from joshua.lokken@gmail.com)
Received: by wproxy.gmail.com with SMTP id 58so442662wri
	for <freebsd-questions@freebsd.org>;
	Wed, 08 Dec 2004 12:48:37 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
	s=beta; d=gmail.com;
	h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references;
	b=ChtxBihei5SM0C3PhCKooU+cMgl6d2j1WOVdnhA6+hQAdWZFFPrsiYuy2ZRYRzfiBhmlESwY+NAVAbglwADgfjvOJmRExRj3A3ytiq4fFpDIgEGAkvb4trWOIUlcbGnJfZO1169/YY8lp6mjBeuOnW6cU7cnOhnhiExJ2C3IoWI=
Received: by 10.54.57.46 with SMTP id f46mr283562wra;
        Wed, 08 Dec 2004 12:48:37 -0800 (PST)
Received: by 10.54.11.34 with HTTP; Wed, 8 Dec 2004 12:48:37 -0800 (PST)
Message-ID: <bc5b638504120812481e37de8a@mail.gmail.com>
Date: Wed, 8 Dec 2004 14:48:37 -0600
From: Joshua Lokken <joshua.lokken@gmail.com>
To: Vonleigh Simmons <nospam@illusionart.com>
In-Reply-To: <78AFAA57-4954-11D9-B2C4-000A2791B6EC@illusionart.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
References: <ED4C536E-48C1-11D9-B2C4-000A2791B6EC@illusionart.com>
	 <1102494183.41b6b9e726b2f@www.domainfactory-webmail.de>
	 <1F2911BC-4900-11D9-B2C4-000A2791B6EC@illusionart.com>
	 <16823.15862.57984.186555@tipi.mininet>
	 <78AFAA57-4954-11D9-B2C4-000A2791B6EC@illusionart.com>
cc: Markus Hoenicka <markus.hoenicka@mhoenicka.de>
cc: freebsd-questions@freebsd.org
Subject: Re: mysql won't start on boot
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
Reply-To: Joshua Lokken <joshua.lokken@gmail.com>
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 08 Dec 2004 20:48:38 -0000

On Wed, 8 Dec 2004 12:05:13 -0800, Vonleigh Simmons
<nospam@illusionart.com> wrote:
> > What happens if you run "/usr/local/etc/rc.d/mysql-server.sh start"
>
> # /usr/local/etc/rc.d/mysql-server.sh start
> Starting mysql.
> 
>        Yet mysql never started up, here is the error log:
> ---
> 041208 14:07:26  mysqld started
> 041208 14:07:26 [ERROR] Can't find messagefile
> '/usr/local/share/mysql/english/errmsg.sys'
> 041208 14:07:26 [ERROR] Aborting
> 
> 041208 14:07:26  mysqld ended
> ---

The documentation specifies that the above is not the way to
start mysql.
 

> 
>        If I start it up with mysql_safe using what I think the script is
> using as startup:
> 
> # /usr/local/bin/mysqld_safe --user=mysql --datadir=/var/db/mysql
> --pid-file=/var/db/mysql/alpargata.net.pid &
> 
>        Then it starts up just fine:
> ---
> 041208 14:07:32  mysqld started
> 041208 14:07:32  InnoDB: Started; log sequence number 0 43912
> /usr/local/libexec/mysqld: ready for connections.
> Version: '4.1.7'  socket: '/tmp/mysql.sock'  port: 3306  FreeBSD port:
> mysql-server-4.1.7
> ---

And you found the correct way.  However, I do not know why it is
not starting at boot time.

-- 
Joshua Lokken
Open Source Advocate