Re: mysql won't start on boot
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 anyway: --- $ grep enable /usr/local/etc/rc.d/mysql-server.sh # Add the following line to /etc/rc.conf to enable mysql: # mysql_enable (bool): Set to NO by default. # Set it to YES to enable MySQL. ..snip.. --- 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 tried recompiling mysql_server but still no go. The only error I get is: --- 041210 07:33:27 mysqld started 041210 7:33:27 [ERROR] Can't find messagefile '/usr/local/share/mysql/english/e rrmsg.sys' 041210 7:33:27 [ERROR] Aborting 041210 07:33:27 mysqld ended --- However when I start it directly it starts up just fine. Vonleigh Simmons http://illusionart.com/ ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql won't start on boot
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 just want mysqld to show up in your process list, swallow your pride and install the package. Works for me. regards, Markus -- Markus Hoenicka [EMAIL PROTECTED] (Spam-protected email: replace the quadrupeds with mhoenicka) http://www.mhoenicka.de ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql won't start on boot
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: # /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 in the start up script the command wasnt right ie. command=/usr/local/bin/safe_mysqld So I changed it to: command=/usr/local/bin/mysqld_safe Regards, Gary Hayers ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql won't start on boot
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 in the start up script the command wasnt right ie. command=/usr/local/bin/safe_mysqld So I changed it to: command=/usr/local/bin/mysqld_safe That's not it either: # grep command /usr/local/etc/rc.d/mysql-server.sh command=/usr/local/bin/mysqld_safe This is very strange. The command I'm using I pulled almost copying and pasting from the script, so it should be the same; yet it still won't start on bootup. Vonleigh Simmons http://illusionart.com/ ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql won't start on boot
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 script, but I'll try it anyway: --- $ grep enable /usr/local/etc/rc.d/mysql-server.sh # Add the following line to /etc/rc.conf to enable mysql: # mysql_enable (bool): Set to NO by default. # Set it to YES to enable MySQL. ..snip.. --- 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 tried recompiling mysql_server but still no go. The only error I get is: --- 041210 07:33:27 mysqld started 041210 7:33:27 [ERROR] Can't find messagefile '/usr/local/share/mysql/english/e rrmsg.sys' 041210 7:33:27 [ERROR] Aborting 041210 07:33:27 mysqld ended --- However when I start it directly it starts up just fine. What command are you issuing to start it directly? Regards, Gary Hayers ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql won't start on boot
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 PROTECTED] 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? 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? ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql won't start on boot
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 own after I reboot. However doing: I'm sitting in front of a Windows box right now, so please excuse me that I reply from memory. AFAIK there is an example start script in /usr/local/etc/init.d/ which you have to rename to mysql.sh. regards, Markus -- Markus Hoenicka [EMAIL PROTECTED] (Spam-protected email: replace the quadrupeds with mhoenicka) http://www.mhoenicka.de ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql won't start on boot
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 a Windows box right now, so please excuse me that I reply from memory. AFAIK there is an example start script in /usr/local/etc/init.d/ which you have to rename to mysql.sh. I do have a file in rc.d: # ll -d /usr/local/etc/rc.d/mysql-server.sh -rwxr-x--- 1 root wheel 1405 Dec 6 20:28 /usr/local/etc/rc.d/mysql-server.sh Vonleigh Simmons http://illusionart.com/ ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql won't start on boot
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 packages mysql-server-4.1.5.tbz and mysql-client-4.1.5.tbz. After adding them, there were the following start scripts in /usr/local/etc/rc.d: 000.mysql-client.sh mysql-server.sh I did not edit any config file but went right ahead to reboot the box. mysqld came up as intended. Do you use ports or a different MySQL version, by any chance? 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)? regards, Markus -- Markus Hoenicka [EMAIL PROTECTED] (Spam-protected email: replace the quadrupeds with mhoenicka) http://www.mhoenicka.de ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql won't start on boot
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/ ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
RE: mysql won't start on boot
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: [EMAIL PROTECTED] 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/ ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql won't start on boot
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 details. Is there such an entry in the rc.conf? 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. Vonleigh Simmons http://illusionart.com/ ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql won't start on boot
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 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 --- The documentation specifies that the above is not the way to start mysql. 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 --- And you found the correct way. However, I do not know why it is not starting at boot time. -- Joshua Lokken Open Source Advocate ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql won't start on boot
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 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 --- The documentation specifies that the above is not the way to start mysql. That's interesting. Why on earth would the mysql package use exactly this way to start up the server (see my previous post) if it is all wrong? regards, Markus -- Markus Hoenicka [EMAIL PROTECTED] (Spam-protected email: replace the quadrupeds with mhoenicka) http://www.mhoenicka.de ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]