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  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  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  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.