From owner-freebsd-database@FreeBSD.ORG Sun May 17 13:45:20 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 8E4B8106566C for ; Sun, 17 May 2009 13:45:20 +0000 (UTC) (envelope-from swun2010@gmail.com) Received: from wf-out-1314.google.com (wf-out-1314.google.com [209.85.200.168]) by mx1.freebsd.org (Postfix) with ESMTP id 65AD88FC0C for ; Sun, 17 May 2009 13:45:20 +0000 (UTC) (envelope-from swun2010@gmail.com) Received: by wf-out-1314.google.com with SMTP id 24so1428374wfg.7 for ; Sun, 17 May 2009 06:45:20 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:date:message-id:subject :from:to:content-type:content-transfer-encoding; bh=zov4gIJ6kz5i+eAb9kPvgjn7BhtVNqks80Dxph2d9mM=; b=uf1WVpijOHzV+a3WajddH98ip/CI9CitTwEaJBy8MNSIt1vME4+6VdOLiBzBbpCYMU b7mA9sMYvPd9SZh5KYu6/6TH3O3Wv5+P3nlBnLEaI3sXbkhth6+8h5jsOWiJX1sqVyU2 918S5USM6Fjer8Fyn8uuZY0UIHlpahA8Q0CUI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type :content-transfer-encoding; b=fv+wFMbl9pWLKIiyLsHDC/fXT2dUeVahsI8QPLMTDroppVrdvkJqrnNHF2cvlO1gsh WeLhlYl3uAITKr82sUJ1ANthd3vS4EZGkE0niCjHu+TUyya/j9oNC2jA+7MiUD4TKXW6 4/62yMI9CoOBGVbSG/PEM7R1x3YjsF7AL+0G8= MIME-Version: 1.0 Received: by 10.143.37.20 with SMTP id p20mr1696582wfj.207.1242566006391; Sun, 17 May 2009 06:13:26 -0700 (PDT) Date: Sun, 17 May 2009 23:13:26 +1000 Message-ID: <736c47cb0905170613w7768c7a8l651e6d5be280554f@mail.gmail.com> From: Sam Wun To: freebsd-database@freebsd.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Subject: '/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: Sun, 17 May 2009 13:45:20 -0000 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 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