Date: Mon, 8 Sep 2008 15:15:24 -0400 From: Joe Tseng <joe_tseng@hotmail.com> To: <freebsd-questions@freebsd.org> Subject: RE: Can't start MySQL 5.0.67 Message-ID: <BAY117-W4218C5B5340992445C7C2C9B550@phx.gbl> In-Reply-To: <200809081056.51762.beech@freebsd.org> References: <20080908162020.QYGI28383.dukecmmtar01.coxmail.com@696908E74163425> <BAY117-W127ED5DFC2C0E7A6E319BB9B550@phx.gbl> <200809081056.51762.beech@freebsd.org>
next in thread | previous in thread | raw e-mail | index | archive | help
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 1844674407= 3709551615 adjusted to 4294967295 080908 13:35:05 [Warning] option 'max_join_size': unsigned value 1844674407= 3709551615 adjusted to 4294967295 080908 13:35:05 InnoDB: Operating system error number 13 in a file operati= on. 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 j= ust tried to give ownership using chown -R mysql /var/db/mysql but that mad= e 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 extr= a parameters. Are they needed? > 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 >=20 > 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 >=20 > Check the logfiles in /var/db/mysql=2C they will usually tell you what=20 > it's choking on. My first guess without more info would be you=20 > probably don't have something configured correctly. >=20 > Beech >=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" _________________________________________________________________ Want to do more with Windows Live? Learn =9310 hidden secrets=94 from Jamie= . http://windowslive.com/connect/post/jamiethomson.spaces.live.com-Blog-cns!5= 50F681DAD532637!5295.entry?ocid=3DTXT_TAGLM_WL_domore_092008=
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?BAY117-W4218C5B5340992445C7C2C9B550>