mysql won't start on boot

[Haulmark, Chris]

Someone broke the silence: 

>> 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.

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 at 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


> 
> 
> Vonleigh Simmons
> <http://illusionart.com/>
> 
> _______________________________________________
> freebsd-questions at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to
> "freebsd-questions-unsubscribe at freebsd.org"