- Koha-devel - lists.koha-community.org

3.13.2 speed
by Paul A 02 Jan '15

02 Jan '15

Happy New Year to all, Finally got 3.18.2 up and running, LAN only, with a mysql dump from our production server. Lots of customization to get to, but I'm quite startled by the slow speed of searching on the OPAC. Speed: 3.8.5 3.18.2 ================================= Time to search catalogue for 's' <http://opac.navalmarinearchive.com/cgi-bin/koha/opac-search.pl?idx=&q=s> <2 secs 19 secs LAN 3.64 sec n/a http://vertain.com/m.q?req=cstr&reqid=dAx78pvE Time to reload homepage: <1 secs 2 secs LAN 2.75 sec n/a http://vertain.com/m.q?req=cstr&reqid=dAx78pvE Size of HTML file: 71932 chrs 191702 chrs All tests with Firefox, zero cache. The new server should be a bit faster than the production box (Haswell quad-core i7, compared to the older Ivy Bridge) same 16 Gig memory, and near identical SSDs. I've tried with Apache (2.4.7) set to mpm_event as well as mpm_prefork + mpm_itk -- no difference. Staff page searches are equally slow, and other staff pages appear a tad sluggish. Obviously the size of the HTML has increased, but can anyone suggest any avenues I could explore to get things speeded up? Many thanks and again happy new year all around. Paul

1 0

Re: [Koha-devel] 3.18 install [was: koha-common install]
by Paul A 31 Dec '14

31 Dec '14

At 09:07 AM 12/30/2014 +1300, Chris Cormack wrote: [snip] >It is because you decided not to install using the packages, and instead >used the tarball, so none of the package supplied scripts >will be there Yup... I tried four times (twice on a 32-bit sandbox, and twice on a new 64-bit machine due to go into production soon), reinstalling the whole server from scratch each time, and coha-common failed every time. So I went back to my notes from Koha 3.8 and used the tarball for 3.18.2. Do you have a list of the "package supplied scripts" not in the tarball? That would be most useful for me to chase down any final "missing advantages" of 3.18 -- our staff are excited at getting their hands on the "new version." Anyways I'm getting closer. The Zebra failure was that the daemon wasn't running, cured with a: paul@hood:/etc/init.d$ sudo ln -s /usr/share/koha/bin/koha-zebra-ctl.sh koha-zebra-daemon paul@hood:/etc/init.d$ sudo /etc/init.d/koha-zebra-daemon start Starting Zebra Server Bingo! OPAC and Staff now functional.

2 1

Debian repo pocket names changed
by Robin Sheat 30 Dec '14

30 Dec '14

TL;DR you don't need to do anything, this is just a heads up in case you notice that instructions differ from what you remember. I've just changed the names of the repository pockets from 'squeeze' to 'stable', and 'squeeze-dev' to 'unstable'. When I say 'changed', I really mean 'aliased'. So if you fetch from squeeze or stable you get exactly the same thing. In the background they are really still called their original names, but end-users shouldn't have to see that any more. This is because 'squeeze' is a bit confusing when people are installing on Debian wheezy, ubuntu, mint, and so on. oldstable is still oldstable. Now I'm going to start rewriting the package installation instructions, they've accreted over the years and it's time for a bit of summer cleaning. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF

1 0

koha-common install
by Paul A 29 Dec '14

29 Dec '14

Happy Christmas, Happy Holidays all around, Having a look at latest releases of Ubuntu and Koha on a 32-bit 'sandbox' server, newly built with latest 14.04.1 LTS Ubuntu. Koha failed despite major attempts at fulfilling dependencies, including CPAN which cannot find yaz, idzebra nor libnet-z3950-zoom-perl. I started with 130-odd missing files, individually installed all but these, despite adding deb's for koha, and Debian wheezy and squeeze to /etc/apt/sources.list I'm *guessing* that i386 is no longer supported, but couldn't find any mention at koha-community. I should be able to get a 64-bit sandbox after staff leave for the holidays later today and will try again. Here's the gory details: paul@hallowell:/$ lsb_release -a Distributor ID: Ubuntu Description: Ubuntu 14.04.1 LTS Release: 14.04 Codename: trusty paul@hallowell:/$ sudo apt-get install koha-common Reading package lists... Done Building dependency tree Reading state information... Done Some packages could not be installed. This may mean that you have requested an impossible situation or if you are using the unstable distribution that some required packages have not yet been created or been moved out of Incoming. The following information may help resolve the situation: The following packages have unmet dependencies: koha-common : Depends: libnet-z3950-zoom-perl but it is not going to be installed Depends: idzebra-2.0 but it is not going to be installed Depends: yaz but it is not going to be installed E: Unable to correct problems, you have held broken packages. br -- paul

