mattjporter Posted May 16, 2011 Posted May 16, 2011 Something has gone wrong with our Moodle, we think it might be something to do with PHP/MYSQL can somebody please help. layton.blackpool.sch.uk/moodle Thanks
bodminman Posted May 16, 2011 Posted May 16, 2011 Hi Matt, when was it last working OK and what if anything has happened since? ie: updates/changes etc.
mattjporter Posted May 16, 2011 Author Posted May 16, 2011 Hi, It was working this morning, tried updating PHP ready for a Moodle 2 test install and then had problems ever since. The MYSQL service doesn't want to start on the server.
mattjporter Posted May 16, 2011 Author Posted May 16, 2011 It's set up on Windows Small Business Server 2003. Convinced it's something to do with MYSQL tables or PHP. If you go to the website you will also see what I mean. http://www.layton.blackpool.sch.uk http://www.layton.blackpool.sch.uk/moodle
glennda Posted May 16, 2011 Posted May 16, 2011 Does seem to be php related but sorry i've got no experience of hosting it on windows - have never even tried to install!
bossman Posted May 16, 2011 Posted May 16, 2011 @mattjporter: Did you take a backup before you upgraded the PHP version? If so you could uninstall the latest PHP and re-install the last version then import your backup to overwrite the moodle files. It is PHP related but not worked on windows version. Good luck
webman Posted May 16, 2011 Posted May 16, 2011 The server is sending PHP files as text documents - i.e. it doesn't know that they should be processed via the PHP interpreter. At this stage, it has nothing to do with MySQL (even though it may or may not be working). It sounds like upgrading PHP didn't work fully, or at all. Have a look at and use one of these instructions to try and get it working again: How To Install PHP on IIS 6.0 » IIS Admin Blog Using FastCGI to Host PHP Applications on IIS 6.0 : Host Applications on the Microsoft Web Platform : Running PHP Applications on IIS : The Official Microsoft IIS Site Side note: due to the error, your passwords are exposed. Optionally change the webroot to somewhere safe, so that Joomla/Moodle aren't made available until fixed; but change your MySQL passwords for the Joomla/Moodle users.
mattjporter Posted May 17, 2011 Author Posted May 17, 2011 Webman I have followed the second guide through right to the end and all the php coding that was appearing on the Moodle is now replaced by: Error: Database connection failed. It is possible that the database is overloaded or otherwise not running properly. The site administrator should also check that the database details have been correctly specified in config.php I still can't get into the MySQL? The website still has all of the code on still http://www.layton.blackpool.sch.uk http://www.layton.blackpool.sch.uk/moodle
webman Posted May 17, 2011 Posted May 17, 2011 OK. Looks like you got PHP installed and working - that's good. But now Joomla and Moodle can't connect to MySQL. Either: a) MySQL is not running or a firewall is interfering with it. b) MySQL is running, you changed the passwords for the MySQL users, but didn't update the config files for Joomla and Moodle. c) PHP hasn't got the MySQL extension enabled or installed. To check for (A) - look for the MySQL service, and search event viewer/log files for any errors relating to MySQL. For (B), just edit the config files for Joomla and Moodle, updating the password to the one that you changed it to for both applications. And ©, you need to find out if the extension is installed. To do this, create a new PHP file with the following contents and save it in the webroot somewhere, as info.php: Then browse to that file. Ctrl + F to look for 'mysql' - there should be an entry there for it, about half way down the page, with a table underneath with the version and some settings.
mattjporter Posted May 17, 2011 Author Posted May 17, 2011 The MySQL service will not start, when trying to start it, the following error is given: Could not start the MySQL service on Local Computer. Error 1067: The process terminated unexpectedly.
webman Posted May 17, 2011 Posted May 17, 2011 Are there any entries made in the event viewer when you attempt to start it?
mattjporter Posted May 17, 2011 Author Posted May 17, 2011 There are a number of entries each time i try to start the service: Warning Event Type: Warning Event Source: MySQL Event Category: None Event ID: 100 Date: 17/05/2011 Time: 10:43:17 User: N/A Computer: MAIL Description: The description for Event ID ( 100 ) in Source ( MySQL ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Changed limits: max_open_files: 2048 max_connections: 800 table_cache: 619 Error Event Type: Error Event Source: MySQL Event Category: None Event ID: 100 Date: 17/05/2011 Time: 10:43:17 User: N/A Computer: MAIL Description: The description for Event ID ( 100 ) in Source ( MySQL ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Error message file 'D:\server\mysql\share\english\errmsg.sys' had only 475 error messages, but it should contain at least 641 error messages. Check that the above file is the right version for this program! Information Event Type: Information Event Source: MySQL Event Category: None Event ID: 100 Date: 17/05/2011 Time: 10:43:17 User: N/A Computer: MAIL Description: The description for Event ID ( 100 ) in Source ( MySQL ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Plugin 'FEDERATED' is disabled. Error Event Type: Error Event Source: MySQL Event Category: None Event ID: 100 Date: 17/05/2011 Time: 10:43:17 User: N/A Computer: MAIL Description: The description for Event ID ( 100 ) in Source ( MySQL ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Can't open the mysql.plugin table. Please run mysql_upgrade to create it. Error Event Type: Error Event Source: MySQL Event Category: None Event ID: 100 Date: 17/05/2011 Time: 10:43:18 User: N/A Computer: MAIL Description: The description for Event ID ( 100 ) in Source ( MySQL ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Aborting Information Event Type: Information Event Source: MySQL Event Category: None Event ID: 100 Date: 17/05/2011 Time: 10:43:19 User: N/A Computer: MAIL Description: The description for Event ID ( 100 ) in Source ( MySQL ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event:
webman Posted May 17, 2011 Posted May 17, 2011 What about the contents of the mysql.err file in the MySQL data directory?
mattjporter Posted May 17, 2011 Author Posted May 17, 2011 110517 10:43:17 [Note] Plugin 'FEDERATED' is disabled. d:\server\mysql\bin\mysqld: Unknown error 1146 110517 10:43:17 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 110517 10:43:18 InnoDB: Started; log sequence number 0 44233 d:\server\mysql\bin\mysqld: Too many arguments (first extra is '=defaults-file=d:\server\mysql\bin\my.ini'). Use --verbose --help to get a list of available options 110517 10:43:18 [ERROR] Aborting 110517 10:43:18 InnoDB: Starting shutdown... 110517 10:43:19 InnoDB: Shutdown completed; log sequence number 0 44233 110517 10:43:19 [Note]
webman Posted May 17, 2011 Posted May 17, 2011 Find your my.ini file. I'm not sure if this is in the Windows folder or the MySQL folder. Then find lines like: #skip-innodb #skip-bdb #skip-federated Make sure they are commented out with hash symbols as shown. Then try to run mysql_upgrade - it should be in the MySQL folder.
mattjporter Posted May 17, 2011 Author Posted May 17, 2011 There are two my.ini files - one in \mysql\ and one in \mysql\bin Both only have #skip-innodb - there is no sign of #skip-bdb or #skip-federated in either file. The mysql_upgrade.exe is in \mysql\bin - running this from the folder just runs through. Running it from cmd give the following error: Looking for 'mysql.exe' in: d:\server\mysql\bin\mysql.exe Looking for 'mysqlcheck.exe' in: d:\server\mysql\bin\mysqlcheck.exe Running 'mysqlcheck'... d:\server\mysql\bin\mysqlcheck.exe: Got error: 2003: Can't connect to MySQL serv er on 'localhost' (10061) when trying to connect FATAL ERROR: Upgrade failed
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now