Date: Wed, 8 Dec 2004 12:05:13 -0800 From: Vonleigh Simmons <nospam@illusionart.com> To: "Markus Hoenicka" <markus.hoenicka@mhoenicka.de> Cc: freebsd-questions@freebsd.org Subject: Re: mysql won't start on boot Message-ID: <78AFAA57-4954-11D9-B2C4-000A2791B6EC@illusionart.com> In-Reply-To: <16823.15862.57984.186555@tipi.mininet> References: <ED4C536E-48C1-11D9-B2C4-000A2791B6EC@illusionart.com> <1102494183.41b6b9e726b2f@www.domainfactory-webmail.de> <1F2911BC-4900-11D9-B2C4-000A2791B6EC@illusionart.com> <16823.15862.57984.186555@tipi.mininet>
next in thread | previous in thread | raw e-mail | index | archive | help
> 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 <http://illusionart.com/>;
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?78AFAA57-4954-11D9-B2C4-000A2791B6EC>