6 8

QueryParser does not manage more than 1 operator?
by Jonathan Druart 29 Dec '14

29 Dec '14

Hello dev, I tried to hack C4::Search to permit to search for a record from its ISBN whatever the form used (10 vs 13, with vs without dash). I have easily done it for the non QP form (~3 lines in C4::Search::buildQuery). It looked easy to do for using the QP too (almost the same ~3 lines in C4::Search::parseQuery). But I think there is a bug somewhere because the PQF query generated by QP is wrong, or I did not use the correct syntax. If I search for nb:foo && nb:bar => OK nb:foo || nb:bar => OK But with a 3rd term: nb:foo && nb:bar && nb:foobar => OK nb:foo && nb:bar || nb:foobar => KO (same as nb:foo && nb:bar && nb:foobar) nb:foo || nb:bar || nb:foobar => KO (same as nb:foo || nb:bar && nb:foobar) Actually the second operator is always replaced with && (AND) I don't know the the bug is come from Koha::QueryParser or OpenILS::QueryParser. Could someone familiar with this code help me giving some tricks? Regards, Jonathan PS: The tests are: is($QParser->target_syntax(' biblioserver', 'au:smith || ti:johnson || au:doe'), '@or @attr 1=1003 @attr 4=6 "smith" @or @attr 1=4 @attr 4=6 "johnson" @attr 1=1003 @attr 4=6 "doe"', 'query with 2 boolean ||'); is($QParser->target_syntax('biblioserver', 'au:smith && ( ti:johnson || au:doe )'), '@and @attr 1=1003 @attr 4=6 "smith" @or @attr 1=4 @attr 4=6 "johnson" @attr 1=1003 @attr 4=6 "doe"', 'query with 2 boolean && + ||'); And the result is: # Failed test 'query with 2 boolean ||' # at /home/koha/src/t/QueryParser.t line 56. # got: '@or @attr 1=1003 @attr 4=6 "smith" @and @attr 1=4 @attr 4=6 "johnson" @attr 1=1003 @attr 4=6 "doe"' # expected: '@or @attr 1=1003 @attr 4=6 "smith" @or @attr 1=4 @attr 4=6 "johnson" @attr 1=1003 @attr 4=6 "doe"' # Failed test 'query with 2 boolean && + ||' # at /home/koha/src/t/QueryParser.t line 59. # got: '@and @attr 1=1003 @attr 4=6 "smith" @and @attr 1=4 @attr 4=6 "johnson" @attr 1=1003 @attr 4=6 "doe"' # expected: '@and @attr 1=1003 @attr 4=6 "smith" @or @attr 1=4 @attr 4=6 "johnson" @attr 1=1003 @attr 4=6 "doe"'

2 1

Re: [Koha-devel] koha-common install
by Paul A 28 Dec '14

28 Dec '14

