[Koha-devel] Re: [Koha] MySQL 5 fixes - Debian packaging.

[Matthew Metzger]

This is important. I had several days of frustration concerning the 
MySQL5 issue and the koha download website did not mention at all that 
it was dependent upon MySQL4 for proper installation. Thanks to Alex and 
others who helped solve the problems, but more and more people will be 
having these problems if the Koha website does not explicitly 
communicate that Koha needs MySQL4 for the basic install.

-Matthew


Alex King wrote:

 >PPS.  I now think it's even more critical to point out the MySQL 
dependencies
 >clearly and explicitly on the website.  Is it there already, have I 
missed something?
 >I think more and more Linux distros are/will be shipping with MySQL 5 
by default.




> This is going to be a show stopper for getting a Debian package out 
> quickly.
>
> MySQL 5 is the standard server in Debian Etch (testing).  There isn't 
> even a version of the 4 or 3 server available for it as far as I can 
> tell.  So were going to need something that works with 5.
>
> I think the current and future versions of Ubuntu are in the same 
> situation.
>
> I'd like to know from the developers what led to the patches shown in 
> the bug report, ie what problems they were solving, how serious is 
> this?  With just the search queries patched, 2.2.5 appears to work OK 
> (apart from barcodes), although I haven't tested it thoroughly.
>
> So we have two possible roads we could go down for a Debian package - 
> either package 2.2.6 and add whatever patches are needed and test test 
> test, or give up on it and package 3.0
>
> What are people's instincts as to what is likely to be the best way to 
> go?  I don't want to spend a lot of time packaging 2.2.6 just to find 
> I have to abandon it and switch to 3.0 because 2.2.6 can't be made to 
> work with MySQL 5.  On the plus side we can probably gather half a 
> dozen or so testers, and if we know what we're looking for (in terms 
> of where the problems might lie with MySQL 5) we could be effective at 
> flushing out the bugs.
>
> Either way it's looking increasingly unlikely we'll get something in 
> for Etch.
>
> I'm still planning to get something together soon - probably still 
> 2.2.6 unless the consensus is otherwise.
>
>
> Cheers,
>
> Alex
>
> PS. My -devel digests have been hidden away by my mailer & I've only 
> just discovered them, so sorry for my lack of responsiveness!  After I 
> told people to post there too :-/
>
> PPS.  I now think it's even more critical to point out the MySQL 
> dependencies clearly and explicitly on the website.  Is it there 
> already, have I missed something?  I think more and more Linux distros 
> are/will be shipping with MySQL 5 by default.
>
> Mike Dalgity wrote:
>> I originally replied to Ms. Johnson off list but I'll post here for 
>> everyone
>> else following this topic.  I am not a developer but the following is 
>> what
>> I've come across on the subject.
>>
>> According to Bug #1089
>> http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1089 MySQL 5 
>> will NOT
>> be supported in Koha 2.x.  Apparently MySQL 5 introduces more 
>> problems other
>> than reserved keywords.  It's my understanding that the fix isn't as 
>> simple
>> as fixing the keywords and the search problems.  The patch that is 
>> included
>> in that bug report makes a LOT of changes, stats modules, aquistions, 
>> etc.
>> And the authour indicates that there are still additional problems 
>> the patch
>> doesn't fix or even introduces.  The probable reason that MySQL 5 isn't
>> supported is that it's a major undertaking to change everything and then
>> test it. Also the 2.x branch is supposed to be stable so a major 
>> change like
>> this is not recommended. AFAIK you will have to wait for Koha 3.0 to 
>> support
>> MySQL 5 (of course it can be modified to work if you really want it 
>> to). If
>> the developers have changed their plans someone please correct me.
>>
>> Mike D.
>>
>>
>> -----Original Message-----
>> From: koha-bounces at lists.katipo.co.nz
>> [mailto:koha-bounces at lists.katipo.co.nz]On Behalf Of Alex King
>> Sent: September 29, 2006 5:40 PM
>> To: BWS Johnson
>> Cc: koha at lists.katipo.co.nz
>> Subject: Re: [Koha] MySQL 5 fixes
>>
>>
>> It looks like Koha version 2.2.5 was released in January.  Normally, the
>> download for 2.2.5 wouldn't be changed.  I would assume the fixes are in
>> the pipeline for the next version in the series, 2.2.6.
>>
>> So when 2.2.6 is released I would expect it will work nicely with 
>> MySQL5.
>>
>> Perhaps a warning could be put on the download page mentioning the
>> MySQL5 issue.
>>
>> Cheers,
>>
>> Alex
>>
>> BWS Johnson wrote:
>>  
>>> Salvete!
>>>
>>> Is there a reason that the reserved language switch to make Koha play
>>> nice with MySQL 5 hasn't been incorporated into the downloads yet? Am
>>> I missing something?
>>>
>>> Cheers,
>>> Brooke @ Hinsdale MA
>>> ------------------------------------------------------------------------ 
>>>
>>>
>>> _______________________________________________
>>> Koha mailing list
>>> Koha at lists.katipo.co.nz
>>> http://lists.katipo.co.nz/mailman/listinfo/koha
>>>
>>>     
>> _______________________________________________
>> Koha mailing list
>> Koha at lists.katipo.co.nz
>> http://lists.katipo.co.nz/mailman/listinfo/koha
>>
>>
>>   
>
>
> _______________________________________________
> Koha-devel mailing list
> Koha-devel at nongnu.org
> http://lists.nongnu.org/mailman/listinfo/koha-devel