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

Documentation review
by Robin Sheat 06 Jan '15

06 Jan '15

I've redone the documentation about the packages. Currently it's untested, that may be a job for tomorrow. However, it'd be good to get a couple more opinions before I publish them. The audience for these is "people who have a reasonable idea of how to get around in Linux", so it's not supposed to be a total newbie guide. I'm aiming for it to have enough information for someone to know what's going on, but not so much that it becomes hard to follow, especially in the "Installation Process" section. The informational bit at the bottom can be wordier. As such, I'm mostly interested to know: * Do the instructions work (though, as I haven't tested them myself yet, I wouldn't be surprised to find an error or three in them), * are there common scenarios that it doesn't account for, and * is there useful/important information that's missing. You can find my new draft here: http://wiki.koha-community.org/wiki/Talk:Koha_on_Debian -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF

3 2

Koha Community Newsletter: December 2014
by kohanews 05 Jan '15

05 Jan '15

Fellow Koha users: The Koha Community Newsletter for December 2014 is here: http://koha-community.org/koha-community-newsletter-december-2014/ Many thanks to the folks who submitted articles and news to this month's newsletter. Please feel free to email us with any corrections or suggestions. Thanks! Chad Roseburg Joanne Dillon Editors, Koha Community Newsletter

1 0

Upgrading the server that runs bugzilla, (and other things)
by Chris Cormack 02 Jan '15

02 Jan '15

Hi all I'm about to upgrade my server which runs bugs.koha-community.org and download.koha-comunity.org (as well as the dashboard and a few other things). So things might disappear for a little bit, ill send another email when it's all done Chris

2 2

Inquiry regarding replication
by Mark Tompsett 02 Jan '15

02 Jan '15

Greetings, I was playing around with MySQL replication recently, and was wondering if anyone actually used it as part of their Koha setup. And if so, what purpose? Why was I playing with it? I was pondering how to handle loss of internet access to a remote host (e.g. Asia undersea cable gets cut and the Philippines is cut off from their hosted data in Amsterdam). Any ideas? GPML, Mark Tompsett

2 1

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 30 Dec '14

30 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