slobjones Posted May 8, 2006 Share Posted May 8, 2006 I can't keep MySQL running. I start it, it turns itself off. This started today, after a week with no problems.I've tried it with installations of EasyPHP and now XAMPP. Same problem. I've tried removing the whole thing and reinstalling. Nothing changes.Could there be some MySQL configuration files on my system that I'm missing?Thanks. Quote Link to comment https://forums.phpfreaks.com/topic/9347-mysql-keeps-turning-itself-off/ Share on other sites More sharing options...
fenway Posted May 10, 2006 Share Posted May 10, 2006 Check the error log, and post whatever messages appear in said log. Quote Link to comment https://forums.phpfreaks.com/topic/9347-mysql-keeps-turning-itself-off/#findComment-34932 Share on other sites More sharing options...
slobjones Posted May 10, 2006 Author Share Posted May 10, 2006 [!--quoteo(post=372938:date=May 10 2006, 10:26 AM:name=fenway)--][div class=\'quotetop\']QUOTE(fenway @ May 10 2006, 10:26 AM) [snapback]372938[/snapback][/div][div class=\'quotemain\'][!--quotec--]Check the error log, and post whatever messages appear in said log.[/quote]Here's a nice, fresh error log. I started XAMPP Control Panel, performed a refresh and status check and got this in the error log:[Wed May 10 13:07:47 2006] [crit] (22)Invalid argument: unable to replace stderr with error_log[Wed May 10 13:07:47 2006] [crit] (2)No such file or directory: unable to replace stderr with /dev/null[Wed May 10 13:07:54 2006] [crit] (22)Invalid argument: unable to replace stderr with error_log[Wed May 10 13:07:54 2006] [crit] (2)No such file or directory: unable to replace stderr with /dev/null[Wed May 10 13:08:06 2006] [notice] Apache/2.2.0 (Win32) DAV/2 mod_ssl/2.2.0 OpenSSL/0.9.8a mod_autoindex_color PHP/5.1.2 configured -- resuming normal operations[Wed May 10 13:08:06 2006] [notice] Server built: Dec 1 2005 18:36:53[Wed May 10 13:08:06 2006] [notice] Parent: Created child process 1244[Wed May 10 13:08:22 2006] [notice] Child 1244: Child process is running[Wed May 10 13:08:22 2006] [notice] Child 1244: Acquired the start mutex.[Wed May 10 13:08:22 2006] [notice] Child 1244: Starting 250 worker threads.[Wed May 10 13:08:22 2006] [notice] Child 1244: Starting thread to listen on port 443.[Wed May 10 13:08:22 2006] [notice] Child 1244: Starting thread to listen on port 80.I've found now that if I run XAMPP-restart, MySQL will operate, even though XAMPP-restart first reports: "Can't connect to MySQL server on localhost (10061)."A check of the error log then shows:[Wed May 10 13:12:57 2006] [notice] Apache/2.2.0 (Win32) DAV/2 mod_ssl/2.2.0 OpenSSL/0.9.8a mod_autoindex_color PHP/5.1.2 configured -- resuming normal operations[Wed May 10 13:12:57 2006] [notice] Server built: Dec 1 2005 18:36:53[Wed May 10 13:12:57 2006] [notice] Parent: Created child process 5648[Wed May 10 13:13:30 2006] [notice] Child 5648: Child process is running[Wed May 10 13:13:30 2006] [notice] Child 5648: Acquired the start mutex.[Wed May 10 13:13:30 2006] [notice] Child 5648: Starting 250 worker threads.[Wed May 10 13:13:31 2006] [notice] Child 5648: Starting thread to listen on port 443.[Wed May 10 13:13:31 2006] [notice] Child 5648: Starting thread to listen on port 80.XAMPP Control Panel reports:ERROR: Status Check Failure [1]ERROR: Status Check Failure [2]But at that point, I can run localhost in my browser and MySQL operates with no problem. So maybe I should just run it this way and ignore the error messages. Quote Link to comment https://forums.phpfreaks.com/topic/9347-mysql-keeps-turning-itself-off/#findComment-35016 Share on other sites More sharing options...
fenway Posted May 10, 2006 Share Posted May 10, 2006 Well, that's not a MySQL error log; and the fact that it thinks it can't connect is definitely a problem. Quote Link to comment https://forums.phpfreaks.com/topic/9347-mysql-keeps-turning-itself-off/#findComment-35069 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.