At 11:58 PM 12/26/2014 +0000, Tomas Cohen Arazi wrote: >We have installed 3.18 using the koha-common package on Ubuntu 14.04 >(amd64) flawlessly. The only caveat I have memory of, was setting mpm_itk >*before* running sudo apt-get install koha-common (because of a mod_itk >package bug, inherited from Debian). Thanks Tomas -- I seem to have got all the dependencies installed -- but 'make test' fails with the following 2 errors. Any ideas? t/Creators.t ........................ 1/16 ERROR in koha-conf.xml -- missing <font type="H">/path/to/font.ttf</font> at /usr/share/koha/koha-3.18.02/blib/PERL_MODULE_DIR/C4/Creators/PDF.pm line 123. ERROR in koha-conf.xml -- missing <font type="H">/path/to/font.ttf</font> at /usr/share/koha/koha-3.18.02/blib/PERL_MODULE_DIR/C4/Creators/PDF.pm line 319. # Failed test 'testing StrWidth() returns correct point width' # at t/Creators.t line 47. # got: '19.344' # expected: '23.044921875' # Failed test 'testing Text() writes to the correct x-value' # at t/Creators.t line 51. # got: '29.344' # expected: '33.044921875' # Looks like you failed 2 tests of 16. t/Creators.t ........................ Dubious, test returned 2 (wstat 512, 0x200) Failed 2/16 subtests /... snip.../ Test Summary Report ------------------- t/Creators.t (Wstat: 512 Tests: 16 Failed: 2) Failed tests: 12, 14 Non-zero exit status: 2 Files=98, Tests=9708, 31 wallclock secs ( 0.57 usr 0.06 sys + 22.15 cusr 1.20 csys = 23.98 CPU) Result: FAIL Failed 1/98 test programs. 2/9708 subtests failed. make: *** [test_dynamic] Error 255 Thanks and best regards -- Paul >regards >To+ > >El Fri Dec 26 2014 at 20:36:30, Paul A >(<<mailto:paul.a@navalmarinearchive.com>paul.a(a)navalmarinearchive.com>) >escribiÃ³: >Hi Mark and Chris, > >Thanks for your input.Â Just tried again on a brand new 64-bit Ubuntu >14.04.1 server, perl 5.18, apache 2.4.6, mysql 5.5, memcached, users/pwds, >etc.Â This will be one of our new production servers, and I was hoping to >upgrade Koha from our current 3.8.5. > >Tried the package first: > >paul@hood:/usr/share/koha$ sudo apt-get install koha-common >/... snip .../ >Errors were encountered while processing: >Â libapache2-mpm-itk >Â apache2-mpm-itk >Â koha-common >E: Sub-process /usr/bin/dpkg returned an error code (1) > >So to get a bit more insight, used the latest tarball: > >paul@hood:/usr/share/koha/koha-3.18.02$ perl ><http://koha_perl_deps.pl>koha_perl_deps.pl -m -u > >Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â >InstalledÂ Â Â Â Â Required >Â Â Â Â Module is >Module >NameÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â >VersionÂ Â Â Â Â Â Version >Required >-------------------------------------------------------------------------------------------- >HTTPD::Bench::ApacheBenchÂ Â Â Â Â Â Â Â Â Â Â 0 >*Â Â Â Â Â Â Â Â 0.73Â Â Â Â Â Â Â Â Â Â No >Module::Bundled::FilesÂ Â Â Â Â Â Â Â Â Â Â Â 0 >*Â Â Â Â Â Â Â Â 0.03Â Â Â Â Â Â Â Â Â Â No >Readonly::XSÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 0 >*Â Â Â Â Â Â Â Â 1.02Â Â Â Â Â Â Â Â Â Â No >Test::DBIx::ClassÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â 0 >*Â Â Â Â Â Â Â Â 0.42Â Â Â Â Â Â Â Â Â Â No >Test::WWW::MechanizeÂ Â Â Â Â Â Â Â Â Â Â Â Â 1.42 >*Â Â Â Â Â Â 1.44Â Â Â Â Â Â Â Â Â Â No > >-------------------------------------------------------------------------------------------- >Total modules reported: 5Â Â Â Â Â Â Â Â Â Â Â * Module is >missing or >requires an upgrade. > >Now confused as to whether these are required or not???Â In any case, perl >Makefile.PL fails: > >Warning: prerequisite HTTPD::Bench::ApacheBench 0.73 not found. >Warning: prerequisite Test::DBIx::Class 0.42 not found. >Warning: prerequisite Test::WWW::Mechanize 1.44 not found. We have 1.42. >Writing Makefile for koha >Unable to open MakeMaker.tmp: Permission denied at >/usr/share/perl/5.18/ExtUtils/MakeMaker.pm line 1030. > > >Have tried (unsuccessfully) some attempts with CPAN, e.g. > >paul@hood:/usr/share/koha$ sudo cpan HTTPD::Bench::ApacheBench >Reading '/home/paul/.cpan/Metadata' >Â Â Database was generated on Fri, 26 Dec 2014 08:53:17 GMT >Running install for module 'HTTPD::Bench::ApacheBench' >Running make for A/AD/ADIRAJ/ApacheBench-0.73.tar.gz >Checksum for >/home/paul/.cpan/sources/authors/id/A/AD/ADIRAJ/ApacheBench-0.73.tar.gz ok > >Â Â CPAN.pm: Building A/AD/ADIRAJ/ApacheBench-0.73.tar.gz > >Checking if your kit is complete... >Looks good >Writing Makefile for HTTPD::Bench::ApacheBench >Writing MYMETA.yml and MYMETA.json >Writing Makefile for HTTPD::Bench::ApacheBench >Writing MYMETA.yml and MYMETA.json >cp lib/HTTPD/Bench/ApacheBench/Regression.pm >blib/lib/HTTPD/Bench/ApacheBench/Regression.pm >cp lib/HTTPD/Bench/ApacheBench/Run.pm blib/lib/HTTPD/Bench/ApacheBench/Run.pm >cp lib/HTTPD/Bench/ApacheBench.pm blib/lib/HTTPD/Bench/ApacheBench.pm >make[1]: Entering directory >`/home/paul/.cpan/build/ApacheBench-0.73-hFvRj7/src' >/usr/bin/perl /usr/share/perl/5.18.2/ExtUtils/xsubppÂ -typemap >/usr/share/perl/5.18/ExtUtils/typemapÂ ApacheBench.xs > ApacheBench.xsc && >mv ApacheBench.xsc ApacheBench.c >cc -cÂ Â -D_REENTRANT -D_GNU_SOURCE -DDEBIAN -fstack-protector >-fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE >-D_FILE_OFFSET_BITS=64 -O2 -gÂ Â -DVERSION=\"0.73\" -DXS_VERSION=\"0.73\" >-fPIC "-I/usr/lib/perl/5.18/CORE"Â Â ApacheBench.c >/bin/sh: 1: cc: not found >make[1]: *** [ApacheBench.o] Error 127 >make[1]: Leaving directory >`/home/paul/.cpan/build/ApacheBench-0.73-hFvRj7/src' >make: *** [subdirs] Error 2 >Â Â ADIRAJ/ApacheBench-0.73.tar.gz >Â Â make -- NOT OK >Running make test >Â Â Can't test without successful make >Running make install >Â Â Make had returned bad status, install seems impossible > >Any thoughts, pointers? > >Thanks and br -- Paul > >P.S. Mark: the additional repositories are in sources.list.d/koha.list, etc >-- not in the main file. > > >At 11:58 PM 12/24/2014 -0500, Mark Tompsett wrote: > >Greetings, > > > >I figured I had not done a 32-bit install in a while, so I grabbed the > >Ubuntu 14.04.1 LTS ISO. > >I installed it in VirtualBox OpenSSH, LAMP, and Mail Server selected (even > >though I probably could have gone with nothing). > >I then followed the instructions > ><<http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages>http://wi > ki.koha-community.org/wiki/Koha_on_ubuntu_-_packages>http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages > >Now, I was expecting some apache2 issues to crop up, but strangely I had > >no problems whatsoever running: > >sudo apt-get install koha-common > > > >You should NEVER tinker with /etc/apt/sources.list, when you SHOULD ADD > >/etc/apt/sources.list.d/NEWFILE.list and sudo apt-get update. > > > >GPML, > >Mark Tompsett > > > > > >From: <mailto:chris.nighswonger@gmail.com>Christopher Nighswonger > >Sent: Wednesday, December 24, 2014 8:28 PM > >To: <mailto:paul.a@navalmarinearchive.com>Paul A > >Cc: <mailto:koha-devel@lists.koha-community.org>Koha Devel > >Subject: Re: [Koha-devel] koha-common install > > > > > >Something is broken with one of the dependencies of yaz on the latest LTS. > >I ran into this the other day on my Dev box. Haven't had time to chase it > >down yet. > > > >Kind Regards > > > >Chris > >On Dec 24, 2014 4:33 PM, "Paul A" > ><<mailto:paul.a@navalmarinearchive.com><mailto:paul.a@navalmarinearchive. > com>paul.a(a)navalmarinearchive.com> wrote: > >Happy Christmas, Happy Holidays all around, > > > >Having a look at latest releases of Ubuntu and Koha on a 32-bit 'sandbox' > >server, newly built with latest 14.04.1 LTS Ubuntu. Koha failed despite > >major attempts at fulfilling dependencies, including CPAN which cannot > >find yaz, idzebra nor libnet-z3950-zoom-perl. I started with 130-odd > >missing files, individually installed all but these, despite adding deb's > >for koha, and Debian wheezy and squeeze to /etc/apt/sources.list > > > >I'm *guessing* that i386 is no longer supported, but couldn't find any > >mention at koha-community. I should be able to get a 64-bit sandbox after > >staff leave for the holidays later today and will try again. Here's the > >gory details: > > > >paul@hallowell:/$ lsb_release -a > >Distributor ID: Ubuntu > >Description:Â Â Ubuntu 14.04.1 LTS > >Release:Â Â Â Â 14.04 > >Codename:Â Â Â Â trusty > > > >paul@hallowell:/$ sudo apt-get install koha-common > >Reading package lists... Done > >Building dependency tree > >Reading state information... Done > >Some packages could not be installed. This may mean that you have > >requested an impossible situation or if you are using the unstable > >distribution that some required packages have not yet been created > >or been moved out of Incoming. > >The following information may help resolve the situation: > > > >The following packages have unmet dependencies: > >koha-common : Depends: libnet-z3950-zoom-perl but it is not going to be > >installed > >Â Â Â Â Â Â Â Â Depends: idzebra-2.0 but it is not going to be > installed > >Â Â Â Â Â Â Â Â Depends: yaz but it is not going to be installed > >E: Unable to correct problems, you have held broken packages. > > > >br -- paul > > > > > >_______________________________________________ > >Koha-devel mailing list > ><mailto:Koha-devel@lists.koha-community.org><mailto:Koha-devel@lists.koha > -community.org>Koha-devel(a)lists.koha-community.org > >http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel > >website : > <<http://www.koha-community.org/>http://www.koha-community.org/>http://www.koha-community.org/ > >git : > <<http://git.koha-community.org/>http://git.koha-community.org/>http://git.koha-community.org/ > >bugs : > <<http://bugs.koha-community.org/>http://bugs.koha-community.org/>http://bugs.koha-community.org/ > > > > > >---------- > >_______________________________________________ > >Koha-devel mailing list > ><mailto:Koha-devel@lists.koha-community.org>Koha-devel(a)lists.koha-communi > ty.org > >http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel > >website : <http://www.koha-community.org/>http://www.koha-community.org/ > >git : <http://git.koha-community.org/>http://git.koha-community.org/ > >bugs : <http://bugs.koha-community.org/>http://bugs.koha-community.org/ > >--- >Maritime heritage and history, preservation and conservation, >research and education through the written word and the arts. ><<http://NavalMarineArchive.com>http://NavalMarineArchive.com> and ><<http://UltraMarine.ca>http://UltraMarine.ca> > >_______________________________________________ >Koha-devel mailing list ><mailto:Koha-devel@lists.koha-community.org>Koha-devel(a)lists.koha-community.org >http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel >website : <http://www.koha-community.org/>http://www.koha-community.org/ >git : <http://git.koha-community.org/>http://git.koha-community.org/ >bugs : <http://bugs.koha-community.org/>http://bugs.koha-community.org/

