<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)">
<style>
<!--
/* Font Definitions */
@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:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","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;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</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-US link=blue vlink=purple style='word-wrap: break-word;
-webkit-nbsp-mode: space;-webkit-line-break: after-white-space'>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Koha version 2.2.5 (Internal IP 10.0.254.3)<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Mysql version 4.1 (Internal IP 10.0.254.4)<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>I did not use the GRANT ALL ON command on the mysql
server. I assume this command has to be performed on the mysql server and
the @server should be the Koha server? (ex. GRANT ALL ON koha.* to <a
href="mailto:kohaadmin@10.0.254.3">kohaadmin@10.0.254.3</a> ) I probably
need to know the mysql root password that I’ve been reading about?<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>I’m not sure how to connect to the mysql server with the
commandline mysql client from the koha server.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>C:\Documents and Settings\rlinebaugh>telnet 10.0.250.4 3306<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Connecting To 10.0.250.4...Could not open connection to the
host, on port 3306:<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Connect failed<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Rob <o:p></o:p></span></p>
</div>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Mason James
[mailto:mason.loves.sushi@gmail.com] <br>
<b>Sent:</b> Friday, May 09, 2008 7:53 PM<br>
<b>To:</b> Ryan Higgins<br>
<b>Cc:</b> Robert Linebaugh; koha<br>
<b>Subject:</b> Re: [Koha] Changed IP - Can't connect to mysql server<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<div>
<div>
<p class=MsoNormal>On 2008/05/10, at 10:02 AM, Ryan Higgins wrote:<o:p></o:p></p>
</div>
<p class=MsoNormal><br>
<br>
<o:p></o:p></p>
<p class=MsoNormal><br>
Did you <br>
<br>
GRANT ALL ON mykoha_db_name.* to <a href="mailto:kohaadmin@72.227.31.7">kohaadmin@72.227.31.7</a>
<br>
<br>
on the mysql server ?<br>
<br>
Can you connect to the mysql server with the commandline mysql client on the
koha server ?<o:p></o:p></p>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'>
<div>
<blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;
margin-left:4.8pt;margin-right:0in'>
<div>
<div>
<p class=MsoNormal>> I had to change the IP scheme of my network. I
have changed the<br>
> interfaces, hosts and koha.conf files to reflect the new IP. When I
try<br>
> to access Koha by typing <a href="http://koha.domain.com:8050"
target="_blank">http://koha.domain.com:8050</a> I get a 500<br>
> internal server error. My opac-error_log file says:<br>
><br>
><br>
><br>
> Thu May 08 21:24:58 2008] [error] [client <a href="http://72.227.31.7"
target="_blank">72.227.31.7</a>] DBI<br>
> connect('Koha:<a href="http://10.0.250.4" target="_blank">10.0.250.4</a>','kohaadmin',...)
failed: Can't connect to<br>
> MySQL server on '<a href="http://10.0.250.4" target="_blank">10.0.250.4</a>'
(111) at<br>
> /usr/local/koha/intranet/modules/C4/Context.pm line 411 <o:p></o:p></p>
</div>
</div>
</blockquote>
</div>
</blockquote>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal>Hi Robert,<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal>Try these tests too...<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal>To test your networking, try a telnet to the remote mysql
box...<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>$ telnet <a href="http://10.0.250.4" target="_blank">10.0.250.4 </a>3306<o:p></o:p></p>
</div>
<div>
<div>
<div>
<div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal>If that works, hit it with the mysql client...<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>$ mysql -u kohaadmin –h <a
href="http://10.0.250.4" target="_blank">10.0.250.4 </a>–p'mypassword'
koha<o:p></o:p></p>
</div>
</div>
</div>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal>Cheers, Mason.<o:p></o:p></p>
</div>
</div>
</div>
</div>
</body>
</html>