From owner-freebsd-questions@FreeBSD.ORG Wed Dec 8 20:05:34 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 1214C16A4CE for ; Wed, 8 Dec 2004 20:05:34 +0000 (GMT) Received: from alpargata.net (alpargata.net [67.18.172.202]) by mx1.FreeBSD.org (Postfix) with ESMTP id 7D60043D67 for ; Wed, 8 Dec 2004 20:05:33 +0000 (GMT) (envelope-from nospam@illusionart.com) Received: from [192.168.1.100] (dsl081-061-217.dsl-isp.net [64.81.61.217] (may be forged)) (authenticated bits=0) by alpargata.net (8.13.1/8.13.1) with ESMTP id iB8KCOTA061330; Wed, 8 Dec 2004 14:12:26 -0600 (CST) (envelope-from nospam@illusionart.com) In-Reply-To: <16823.15862.57984.186555@tipi.mininet> References: <1102494183.41b6b9e726b2f@www.domainfactory-webmail.de> <1F2911BC-4900-11D9-B2C4-000A2791B6EC@illusionart.com> <16823.15862.57984.186555@tipi.mininet> Mime-Version: 1.0 (Apple Message framework v619) Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: <78AFAA57-4954-11D9-B2C4-000A2791B6EC@illusionart.com> Content-Transfer-Encoding: 7bit From: Vonleigh Simmons Date: Wed, 8 Dec 2004 12:05:13 -0800 To: "Markus Hoenicka" X-Mailer: Apple Mail (2.619) X-Virus-Scanned: ClamAV 0.80/620/Tue Dec 7 01:41:43 2004 clamav-milter version 0.80j on alpargata.net X-Virus-Status: Clean cc: freebsd-questions@freebsd.org Subject: Re: mysql won't start on boot 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: Wed, 08 Dec 2004 20:05:34 -0000 > What happens if you run "/usr/local/etc/rc.d/mysql-server.sh start" > manually? Does the log file enlighten you > (/var/db/mysql/[boxname].err)? I think you may have found it. I was able to stop mysql using the rc script. However starting it back up did nothing: # /usr/local/etc/rc.d/mysql-server.sh start Starting mysql. Yet mysql never started up, here is the error log: --- 041208 14:07:26 mysqld started 041208 14:07:26 [ERROR] Can't find messagefile '/usr/local/share/mysql/english/errmsg.sys' 041208 14:07:26 [ERROR] Aborting 041208 14:07:26 mysqld ended --- I do have the file it's complaining about: # ll -d /usr/local/share/mysql/english/errmsg.sys -r--r--r-- 1 root wheel 16568 Dec 6 20:28 /usr/local/share/mysql/english/err msg.sys If I start it up with mysql_safe using what I think the script is using as startup: # /usr/local/bin/mysqld_safe --user=mysql --datadir=/var/db/mysql --pid-file=/var/db/mysql/alpargata.net.pid & Then it starts up just fine: --- 041208 14:07:32 mysqld started 041208 14:07:32 InnoDB: Started; log sequence number 0 43912 /usr/local/libexec/mysqld: ready for connections. Version: '4.1.7' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-4.1.7 --- So I'm really not sure what's going on. Vonleigh Simmons