2 1

Koha 3.16.6 released
by Mason James 24 Dec '14

24 Dec '14

The Koha release team are proud to announce the release of Koha 3.16.6. This is a maintenance release, but contains one security fix. Everyone running 3.16.x is strongly recommended to upgraded. As always you can download the release from http://download.koha-community.org. Release notes at http://koha-community.org/koha-3-16-6-release/ cheers, Mason

1 0

Koha 3.18.2 released
by Chris Cormack 22 Dec '14

22 Dec '14

The Koha release team are proud to announce the release of Koha 3.18.2 this is a maintenance release but contains one security fix. Everyone running 3.18.x is strongly recommended to upgraded. http://koha-community.org/koha-3-18-2-release/ Chris

1 0

koha 3.14.12 released
by Fridolin SOMERS 22 Dec '14

22 Dec '14

The Koha community is proud to announce the release of 3.14.12. This is a maintenance release and contains several bugfixes. As always you can download the release from http://download.koha-community.org. Have a look at release post : http://koha-community.org/koha-3-14-12-released "Get the pie while it's hot" and Merry XMas ! Regards, -- Fridolin SOMERS Biblibre - Pôles support et système fridolin.somers(a)biblibre.com

1 0

Discussion needed regarding holds circ rules.
by Barton 18 Dec '14

