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

[Alex King]

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
>
>
>