From owner-freebsd-questions@FreeBSD.ORG Mon Sep 8 19:46:12 2008 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 A2488106564A for ; Mon, 8 Sep 2008 19:46:12 +0000 (UTC) (envelope-from beech@freebsd.org) Received: from bsdevel.alaskaparadise.com (bsdevel.alaskaparadise.com [208.86.224.193]) by mx1.freebsd.org (Postfix) with ESMTP id 773448FC13 for ; Mon, 8 Sep 2008 19:46:12 +0000 (UTC) (envelope-from beech@freebsd.org) Received: from stargate.alaskaparadise.com (129-78-237-24.gci.net [24.237.78.129]) by bsdevel.alaskaparadise.com (Postfix) with ESMTP id 935AD28E1077; Mon, 8 Sep 2008 19:46:11 +0000 (UTC) From: Beech Rintoul To: Joe Tseng Date: Mon, 8 Sep 2008 11:46:02 -0800 User-Agent: KMail/1.9.10 References: <20080908162020.QYGI28383.dukecmmtar01.coxmail.com@696908E74163425> <200809081056.51762.beech@freebsd.org> In-Reply-To: X-Face: jC2w\k*Q1\0DA2Q0Eh&BrP/Rt2M,^2O#R07VoT98m*>miQF9%Bi9vy`F6cPjwEe?m,)=?utf-8?q?2=0A=09X=3FM=5C=3AOE9QgZ?="xT3/n3,3MJ7N=Cfkmi%f(w^~X"SUxn>; 27NO; C+)g[7J`$G*SN>{<=?utf-8?q?O=3Bg7=7C=0A=09o=7D=265A=5D4?=@7D`=Eb@Zs1Ln814?]|k@'bG=.Ca"[|8+_.OsNAo8!#?4u MIME-Version: 1.0 Content-Type: text/plain; charset="windows-1252" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200809081146.06240.beech@freebsd.org> Cc: freebsd-questions@freebsd.org Subject: Re: Can't start MySQL 5.0.67 X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: Beech Rintoul List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 08 Sep 2008 19:46:12 -0000 On Monday 08 September 2008, Joe Tseng said: > So I checked in that directory you suggested and I found this: > > 080908 13:35:05 mysqld started > 080908 13:35:05 [Warning] option 'max_join_size': unsigned value > 18446744073709551615 adjusted to 4294967295 080908 13:35:05 > [Warning] option 'max_join_size': unsigned value > 18446744073709551615 adjusted to 4294967295 080908 13:35: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. > 080908 13:35:05 mysqld ended > > So my questions are: > 1. What directory is it referring to? Is it /var/db/mysql by > default? I just tried to give ownership using chown -R mysql > /var/db/mysql but that made no difference. 2. I've read also for > this kind of issue I have to reinstall the software... When I > initially installed this from ports I didn't use any kind of extra > parameters. Are they needed? Yes, the /var/db/mysql dir needs to be readable and writeable by mysql. Try the following: chown -R mysql:mysql /var/db/mysql. The error is telling you that innodb can't create /var/db/mysql/ibdata1. After fixing permissions, you may need to do another initdb. Beech > > > From: beech@freebsd.org > > To: freebsd-questions@freebsd.org > > Date: Mon, 8 Sep 2008 10:56:48 -0800 > > CC: joe_tseng@hotmail.com > > Subject: Re: Can't start MySQL 5.0.67 > > > > On Monday 08 September 2008, Joe Tseng said: > > > I've got a server running FreeBSD7 and got MySQL 5.0.67 > > > installed on it today. I ran mysql_install_db and then > > > assigned the root password. I tried to get it running on boot > > > (mysql_enable="YES") and by hand > > > (/usr/local/etc/rc.d/mysql-server start) but I can't get the > > > daemon to start. What else do I need to do to get this > > > working? > > > > > > - Joe > > > > Check the logfiles in /var/db/mysql, they will usually tell you > > what it's choking on. My first guess without more info would be > > you probably don't have something configured correctly. > > > > Beech -- --------------------------------------------------------------------------------------- Beech Rintoul - FreeBSD Developer - beech@FreeBSD.org /"\ ASCII Ribbon Campaign | FreeBSD Since 4.x \ / - NO HTML/RTF in e-mail | http://people.freebsd.org/~beech X - NO Word docs in e-mail | Skype: akbeech / \ - http://www.FreeBSD.org/releases/7.0R/announce.html ---------------------------------------------------------------------------------------