Time  Nick            Message
03:16 reza            Hello, I have a problem with opac search. It's incredibly slow! i have 8gb of memory with 8 core. 148,133 biblioitems and running on Debian package Koha version 3.2204000. 45,097 borrowers.
03:17 reza            yaz client search result:
03:18 reza            Z> f linux
03:18 reza            Sent searchRequest.
03:18 reza            Received SearchResponse.
03:18 reza            Search was a success.
03:18 reza            Number of hits: 235, setno 3
03:18 reza            SearchResult-1: term=linux cnt=235
03:18 reza            records returned: 0
03:18 reza            Elapsed: 0.000647
03:19 reza            but when I use the opac to search it may take 40 seconds to show the results. Do you know what is the problem??
03:20 reza            My uname: Linux lib 3.19.0-64-generic #72~14.04.1-Ubuntu SMP Fri Jun 24 17:59:48 UTC 2016 x86_64 x86_64 x86_64 GNU/Linux
03:23 wizzyrea        reza do you have local book covers?
03:23 wizzyrea        and what version of Koha?
03:24 reza            Koha version 3.2204000
03:24 reza            no. I'm using amazon
03:24 wizzyrea        ah yeah, you'll want to do the minor upgrades
03:24 wizzyrea        and make sure that local covers are turned off if you're not using them
03:24 reza            can I do it without downtime?
03:24 reza            I mean the minor upgrade
03:25 wizzyrea        it'd be pretty short downtime
03:25 reza            ah OK.
03:25 reza            thank you
03:25 reza            ;)
03:25 wizzyrea        the packages will upgrade the schema, something like, generously, 10 minutes.
03:25 wizzyrea        very generously.
03:26 reza            yeah. I have to wait till library is closed :/
03:26 wizzyrea        as you do :)
03:26 * wizzyrea      knows all about it
03:26 reza            :) thanks man
03:26 wizzyrea        no worries
03:27 wizzyrea        be careful when you do the upgrades, make sure your repo is set to oldstable, otherwise you'll do a full version upgrade!
03:27 wizzyrea        and I don't think you want that :)
03:27 reza            is oldstable in configuration?
03:27 wizzyrea        it'll be in your apt confi
03:27 wizzyrea        config
03:28 wizzyrea        wherever you put in the koha apt sources
03:28 wizzyrea        assuming you run from packages
03:28 reza            yes. I am using package
03:28 wizzyrea        some people put them in /etc/apt/sources.list
03:28 wizzyrea        others in /etc/apt/sources.list.d/koha.list
03:29 reza            oh, mine is in koha.list
03:29 wizzyrea        so where it says "stable" change it to "oldstable"
03:29 reza            critical point :D
03:29 wizzyrea        and that will pull from the 3.22 seris
03:29 wizzyrea        series*
03:30 reza            deb http://debian.koha-community.org/koha oldstable main
03:30 reza            looks good?
03:30 wizzyrea        yep
03:30 reza            great. thank you
03:31 wizzyrea        note that when a new major version is released, oldstable becomes the next version up
03:31 wizzyrea        so in november, that will change to 16.05
03:32 reza            yeah. I see that 16 is out
03:32 reza            so Nov is the next stable release
03:32 wizzyrea        and stable becomes 16.11 and so on
03:32 reza            cool
03:33 reza            I'm trying to move the Koha to amazon web service
03:34 reza            do you know where is the zebra indexing db folder?
03:38 wizzyrea        i *think* /var/spool/koha but I might be wrong
03:39 reza            thanks wizzyrea ;)
05:01 drojf           morning #koha
05:02 dcook           yo drojf
05:03 drojf           hi dcook
05:12 * dcook         waves to cait
05:44 * cait          waves
06:29 reza            I'm trying to minor upgrade my koha from 3.2204 to the latest 3.22xx with apt-get install --only-upgrade koha-common
06:30 reza            but it's downloading 63mb of file
06:30 reza            am I doing something wrong?
06:39 drojf           that sounds like the size of the file
06:42 drojf           koha-common_3.22.09_all.deb 02-Aug-2016 11:56   60M
06:43 drojf           also, why do you not want to upgrade your whole system?
06:49 morgane         hi #koha !
07:14 gaetan_B        hello
07:14 wahanui         bidet, gaetan_B
07:35 sameeenz        Evening all
07:37 * cait          waves
07:43 drojf           hi cait
07:43 * sameeenz      waves back
07:43 eythian         hi
07:43 wahanui         hello, eythian
08:23 LibraryClaire   morning #koha
08:24 drojf           guten morgen LibraryClaire
08:24 cait            morning LibraryClaire
08:24 cait            mornign drojf :)
08:24 LibraryClaire   hi drojf!
08:24 LibraryClaire   hi cait!
08:24 drojf           hi cait. i said hi earlier :)
08:24 drojf           must. migrate. data.
08:25 drojf           but i want to play with packages
08:25 cait            sorry... another chaos day
08:25 drojf           if i had to do packaging, i would want to migrate data
08:25 drojf           cait: why chaos?
08:27 cait            ah... just like every nrmal day
08:29 drojf           i see :)
08:29 LibraryClaire   :)
08:29 eythian         hi LibraryClaire, drojf, cait
08:30 drojf           hi eythian
08:30 LibraryClaire   hi eythian
09:05 vfernandes      hi #koha
09:06 vfernandes      I need some help
09:07 vfernandes      after many debug and installing koha 3.22 in Debian and in Ubuntu to test, Koha 3.22 has a poor performance comparing to Koha 3.20 and I don't know why
09:08 vfernandes      for example: OPAC search with 20 results -> 20 opac-image.pl scripts
09:09 vfernandes      koha 3.20 -> 0.3ms each opac-image.pl script
09:09 vfernandes      koha 3.22 -> 2/3s each opac-image.pl script
09:09 vfernandes      why such difference between these versions?
09:13 vfernandes      a simple SQL query to get a systempreference is more slow in Koha 3.22
09:15 cait            vfernandes: are you using plack? caching?
09:15 cait            i thin opac-image had some problem, but I don't remember what it was
09:15 cait            Joubu: maybe you know?
09:16 vfernandes      cait: i'm not using plack
09:18 vfernandes      cait: besides opac-image having a problem other scripts are taking more time in Koha 3.22
09:19 cait            yes
09:19 cait            3.22 without caching and plack is slower
09:19 cait            benchmarks?
09:20 cait            Joubu, tcohen or someone else will be better to talk to about this
09:20 cait            https://wiki.koha-community.org/wiki/Benchmark_for_3.22
09:20 cait            are you using the latest version of 3.22?
09:20 vfernandes      cait: i'm using Cache::Memory and cache on Apache
09:20 vfernandes      3.22.6
09:20 cait            yeah, that's a different thing
09:20 cait            koha's caching
09:21 cait            you should probably try to update to the most recent
09:21 cait            there has been work on improving speed
09:21 cait            3.22.9 - so yours is 3 months old already again
09:21 vfernandes      I can update on installation
09:22 vfernandes      *one installation
09:22 vfernandes      but I don't think is that
09:22 vfernandes      How I can activate Koha cache?
09:22 cait            sorry, wrong person to talk to
09:23 cait            it's quiet in here today - maybe try again a bit later
09:24 cait            but they will probably tell you to use the latest 3.22.x as a start -  there have been security fixes and speed improvement stuff i am quite sure
09:28 vfernandes      ok... I will update from koha 3.22.6 to koha 3.22.9
09:43 vfernandes      updating didn't solve the problem
10:01 cait            are specific pages apart from covers slow?
10:03 vfernandes      yes... specially when called from another .pl
10:04 vfernandes      http://catalogo2.biblioteca.iscte-iul.pt/cgi-bin/koha/opac-lastdocuments.pl -> 1.7s
10:04 vfernandes      the same paged called from opac-search.pl HTML -> 3/4s
10:05 cait            hm is that a custom page?
10:05 vfernandes      yes
10:06 vfernandes      but the code is very simple... only reads a file from the filesystem and builds the HTML
10:07 vfernandes      http://catalogo2.biblioteca.iscte-iul.pt/cgi-bin/koha/opac-image.pl?thumbnail=1&biblionumber=74781 -> 0.5s
10:07 vfernandes      the same paged called from opac-search.pl HTML -> +- 3s
10:07 vfernandes      these differences are huge
10:08 cait            sorry, no idea
10:09 vfernandes      thanks anyway cait :)
10:09 vfernandes      i don't even know what's causing the problem: Apache, MySQL, Koha, Perl... :/
11:37 marcelr         hi #koha
11:37 LibraryClaire   hi marcelr :)
11:37 marcelr         :)
13:09 vfernandes      plack is giving the following error: Response needs to be 3 element array, or 2 element in streaming at /usr/local/share/perl/5.22.1/Plack/Middleware/Lint.pm line 112
13:33 oleonard        Hi all
13:35 * cait          waves
13:45 LibraryClaire   hi oleonard
14:07 vfernandes      plack works on Ubuntu Server 16.04?
14:08 tubaclarinet    Good morn everyone. we got blacklisted by hotmail & now i'm trying to create a spf record on our domain.
14:08 tubaclarinet    can anyone help me with this?
14:10 drojf           is there a law against line breaks in bibliographic records? because there should be
14:12 drojf           tubaclarinet: that does not sound like a koha problem
14:15 cait            drojf: probably not...
14:15 tubaclarinet    drojf: our instance of koha is hosted by BWS & I need to convince hotmail that mail sent from BWS server is from us
14:17 drojf           do BWS know? that sounds like a problem that not only you will have then
14:17 cait            hm i think i know what it is
14:17 cait            different domain thing?
14:17 tubaclarinet    cait: do tell
14:18 cait            mail servers don't like it when your from/sender e-mail is a different domain than the mail server... something like that
14:19 cait            ashimema has put some notes ont he wiki https://wiki.koha-community.org/wiki/MRenvoize/Email
14:19 cait            it's the main reason you can now specify a different reply-to and return-path address in koha
14:19 tubaclarinet    yes, we have a domain (basinlibraries.org) which is diff than BWS' domain
14:21 tubaclarinet    I spoke with a colleague at a lib which was also blacklisted by hotmail and creating a spf record was 1 of the step to remedy problem
14:26 tubaclarinet    drojf: i submitted support ticket to BWS, but haven't heard back from them yet
14:26 cait            i think either that - or changing your branchemail to be from the domain you send from and use the other email fields like reply-to for the library's address
14:26 cait            that's how we do it
14:27 cait            we have a noreply@... that is the 'branchemail' and kohaadmin... and a return-path and only reply to is from the library
14:27 tubaclarinet    cait: thank you, yes i changed the branch email add and koha admin email add this morn
14:28 cait            i think return-path is also a critical one
14:28 cait            if you don't want to end up in spam
14:29 tubaclarinet    i'm tweaking the branch records now...
14:30 cait            there are matching prefs too - for the e-mais not sent from the branch email address
14:33 tubaclarinet    cait and drojf: I think that i have changed all applicable email adds in koha appropriately- thanks
14:34 tubaclarinet    but i still need to set up a spf record on our domain :-(
14:35 drojf           that seems like something google would know how to do
14:36 drojf           so when i add a patron, the save button is now floating on top, but when i set the permissions, it is at the bottom? hmm
14:37 tubaclarinet    drojf: thanks :-)
14:43 archer121       hi,
14:44 vfernandes      can anyone help me starting plack on Ubuntu?
14:46 archer121       We are asked to make our OPAC available publicly over the internet. Due to security reasons, it was decided to set up a separate koha server for this purpose. We are planning to give this koha instance readonly access to the main koha database. What go you guys think about this? Is there a better/safer way to do this?
14:47 oleonard        What security problems do you think you'll have archer121?
14:47 oleonard        Our OPAC has always been public.
14:48 archer121       I really don't know. I am a student admin and my professor suggests that we do it like this.
14:48 archer121       Maybe he is not very keen to make the koha system public.
14:48 oleonard        archer121: Making your OPAC read-only will prevent the creation of lists, holds, patron modification requests, patron self-registration, etc.
14:50 archer121       And we don't want anyone from outside the intranet to use these facilities.
14:52 oleonard        archer121: You could require that users of the OPAC log in before they can use it.
14:53 * kidclamp      waves
14:53 LibraryClaire   hi kidclamp
14:53 kidclamp        Hi LibraryClaire
14:53 LibraryClaire   :)
14:54 archer121       We just set up koha. currently we have just setup the username and password to be the same. We plan to roll out user login and those advanced features only in a later stage.
14:57 oleonard        archer121: If you're talking about limiting the OPAC to an intranet, it seems like you could do something with your Apache setup to accomplish that without creating a separate Koha server
14:58 oleonard        archer121: I don't know how to advise you on that, but I do think worrying about the OPAC being a security risk is not necessary.
15:00 kidclamp        hiya nengard
15:00 nengard         hola all
15:00 oleonard        Hi nengard!
15:00 nengard         kidclamp, i got it working on my irc client
15:00 nengard         it was a space .....
15:00 kidclamp        huzzah!
15:00 nengard         DUH
15:00 kidclamp        hah!
15:00 nengard         now I can be in here all day :) hehe
15:00 nengard         hiya oleonard
15:00 nengard         how's things?
15:01 nengard         my new team isn't as big on IRC and I miss chatting with folks every day
15:01 oleonard        Everything has fallen apart without you nengard. Just look at this place.
15:01 nengard         LOL
15:01 * oleonard      indicates the devastation all around.
15:01 nengard         I'm so sorry - but I'm not gone!! I'm still here
15:01 nengard         I told my team I'm gonna keep working on Koha documentation
15:01 nengard         I couldn't leave you all - you're my family
15:03 nengard         uh oh i scared jessem away
15:03 oleonard        He crashed his IRC client by pasting too many heart emojis at once.
15:06 archer121       oleonard: Alright, thanks!
15:10 archer121       I already have a running ubuntu 14.04 machine with apache installed and running. Is it okey to install koha on this system? I am asking this because the instructions in koha wiki is to install ubuntu server and then not install apache/mysql before isntalling koha.
15:10 nengard         jessem
15:10 nengard         peek a boo
15:11 nengard         tgoat just saying :p
15:11 JesseM          hiya nengard
15:12 nengard         :)
15:19 amyk            hi nengard!
15:20 drojf           archer121: koha uses libapache2-mpm-itk to allow multiple instances. if you are using a different apache engine, that will probably lead to problems
15:21 drojf           so you should check what is installed now
15:23 archer121       drojf: I don't see that package listed in dpkg -l. But I see this: apache2-mpm-prefork
15:23 nengard         hi amyk
15:23 amyk            how ya doing nengard?
15:24 drojf           archer121: those are not compatible. if you install koha, it will deinstall that package
15:24 drojf           so you would have to setup a new apachje config for the existing site
15:25 archer121       I see. Thanks for the hint.
15:26 morgane         bye #koha
15:35 nengard         amyk i'm doing awesome!!
15:36 amyk            i am so happy to hear it! :)
15:53 archer121       oleonard: Is there a system preference that will completely disable OPAC login?
15:53 archer121       If so it would be okey to make the koha system public.
15:53 oleonard        archer121: Yes, it's called  opacuserlogin
15:58 nengard         rocio!!!!!
15:59 rocio           nengard!!!!!!!!!!
15:59 wahanui         somebody said nengard was the queen of documentation.
15:59 nengard         LOL
15:59 rocio           :-)
15:59 rocio           yaaay!!
16:00 kidclamp        oleonard: do you think we could make the dropdown for search only show if you click the arrow and have the 'Search' link still go directly to the Adv. Search page?
16:00 nengard         rocio, you are so cute :) hehe
16:00 nengard         rocio did you see my new fluffy baby?
16:00 cait            i like that idea
16:00 rocio           YOU are!! I miss you!!
16:00 nengard         I miss you too
16:00 rocio           YES!!! she's beautiful!!! sweet Ariel!!
16:00 cait            a new dog?
16:00 nengard         For others: https://www.flickr.com/photos/nengard
16:01 nengard         yes cait
16:01 rocio           I saw the pic of the pups on your bed, taking over the whole thing lol
16:01 nengard         Coda passed in April and Beau was lonely
16:01 cait            bailey looks all grown up too
16:01 nengard         The poms in those pics are not mine hehe
16:01 nengard         and he is!! He grew so fast
16:01 rocio           and there's Bailey in a sink! I love it when cats do that
16:02 rocio           was about to ask you about the poms!
16:02 oleonard        kidclamp: Seems like it should be possible since you can do it with buttons (split buttons)
16:03 nengard         rocio those are my friend (at Red Hat) Gina's poms and they were so happy to see me that they climbed all over me
16:03 nengard         it was so much fun
16:03 rocio           oh that is precious!
16:03 nengard         after a week away from my babies I needed the puppy love
16:03 rocio           definitely. there's nothing like it
16:03 kidclamp        oleonard: would you agree with the change is what I should have asked :-)
16:04 oleonard        Yes I would agree with that change if it was clear visually that the menu worked differently than the "More" one.
16:05 kidclamp        thanks
16:53 archer121       hi
16:55 archer121       I ama trying to set up a second koha server with readonly database access to the main koha server on a Ubuntu 14.04 system. So I did the create-db, created the table and user on the main server, ran populate-db, but I get this error message when I try to access the koha website: http://paste.ubuntu.com/23065160/
16:55 archer121       am*
16:56 archer121       would someone please help me out with this?
16:57 kidclamp        do you get the installer if you access via the intranet archer121?
16:57 archer121       nope, I get the error when I do that
16:58 kidclamp        not sure off top of my head, anything in the koha logs?
16:59 archer121       /var/log/koha/koha_nitc/intranet-error.log has nothing
16:59 archer121       is there some other place I need to be looking?
17:13 oleonard        archer121: It looks like you're hitting the OPAC, not the staff client.
17:13 oleonard        If you're setting up a new instance, you have to run the web installer via the staff client
17:20 archer121       oleonard: Should I be setting up a new instance? What I am trying to do is to create a readonly mirror of the koha server.
17:21 oleonard        Sorry I don't know anything about that archer121
17:23 archer121       Thanks for trying to help, oleonard.
17:30 kidclamp        brb
18:04 huginn          New commit(s) kohagit: Bug 14844: Corrupted storable string. When adding/editing an Item, cookie LastCreated... <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=9237fe676336f5908a9acc26a3b70b70d25602ae> / Bug 17103 - Google API Loader jsapi called over http <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=6fcd32a75c41c7815a883cc4952899ea24045b3c> / Bug 17084 - Automatic debian/control updates (master) <http://git.k
18:14 huginn          New commit(s) kohagit: Bug 16829 - DBRev <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=0caed05779b886229d2a02c168bdb38453c67bb4> / Bug 16829: Unit tests for logaction's 'interface parameter' <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=3a7aaf1339247689405e769349faaca6fe359950> / Bug 16829: DBIx update <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=25cdf478958b4fd6c0e6d2510dce49
18:44 huginn          New commit(s) kohagit: Bug 14642 - DBRev <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=090c0fc6c49e448b1ee506808e5f157c4ba88414> / Bug 14642: Make sure the log will be written only if the hold has been deleted <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=b4a08cad608b8b8aebfebd5a6e058554a7b4bf59> / Bug 14642: (QA followup) Add tests for Koha::Hold->delete <http://git.koha-community.org/gitweb/?p=
18:55 mveron-away     Good evening / daytime #koha
18:56 cait            hi mveron-away :)
18:56 mveron          Hi cait
19:47 agoforth        I'm having trouble figuring out how to catalog publisher data in Koha. It seems like MARC fields 260$a, 260$b, and 260$c are what I want, but I also want to make the publisher name and place an authority value. It seems like I could use the Corporate Name authority type and fill in the 110$a and 110$c subfields, but then the data gets put into the subfields backwards in the MARC record of the book.
19:47 agoforth        How do people usually catalog publisher data? Is there some way to make the Corporate Name authority work or do I have to do something else?
20:33 hortlibrarian   Hello I'm looking for some help, I want to connect my Koha ILS through a Z-Link connection in ABLE (a database used for binding prep from HF Group) and I'm looking ofr information on the host and port address for my ILS
20:33 bag             manual?
20:33 wahanui         manual is probably at http://www.koha-community.org/documentation
20:34 bag             you could start there hortlibrarian
20:34 hortlibrarian   here's what ABLE wants
20:34 hortlibrarian   http://ablein.hfgroup.com/com/ProgrammingConcepts/Able/Help/R6-zlink.htm
20:34 bag             wiki?
20:34 wahanui         it has been said that wiki is http://wiki.koha-community.org
20:34 bag             or in there for turing on your z-server
20:34 hortlibrarian   yea I just started checking the wiki now
20:34 hortlibrarian   we use the Z39.50 search for cataloging items
20:34 hortlibrarian   so we import from OCLC
20:35 hortlibrarian   but is there a way to go into our ILS as well?
20:35 hortlibrarian   for this ABLE stuff?
20:38 bag             yes but you’ve got to turn it on ;)
20:39 bag             sorry really slow internet connection currently - trying to find the page you need
20:43 bag             hortlibrarian: https://wiki.koha-community.org/wiki/Troubleshooting_Koha_as_a_Z39.50_server  try that
20:50 hortlibrarian   oooh okay
20:50 hortlibrarian   thank you
20:53 hortlibrarian   wow that is greek to me haha
20:54 hortlibrarian   what is zebra
20:54 wahanui         somebody said zebra was a fielded free text indexing and retrieval engine with a Z39.50 front-end. You can use any compatible, commercial, or freeware Z39.50 client to access data stored in Zebra. or the search engine koha uses
20:54 hortlibrarian   hmm yea makes sense
20:54 hortlibrarian   I was just hoping I could plunk in a host address and port
20:54 hortlibrarian   and get in
20:55 bag             once you uncomment those sections in the koha-conf.xml and restart zebra - you can :)
20:59 hortlibrarian   bag: that is Greek to me
20:59 * hortlibrarian is not the IT Librarian
21:00 hortlibrarian   I just like computers and am good with searching
21:00 hortlibrarian   but not sure how to do this Zebra stuff
21:00 cait            mveron-away: thunderstorm just arrived
21:03 cait            @wunder Konstanz
21:03 huginn          cait: The current temperature in LuisenstraÃ&#376;e, Konstanz, Germany is 21.7°C (11:02 PM CEST on August 17, 2016). Conditions: Clear. Humidity: 74%. Dew Point: 17.0°C. Pressure: 29.89 in 1012 hPa (Steady).
21:04 cait            hm not at the weatherstation apparently
21:05 hortlibrarian   also I can't figure out how to get the z-link mapping to work
21:05 hortlibrarian   for OCLC Z39.50 searching
21:05 hortlibrarian   I was able to get Z-link working for OCLC
21:09 mveron          cait: I see the thunderstorm on te radar above Konstanz...  Seems to be the same that hit Allschwil earlier...
21:09 cait            it's loud :)
21:09 bag             BOOM
21:09 cait            yep
21:10 mveron          Rain came in horizontally here...
21:16 wizzyrea        it's sunny here :D
21:19 hortlibrarian   huzzah I imported from OCLC into ABLE
21:19 * hortlibrarian does a happy dance
21:25 mveron          Good night / daytime #koha