[Koha] Help please

[Rob Weir]

MySQL 4.1 and 5 use a different password hashing algorithm than earlier versions. I think so far all the Koha installs have used MySQL 4.0.x or earlier. I'm not sure of the best way to fix it. If I get a chance, I'll do some testing over the next couple days. 

For now, here a a couple links that suggest some fixes. Or maybe someone else on the list has a fix. I also want to see if upgrading the version of DBD-Mysql and DBI modules that we use might fix the problem.

See links:
http://dev.mysql.com/doc/refman/5.0/en/old-client.html
http://www.digitalpeer.com/id/mysql
http://www.fogcreek.com/FogBugz/KB/errors/MySQLClientdoesnotsupport.html

Rob

>  -------Original Message-------
>  From: Stephon McCray <smccray at westernacademycharter.com>
>  Subject: [Koha] Help please
>  Sent: 30 Nov '05 14:38
>  
>  Could someone please help me to understand what's going on and how I can
>  fix it.
>  
>  
>  Running a XP professional SP2 machine with MySQL 5 and Apache 2.0.55 and
>  the latest version of Active Perl.
>  
>  [Tue Nov 29 17:41:58 2005] [error] [client 127.0.0.1] Premature end of
>  script headers: mainpage.pl [Tue Nov 29 17:41:58 2005] [error] [client
>  127.0.0.1] DBI connect('blank224:localhost','koha',...) failed: Client
>  does not support authentication protocol requested by server; consider
>  upgrading MySQL client at c:/usr/koha224/intranet/modules/C4/Context.pm
>  line 411 [Tue Nov 29 17:41:58 2005] [error] [client 127.0.0.1] Can't call
>  method "prepare" on an undefined value at
>  c:/usr/koha224/intranet/modules/C4/Koha.pm line 326.
>  
>  Also:
>  
>  [Tue Nov 29 17:41:41 2005] [error] [client 127.0.0.1] Premature end of
>  script headers: opac-main.pl [Tue Nov 29 17:41:41 2005] [error] [client
>  127.0.0.1] DBI connect('blank224:localhost','koha',...) failed: Client
>  does not support authentication protocol requested by server; consider
>  upgrading MySQL client at c:/usr/koha224/intranet/modules/C4/Context.pm
>  line 411
>  
>  
>  Thanks,
>  
>  
>  Stephon McCray
>  
>  IT Director
>  
>  Western Academy Charter School
>  
>  
>  --------------------
>  _______________________________________________
>  Koha mailing list
>  [LINK: compose.php?to=Koha at lists.katipo.co.nz] Koha at lists.katipo.co.nz
>  [LINK: http://lists.katipo.co.nz/mailman/listinfo/koha]
>  http://lists.katipo.co.nz/mailman/listinfo/koha