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.