18 Dec '14

Hi, I wanted to bring up an issue that's been kicked around a fair amount on Bugzilla, and has not, as far as I can tell, received as much attention in terms of design as I believe it deserves: The interaction between holds (aka reserves) and circulation rules is broken: see * bug 10314 : CanItemBeReserved does not respect the holds policies. * bug 4850: CheckReserves does not respect holds circulation policies * bug 4045: No check for maximum number of allowed holds from OPAC [This was pushed to Master, but is only a partial fix]. I think that there are two things that are really at the heart of each of these issues: 1) We're using the system preference 'ReservesControlBranch' to determine which set of Circulation rules should apply. The choices are "Item's Home Branch" or "Patron's Home Branch". The problem is that we're essentially saying "You have the choice of which set of Hold Rules you want to ignore". Unfortunately, these are not mutually exclusive: There's no way of saying "Choose the strictest set of hold limits" 2) Circulation rules apply to items, but Holds are biblio level objects. We make the decision about whether a hold may be filled on a bib record based on whether any of the items may fill the hold, bu t we're un-critical about the limits of that statement. If we say that a hold on a bib record may be filled, are we sure that we're re-checking to make sure that each item attached to the bib is holdable when we look again at the item level? I'm sorry if I'm asking a frequently asked question here; I tried to do my due diligence with Google, and got a fire hose full of "not quite what I meant" :-) Cheers, --Barton

1 0