From owner-freebsd-questions@FreeBSD.ORG Mon Sep 8 19:55:40 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 C0E151065675 for ; Mon, 8 Sep 2008 19:55:40 +0000 (UTC) (envelope-from joe_tseng@hotmail.com) Received: from bay0-omc1-s18.bay0.hotmail.com (bay0-omc1-s18.bay0.hotmail.com [65.54.246.90]) by mx1.freebsd.org (Postfix) with ESMTP id AE9388FC1C for ; Mon, 8 Sep 2008 19:55:40 +0000 (UTC) (envelope-from joe_tseng@hotmail.com) Received: from BAY117-W4 ([207.46.8.39]) by bay0-omc1-s18.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.3959); Mon, 8 Sep 2008 12:55:40 -0700 Message-ID: X-Originating-IP: [66.134.128.178] From: Joe Tseng To: Date: Mon, 8 Sep 2008 15:55:40 -0400 Importance: Normal In-Reply-To: <200809081146.06240.beech@freebsd.org> References: <20080908162020.QYGI28383.dukecmmtar01.coxmail.com@696908E74163425> <200809081056.51762.beech@freebsd.org> <200809081146.06240.beech@freebsd.org> MIME-Version: 1.0 X-OriginalArrivalTime: 08 Sep 2008 19:55:40.0401 (UTC) FILETIME=[DEC27610:01C911EC] Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Subject: RE: Can't start MySQL 5.0.67 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, 08 Sep 2008 19:55:40 -0000 Yeah that was it... The chown -R mysql:mysql /var/db/mysql was what did it= ... Thx to all for the help. - Joe > From: beech@freebsd.org > To: joe_tseng@hotmail.com > Date: Mon=2C 8 Sep 2008 11:46:02 -0800 > CC: freebsd-questions@freebsd.org > Subject: Re: Can't start MySQL 5.0.67 >=20 > On Monday 08 September 2008=2C 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=20 > > 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? >=20 > Yes=2C the /var/db/mysql dir needs to be readable and writeable by=20 > mysql. Try the following: chown -R mysql:mysql /var/db/mysql. >=20 > The error is telling you that innodb can't=20 > create /var/db/mysql/ibdata1. After fixing permissions=2C you may need=20 > to do another initdb. >=20 > Beech >=20 > > > > > From: beech@freebsd.org > > > To: freebsd-questions@freebsd.org > > > Date: Mon=2C 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=2C 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=3D"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=2C 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 >=20 >=20 >=20 > --=20 > -------------------------------------------------------------------------= -------------- > 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 > -------------------------------------------------------------------------= -------------- >=20 >=20 >=20 > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe=2C send any mail to "freebsd-questions-unsubscribe@freebsd= .org" _________________________________________________________________ See how Windows connects the people=2C information=2C and fun that are part= of your life. http://clk.atdmt.com/MRT/go/msnnkwxp1020093175mrt/direct/01/=