Re: MySQL not starting at boot-Fedora Core 3
Hello. Are you able to start MySQL server by this command? service mysqld start I think you should put the correct values for the basedir, datadir, PATH variables at the beginning of the /etc/init.d/mysql file. Mark Sargent <[EMAIL PROTECTED]> wrote: > Hi All, > > attempting another mysql install, on a 3rd machine. Extracted the tar.gz > file to /usr/local/mysql. Followed the install docs here, > > http://dev.mysql.com/doc/mysql/en/installing-binary.html > > and successfully ran the MySql grant tables script, > > 6. If you haven't installed MySQL before, you must create the MySQL > grant tables: > > shell> scripts/mysql_install_db --user=mysql > > > I then followed here, > > http://dev.mysql.com/doc/mysql/en/automatic-start.html > > to a T, and copied mysql.server to /etc/init.d, and just for good > measure, gave it permission to execute, > > chmod +x /etc/init.d/mysql > > I then rebooted, to see how things would go at boot, and saw a failed > message for mysqld_safe, > > Apr 16 21:20:01 localhost lsb_log_message: Can't execute > ./bin/mysqld_safe failed > > Can anyone explain why it wouldn't start..? Anything I should be looking > for..? I can start the server with ./mysqld_safe from within the bin dir > and I can connect as root or mysql. Cheers. > > /etc/init.dmysql permissions > > [EMAIL PROTECTED] init.d]# ls -lh mysql > -rwxr-xr-x 1 root root 6.2K Apr 16 21:11 mysql > > Mark Sargent. > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL not starting at boot-Fedora Core 3
Michael Stassen wrote: Mark Sargent wrote: Andy Pieters wrote: Hi Try to see in the log files cat /var/log/mysqld or start the mysql server and then type tail /var/log/messages On Fedora, once you have properly installed mysql there is no need to reboot your system to test it. Just type /sbin/service mysql start other options you can use there: stop restart I have a MySql server on one of my machines that is running FC3 and I don't even have mysql_safe here. (Version 3.23.58) Andy Hi All, that's just the problem. It won't start that way. I had already checked the logs, but, it only seems to log things after starting, bringing me back to zero position, a server that won't start this way. Cheers. (It was safe_mysqld in mysql 3.) Not sure what you mean there.. [EMAIL PROTECTED] ~]# /sbin/service mysql start Can't execute ./bin/mysqld_safe[FAILED] Your error message is right there -- "Can't execute ./bin/mysqld_safe". If you look in mysql.server, you'll see cd $basedir case "$mode" in 'start') # Start daemon if test -x $bindir/mysqld_safe then # ... code to start the server ... else log_failure_msg "Can't execute $bindir/mysqld_safe" fi Clearly, ./bin/mysqld_safe is failing the -x test. As you previously reported that ./mysqld_safe works if you are in mysql's bin directory, we know that mysqld_safe is executable. Hence, when mysql.server tries to run ./bin/mysqld_safe, it must not be in the right directory. That is, it has the wrong value for $basedir. Perhaps you installed mysql somewhere other than the standard location? Nope, it is located here, /usr/local/mysql. You could edit mysql.server to add an "echo $basedir" right before the cd, then run it by hand to you can see where the script thinks it should go. The fix will probably involve setting the basedir in /etc/my.cnf to the correct value. Yes, I went and looked at the script, to see if something was wrong. I couldn't see anything out of order, although, I'm a novice at scripts(programming). If that's not enough to get you going in the right direction, write back and let us know. Hopefully it'll get me going. Cheers. Michael Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL not starting at boot-Fedora Core 3
Mark Sargent wrote: Andy Pieters wrote: Hi Try to see in the log files cat /var/log/mysqld or start the mysql server and then type tail /var/log/messages On Fedora, once you have properly installed mysql there is no need to reboot your system to test it. Just type /sbin/service mysql start other options you can use there: stop restart I have a MySql server on one of my machines that is running FC3 and I don't even have mysql_safe here. (Version 3.23.58) Andy Hi All, that's just the problem. It won't start that way. I had already checked the logs, but, it only seems to log things after starting, bringing me back to zero position, a server that won't start this way. Cheers. (It was safe_mysqld in mysql 3.) [EMAIL PROTECTED] ~]# /sbin/service mysql start Can't execute ./bin/mysqld_safe[FAILED] Your error message is right there -- "Can't execute ./bin/mysqld_safe". If you look in mysql.server, you'll see cd $basedir case "$mode" in 'start') # Start daemon if test -x $bindir/mysqld_safe then # ... code to start the server ... else log_failure_msg "Can't execute $bindir/mysqld_safe" fi Clearly, ./bin/mysqld_safe is failing the -x test. As you previously reported that ./mysqld_safe works if you are in mysql's bin directory, we know that mysqld_safe is executable. Hence, when mysql.server tries to run ./bin/mysqld_safe, it must not be in the right directory. That is, it has the wrong value for $basedir. Perhaps you installed mysql somewhere other than the standard location? You could edit mysql.server to add an "echo $basedir" right before the cd, then run it by hand to you can see where the script thinks it should go. The fix will probably involve setting the basedir in /etc/my.cnf to the correct value. If that's not enough to get you going in the right direction, write back and let us know. Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL not starting at boot-Fedora Core 3
Andy Pieters wrote: Hi Try to see in the log files cat /var/log/mysqld or start the mysql server and then type tail /var/log/messages On Fedora, once you have properly installed mysql there is no need to reboot your system to test it. Just type /sbin/service mysql start other options you can use there: stop restart I have a MySql server on one of my machines that is running FC3 and I don't even have mysql_safe here. (Version 3.23.58) Andy Hi All, that's just the problem. It won't start that way. I had already checked the logs, but, it only seems to log things after starting, bringing me back to zero position, a server that won't start this way. Cheers. [EMAIL PROTECTED] ~]# /sbin/service mysql start Can't execute ./bin/mysqld_safe[FAILED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL not starting at boot-Fedora Core 3
Hi Try to see in the log files cat /var/log/mysqld or start the mysql server and then type tail /var/log/messages On Fedora, once you have properly installed mysql there is no need to reboot your system to test it. Just type /sbin/service mysql start other options you can use there: stop restart I have a MySql server on one of my machines that is running FC3 and I don't even have mysql_safe here. (Version 3.23.58) Andy -- Registered Linux User Number 379093 -- --BEGIN GEEK CODE BLOCK- Version: 3.1 GAT/O/>E$ d-(---)>+ s:(+)>: a--(-)>? C$(+++) UL>$ P-(+)>++ L+++>$ E---(-)@ W+++>+++$ !N@ o? !K? W--(---) !O !M- V-- PS++(+++) PE--(-) Y+ PGP++(+++) t+(++) 5-- X++ R*(+)@ !tv b-() DI(+) D+(+++) G(+) e>$@ h++(*) r-->++ y--()> -- ---END GEEK CODE BLOCK-- -- Check out these few php utilities that I released under the GPL2 and that are meant for use with a php cli binary: http://www.vlaamse-kern.com/sas/ -- -- pgpAURHhrWK92.pgp Description: PGP signature
MySQL not starting at boot-Fedora Core 3
Hi All, attempting another mysql install, on a 3rd machine. Extracted the tar.gz file to /usr/local/mysql. Followed the install docs here, http://dev.mysql.com/doc/mysql/en/installing-binary.html and successfully ran the MySql grant tables script, 6. If you haven't installed MySQL before, you must create the MySQL grant tables: shell> scripts/mysql_install_db --user=mysql I then followed here, http://dev.mysql.com/doc/mysql/en/automatic-start.html to a T, and copied mysql.server to /etc/init.d, and just for good measure, gave it permission to execute, chmod +x /etc/init.d/mysql I then rebooted, to see how things would go at boot, and saw a failed message for mysqld_safe, Apr 16 21:20:01 localhost lsb_log_message: Can't execute ./bin/mysqld_safe failed Can anyone explain why it wouldn't start..? Anything I should be looking for..? I can start the server with ./mysqld_safe from within the bin dir and I can connect as root or mysql. Cheers. /etc/init.dmysql permissions [EMAIL PROTECTED] init.d]# ls -lh mysql -rwxr-xr-x 1 root root 6.2K Apr 16 21:11 mysql Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]