[Xerte] Re: MYSQL access denied error

[Pat Lockley]

localhost would be a good bet - Check the mysql user table to see if that
applies.

I've never known an install fail unless maybe it is a privileges issue?

Then also be sure to rename demo.php to something else as it is unsecure as
anyone can log in and you've shown the world :)

On Tue, Apr 3, 2012 at 4:52 PM, Paul Swanson <Paul.Swanson at harlandfs.com>wrote:

> 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 :-****
>
>  ****
>
> [image: Description: Description: cid:image001.png at 01CD1178.FCB48890]****
>
>  ****
>
> 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. ****
>
> _______________________________________________
> Xerte mailing list
> Xerte at lists.nottingham.ac.uk
> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
>
> 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/2f391594/attachment.html>