Re: mysql won't start on boot

2004-12-10 Thread Vonleigh Simmons
Yes, was in my original message but you caught us half-way: # grep mysql /etc/rc.conf mysql_enable=YES I'm using the mysql from ports. I'm going from memory here as I'm not in front of my BSD machine but isn't it mysqld_enable=YES? Not according to the script, but I'll try it

Re: mysql won't start on boot

2004-12-10 Thread Markus Hoenicka
Vonleigh Simmons [EMAIL PROTECTED] was heard to say: Nope, still no dice. Changed it back to mysql_enable but it still won't start up on boot. Anyone have any other ideas of what it could be? I can't help you any further if you want to understand what's going wrong. However, if you

Re: mysql won't start on boot

2004-12-10 Thread Gary Hayers
Vonleigh Simmons wrote: After updating to 5.3 MySQL won't start at boot time. I read UPDATING and it says to include a line in /etc/rc.conf. But even after adding that line: # grep mysql /etc/rc.conf mysql_enable=YES It still won't start up on its own after I reboot. However doing: #

Re: mysql won't start on boot

2004-12-10 Thread Vonleigh Simmons
It still won't start up on its own after I reboot. However doing: # /usr/local/bin/mysqld_safe --user=mysql --datadir=/var/db/mysql --pid-file=/var/db/mysql/my_hostname.pid Ok forget that last question, I found the answer, check the startup script is running the correct command, I found that

Re: mysql won't start on boot

2004-12-10 Thread Gary Hayers
Vonleigh Simmons wrote: Yes, was in my original message but you caught us half-way: # grep mysql /etc/rc.conf mysql_enable=YES I'm using the mysql from ports. I'm going from memory here as I'm not in front of my BSD machine but isn't it mysqld_enable=YES? Not according to the

Re: mysql won't start on boot

2004-12-09 Thread CHris Rich
On Wed, 8 Dec 2004 12:22:53 -0800, Vonleigh Simmons [EMAIL PROTECTED] wrote: 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: [EMAIL

Re: mysql won't start on boot

2004-12-08 Thread Markus Hoenicka
Vonleigh Simmons [EMAIL PROTECTED] was heard to say: After updating to 5.3 MySQL won't start at boot time. I read UPDATING and it says to include a line in /etc/rc.conf. But even after adding that line: # grep mysql /etc/rc.conf mysql_enable=YES It still won't start up on its

Re: mysql won't start on boot

2004-12-08 Thread Vonleigh Simmons
After updating to 5.3 MySQL won't start at boot time. I read UPDATING and it says to include a line in /etc/rc.conf. But even after adding that line: # grep mysql /etc/rc.conf mysql_enable=YES It still won't start up on its own after I reboot. However doing: I'm sitting in front of

Re: mysql won't start on boot

2004-12-08 Thread Markus Hoenicka
Vonleigh Simmons writes: /usr/local/etc/init.d/ which you have to rename to mysql.sh. I do have a file in rc.d: Ah, sure. init.d is linuxish. It just so happened that I installed a 5.3 box from scratch in the last couple of days. MySQL wasn't installed yet, so I grabbed the

Re: mysql won't start on boot

2004-12-08 Thread Vonleigh Simmons
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

RE: mysql won't start on boot

2004-12-08 Thread 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

Re: mysql won't start on boot

2004-12-08 Thread Vonleigh Simmons
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: [EMAIL PROTECTED] The MySQL Daemon must now be enabled / disabled in rc.conf. See the script for

Re: mysql won't start on boot

2004-12-08 Thread Joshua Lokken
On Wed, 8 Dec 2004 12:05:13 -0800, Vonleigh Simmons [EMAIL PROTECTED] wrote: What happens if you run /usr/local/etc/rc.d/mysql-server.sh start # /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

Re: mysql won't start on boot

2004-12-08 Thread Markus Hoenicka
Joshua Lokken [EMAIL PROTECTED] was heard to say: On Wed, 8 Dec 2004 12:05:13 -0800, Vonleigh Simmons [EMAIL PROTECTED] wrote: What happens if you run /usr/local/etc/rc.d/mysql-server.sh start # /usr/local/etc/rc.d/mysql-server.sh start Starting mysql. Yet mysql never