From owner-freebsd-ports@FreeBSD.ORG  Wed Dec 20 03:58:09 2006
Return-Path: <owner-freebsd-ports@FreeBSD.ORG>
X-Original-To: freebsd-ports@freebsd.org
Delivered-To: freebsd-ports@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [69.147.83.52])
	by hub.freebsd.org (Postfix) with ESMTP id 6093816A415
	for <freebsd-ports@freebsd.org>; Wed, 20 Dec 2006 03:58:09 +0000 (UTC)
	(envelope-from swhetzel@gmail.com)
Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.228])
	by mx1.FreeBSD.org (Postfix) with ESMTP id C2EE543CA2
	for <freebsd-ports@freebsd.org>; Wed, 20 Dec 2006 03:58:08 +0000 (GMT)
	(envelope-from swhetzel@gmail.com)
Received: by nz-out-0506.google.com with SMTP id i11so809901nzh
	for <freebsd-ports@freebsd.org>; Tue, 19 Dec 2006 19:58:05 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=lPbAP4leSu33NnBBsDi45lhi9iJs1qUBwEFkl72a+V0nPxNprSEyCkU6XkbhtQboEtMIvQ3q4Er7gq0q/OICvYlW6xNcNv1xxuJwUW5WK8dqz4OHAKkA/L0ZJo8j80NcAtV2v3smfs0B8C5WlP1eHKTSYMFjkAD8wK4hPkLl5V8=
Received: by 10.65.114.4 with SMTP id r4mr8328803qbm.1166587085922;
	Tue, 19 Dec 2006 19:58:05 -0800 (PST)
Received: by 10.65.61.1 with HTTP; Tue, 19 Dec 2006 19:58:05 -0800 (PST)
Message-ID: <790a9fff0612191958g7730a1e4pca18cee27436acc8@mail.gmail.com>
Date: Tue, 19 Dec 2006 21:58:05 -0600
From: "Scot Hetzel" <swhetzel@gmail.com>
To: freebsd-ports@freebsd.org, sysadmin@alexdupre.com
In-Reply-To: <20061220030746.A707FB822@shodan.nognu.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <20061220030746.A707FB822@shodan.nognu.de>
Cc: 
Subject: Re: mysql41-server's rc.d script broken?
X-BeenThere: freebsd-ports@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Porting software to FreeBSD <freebsd-ports.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ports>,
	<mailto:freebsd-ports-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-ports>
List-Post: <mailto:freebsd-ports@freebsd.org>
List-Help: <mailto:freebsd-ports-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ports>,
	<mailto:freebsd-ports-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 20 Dec 2006 03:58:09 -0000

On 12/19/06, Frank Steinborn <steinex@nognu.de> wrote:
> If I run mysqld_safe directly mysqld starts as expected. I had a look
> into the script but could not find the source of the problem. I'm not
> sure if that's a misconfiguration just on my site - anyone else seeing
> this?
>
> OK - I just edited the script so that it won't send mysqld_safe's
> output to /dev/null and got the following:
>
> Starting mysql.
> Starting mysqld daemon with databases from /var/db/mysql
> STOPPING server from pid file /var/db/mysql/shodan.nognu.de.pid
> 061220 04:05:50  mysqld ended
>
> /var/db/mysql/shodan.nognu.de.err says this:
>
> 061220 04:04:03  mysqld started
> 061220  4:04:03 [ERROR] Can't find messagefile
> '/usr/local/share/mysql/english/errmsg.sys'
> 061220  4:04:03 [ERROR] Aborting
>
> Strange. /usr/local/share/mysql/english/errmsg.sys is there and mysqld
> just starts fine if I start it manually. Any clues are welcome.
>
When you run the script, mysqld_safe is run as the mysql user.

What happens when you run mysqld_safe as the mysql user?

Does the mysql user have read access to this file (including sub
directories leading to the file)?

Scot
-- 
DISCLAIMER:
No electrons were mamed while sending this message. Only slightly bruised.