Hey Stephen, Thanks for the help...I had tried 3 different MySQL's and this last one was the one. The Koha for Windows documentation author need to specifically state what version to use. Have you heard anything about the Z3950 issue for Windows XP? Thanks a bunch. Stephon ----- Original Message ----- From: "Stephen Hedges" <shedges@skemotah.com> To: "Stephon E. McCray" <smccray@westernacademycharter.com> Cc: "koha" <koha@lists.katipo.co.nz> Sent: Thursday, December 08, 2005 12:38 PM Subject: Re: [Koha] Help please
yep, that's the old-password/new-password problem.
Since you seem to have control over what version of MySQL runs on this machine, why not grab a Windows zip file of version 4.0.26 from http://downloads.mysql.com/archives.php?p=mysql-4.0&v=4.0.26
Stephen
Stephon E. McCray said:
The Error Message reads like this: [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----- Original Message ----- From: "Stephen Hedges" <shedges@skemotah.com> To: "Stephon E. McCray" <smccray@westernacademycharter.com> Cc: "koha" <koha@lists.katipo.co.nz> Sent: Wednesday, December 07, 2005 6:12 PM Subject: Re: [Koha] Help please
Did you start the mysql daemon with the "--old-passwords" option? Can you send us the complete error message as it now reads?
Stephen
Stephon E. McCray said:
I uninstalled everything and reinstalled KOHA with MYSQL 4.1 over again and I still get an error message when I try to access 'OPAC'. It says "Premature end of script headers: opac-main.pl"
Can You please help?
Stephon ----- Original Message ----- From: "Stephen Hedges" <shedges@skemotah.com> To: "Stephon McCray" <smccray@westernacademycharter.com> Cc: "koha" <koha@lists.katipo.co.nz> Sent: Monday, December 05, 2005 12:22 PM Subject: Re: [Koha] Help please
Actually, MySQL 5.0 has another problem when used with Koha -- Koha has a data column named "return" but this is a MySQL reserved word starting with version 5.0. (Didn't your Koha install program throw errors when it tried to create the database?) If you must use MySQL 5.0, I don't think you can use Koha. Maybe someone else knows a trick that I don't know...
Stephen
Stephon McCray said:
MySQL server is running on the same machine that I'm trying to get KOHA to run on...is KOHA not going to run on MySQL 5.0? Do I need to install some other program in order for it to work? Thanks, Stephon McCray
>-----Original Message----- >From: Stephen Hedges [mailto:shedges@skemotah.com] >Sent: Wednesday, November 30, 2005 01:08 PM >To: 'Stephon McCray' >Cc: 'koha' >Subject: Re: [Koha] Help please > >Here's the official word from MySQL: > >"MySQL 5.0 uses an authentication protocol based on a password > hashing >algorithm that is incompatible with that used by older (pre-4.1) > clients. >If you upgrade the server from 4.1, attempts to connect to it with an >older client may fail with the following message: > >shell> mysql >Client does not support authentication protocol requested >by server; consider upgrading MySQL client > >To solve this problem, you should use one of the following > approaches: > > * Upgrade all client programs to use a 4.1.1 or newer client > library. > * When connecting to the server with a pre-4.1 client program, use > an >account that still has a pre-4.1-style password. > * Reset the password to pre-4.1 style for each user that needs to > use >a pre-4.1 client program. This can be done using the SET PASSWORD >statement and the OLD_PASSWORD() function: > >mysql> SET PASSWORD FOR > -> 'some_user'@'some_host' = OLD_PASSWORD('newpwd'); > > Alternatively, use UPDATE and FLUSH PRIVILEGES: > >mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd') > -> WHERE Host = 'some_host' AND User = 'some_user'; >mysql> FLUSH PRIVILEGES; > > Substitute the password you want to use for "newpwd" in the >preceding examples. MySQL cannot tell you what the original password >was, so you'll need to pick a new one. > * Tell the server to use the older password hashing algorithm: > 1. Start mysqld with the --old-passwords option. > 2. Assign an old-format password to each account that has had its >password updated to the longer 4.1 format. You can identify these >accounts with the following query: > >mysql> SELECT Host, User, Password FROM mysql.user > -> WHERE LENGTH(Password) > 16; > > For each account record displayed by the query, use the Host >and User values and assign a password using the OLD_PASSWORD() >function and either SET PASSWORD or UPDATE, as described >earlier." > >HTH. > >Stephen > >Stephon McCray said: >> 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 >> 411Thanks,Stephon McCrayIT DirectorWestern Academy Charter School >> _______________________________________________
-- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges@skemotah.com
-- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges@skemotah.com
-- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges@skemotah.com