<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><title>KIRKLEES COLLEGE</title><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.msochpdefault, li.msochpdefault, div.msochpdefault
{mso-style-name:msochpdefault;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Calibri","sans-serif";}
span.emailstyle17
{mso-style-name:emailstyle17;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-GB link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='color:#1F497D'>I think what Paul and Pat meant was in database.php (or when running setup) use localhost for database_host rather than an IP address <o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>e.g. in database.php do you have the following<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>/*<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'> * Host where database is<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'> */<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>$xerte_toolkits_site->database_host = "localhost";<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>assuming you db is on the same server as toolkits?<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>HTH<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Ron<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><a name="_MailEndCompose"><span style='color:#1F497D'><o:p> </o:p></span></a></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> xerte-bounces@lists.nottingham.ac.uk [mailto:xerte-bounces@lists.nottingham.ac.uk] <b>On Behalf Of </b>James Burns<br><b>Sent:</b> 05 April 2012 11:04<br><b>To:</b> xerte@lists.nottingham.ac.uk<br><b>Subject:</b> [Xerte] Re: MYSQL access denied error<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>Hi,<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal>Do you mean use “localhost” as the “bind-address in “my.cnf”?<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal>If I do this, I get 111 errors when trying to access through a browser on remote workstation (we need to be able to access mysql from remote PCs). I am using “bind-address” “0.0.0.0” which seems to get me as far as the original error mentioned.<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal>If I login to mysql at the command line locally, then type this :-<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal>“use mysql;”<o:p></o:p></p><p class=MsoNormal>“select user, host, super_priv from user;”<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal>I get this response :-<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal>+------------------+----------------+------------+-----------------------<o:p></o:p></p><p class=MsoNormal>| user | host | super_priv |<o:p></o:p></p><p class=MsoNormal>+------------------+----------------+------------+-----------------------<o:p></o:p></p><p class=MsoNormal>| root | localhost | Y |<o:p></o:p></p><p class=MsoNormal>| debian-sys-maint | localhost | Y |<o:p></o:p></p><p class=MsoNormal>| pma | localhost | N |<o:p></o:p></p><p class=MsoNormal>| root | % | Y |<o:p></o:p></p><p class=MsoNormal>| www-data | % | N |<o:p></o:p></p><p class=MsoNormal>| pma | 192.168.240.98 | N |<o:p></o:p></p><p class=MsoNormal>+------------------+----------------+------------+-----------------------<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal>Can you see an issue here? (I am using “root” at this point for xerte “proxy” mysql account – have tried changing it to another user with no success as far)<o:p></o:p></p><p class=MsoNormal>The file system permissions on the “xerte” directory under Apache root are all flagged 777 for global access.<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal>Regards<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p></div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'>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. <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><br>KIRKLEES COLLEGE<br>YOUR SUCCESS IS OUR FOCUS <br><br>Please consider the environment. Don't print this e-mail unless necessary. <o:p></o:p></span></p><p>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. <o:p></o:p></p><p>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. <o:p></o:p></p></div></body></html>