From owner-freebsd-questions@FreeBSD.ORG Mon Sep 8 19:34:03 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 2FCC01065673 for ; Mon, 8 Sep 2008 19:34:03 +0000 (UTC) (envelope-from glarkin@FreeBSD.org) Received: from mail1.sourcehosting.net (113901-app1.sourcehosting.net [72.32.213.11]) by mx1.freebsd.org (Postfix) with ESMTP id 0E6118FC15 for ; Mon, 8 Sep 2008 19:34:02 +0000 (UTC) (envelope-from glarkin@FreeBSD.org) Received: from 68-189-244-97.dhcp.oxfr.ma.charter.com ([68.189.244.97] helo=Gregory-Larkins-Computer.local) by mail1.sourcehosting.net with esmtp (Exim 4.69 (FreeBSD)) (envelope-from ) id 1KcmUm-000HYa-Ns; Mon, 08 Sep 2008 15:34:02 -0400 Received: from [127.0.0.1] (fireball.entropy.prv [192.168.1.12]) by Gregory-Larkins-Computer.local (Postfix) with ESMTP id 32E21248A598; Mon, 8 Sep 2008 15:33:56 -0400 (EDT) Message-ID: <48C57E24.7020400@FreeBSD.org> Date: Mon, 08 Sep 2008 15:33:56 -0400 From: Greg Larkin Organization: The FreeBSD Project User-Agent: Thunderbird 2.0.0.16 (Windows/20080708) MIME-Version: 1.0 To: Joe Tseng References: <20080908162020.QYGI28383.dukecmmtar01.coxmail.com@696908E74163425> <200809081056.51762.beech@freebsd.org> In-Reply-To: X-Enigmail-Version: 0.95.7 OpenPGP: id=1C940290 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: 7bit X-Spam-Score: -1.2 (-) 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: glarkin@FreeBSD.org List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 08 Sep 2008 19:34:03 -0000 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Joe Tseng wrote: > 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? > > >> 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 >> Hi Joe, Do you have a my.cnf file anywhere? If so, look for the following options and make sure that the directories they are set to are also accessible by the mysql user: innodb_data_home_dir innodb_data_file_path If that doesn't work, I often use truss (http://www.freebsd.org/cgi/man.cgi?query=truss&apropos=0&sektion=0&manpath=FreeBSD+7.0-RELEASE&format=html) to debug permissions issues like this. You'll usually be able to tell from its output what syscall generates an EACCES and causes MySQL to fail. Regards, Greg - -- Greg Larkin http://www.FreeBSD.org/ - The Power To Serve http://www.sourcehosting.net/ - Ready. Set. Code. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFIxX4k0sRouByUApARAsKWAJ9kXqvPltMfS8GE3GQWHKey1CxXZQCghwNz zzA4qQBzxZqci87+bufKCto= =rMlL -----END PGP SIGNATURE-----