Date: Wed, 8 Dec 2004 15:11:05 -0500 From: "Haulmark, Chris" <chris@sigd.net> To: "Vonleigh Simmons" <nospam@illusionart.com>, "Markus Hoenicka" <markus.hoenicka@mhoenicka.de> Cc: freebsd-questions@freebsd.org Subject: RE: mysql won't start on boot Message-ID: <6FC9F9894A9F8C49A722CF9F2132FC2202972ECD@ms05.mailstreet2003.net>
next in thread | raw e-mail | index | archive | help
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 > <http://illusionart.com/>; >=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"
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?6FC9F9894A9F8C49A722CF9F2132FC2202972ECD>