From owner-freebsd-questions@FreeBSD.ORG Wed Mar 17 23:57:46 2004 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 4BC4016A4CE for ; Wed, 17 Mar 2004 23:57:46 -0800 (PST) Received: from mail.xiplan.com (unknown [196.31.69.30]) by mx1.FreeBSD.org (Postfix) with ESMTP id D106843D2F for ; Wed, 17 Mar 2004 23:57:44 -0800 (PST) (envelope-from freebsd@xiplan.com) Received: from localhost (localhost.xiplan.com [127.0.0.1]) by mail.xiplan.com (Postfix) with ESMTP id AE78B4088 for ; Thu, 18 Mar 2004 09:57:45 +0200 (SAST) Received: from mail.xiplan.com ([127.0.0.1]) by localhost (server.xiplan.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 51072-08 for ; Thu, 18 Mar 2004 09:57:45 +0200 (SAST) Received: from BAILEY (bailey [192.168.0.5]) by mail.xiplan.com (Postfix) with ESMTP id 1B80A4087 for ; Thu, 18 Mar 2004 09:57:44 +0200 (SAST) Message-ID: <001c01c40cbe$b6fa6800$0500a8c0@BAILEY> From: "Gareth Bailey" To: "FreeBSD - questions" Date: Thu, 18 Mar 2004 09:57:49 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at xiplan.com Subject: MYSQL startup error X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 18 Mar 2004 07:57:46 -0000 I am running 5.2 Release, and have recently installed mysql-4.0.18 server. I first made a default install by issuing the following commands in the port: $ make # make install $ cd /var/db/mysql && mysql_db_install Worked perfectly when i started up with: $ mysqld_safe & Then i decided i wanted to reinstall with DB_DIR=/usr/db/mysql I made deinstall and clean in the port. I removed the /var/db directory manually. I then did the following in an attempt to install the DB_DIR in /usr/db/mysql: # mkdir /usr/db/mysql # chown -R mysql /usr/db #chgrp -R mysql /usr/db $ make DB_DIR=/usr/db/mysql # make DB_DIR=/usr/db/mysql install I encountered the following two problems: 1. Crontab complained with the following message: "mkdir: /var/db/entropy: Permission denied /usr/libexec/save-entropy[45954]: The entropy directory /var/db/entropy does not exist, and cannot be created. Therefore no entropy can be saved." I solved this by creating /var/db/entropy and chowned and chgrped to mysql (don't know if that was right.) 2. I can't start mysqld_safe using command 'mysqld_safe &'. I get the following errors... when i try as normal user: "/usr/local/bin/mysqld_safe: cannot create /usr/db/mysql/server.err: Permission denied" when i try from root: "server# Starting mysqld daemon with databases from /usr/db/mysql 040318 09:51:58 mysqld ended" I had a look at server.err in /usr/db/mysql and i found the following line: "040318 9:51:56 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)" Please advise. Any assistance will be very much appreciated. Thank you Gareth