Time  Nick            Message
15:21 fbcit           g'morning koha
15:21 gmcharlt        hi fbcit
15:22 paul            hello fbcit & gmcharlt
15:22 gmcharlt        hi paul
15:22 fbcit           hi paul
15:27 hdl             hi all.
15:28 gmcharlt        hi hdl
15:54 fbcit           hello hdl
16:28 MatthewMetzger_ gmcharlt: sorry for my ignorance. How do I apply the patches you sent me?
16:30 gmcharlt        MatthewMetzger_: what mode did you install Koha in - 'dev', 'single', or 'standard'?
16:30 MatthewMetzger_ I believe "standard"
16:30 MatthewMetzger_ gmcharlt: I also know the answer to your question about different versions of perl
16:31 gmcharlt        ok, let's start with the first
16:31 MatthewMetzger_ I saw that cpan installed perl 5.10 in addition to 5.8 (if my memory serves me correctly on the version numbers).
16:31 MatthewMetzger_ I think it installed this when I asked cpan to install one of the modules in question
16:32 MatthewMetzger_ "it" being cpan
16:32 gmcharlt        yikes, that could well do it
16:32 MatthewMetzger_ I thought it was weird, but don't know enough about perl for it to have raised a big red flag
16:32 gmcharlt        so we can follow that -- first, find the installed copy of about.pl and check the first line
16:33 gmcharlt        that should be the path to Perl used by all of the CGI scripts
16:33 MatthewMetzger_ okay
16:34 MatthewMetzger_ #!/usr/bin/perl
16:34 MatthewMetzger_ is the first line
16:34 MatthewMetzger_ so 5.10 must have a different path
16:34 MatthewMetzger_ ?
16:34 gmcharlt        so /usr/bin/perl -V shows version 5.8?
16:35 MatthewMetzger_ that gave me a lot of output...
16:36 MatthewMetzger_ the end of the output says:
16:36 MatthewMetzger_ @INC:
16:36 MatthewMetzger_     /etc/perl
16:36 MatthewMetzger_     /usr/local/lib/perl/5.8.7
16:36 MatthewMetzger_     /usr/local/share/perl/5.8.7
16:36 MatthewMetzger_     /usr/lib/perl5
16:36 MatthewMetzger_     /usr/share/perl5
16:36 MatthewMetzger_     /usr/lib/perl/5.8
16:36 MatthewMetzger_     /usr/share/perl/5.8
16:36 MatthewMetzger_     /usr/local/lib/site_perl
16:36 MatthewMetzger_ so it must be 5.8
16:36 gmcharlt        yeah
16:36 gmcharlt        next, do 'find /usr -name Syck.pm 2> /dev/null' to see where YAML::Syck ended up
16:37 MatthewMetzger_ four lines: one of the is: /usr/local/lib/perl5/site_perl/5.10.0/i686-linux/JSON/Syck.pm
16:37 MatthewMetzger_ so 5.10
16:38 gmcharlt        but just to be sure, where is YAML/Syck.pm ?
16:38 MatthewMetzger_ "/usr/local/lib/perl5/site_perl/5.10.0/i686-linux/YAML/Syck.pm"
16:38 gmcharlt        ok, that clinches it
16:38 gmcharlt        so, here's how to invoke CPAN and hopefully force it to use 5.8.8:
16:39 MatthewMetzger_ Can I blame cpan? or am I just stupid? thanks so much for your help!
16:39 gmcharlt        /usr/bin/perl -MCPAN -e shell
16:39 gmcharlt        no, you're not stupid
16:39 gmcharlt        just some weird PATH issues
16:40 MatthewMetzger_ okay. I'm in the cpan shell with your command. Thanks for the reassurance :)
16:40 gmcharlt        so now you should be able to install those modules for 5.8
16:40 gmcharlt        let me know how it goes
16:40 MatthewMetzger_ thanks so much! I'll give it a try and get back to you.
16:43 MatthewMetzger_ on install XML::LibXSLT:
16:44 MatthewMetzger_ make: *** [blib/arch/auto/XML/LibXSLT/LibXSLT.so] Error 1
16:44 MatthewMetzger_   /usr/bin/make  -- NOT OK
16:44 MatthewMetzger_ Running make test
16:44 MatthewMetzger_   Can't test without successful make
16:44 MatthewMetzger_ Running make install
16:44 MatthewMetzger_   make had returned bad status, install seems impossible
16:45 gmcharlt        hmm, what platform are you on?
16:45 MatthewMetzger_ ubuntu 6.06 intel
16:48 MatthewMetzger_ gmcharlt: it is odd that it can't install with 5.8, but can with 5.10. That means that the needed dev tools are installed and working.
16:49 gmcharlt        yeah, for XML::LibXSLT, it might be easier to install the dapper package libxml-libxslt-perl
16:50 gmcharlt        so if you're in your CPAN shell, let's skip that for a moment and try installing YAML::Syck
16:51 MatthewMetzger_ okay, here's goes...
16:52 MatthewMetzger_ gmcharlt: It looks like that installed correctly!
16:53 gmcharlt        ok, so if there were no others Perl modules missing, exit out of CPAN and apt-get install libxml-libxslt-perl
16:54 MatthewMetzger_ just to check, cgi-bin/koha/about.pl reports that YAML::Syck is at version 1.01 :)
16:54 MatthewMetzger_ I'll do the apt-get now...
16:54 gmcharlt        progress :)
16:56 MatthewMetzger_ gmcharlt: I'm getting errors, but I have a hunch as to why... Here's the errors:
16:56 MatthewMetzger_ Errors were encountered while processing:
16:56 MatthewMetzger_  libxml-sax-perl
16:56 MatthewMetzger_  libxml-libxml-perl
16:56 MatthewMetzger_  libxml-libxslt-perl
16:56 MatthewMetzger_ E: Sub-process /usr/bin/dpkg returned an error code (1)
16:56 MatthewMetzger_ here's the hunch:
16:56 MatthewMetzger_ I remember that the koha install notes asked that I use dpkg or something having to do with apt to install certain packages. Could that still be running in the background messing things up?
16:57 MatthewMetzger_ There are more apt-get errors, but those are the ones at the end of the output
16:58 gmcharlt        it may still be in the middle of a dselect
16:59 gmcharlt        see if you have any running dselect or dpkg processes, and if not, do dselect and see if choose [I]install and [C]onfigure start anything
17:00 MatthewMetzger_ ps -e | grep dselect and ps -e | grep dpkg returned nothing...
17:02 MatthewMetzger_ gmcharlt: yes it does start something. The same apt-get request we ran a minute ago
17:02 MatthewMetzger_ end with: installation script returned error exit status 100.
17:02 gmcharlt        try [R]emove, then see if [I]nstall does anything again
17:03 MatthewMetzger_ okay...
17:03 MatthewMetzger_ I chose remove and then install, but it returned the same errors
17:04 gmcharlt        hmm -- then try dpkg --clear-selections, then dselect [R]emove
17:05 MatthewMetzger_ sudo dpkg --clear-selections
17:05 MatthewMetzger_ dpkg: unknown option --clear-selections
17:06 gmcharlt        hmm, what dpkg version do you have?
17:07 MatthewMetzger_ Debian GNU/Linux `dpkg' package management program version 1.13.11 (i386).
17:09 gmcharlt        ok, does dpkg -C (or dpkg --audit) suggest anything?
17:09 MatthewMetzger_ The following packages have been unpacked but not yet configured.
17:09 MatthewMetzger_ They must be configured using dpkg --configure or the configure
17:09 MatthewMetzger_ menu option in dselect for them to work:
17:09 MatthewMetzger_  libxml-libxml-perl   Perl module for using the GNOME libxml2 library
17:09 MatthewMetzger_  libxml-libxslt-perl  Perl module for using the GNOME libxslt library
17:09 MatthewMetzger_ The following packages are only half configured, probably due to problems
17:09 MatthewMetzger_ configuring them the first time.  The configuration should be retried using
17:09 MatthewMetzger_ dpkg --configure <package> or the configure menu option in dselect:
17:09 MatthewMetzger_  libxml-sax-perl      Perl module for using and building Perl SAX2 XML processo
17:10 MatthewMetzger_ gmcharlt: from dpkg -C
17:10 gmcharlt        well, let's see if dpkg --configure for each of them helps
17:10 MatthewMetzger_ okay..
17:11 MatthewMetzger_ sudo dpkg --configure libxml-sax-perl
17:11 MatthewMetzger_ Setting up libxml-sax-perl (0.12-5) ...
17:11 MatthewMetzger_ Can't locate object method "save_parsers_debian" via package "XML::SAX" at /usr/bin/update-perl-sax-parsers line 90.
17:11 MatthewMetzger_ dpkg: error processing libxml-sax-perl (--configure):
17:11 MatthewMetzger_  subprocess post-installation script returned error exit status 255
17:11 MatthewMetzger_ Errors were encountered while processing:
17:11 MatthewMetzger_  libxml-sax-perl
17:11 MatthewMetzger_ I'll try the others, too.
17:12 MatthewMetzger_ gmcharlt: I also get errors on those.
17:12 MatthewMetzger_ Errors were encountered while processing:
17:12 MatthewMetzger_  libxml-libxml-perl
17:12 MatthewMetzger_  libxml-libxslt-perl
17:14 gmcharlt        what's the contents of /etc/perl/XML/SAX/ParserDetails.ini
17:14 MatthewMetzger_ gmcharlt: dependency problems prevent configuration of libxml-libxslt-perl
17:14 gmcharlt        and what files if any are in /etc/perl/XML/SAX/ParserDetails.d
17:14 MatthewMetzger_ okay...
17:15 MatthewMetzger_ nothing in /etc/perl/XML/SAX/ParserDetails.ini
17:15 gmcharlt        what's the first line of /usr/bin/update-perl-sax-parsers (wonder if it's trying to use 5.10 instead of 5.8)
17:15 MatthewMetzger_ gmcharlt: also no files in that directory ls -la /etc/perl/XML/SAX/ParserDetails.d
17:16 MatthewMetzger_ #!/usr/bin/perl
17:16 MatthewMetzger_ so it looks like perl 5.8
17:18 gmcharlt        ok, found more info that may help -- we'll check for conflicting versions of XML::Sax
17:18 gmcharlt        so do a 'locate SAX.pm'
17:19 MatthewMetzger_ some results returned source files in my home directory. I did try to install these modules from source, if that it information you need.
17:19 MatthewMetzger_ otherwise it returned
17:19 MatthewMetzger_ "/usr/local/lib/perl/5.8.7/XML/LibXML/SAX.pm
17:20 MatthewMetzger_ oops, sorry IRC won't post all the lines beginning with "/"
17:20 MatthewMetzger_ "/usr/local/lib/perl/5.8.7/XML/LibXML/SAX.pm
17:20 MatthewMetzger_ "/usr/local/lib/perl5/site_perl/5.10.0/i686-linux/XML/LibXML/SAX.pm
17:20 MatthewMetzger_ "/usr/local/lib/perl5/site_perl/5.10.0/MARC/File/SAX.pm
17:20 MatthewMetzger_ "/usr/local/lib/perl5/site_perl/5.10.0/XML/SAX.pm
17:20 MatthewMetzger_ "/usr/local/share/perl/5.8.7/MARC/File/SAX.pm
17:20 MatthewMetzger_ "/usr/local/share/perl/5.8.7/XML/SAX.pm
17:20 MatthewMetzger_ "/usr/share/perl5/XML/DOM/PerlSAX.pm
17:20 MatthewMetzger_ "/usr/share/perl5/XML/Parser/PerlSAX.pm
17:20 MatthewMetzger_ "/usr/share/perl5/XML/Perl2SAX.pm
17:20 MatthewMetzger_ "/usr/share/perl5/XML/XPath/PerlSAX.pm
17:21 MatthewMetzger_ gmcharlt: looks like there might be conflicts...?
17:21 gmcharlt        does /usr/local/share/perl/5.8.7/XML/SAX.pm have save_debian_parsers in it?
17:22 gmcharlt        if not, rename it and try apt-get install libxml-sax-perl again
17:22 MatthewMetzger_ "cat /usr/local/share/perl/5.8.7/XML/SAX.pm | grep save_debian_parsers" returns no output
17:23 MatthewMetzger_ okay, so I change that file to a different name? Can I just append ."backup" to it with the mv command to get the job done?
17:23 gmcharlt        yep
17:23 MatthewMetzger_ now I'll try the apt-get command again...
17:24 MatthewMetzger_ Setting up libxml-sax-perl (0.12-5) ...
17:24 MatthewMetzger_ Setting up libxml-libxml-perl (1.58-3) ...
17:24 MatthewMetzger_ update-perl-sax-parsers: Adding Perl SAX parser module info file of XML::LibXML::SAX::Parser...
17:24 MatthewMetzger_ update-perl-sax-parsers: Adding Perl SAX parser module info file of XML::LibXML::SAX...
17:24 MatthewMetzger_ update-perl-sax-parsers: Updating overall Perl SAX parser modules info file...
17:24 MatthewMetzger_ Setting up libxml-libxslt-perl (1.58-1) ...
17:24 MatthewMetzger_ That looks good, right? :)
17:25 gmcharlt        yep :)
17:25 gmcharlt        so now let's see if about.pl is happier
17:25 MatthewMetzger_ now i'll check the about.pl
17:25 gmcharlt        snap
17:26 MatthewMetzger_ All modules are installed with version numbers. XML::LibXSLT 1.58
17:26 MatthewMetzger_ :)
17:26 MatthewMetzger_ gmcharlt: you are a genius!
17:26 gmcharlt        naw, just good with Google :)
17:26 gmcharlt        so now that YAML::Syck is installed, you should be to log out, log in again, and have Koha's cookie-based session persist
17:26 MatthewMetzger_ gmcharlt: I'm glad you know what to google. I'll save this chat for future inspiration :)
17:27 MatthewMetzger_ gmcharlt: the cookie problem seems to be solved. I'll try logging out and logging in...
17:28 MatthewMetzger_ gmcharlt: the intranet seems fine!
17:29 MatthewMetzger_ gmcharlt: I have one more quick question that I can probably do the research for on my own if it is complicated...
17:29 gmcharlt        go ahead
17:29 MatthewMetzger_ the OPAC doesn't return any search results. Should I reinstall koha without zebra as we have a very small library?
17:30 MatthewMetzger_ the whole, perl Makefile.PL, make, make install?
17:31 gmcharlt        no, you don't need to go that far
17:31 MatthewMetzger_ gmcharlt: just some settings in admin?
17:31 gmcharlt        yes, the NoZebra system preference would be a start
17:32 gmcharlt        if you set NoZebra to on, you also should set the following to off:
17:32 gmcharlt        QueryFuzzy QueryWeightFields QueryStemming
17:33 gmcharlt        longer term, though, I would encourage you to consider turning Zebra back on
17:33 gmcharlt        the advanced features that Zebra offers will not always make it back to NoZebra mode
17:35 MatthewMetzger_ okay, thanks so much. I'll have to come back to it later, as I have to be away for an hour or so. Much appreciated :)
17:35 gmcharlt        (and, although this may be a pipe dream, I hope that Koha's Zebra support and indexing will eventually become bulletproof enough and simple enough to set up that we can deprecate NoZebra mode)
17:35 gmcharlt        you're welcome
17:35 MatthewMetzger_ gmcharlt: that sounds good!
17:35 MatthewMetzger_ gmcharlt: do you work for liblime?
17:35 gmcharlt        yep
17:36 MatthewMetzger_ gmcharlt: good to know. I'm pleased.
17:46 martinmorris    While people are around can I get a bit of help on why I get ERROR 109 in my zebrasrv log for authorities but not for biblios.  I've reindexed both.
17:51 gmcharlt        martinmorris: are you running 3.0 alpha or the latest git HEAD?
17:56 martinmorris    3.0 alpha
17:56 martinmorris    on ubuntu
18:01 gmcharlt        martinmorris: ok, please grep for 'listen' in the zebra log and and let me know if it includes any references to authoritysocket
18:02 martinmorris    yep: 19:22:39-10/02 [server] Adding dynamic listener on unix:/var/run/koha/zebradb/authoritysocket id=2
18:03 gmcharlt        and does the authoritysocket exist on the filesystem?
18:03 martinmorris    checking
18:03 martinmorris    it does
18:06 martinmorris    here's a log snipped from an authority search i've just done
18:06 martinmorris    18:05:56-12/02 zebrasrv(28) [session] Session - OK 28 unix:/var/run/koha/zebradb/authoritysocket 31360
18:06 martinmorris    18:05:56-12/02 zebrasrv(28) [request] Auth idPass kohauser -
18:06 martinmorris    18:05:56-12/02 zebrasrv(28) [request] Init OK - ID:81/81 Name:ZOOM-C/YAZ Version:1.154/3.0.24
18:06 martinmorris    18:05:56-12/02 zebrasrv(28) [request] Search authorities ERROR 109 1 1+0 RPN @attrset Bib-1 @or @attr "1=Heading" @attr 7=1 0 @attr 4=6 @attr 5=1 @attr "1=Heading" Cherpillod
18:06 martinmorris    18:05:56-12/02 zebrasrv(28) [session] Connection closed by client
18:07 gmcharlt        martinmorris: let's see if yaz-client can search it correct, viz
18:07 gmcharlt        yaz-client
18:07 martinmorris    never used that before, give me a sec and i'll work it out
18:07 gmcharlt        Z> open unix:/var/run/koha/zebradb/authoritysocket
18:08 gmcharlt        Z> base authorities
18:08 martinmorris    ok done that
18:08 gmcharlt        Z> find @attrset Bib-1 @attr "1=Heading" Cherpillod
18:08 martinmorris    socket seems to open fine
18:08 martinmorris    here's what i get
18:08 martinmorris    Sent searchRequest.
18:08 martinmorris    Received SearchResponse.
18:08 martinmorris    Search was a bloomin' failure.
18:08 martinmorris    Number of hits: 0, setno 1
18:08 martinmorris    Result Set Status: none
18:08 martinmorris    records returned: 0
18:08 martinmorris    Diagnostic message(s) from database:
18:08 martinmorris        [109] Database unavailable -- v2 addinfo 'authorities'
18:08 martinmorris    Elapsed: 0.016800
18:09 martinmorris    like the failure message :)
18:09 gmcharlt        yeah, I do too :)
18:09 gmcharlt        please do a list_all in yaz-client
18:09 martinmorris    ok
18:10 martinmorris    want me to just copy and paste the reply?
18:10 gmcharlt        yeah, go ahead
18:10 martinmorris    Connected to         : unix:/var/run/koha/zebradb/authoritysocket
18:10 martinmorris    auto_reconnect       : off
18:10 martinmorris    auto_wait            : on
18:10 martinmorris    Authentication       : none
18:10 martinmorris    Bases                : authorities
18:10 martinmorris    CCL file             : default.bib
18:10 martinmorris    CQL file             : /usr/local/share/yaz/etc/pqf.properties
18:10 martinmorris    Query type           : prefix (RPN sent to server)
18:10 martinmorris    Named Result Sets    : on
18:10 martinmorris    ssub/lslb/mspn       : 0/1/0
18:10 martinmorris    Format               : usmarc
18:10 martinmorris    Schema               : not set
18:10 martinmorris    Elements             :
18:10 martinmorris    APDU log             : off
18:10 martinmorris    Record log           : off
18:10 martinmorris    Other Info:
18:14 gmcharlt        hmm, could you paste in the output of 'grep authorities' on your koha-conf.xml?
18:14 martinmorris    sure
18:15 martinmorris        <directory>/var/lib/koha/zebradb/authorities</directory>
18:15 martinmorris        <config>/etc/koha/zebradb/zebra-authorities.cfg</config>
18:15 martinmorris        <xi:include href="/etc/koha/zebradb/explain-authorities.xml"
18:15 martinmorris                <database>authorities</database>
18:15 martinmorris     <authorityserver>authorities</authorityserver>
18:16 gmcharlt        hmm, that looks OK  -- does /var/lib/koha/zebradb/authorities/register exist and have a bunch of *.mf files in it?
18:17 martinmorris    it does
18:17 martinmorris    i'm noticing that a grep for biblios in the koha-conf file has these lines which don't appear to have a corresponding line in authorities
18:17 martinmorris    <serverinfo id="biblioserver">
18:17 martinmorris     <biblioserver>biblios</biblioserver>
18:17 martinmorris     <biblioservershadow>1</biblioservershadow>
18:17 martinmorris    authorities only has a middle line corresponding
18:18 gmcharlt        yeah, but the equivalent is <serverinfo id="authorityserver">, and that should be OK
18:19 martinmorris    as i've just found out - thanks!
18:26 gmcharlt        I assume you used rebuild_zebra.pl to reindex the authorities?
18:26 martinmorris    i did, yes
18:26 martinmorris    ill just check which flags
18:26 martinmorris    i imported a few authorities in marc21 format then ran rebuild_zebra.pl
18:26 martinmorris    this was after I had imported my biblios and reindexed
18:27 gmcharlt        well, just for the sake of argument, let's do rebuild_zebra.pl -a -r again
18:27 martinmorris    sure :)
18:27 gmcharlt        and stop and restart zebrasrv after you do that
18:28 gmcharlt        then try the yaz-client stuff again (note that yaz-client let's you use the up arrow to access command history)
18:29 martinmorris    no difference i'm afraid :(
18:30 martinmorris    i'm not stopping zebrasrv nicely btw, i'm just killing the process and rerunning zebrasrv -f /etc/koha/koha-conf.xml
18:30 martinmorris    assume that doesn't matter?
18:30 gmcharlt        correct, that doesn't matter
18:32 gmcharlt        ok, let's try something else -- could you pastebin in your entire koha-conf.xml?
18:32 martinmorris    certainly, how do I do that?
18:33 gmcharlt        go to pastebin, paste in the contents, and it will give you a URL that you can post here in the channel
18:33 gmcharlt        pastebin.com, rather
18:33 martinmorris    got you, hold on
18:33 martinmorris    http://pastebin.com/m4ef9919e
18:35 kados           does rebuild_zebra.pl do an init with the database name?
18:36 gmcharlt        kados: yes
18:36 martinmorris    i'm glad you answered that gmcharlt :)
18:36 martinmorris    it's ok that zebrasrv is running while i do the reindex_zebra?  so long as i stop/start it after?
18:37 gmcharlt        yes (and you don't need to restart it every time you reindex, I just asked you to do it to make sure it was reading the config files)
18:37 martinmorris    right OK
18:38 gmcharlt        if you do a plain 'zebrasrv', what version number does it report?
18:38 martinmorris    18:37:58-12/02 [log] zebra_start 2.0.26 zebra.cfg
18:38 martinmorris    is that what you meant?
18:39 gmcharlt        yep
18:39 martinmorris    and it's yaz version 3.0.24 if that is of any use (expects it isn't)
18:45 gmcharlt        ok, here's something else to try (this is a big stretch, but anyhoo) -- in /var/lib/koha/zebradb/authorities/register, do a 'grep -l databaseInfo *'
18:45 martinmorris    ok
18:45 gmcharlt        then, on whichever file is turned up, do 'strings xxx.mf | grep database'
18:46 martinmorris    here's what i get
18:46 martinmorris    cessInfo><zebraInfo><version>2.0.26</version><databaseList><database><name>IR-Explain-1</name><id>2</id><attributeDetail
18:46 martinmorris    sId>3</attributeDetailsId></database></databaseList><ordinalSU>15</ordinalSU><ordinalDatabase>2</ordinalDatabase><runNum
18:46 martinmorris    <explain><databaseInfo>DatabaseInfo
18:46 martinmorris    nalDatabase>1</ordinalDatabase></zebraInfo></databaseInfo></explain>
18:46 gmcharlt        wow, that actually worked
18:47 martinmorris    :)
18:47 martinmorris    it was in the recdA-0.mf file
18:47 gmcharlt        in the databaseList.database.name element, it's saying IR-Explain-1 when it should be 'authorities'
18:47 martinmorris    right
18:47 gmcharlt        so just to check, do the yaz-client thing again, but do 'base IR-Explain-1' before you do the find
18:47 martinmorris    two secs
18:49 martinmorris    different error this time
18:50 martinmorris    Diagnostic message(s) from database:
18:50 martinmorris        [114] Unsupported Use attribute -- v2 addinfo 'Heading'
18:51 gmcharlt        might need the full set of qualifiers -- try
18:51 gmcharlt        @attrset Bib-1 @or @attr "1=Heading" @attr 7=1 0 @attr 4=6 @attr 5=1 @attr "1=Heading" Cherpillod
18:51 gmcharlt        rather, try
18:51 gmcharlt        find @attrset Bib-1 @or @attr "1=Heading" @attr 7=1 0 @attr 4=6 @attr 5=1 @attr "1=Heading" Cherpillod
18:51 martinmorris    nope
18:51 martinmorris    same message
18:51 martinmorris    something's profoundly screwed here :)
18:52 martinmorris    it's the 1-Heading it doesn't like I take it
18:53 gmcharlt        yeah, try the shorter search again but replace 1=Heading with 1=8001
18:53 martinmorris    ok
18:54 martinmorris        [114] Unsupported Use attribute -- v2 addinfo '8001'
18:57 gmcharlt        ok -- and I was on a bit of tangent -- IR-Explain-1 is the Z39.50 explain database that Zebra automatically creates
18:57 martinmorris    right
18:58 gmcharlt        let's check something else -- in that same *.mf file, do 'strings xxx.mf | grep database'
18:58 martinmorris    ok
18:59 martinmorris    that's the same command as before
18:59 martinmorris    i've done that
18:59 gmcharlt        oh, right misread the log and thought I had you grep for databaseInfo
18:59 martinmorris    ok :)
19:00 gmcharlt        for the sake of comparison, let's do the same thing in /var/lib/koha/zebradb/biblios/register
19:00 martinmorris    OK
19:00 martinmorris    will take a little longer
19:01 martinmorris    explain><databaseInfo>DatabaseInfo
19:01 martinmorris    <commonInfo><dateAdded>20080210225725</dateAdded><dateChanged>20080210225725</dateChanged><languageCode>EN</languageCode></commonInfo><accessInfo><unitSystems><string>ISO</string></unitSystems></accessInfo><name>biblios</name><userFee>0</userFee><available>1</available><recordCount><recordCountActual>6050</recordCountActual></recordCount><zebraInfo><recordBytes>3645902</recordBytes><ordinalDatabase>2</ordinalDatabase></zebraInfo></databa
19:01 martinmorris    <explain><databaseInfo>DatabaseInfo
19:01 martinmorris    nfo><unitSystems><string>ISO</string></unitSystems><schemas><oid>1.2.840.10003.13.1000.81.2</oid></schemas></accessInfo><name>IR-Explain-1</name><userFee>0</userFee><available>1</available><recordCount><recordCountActual>7</recordCountActual></recordCount><zebraInfo><recordBytes>0</recordBytes><ordinalDatabase>1</ordinalDatabase></zebraInfo></databaseInfo></explain>
19:01 martinmorris    de></commonInfo><accessInfo><unitSystems><string>ISO</string></unitSystems><schemas><oid>1.2.840.10003.13.1000.81.2</oid></schemas></accessInfo><zebraInfo><version>2.0.26</version><databaseList><database><name>biblios</name><id>6052</id><attributeDetailsId>6053</attributeDetailsId></database><database><name>IR-Explain-1</name><id>6054</id><attributeDetailsId>6055</attributeDetailsId></database></databaseList><ordinalSU>93</ordinalSU><ord
19:01 martinmorris    that's got biblios as the database
19:02 martinmorris    oh no it hasn't, that's IR-Explain-1 too
19:02 gmcharlt        yes, but it still has the biblios database also
19:02 martinmorris    so it does
19:03 gmcharlt        so that's the difference
19:03 martinmorris    yes
19:03 martinmorris    well spotted
19:03 gmcharlt        next, I'm going to walk you through reindexing the authorities in such a way that we can what zebraidx
19:03 martinmorris    ok :)
19:04 gmcharlt        so first, do rebuild_zebra.pl -a -d /tmp/zebindex -k -r
19:04 gmcharlt        this does the indexing, but it also keeps the exported authority records so that we can do zebraidx manually
19:04 martinmorris    ok
19:05 martinmorris    done
19:05 martinmorris    there's only about five authorities at the moment
19:05 martinmorris    so it's very quick
19:05 gmcharlt        next, do zebraidx -c /etc/koha/zebra/zebra-authorities.cfg -g iso2709 -d authorities init
19:06 gmcharlt        /etc/koha/zebradb... rather
19:07 martinmorris    done :)
19:07 gmcharlt        no messages?
19:07 martinmorris    19:06:33-12/02 zebraidx(31577) [log] zebra_start 2.0.26 /etc/koha/zebradb/zebra-authorities.cfg
19:07 martinmorris    19:06:33-12/02 zebraidx(31577) [log] enabling shadow spec=/var/lib/koha/zebradb/authorities/shadow:1G
19:07 martinmorris    19:06:33-12/02 zebraidx(31577) [log] cache_fname = /var/lib/koha/zebradb/authorities/shadow/cache
19:07 martinmorris    19:06:33-12/02 zebraidx(31577) [log] zebra_stop: 0.00 0.00 0.00
19:08 gmcharlt        if not, then zebraidx -c /etc/koha/zebradb/zebra-authorities.cfg -g iso2709 -d authorities update /tmp/zebindex/authorities
19:08 martinmorris    that's fine
19:08 martinmorris    i get a warning each time
19:08 martinmorris    19:08:11-12/02 zebraidx(31594) [warn] No such record type: grs.marcxml.record
19:09 gmcharlt        progress, I think
19:09 martinmorris    :)
19:10 kados           hmmm, might need to update your zebra cfg file
19:10 martinmorris    because of the grs.marcxml.record thing?
19:10 owen            Hi folks
19:10 martinmorris    hi owen
19:11 kados           hey owen
19:11 kados           martinmorris: yea, it's possible
19:11 martinmorris    ok
19:11 kados           sec
19:11 martinmorris    this is all a bit above my head so all this help is very much appreciated
19:11 gmcharlt        yeah, please pastebin your zebra-authorities.cfg
19:11 martinmorris    will do
19:11 kados           http://git.koha.org/cgi-bin/gitweb.cgi?p=Koha;a=blob;f=etc/zebradb/zebra-biblios.cfg;h=980c01a909059b22fbf5958e124738b646d5c034;hb=HEAD
19:12 kados           oh, it's for authorities?
19:12 gmcharlt        yes
19:12 martinmorris    yes, my biblios are fine
19:12 gmcharlt        heh
19:13 martinmorris    LOL
19:13 martinmorris    http://pastebin.com/m1b607bf4
19:14 martinmorris    aaaaaaaaaaaaah
19:14 martinmorris    two secs...
19:16 martinmorris    it's fixed :)
19:17 martinmorris    the path to the modules was wrong!  i'd fixed it in biblios but didn't do so for authorities
19:17 kados           dou!
19:17 gmcharlt        yay!
19:17 kados           that'll do it :-)
19:17 gmcharlt        so did the installer get it wrong?
19:18 martinmorris    i'm SO sorry guys thank you all
19:18 martinmorris    yes it did, for both
19:18 martinmorris    i'm going to submit a bug report
19:18 martinmorris    as well as a suggestion that the INSTALL file needs to mention zebra indexing
19:18 martinmorris    jaron helped me with that one
19:18 gmcharlt        ok, I await your bug report with bated breath :)
19:18 martinmorris    you've been VERY helpful, thank you very much indeed i'm pathetically grateful :)
19:19 gmcharlt        what is the correct modulePath on your platform, btw?
19:19 gmcharlt        you're welcome
19:19 martinmorris     /usr/local/lib/idzebra-2.0/modules
19:20 gmcharlt        ok, and is it Ubuntu 6 or 7?
19:20 martinmorris    7.04
19:20 gmcharlt        thanks!
19:20 martinmorris    you're welcome :)
19:20 martinmorris    the reindex log is longer when the modules are right too!
19:21 martinmorris    i'll import the rest of my authorities now
19:46 atz             gmcharlt++ on the debug
19:53 MatthewMetzger  Hello. I have been following the upgrade instructions at: http://wiki.koha.org/doku.php?id=22_to_30
19:54 MatthewMetzger  I think I made another mistake.
19:55 MatthewMetzger  Under the NoZebra stuff, I used the sample NoZebraIndexes that was on that guide and then realized it was for UNIMARC and I"m using MARC21. Where do I find a sample NoZebraIndex value for MARC21
19:55 MatthewMetzger  ?
19:55 MatthewMetzger  Can I look directly at my mysql database to find these values?
19:55 MatthewMetzger  or is there a better way?
20:05 gmcharlt        MatthewMetzger: see installer/data/mysql/en/mandatory/sysprefs.sql (grep for NoZebraIndex) for an example appropriate for MARC21
20:34 MatthewMetzger  gmcharlt: thanks
20:50 MatthewMetzger  gmcharlt: it gives an example, but I'm not sure what to do with it. Do I have to go back to our old database and look to see what values are for each MARC tag? I'm not sure what to do with the NoZebraIndexes value
20:51 gmcharlt        MatthewMetzger: I don't know if 2.2.9 has the same syspref -- if it does, you could probably get away with try to copy and paste
20:51 gmcharlt        if not, you should be able to set up the indexes as follows
20:52 gmcharlt        1. delete the NoZebraIndex syspref
20:52 gmcharlt        2. grep out that line in the sysprefs.sql into a separate file
20:52 gmcharlt        3. load it using mysql --database xxx --user xxx -ppassword < new_file.sql
20:52 gmcharlt        4. check to make sure it looks OK in the sysprefs
20:53 gmcharlt        5. run rebuild_zebra.pl
20:54 MatthewMetzger  gmcharlt: okay, thanks. Libraries are complicated.
20:55 gmcharlt        you're telling me :)
20:55 MatthewMetzger  :)
21:06 MatthewMetzger  gmcharlt: I'm still terribly confused. That line in sysprefs.sql is only this:
21:06 MatthewMetzger  Enter : \'indexname\' => \'100a,245a,500*\',\'index2\' => \'...\'','','Free');
21:06 MatthewMetzger  That doesn't seem to be complete to me. I can't use that, can I?
21:08 gmcharlt        MatthewMetzger: only because it is incomplete :)
21:08 gmcharlt        kados added a more complete set of values on 1/8, after the alpha was released:
21:09 gmcharlt        INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('NoZebraIndexes','\'title\' => \'130a,210a,222a,240a,243a,245a,245b,246a,246b,247a,247b,250a,250b,440a,830a\',\r\n\'author\' => \'100a,100b,100c,100d,110a,111a,111b,111c,111d,245c,700a,710a,711a,800a,810a,811a\',\r\n\'isbn\' => \'020a\',\r\n\'issn\' => \'022a\',\r\n\'lccn\' => \'010a\',\r\n\'biblionumber => \'999c\',\r\n\'itemtype\' => \'942c\',\r
21:09 gmcharlt        \n\'publisher\' => \'260b\',\r\n\'date\' => \'260c\',\r\n\'note\' => \'500a, 501a,504a,505a,508a,511a,518a,520a,521a,522a,524a,526a,530a,533a,538a,541a,546a,555a,556a,562a,563a,583a,585a,582a\',\r\n\'subject\' => \'600*,610*,611*,630*,650*,651*,653*,654*,655*,662*,690*\',\r\n\'dewey\' => \'082\',\r\n\'bc\' => \'952p\',\r\n\'callnum\' => \'952o\',\r\n\'an\' => \'6009,6109,6119\',\r\n\'host-item\' => \'952a,952c\'','','Enter a s
21:09 gmcharlt        pecific hash for NoZebra indexes. Enter : \'indexname\' => \'100a,245a,500*\',\'index2\' => \'...\'','Free');
21:09 gmcharlt        or see http://pastebin.com/d25edf1ef
21:10 MatthewMetzger  gmcharlt: okay. I'll try to wrap my head around this... I'll check out that link.
21:21 MatthewMetzger  gmcharlt: sorry to be so slow... when trying to insert the sql, I get this: ERROR 1062 (23000) at line 1: Duplicate entry 'NoZebraIndexes' for key 1
21:21 MatthewMetzger  Do I need to drop NoZebraIndexes somehow?
21:22 gmcharlt        right, first you need to do "delete from systempreferences where variable = 'NoZebraIndexes';"
21:22 MatthewMetzger  gmcharlt: okay, I think I get it.
21:22 MatthewMetzger  I just removed its value by editing it, I now see the delete button.
21:23 MatthewMetzger  gmcharlt: that worked, I'll rebuild the index now...
02:57 MatthewMetzger  Hello again. I'm still having major problems with my 2.2.9 to 3.0 upgrade. gmcharlt helped immensely earlier today to fix some session errors with the intranet, but searching the opac give no results.
03:01 MatthewMetzger  I'm trying to set up NoZebra, but even after explicitly following directions given here and in the docs I'm getting nowhere.
06:20 rickw           hello
06:21 rickw           i am checking if this is the correct server and channel for the upcoming KADOS meeting (14.Feb 3:00pm EST) ?
06:21 rickw           i do see a ick called kodos here ... :)
10:34 donovan         morning...
10:34 donovan         anyone up?
10:42 custard         Hi. Just started up zebra (in prep for the Koha 3 web installer bit) and noticed a couple of errors.
10:42 custard         Failed to bind to unix:/var/run/koha/zebradb/bibliosocket [No such file or directory]
10:42 custard         and similar for authoritysocket.
10:43 custard         Does anyone know if this is normal first time up? (ie, they get made later) or if the kindly mac people have hiddent them somewhere odd.