From owner-freebsd-questions@FreeBSD.ORG Wed Dec 8 20:11:11 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 59E1016A4CE for ; Wed, 8 Dec 2004 20:11:11 +0000 (GMT) Received: from ms05.mailstreet2003.net (MS05.mailstreet2003.net [63.251.155.133]) by mx1.FreeBSD.org (Postfix) with ESMTP id EF60843D58 for ; Wed, 8 Dec 2004 20:11:10 +0000 (GMT) (envelope-from chris@sigd.net) X-MimeOLE: Produced By Microsoft Exchange V6.5.6944.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Date: Wed, 8 Dec 2004 15:11:05 -0500 Message-ID: <6FC9F9894A9F8C49A722CF9F2132FC2202972ECD@ms05.mailstreet2003.net> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: mysql won't start on boot Thread-Index: AcTdYXoZxFoFim5kTQijVKaai1VxPwAAEUtA From: "Haulmark, Chris" To: "Vonleigh Simmons" , "Markus Hoenicka" 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:11:11 -0000 Someone broke the silence:=20 >> 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)? >=20 > I think you may have found it. I was able to stop mysql > using the rc > script. However starting it back up did nothing: >=20 > # /usr/local/etc/rc.d/mysql-server.sh start > Starting mysql. >=20 > 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 >=20 > 041208 14:07:26 mysqld ended > --- >=20 > I do have the file it's complaining about: >=20 > # 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 >=20 > If I start it up with mysql_safe using what I think the > script is > using as startup: >=20 > # /usr/local/bin/mysqld_safe --user=3Dmysql --datadir=3D/var/db/mysql > --pid-file=3D/var/db/mysql/alpargata.net.pid & >=20 > 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 > --- >=20 > So I'm really not sure what's going on. Since you didn't mention which mysql version you are using..I will say = this. In the /usr/ports/UPDATING...there is a paragraph. 20041031: AFFECTS: users of databases/mysql40-server AUTHOR: ale@FreeBSD.org The MySQL Daemon must now be enabled / disabled in rc.conf. See the script for details. Is there such an entry in the rc.conf? Chris >=20 >=20 > Vonleigh Simmons > >=20 > _______________________________________________ > 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"