[Xerte] Re: MySQL plugin FEDERATED is disabled

[Paul Swanson]

You won't find logs specific to phpMyAdmin, but there may be one for PHP
(phpMyAdmin is a PHP program). If you have a print out of your PHP
Information, you can find the location of the log file there. If you
don't, you can create a script that will display this information, which
I recommend you then print and keep somewhere. All you need for the
script is the following:
 
<?php
phpinfo();
?>
 
Call it 'phpinfo.php'. Upload this somewhere on your webserver
(preferably NOT the document root folder, commonly called htdocs). If
you create a folder off htdocs named "info" use the following address to
run the file: http://yourDomainName/info/phpinfo.php. When it runs, look
for the error_log entry in the Core section. It will tell you the path
to the file. Download the file and open it in any text editor. It will
only have the details of your error if log_errors is On. It's usually On
by default.
 
You should delete the phpinfo.php file when you are done. It reveals a
lot of information about your PHP installation that is best to keep to
yourself.
 
Paul
 
From: xerte-bounces at lists.nottingham.ac.uk
[mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of KnowledgeWare
Sent: Friday, April 27, 2012 1:40 PM
To: 'Xerte discussion list'
Subject: [Xerte] Re: MySQL plugin FEDERATED is disabled
 
Hmm...just logged in with a regular account to phyMyAdmin, then the root
account failed, then was successful at logging in.
 
Any idea where logs are kept in phpMyAdmin? I can't see anything
resembling a log file.
 
RonM2
 
From: xerte-bounces at lists.nottingham.ac.uk
[mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of David Goodwin
Sent: Friday, April 27, 2012 11:38 AM
To: Xerte discussion list
Subject: [Xerte] Re: MySQL plugin FEDERATED is disabled
 
 
On 27 Apr 2012, at 19:07, KnowledgeWare wrote:
 
I'm unable to access the toolkits 1.5 management interface on a Windows
2008 R2 server today - just get a blank screen where I would normally
get the list of courses, create a new course, etc. My suspicion is the
MySQL connection is broken.
 
In the Windows event log I have a MySQL error: Plugin 'FEDERATED' is
disabled.  The MySQL service is running, however.
 
I'm not a MySQL person and not sure how to deal with this. Some googling
indicates a firewall exception is needed after a Windows update, I'm
looking into that.
 
Has anyone else run into this?
 
 
 
I think the message about the federated plugin being disabled is a red
herring - you would be using either InnoDB or MyISAM - which are
different.
 
Are you able to connect to the database locally using any of the MySQL
management tools you get ?
 
(Were you on linux, I'd say run 'mysql -u root -pblahblahblah
database_name ' to test a connection).
 
thanks
David.
 
 
Pale Purple Ltd.  (Company No: 5580814)
'Business Web Application Development and Training in PHP'
 
http://www.palepurple.co.uk   
Office: 0845 0046746     Mobile: 07792380669 
 
Follow us on Twitter: @PalePurpleLtd
 
This message and any attachment are intended solely for the addressee
and may contain confidential information. If you have received this
message in error, please send it back to me, and immediately delete it.
Please do not use, copy or disclose the information contained in this
message or in any attachment. Any views or opinions expressed by the
author of this email do not necessarily reflect the views of the
University of Nottingham. 
This message has been checked for viruses but the contents of an
attachment may still contain software viruses which could damage your
computer system: you are advised to perform your own checks. Email
communications with the University of Nottingham may be monitored as
permitted by UK legislation. 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nottingham.ac.uk/pipermail/xerte/attachments/20120427/bf9bbefe/attachment-0001.html>