<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" 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 11 (filtered medium)">
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="country-region"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 77.95pt 72.0pt 77.95pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoPlainText><font size=2 face="Courier New"><span style='font-size:
10.0pt'>Chris (and list),<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span style='font-size:
10.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span style='font-size:
10.0pt'>I can connect via a TCP/IP port from the command line. For example,
"mysqladmin -h penguin version" yields:<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span style='font-size:
10.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText style='margin-left:36.0pt'><font size=2 face="Courier New"><span
style='font-size:10.0pt'><snip/><o:p></o:p></span></font></p>
<p class=MsoPlainText style='margin-left:36.0pt'><font size=2 face="Courier New"><span
style='font-size:10.0pt'>Server
version 5.0.33-log<o:p></o:p></span></font></p>
<p class=MsoPlainText style='margin-left:36.0pt'><font size=2 face="Courier New"><span
style='font-size:10.0pt'>Protocol
version 10<o:p></o:p></span></font></p>
<p class=MsoPlainText style='margin-left:36.0pt'><font size=2 face="Courier New"><span
style='font-size:10.0pt'>Connection
penguin via TCP/IP<o:p></o:p></span></font></p>
<p class=MsoPlainText style='margin-left:36.0pt'><font size=2 face="Courier New"><span
style='font-size:10.0pt'>TCP
port
3306<o:p></o:p></span></font></p>
<p class=MsoPlainText style='margin-left:36.0pt'><font size=2 face="Courier New"><span
style='font-size:10.0pt'>Uptime:
41 sec<o:p></o:p></span></font></p>
<p class=MsoPlainText style='margin-left:36.0pt'><font size=2 face="Courier New"><span
style='font-size:10.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText style='margin-left:36.0pt'><font size=2 face="Courier New"><span
style='font-size:10.0pt'>Threads: 1 Questions: 2 Slow queries:
0 Opens: 12 Flush tables: 1 Open tables: 6 Queries per
second avg: 0.049<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span style='font-size:
10.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span style='font-size:
10.0pt'>So, I changed my koha.conf to point to “penguin” rather
than “localhost” and tried to hit opac-main.pl again and I found a
new error in my apache error log:<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span style='font-size:
10.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText style='margin-left:36.0pt'><font size=2 face="Courier New"><span
style='font-size:10.0pt'>DBI connect('CKI:penguin','kohaadmin',...) failed:
Client does not support authentication protocol requested by server; consider
upgrading MySQL client at /usr/local/koha/intranet/modules/C4/Context.pm line
411<o:p></o:p></span></font></p>
<p class=MsoPlainText style='margin-left:36.0pt'><font size=2 face="Courier New"><span
style='font-size:10.0pt'>Can't call method "prepare" on an undefined
value at opac-main.pl line 17.<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span style='font-size:
10.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span style='font-size:
10.0pt'>What on earth does that mean? If I try, “mysql -h penguin -u
kohaadmin -p CKI” from the command line and provide the password in the
koha.conf file, I get a very nice connection to the CKI db.<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span style='font-size:
10.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span style='font-size:
10.0pt'>-cht<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span style='font-size:
10.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span style='font-size:
10.0pt'>Chris Hammond-Thrasher MLIS<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span style='font-size:
10.0pt'>Library Systems Manager<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span style='font-size:
10.0pt'>University of the South Pacific<o:p></o:p></span></font></p>
<p class=MsoPlainText><st1:place w:st="on"><st1:City w:st="on"><font size=2
face="Courier New"><span style='font-size:10.0pt'>Suva</span></font></st1:City>,
<st1:country-region w:st="on">Fiji</st1:country-region></st1:place><o:p></o:p></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span style='font-size:
10.0pt'>+679 3232233<o:p></o:p></span></font></p>
<p class=MsoPlainText><st1:PersonName w:st="on"><font size=2 face="Courier New"><span
style='font-size:10.0pt'>hammondthrasher_c@usp.ac.fj</span></font></st1:PersonName><o:p></o:p></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span style='font-size:
10.0pt'>-----Original Message-----<br>
From: Chris Cormack [mailto:chris@katipo.co.nz] <br>
Sent: Wednesday, 7 February 2007 2:01 PM<br>
To: Chris Hammond-Thrasher<br>
Cc: koha@lists.katipo.co.nz<br>
Subject: Re: [Koha] Trouble with MySQL, DBI/DBD::mysql</span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span style='font-size:
10.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span style='font-size:
10.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span style='font-size:
10.0pt'>> <o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span style='font-size:
10.0pt'>> In summary, I cannot make mysqld_safe listen at anything other
than <o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span style='font-size:
10.0pt'>> /tmp/mysql.sock and I cannot make perl DBI/DBD::mysql attempt to
connect <o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span style='font-size:
10.0pt'>> anywhere other than /var/run/mysqld/mysqld.sock .<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span style='font-size:
10.0pt'>> <o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span style='font-size:
10.0pt'>> <o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span style='font-size:
10.0pt'>> <o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span style='font-size:
10.0pt'>> Any ideas?<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span style='font-size:
10.0pt'>> <o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span style='font-size:
10.0pt'>Hi Chris<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span style='font-size:
10.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span style='font-size:
10.0pt'>In your /etc/my.cnf is skip-networking set on, if you turn this off you
<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span style='font-size:
10.0pt'>could get mysql listening on the network, and then connect to it with a
<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span style='font-size:
10.0pt'>tcp socket, rather than a unix one.<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span style='font-size:
10.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span style='font-size:
10.0pt'>Chris<o:p></o:p></span></font></p>
</div>
</body>
</html>