[Xerte] Re: MYSQL access denied error

[Paul Swanson]

I see you are using 192.168.240.98 as the database host. Have you tried
using 'localhost' as the host?
 
Paul
 
From: xerte-bounces at lists.nottingham.ac.uk
[mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of James Burns
Sent: Tuesday, April 03, 2012 8:39 AM
To: xerte at lists.nottingham.ac.uk
Subject: [Xerte] MYSQL access denied error
 
Hello,
 
I am in the process of trying to implement the Xerte Toolkit in our
College, but I am experiencing a specific issue.
 
I have installed the Toolkit (seemingly successfully) to a LAMP server,
following instructions in the Toolkits Guide. However, I keep getting
the same error when trying to access the PHP pages which come with Xerte
( I can run phpinfo.php ok) , see below :-
 
 
 
I have been through the suggestions in this documentation section about
"access denied" errors in MYSQL :-
 
http://dev.mysql.com/doc/refman/5.1/en/access-denied.html
 
However, I still get same error all the time (after several
installations tried). I there anyone who could offer some further
suggestions? There may be something I have missed or not tried yet
.......
 
I can authenticate to the MYSQL database directly remotely fine using a
Windows MYSQL client on my PC (with same credentials) and I can
authenticate to MYSQL directly ok with same credentials locally on the
server itself. I have checked user and host permissions in MYSQL and
they seem fine for remote access from any host for this mysql user.
However,  when going through Apache and PHP route I get same error every
time ....
 
When looking at database.php, the username/password are showing
correctly...
 
LAMP Server :-
 
PHP 5.3.2
MYSQL 5.1.61
Apache 2.2.14
 
Could you provide any suggestions that could enable us to move past this
issue and properly implement Xerte Toolkit in our College?
 
Regards
 
James Burns
Server Administrator
 
 
This email and any attachments are confidential and should not be used
by anyone who is not the original intended recipient. If you receive
this in error, please contact the sender and delete the material from
your computer. You are not authorised to, and must not, read, copy,
distribute, use or retain this message or any part of it. Kirklees
College cannot accept liability for any statements made which are
clearly the sender's own and not expressly made on behalf of Kirklees
College or one of its agents. 

KIRKLEES COLLEGE
YOUR SUCCESS IS OUR FOCUS 

Please consider the environment. Don't print this e-mail unless
necessary. 
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/20120403/86ea5d98/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 128909 bytes
Desc: image001.png
URL: <http://lists.nottingham.ac.uk/pipermail/xerte/attachments/20120403/86ea5d98/attachment-0001.png>