[Koha] Koha 2.2.0RC2 and MySQL 4.1.7 authentication problem

[Andrew Koebrick]

I just solved a problem which I also saw in an archived post, and which
nobody seems to have posted a fix:

 

>> DBI connect('sefovan:localhost','koha',...) failed: Client does not
support 
>> authentication protocolrequested by server; consider upgrading MySQL
client at 
>> C:\usr\koha-2.2.0RC2\modules/C4/Context.pm line 409.
 
This problem arises from the mysql authentication change documented at:
http://dev.mysql.com/doc/mysql/en/old-client.html
 
You can overcome the problem by editing line 1808 of Install.pm from:
 
print system("$mysqldir/bin/mysql -u$mysqluser -e \"insert into user
(Host,User,Password) values
('$hostname','$user',password('$pass'))\" mysql\;"); 
 
to:  
 
print system("$mysqldir/bin/mysql -u$mysqluser -e \"insert into user
(Host,User,Password) values
('$hostname','$user',OLD_PASSWORD('$pass'))\" mysql\;");

 

Andrew Koebrick
Web Coordinator / Librarian

Dept. of Administration
State of Minnesota
658 Cedar St.
St. Paul, MN 55155

651-296-4156
http://server.admin.state.mn.us

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20050223/a1467e72/attachment-0001.html