<html>
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 10 (filtered)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        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
        {margin-right:0in;
        margin-left:0in;
        font-size:12.0pt;
        font-family:"Times New Roman";}
pre
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:10.0pt;
        font-family:"Courier New";}
span.EmailStyle17
        {font-family:Arial;
        color:windowtext;}
@page Section1
        {size:8.5in 11.0in;
        margin:1.0in 81.35pt 1.0in 94.3pt;}
div.Section1
        {page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>I just solved a problem which I also saw
in an archived post, and which nobody seems to have posted a fix:</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<pre><font size=2 face="Courier New"><span style='font-size:10.0pt'>>> DBI connect('sefovan:localhost','koha',...) failed: Client does not support </span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>>> authentication protocolrequested by server; consider upgrading MySQL client at </span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>>> C:\usr\koha-2.2.0RC2\modules/C4/Context.pm line 409.</span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'> </span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>This problem arises from the mysql authentication change documented at:</span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'><a
href="http://dev.mysql.com/doc/mysql/en/old-client.html">http://dev.mysql.com/doc/mysql/en/old-client.html</a></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'> </span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>You can overcome the problem by editing line 1808 of Install.pm from:</span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'> </span></font></pre><pre><font
size=2 color=navy face="Courier New"><span style='font-size:10.0pt;color:navy'>print system("$mysqldir/bin/mysql -u$mysqluser -e \"insert into user (Host,User,Password) values</span></font></pre><pre><font
size=2 color=navy face="Courier New"><span style='font-size:10.0pt;color:navy'>('$hostname','$user',password('$pass'))\" mysql\;");</span></font> </pre><pre><font
size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'> </span></font></pre><pre><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'>to: </span></font></pre><pre><font
size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'> </span></font></pre><pre><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'>print system("$mysqldir/bin/mysql -u$mysqluser -e \"insert into user (Host,User,Password) values</span></font></pre><pre><font
size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'>('$hostname','$user',OLD_PASSWORD('$pass'))\" mysql\;");</span></font></pre>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p style='margin-bottom:12.0pt'><font size=2 face="Times New Roman"><span
style='font-size:10.0pt'>Andrew Koebrick</span></font><font size=2><span
style='font-size:10.0pt'><br>
Web Coordinator / Librarian<br>
<br>
Dept. of Administration<br>
State of </span></font><font size=2><span style='font-size:10.0pt'>Minnesota</span></font><font
size=2><span style='font-size:10.0pt'><br>
</span></font><font size=2><span style='font-size:10.0pt'>658 Cedar St</span></font><font
size=2><span style='font-size:10.0pt'>.<br>
</span></font><font size=2><span style='font-size:10.0pt'>St. Paul</span></font><font
size=2><span style='font-size:10.0pt'>, </span></font><font size=2><span
style='font-size:10.0pt'>MN</span></font><font size=2><span style='font-size:
10.0pt'> </span></font><font size=2><span style='font-size:10.0pt'>55155</span></font><font
size=2><span style='font-size:10.0pt'><br>
<br>
651-296-4156<br>
<a href="http://server.admin.state.mn.us">http://server.admin.state.mn.us</a></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> </span></font></p>
</div>
</body>
</html>