From owner-freebsd-questions@FreeBSD.ORG Mon Jun 11 18:40:30 2012 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 06AA6106566B for ; Mon, 11 Jun 2012 18:40:30 +0000 (UTC) (envelope-from subhro@80386.org) Received: from oproxy7-pub.bluehost.com (oproxy7.bluehost.com [IPv6:2605:dc00:100:2::a7]) by mx1.freebsd.org (Postfix) with SMTP id C5F0A8FC16 for ; Mon, 11 Jun 2012 18:40:29 +0000 (UTC) Received: (qmail 4718 invoked by uid 0); 11 Jun 2012 18:40:29 -0000 Received: from unknown (HELO box761.bluehost.com) (66.147.244.61) by oproxy7.bluehost.com with SMTP; 11 Jun 2012 18:40:29 -0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=80386.org; s=default; h=To:References:Message-Id:Content-Transfer-Encoding:Cc:Date:In-Reply-To:From:Content-Type:Mime-Version:Subject; bh=0s6kAfiPXImd4wXTQkHz6YmdDOvTjsdH4y1JDH6Agko=; b=QveJkZdFS5VTITC8OgXWXermevgGuYmPl2AdeGWjkU+q6N/vvUhR8Xa92cSdTeXG3OEzPdBd3oXBhYCGU3RzfDJu4Sx0Tvu3Gr/S2Zt/tsrL9lrItAgrIfzPVxLToN5B; Received: from [117.194.35.27] (port=59071 helo=[192.168.1.4]) by box761.bluehost.com with esmtpsa (TLSv1:AES128-SHA:128) (Exim 4.76) (envelope-from ) id 1Se9XQ-0003QF-Ue; Mon, 11 Jun 2012 12:40:29 -0600 Mime-Version: 1.0 (Apple Message framework v1278) Content-Type: text/plain; charset=iso-8859-1 From: Subhro Sankha Kar In-Reply-To: <4FD62BA8.7030702@dreamchaser.org> Date: Tue, 12 Jun 2012 00:10:24 +0530 Content-Transfer-Encoding: quoted-printable Message-Id: <721F59E6-BCA8-4589-8BB2-A0BCD5613031@80386.org> References: <4FD62BA8.7030702@dreamchaser.org> To: freebsd@dreamchaser.org X-Mailer: Apple Mail (2.1278) X-Identified-User: {1190:box761.bluehost.com:pixelpa2:80386.org} {sentby:smtp auth 117.194.35.27 authed with subhro@80386.org} Cc: FreeBSD Mailing List Subject: Re: mysqld startup issue 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, 11 Jun 2012 18:40:30 -0000 On 11-Jun-2012, at 11:02 PM, Gary Aitken wrote: > I've done the following after having a running system with a running = mysql on it: >=20 > moved user accounts, although no logical move: > /usr/home/foo was =3D> /hd1/foo > now > /usr/home =3D> /hd1/home and /hd1/foo is now /hd1/home/foo > repartitioned the SSD and restored the system from a dump taken prior = to repartitioning. > removed all ports and reinstalled them >=20 > Unfortunately, mysqld won't start: >=20 > 120611 10:55:52 [Warning] Can't create test file = /var/db/mysql/breakaway.lower-test What's the permission of /var/db/mysql? Also what user is mysql running = as? Thanks Subhro -- Subhro Sankha Kar System Administrator Working and Playing with FreeBSD since 2002 > 120611 10:55:52 [Warning] Can't create test file = /var/db/mysql/breakaway.lower-test > mysqld: Table 'mysql.plugin' doesn't exist > 120611 10:55:52 [ERROR] Can't open the mysql.plugin table. Please run = mysql_upgrade to create it. > 120611 10:55:52 InnoDB: The InnoDB memory heap is disabled > 120611 10:55:52 InnoDB: Mutexes and rw_locks use GCC atomic builtins > 120611 10:55:52 InnoDB: Compressed tables use zlib 1.2.5 > 120611 10:55:52 InnoDB: Initializing buffer pool, size =3D 128.0M > 120611 10:55:52 InnoDB: Completed initialization of buffer pool > 120611 10:55:52 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. >=20 > Running mysqld --verbose shows: >=20 > basedir /usr/local > general-log-file /var/db/mysql/breakaway.log >=20 > ls -aol /usr/local/libexec/mysqld > -rwxr-xr-x 1 root wheel - 9558944 Jun 11 10:40 = /usr/local/libexec/mysqld > ls -dl /var/db/mysql > drwxr-xr-x 2 mysql mysql 512 Jun 11 10:31 /var/db/mysql >=20 > cd / > find . -ls | grep my.cnf >=20 > shows nothing. >=20 > This looks like some kind of access / setuid problem, but I'm not sure = what. > Suggestions? > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to = "freebsd-questions-unsubscribe@freebsd.org"