Date: Mon, 8 Sep 2008 11:46:02 -0800 From: Beech Rintoul <beech@freebsd.org> To: Joe Tseng <joe_tseng@hotmail.com> Cc: freebsd-questions@freebsd.org Subject: Re: Can't start MySQL 5.0.67 Message-ID: <200809081146.06240.beech@freebsd.org> In-Reply-To: <BAY117-W4218C5B5340992445C7C2C9B550@phx.gbl> References: <20080908162020.QYGI28383.dukecmmtar01.coxmail.com@696908E74163425> <200809081056.51762.beech@freebsd.org> <BAY117-W4218C5B5340992445C7C2C9B550@phx.gbl>
next in thread | previous in thread | raw e-mail | index | archive | help
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 ---------------------------------------------------------------------------------------
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200809081146.06240.beech>