From owner-freebsd-questions@FreeBSD.ORG  Thu Apr 13 22:59:33 2006
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
X-Original-To: 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 79C1716A401
	for <freebsd-questions@freebsd.org>;
	Thu, 13 Apr 2006 22:59:33 +0000 (UTC)
	(envelope-from gayn.winters@bristolsystems.com)
Received: from fed1rmmtao08.cox.net (fed1rmmtao08.cox.net [68.230.241.31])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 9E7BB43D55
	for <freebsd-questions@freebsd.org>;
	Thu, 13 Apr 2006 22:59:20 +0000 (GMT)
	(envelope-from gayn.winters@bristolsystems.com)
Received: from workdog ([68.5.182.86]) by fed1rmmtao08.cox.net
	(InterMail vM.6.01.06.01 201-2131-130-101-20060113) with ESMTP
	id <20060413225920.IIQG20694.fed1rmmtao08.cox.net@workdog>;
	Thu, 13 Apr 2006 18:59:20 -0400
From: "Gayn Winters" <gayn.winters@bristolsystems.com>
To: "'Gerard Seibert'" <root@seibercom.net>,
	"'Freebsd Questions'" <freebsd-questions@freebsd.org>
Date: Thu, 13 Apr 2006 16:00:52 -0700
Organization: Bristol Systems Inc.
Message-ID: <003201c65f4e$20444270$6501a8c0@workdog>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook, Build 10.0.4024
In-Reply-To: <20060413182703.Q65056@localhost.seibercom.net>
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
Importance: Normal
Cc: 
Subject: RE: Unable to start MySQL
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
Reply-To: gayn.winters@bristolsystems.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: Thu, 13 Apr 2006 22:59:33 -0000

> [mailto:owner-freebsd-questions@freebsd.org] On Behalf Of 
> Gerard Seibert
> Sent: Thursday, April 13, 2006 3:35 PM
> To: Freebsd Questions
> Subject: Unable to start MySQL

> I am unable to get the latest version of MySQL 5.1.7 running 
> under FreeBSD 
> 6.1 
> beta4.
> 
> This is the output from the <hostname>.err file.
> 
> 
> 060409 20:06:04  mysqld started
> ^G/usr/local/libexec/mysqld: Can't find file: 
> './mysql/general_log.frm' 
> (errno: 13)
> 060409 20:06:05  InnoDB: Operating system error number 13 in a file 
> operation.
> InnoDB: The error means mysqld does not have the access rights to
> InnoDB: the directory.
> InnoDB: File name ./ibdata1
> InnoDB: File operation call: 'create'.
> InnoDB: Cannot continue operation.
> 060409 20:06:05  mysqld ended
> 
> 
> I have Googled for an answer, and found a few, but none of 
> them work. I 
> finally completely deleted MySQL including removing the /var/db/mysql 
> directory and then reinstalled the entire package, but 
> without success.
> 
> Has anybody else encountered this problem and found a solution to it?
> 
> Thanks!
> 
> -- 
> Gerard Seibert

It looks like user mysql can't access that directory.  Double check
setup, ownership, access bits, etc. The installation instructions are
well tested to be sure.  Post details on access rights if you're still
stuck.

-gayn

Bristol Systems Inc.
714/532-6776
www.bristolsystems.com