From owner-freebsd-database@FreeBSD.ORG Tue May 19 09:08:59 2009 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id B7C36106566B for ; Tue, 19 May 2009 09:08:59 +0000 (UTC) (envelope-from tevans.uk@googlemail.com) Received: from mail-fx0-f216.google.com (mail-fx0-f216.google.com [209.85.220.216]) by mx1.freebsd.org (Postfix) with ESMTP id 42E358FC1C for ; Tue, 19 May 2009 09:08:58 +0000 (UTC) (envelope-from tevans.uk@googlemail.com) Received: by fxm12 with SMTP id 12so3725316fxm.43 for ; Tue, 19 May 2009 02:08:58 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=googlemail.com; s=gamma; h=domainkey-signature:received:received:subject:from:to:cc :in-reply-to:references:content-type:date:message-id:mime-version :x-mailer:content-transfer-encoding; bh=7puHb8Lk3Iv6KFfbu6B60nB6KJLjFX4llQfu5IHBbu8=; b=I7TV5PSSc/UwNxodO0s94dIcYplHK79ycSJHjc88mVfUDkiW1+yEGvfAIAJGmkgBNF /WKGI+aBO/V6VacNGUT22GpXLgQXGzDULdig0bZQp77zTEVklYEbs33YVNKlTlqaS356 V8siMIhu7QcNXj7JN7oyMbMjvJWqTmFF606z4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=googlemail.com; s=gamma; h=subject:from:to:cc:in-reply-to:references:content-type:date :message-id:mime-version:x-mailer:content-transfer-encoding; b=dJkdIWw494XwxGlDSRWsrTYH+XLnoFfcTYaKMrNyIKbQSLM3PPMDpK6DiJ0d7fAkpa 52dCkrnAXOfRxsNVv+9iqKvcL9AGiC3UviQLy/veWpRBq3kn5kHKA7pqX2MX3coZ6kRL 9m814MP01LgC5RdXzoBpFj/5RK28j4x2bSUrk= Received: by 10.86.80.17 with SMTP id d17mr2852279fgb.27.1242722150758; Tue, 19 May 2009 01:35:50 -0700 (PDT) Received: from ?127.0.0.1? (87-194-39-182.bethere.co.uk [87.194.39.182]) by mx.google.com with ESMTPS id d6sm9293687fga.12.2009.05.19.01.35.48 (version=SSLv3 cipher=RC4-MD5); Tue, 19 May 2009 01:35:49 -0700 (PDT) From: Tom Evans To: Sam Wun In-Reply-To: <736c47cb0905170613w7768c7a8l651e6d5be280554f@mail.gmail.com> References: <736c47cb0905170613w7768c7a8l651e6d5be280554f@mail.gmail.com> Content-Type: text/plain Date: Tue, 19 May 2009 09:35:47 +0100 Message-Id: <1242722147.30192.8.camel@strangepork.london.mintel.ad> Mime-Version: 1.0 X-Mailer: Evolution 2.26.1.1 FreeBSD GNOME Team Port Content-Transfer-Encoding: 7bit Cc: freebsd-database@freebsd.org Subject: Re: '/var/db/mysql/mysql-bin.index' not found X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 19 May 2009 09:09:00 -0000 On Sun, 2009-05-17 at 23:13 +1000, Sam Wun wrote: > Hi, > > I am running mysql 5.1 server in freebsd 7.2. > > I got the an error when I tried to start the following command: > # /usr/local/bin/mysqld_safe --skip-grant-tables > > Error is: > 090517 23:05:19 mysqld_safe Starting mysqld daemon with databases from > /var/db/mysql > /usr/local/libexec/mysqld: File '/var/db/mysql/mysql-bin.index' not > found (Errcode: 13) > 090517 23:05:19 [ERROR] Aborting > > 090517 23:05:19 [Note] /usr/local/libexec/mysqld: Shutdown complete > > Here are all files in the directory: > > wp1:mysql # pwd > /var/db/mysql > wp1:mysql # ls -l > total 22002 > drwx------ 4 root mysql 512 May 17 23:05 ./ > drwxr-xr-x 9 root wheel 512 May 12 13:57 ../ > -rw-rw---- 1 mysql mysql 5242880 May 17 22:29 ib_logfile0 > -rw-rw---- 1 mysql mysql 5242880 May 17 22:12 ib_logfile1 > -rw-rw---- 1 mysql mysql 10485760 May 17 22:29 ibdata1 > drwx------ 2 root mysql 2048 May 12 13:57 mysql/ > -rw-rw---- 1 mysql mysql 125 May 17 22:16 mysql-bin.000001 > -rw-rw---- 1 mysql mysql 125 May 17 22:17 mysql-bin.000002 > -rw-rw---- 1 mysql mysql 951 May 17 22:19 mysql-bin.000003 > -rw-rw---- 1 mysql mysql 708461 May 17 22:19 mysql-bin.000004 > -rw-rw---- 1 mysql mysql 406 May 17 22:29 mysql-bin.000005 > -rw-rw---- 1 root mysql 951 May 17 22:27 mysql-bin.000006 > -rw-rw---- 1 root mysql 708461 May 17 22:27 mysql-bin.000007 > -rw-rw---- 1 mysql mysql 133 May 17 22:27 mysql-bin.index > drwx------ 2 root mysql 512 May 12 13:57 test/ > -rw-rw---- 1 mysql mysql 6841 May 17 23:05 wp1.ip6.com.au.err > -rw-rw---- 1 mysql mysql 5681 May 17 22:17 wp1.ip6.com.au.err-old > wp1:mysql # > > The mysql-bin.index is in the path , why mysqld_safe can't pick it up? > > Your help is very much appreciated. > > Thanks mysql runs as user mysql, and you have some files it cannot access - probably the most important is the folder isn't owned by mysql, and it also wouldn't be able to open the 'mysql' database, which stores user info. Cheers Tom