Moodle died - help with PHP/MYSQL needed

[mattjporter]

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]

Hi Matt,

when was it last working OK and what if anything has happened since? ie: updates/changes etc.

[mattjporter]

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.

[glennda]

Are we talking windows or linux?

[mattjporter]

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]

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]

@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]

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]

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]

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]

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]

Are there any entries made in the event viewer when you attempt to start it?

[mattjporter]

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]

What about the contents of the mysql.err file in the MySQL data directory?

[mattjporter]

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]

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]

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