IRC log for #koha, 2012-09-16

← Previous day | Today | Next day → | Search | Index

All times shown according to UTC.

Time Nick Message
00:46 Waylon joined #koha
00:46 Waylon hey all.
00:48 what determines the display format of search results?
00:48 is there a xslt file involved?
00:48 or something?
00:49 * jcamins stops by while waiting for his bread to bake.
00:49 jcamins Waylon: it depends. If you have XSLT mode turned on then yes, XSLT is involved.
00:49 Otherwise, no.
00:49 Waylon okay, what is XSLT?
00:49 wahanui XSLT is a maze of twisty turny passages, all alike.
00:50 jcamins lol
00:50 Waylon no.. that sounds like zork.
00:50 jcamins XSLT is not that hard, wahanui.
00:50 wahanui ...but xslt is a maze of twisty turny passages, all alike....
00:50 Waylon grue?
00:50 xyzzy?
00:50 jcamins eXtensible Stylesheet Language for Transformations.
00:51 Waylon xyzzy is cheating! Cheater!
00:51 xyzzy?
00:51 wahanui xyzzy is cheating! Cheater!
00:51 Waylon ah.. exactly what i want to use then.
00:53 jcamins wahanui: xslt is also http://en.wikipedia.org/wiki/XSLT and the pages at http://cs.au.dk/~amoeller/XML/transformation/ may be useful for learning the basics.
00:53 wahanui okay, jcamins.
00:53 jcamins xslt?
00:53 wahanui xslt is a maze of twisty turny passages, all alike. or http://en.wikipedia.org/wiki/XSLT and the pages at http://cs.au.dk/~amoeller/XML/transformation/ may be useful for learning the basics.
00:56 jcamins Waylon: XSLT has, generally-speaking, replaced "normal" mode.
00:57 One of the neat features for XSLT is that if the display you want is not at all suitable for inclusion upstream, you can specify your own custom XSLT.
00:58 However, if what you need is generally applicable, it's much better to get your changes upstream, so that any future improvements are available to you.
00:58 Waylon right. XSLT happens serverside, right?
00:59 jcamins Yes.
01:00 I believe it is possible to load a remote XSLT stylesheet, though, by using a fully-qualified URL.
01:00 Waylon changes i'll be making, is making the existance of a download, 856u, visible, but the actual url not there, instead, takes one to opac-download.pl?biblio=<biblio> for download tracking purposes, using C4::Log and BorrowerAttributes
01:01 which probably won't be applicable to general use?
01:01 jcamins Uhhh...
01:01 Waylon and therefore, XSLT will be the thing to use.
01:01 jcamins frankly, that sounds like a bad idea on so many levels I don't have a response.
01:02 Waylon ah?
01:02 wahanui ah is probably ?
01:02 Waylon whats wrong with it?
01:03 jcamins You are eliminating the repeatability of 856s, to start with.
01:06 Waylon ah, right. yes, so this is strictly a inhouse mod then, as for the company i work with, only one 856 per record.
01:06 jcamins Second, you're trying to use the log for analytics, which I expect is going to run into issues of database size.
01:07 (C4::Log, I mean, not logs generally)
01:07 Waylon hmm? what issues?
01:14 jcamins The size is going to explode, and it's going to be as slow as heck to get any information out of the log.
01:14 Didn't you say you had a userbase in the 10000s?
01:15 Waylon university students yeah.
01:16 jcamins Even just one hit per week from each of those is 500k entries in the log.
01:16 Waylon one account per university (for some reason i don't know, but thats the way it is)
01:16 so i think we actually only have 30 accounts.. i think..
01:16 * Waylon shrugs.
01:17 jcamins Don't forget you can't free up space.
01:17 Waylon only by dumping and reinserting yeah.
01:17 jcamins And you get to upgrade things how often?
01:17 upgrade/maintain
01:19 * jcamins is a strong believer in trying to anticipate problems.
01:20 jcamins I think you're better off using an actual analytics package, rather than trying to use Koha's auditing functionality for crude analytics.
01:21 Waylon we are starting to use piwik, i could make the suggestion.
01:22 okay, back in 45 minutes. lunch
01:22 * jcamins leaves to eat dinner, probably won't be back.
01:48 tater joined #koha
02:35 Waylon hmmm.
02:36 took a old 3.0 biblio db.. upgraded it to master.. used the same zebra config as the old setup... reindexed.
02:36 no results.
02:38 oooo
02:38 the xsl thing.
02:38 forgot to create it.
02:45 k.. wasn't taht.
03:18 after copying over the old xslt files to new koha, reindexing.
04:31 cait joined #koha
04:31 cait good morning #koha
05:01 bye #koha
06:04 wajasu Waylon: i
06:04 i've got to migrate from 3.0 as well.
06:05 Waylon ... after another reindex.. still no results
06:06 wajasu when you run a rebuild_zebra -b -a -v      do you see reocrds being dumped.
06:07 and are you sure the zerbasrv is started with the correct KOHA_CONF and PERL5LIB
06:14 Waylon yes and yes.
06:14 gotta go, back laters
06:15 wajasu later
06:40 cait joined #koha
06:40 cait hi #koha
06:44 mbalmer joined #koha
06:48 cait1 joined #koha
06:57 cait joined #koha
08:08 cait joined #koha
08:09 jenkins_koha Starting build #173 for job Koha_3.8.x (previous build: SUCCESS)
08:43 drojf good day #koha
08:44 drojf left #koha
08:47 cait joined #koha
08:49 * cait waves again
08:52 drojf joined #koha
09:03 cait joined #koha
09:11 jenkins_koha Project Koha_3.8.x build #173: SUCCESS in 1 hr 2 min: http://jenkins.koha-community.[…]b/Koha_3.8.x/173/
09:11 * jcamins: Bug 8447: Make sure we have enough subfields for broader_headings
09:11 * Chris Cormack: Bug 7409 : Missing dependency on libtest-mockmodule-perl
09:11 huginn 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=8447 critical, P1 - high, ---, gmcharlt, Pushed to Stable , can't save new records / indicator error
09:11 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=7409 normal, P5 - low, ---, robin, Needs Signoff , Missing dependencies for Debian package
09:11 jenkins_koha Starting build #174 for job Koha_3.8.x (previous build: SUCCESS)
09:33 drojf1 joined #koha
09:46 cait joined #koha
09:59 cait left #koha
10:13 jenkins_koha Project Koha_3.8.x build #174: SUCCESS in 1 hr 2 min: http://jenkins.koha-community.[…]b/Koha_3.8.x/174/
10:13 * colin.campbell: Bug 6976 Close loophole allowing borrowers extra holds via opac
10:13 * jonathan.druart: Bug 8002: FIX Change datatype from varchar 1 to 10 for borrower_attribute_types.category_code
10:13 * Chris Cormack: Bug 8002 : Database bump
10:13 * jcamins: Bug 8743: ZOOM error when merging authority change to biblios
10:13 * Paul Poulain: Bug 8743 follow-up, throw a more explanatory error message
10:13 * colin.campbell: Bug 8653 remove erroneous whitespace blocking indexing
10:13 huginn 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=6976 major, P1 - high, ---, colin.campbell, Pushed to Stable , User hold limit can be avoided by users in OPAC
10:13 jenkins_koha * tomascohen: Bug 8520 - Authorities summary incorrect on posible duplicate notice
10:13 huginn 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=8002 critical, P2, ---, oleonard, Pushed to Stable , Can't add patron attribute type in newer installation
10:13 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=8743 critical, P3, ---, jcamins, Pushed to Stable , ZOOM error when merging authority change to biblios
10:14 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=8653 normal, P4, ---, colin.campbell, Pushed to Stable , With DOM indexing turned on subject authority links are not indexed
10:14 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=8520 critical, P5 - low, ---, jcamins, Pushed to Stable , Authorities display incorrectly in staff results
10:14 jenkins_koha Starting build #175 for job Koha_3.8.x (previous build: SUCCESS)
10:19 Waylon joined #koha
10:19 Waylon hiya all!
10:41 took a old 3.0 biblio db.. upgraded it to master.. used the same zebra config as the old setup... reindexed, got no results. help?
10:45 mtj did you follow the upgrade notes in INSTALL.debian ?
10:46 and run this script? ->  misc/maintenance/remove_items_from_biblioitems.pl --run
10:47 Waylon yes, i did.
10:48 and also ran updatedatabase too, since it found it needed doing.
10:48 mtj have you checked all the obvious stuff?
10:48 Waylon whats obvious?
10:49 mtj run zebra_rebuild -r -b -x - v , and got no errors
10:49 and got a sane count of bibs processes, on completion
10:49 Waylon did zebra_rebuild -r -b -a -v -v
10:50 why -x?
10:50 mtj did it complete ok? or barf?
10:50 Waylon said it completed okay.
10:51 mtj do yu have a stable koha to compare against?
10:51 Waylon [log] Records: 196893 i/u/d 196893/0/0
10:51 mtj that looks good
10:51 Waylon hmm? only the koha currently in production.
10:51 eythian joined #koha
10:51 Waylon thats 3.0
10:52 [log] Iterations: isam/dict 291501887/3024638
10:52 mtj my advice…. sort a stable koha to compare against
10:52 Waylon [log] Dict: inserts/updates/deletions: 3024638/0/0
10:53 mtj if you get different outputs to your stable koha, you've got a debuggable problem
10:55 so, is your zeb-rebuild behaving similar to your stable koha
10:55 is your zebrasrv behaving similar to your stable koha
10:56 if no, you've got a debuggable problem - if yes, you've got a trickier problem :/
10:56 Waylon turned on debug level logging in koha-zebra..
10:57 huh.. new Zebra doesn't give the query used?
10:58 05:56:56-16/09 zebrasrv(1) [debug] Got PDU, 119 bytes: lead=B4 75 83
10:58 05:56:56-16/09 zebrasrv(1) [debug] server select: config=/usr/local/apps/koha/kohadev​-etc/etc/zebradb/zebra-biblios.cfg
10:58 05:56:56-16/09 zebrasrv(1) [debug] bend_init
10:58 05:56:56-16/09 zebrasrv(1) [debug] zebra_open zs=0x1250570 returns 0x1250e20
10:58 05:56:56-16/09 zebrasrv(1) [debug] Sort handler installed
10:58 05:56:56-16/09 zebrasrv(1) [debug] Search handler installed
10:58 05:56:56-16/09 zebrasrv(1) [debug] ESRequest handler installed
10:58 05:56:56-16/09 zebrasrv(1) [debug] Delete handler installed
10:59 05:56:56-16/09 zebrasrv(1) [debug] Scan handler installed
10:59 05:56:56-16/09 zebrasrv(1) [debug] Segment handler installed
10:59 05:56:56-16/09 zebrasrv(1) [debug]   result immediately available
10:59 05:56:56-16/09 zebrasrv(1) [debug] ir_session (output)
10:59 05:56:56-16/09 zebrasrv(1) [debug] Wrote PDU, 183 bytes
10:59 05:56:56-16/09 zebrasrv(1) [debug] zebra_close zh=0x1250e20
10:59 cait joined #koha
10:59 cait left #koha
10:59 Waylon thats all there is.
10:59 mtj http://paste.koha-community.org/
11:00 Waylon hm. right.. ah.. too late
11:00 mtj so, what happens if you do a search?
11:01 Waylon that is from a search
11:01 from a intranet search
11:02 mandumah.com, working server, is zebra 2.0.43, the new server in devel, is zebra 2.0.52
11:02 hmmmmmmm..
11:02 mtj hmm, perhaps use the new zebra conf files, much has changed since 3.0
11:03 Waylon right, but that would take out all the customization that mandumah did.
11:03 mtj do a diff, lots of changes yeah?
11:04 yep, you would lose those mods :/ but at least you might have a working search… to start with
11:04 Waylon maybe.. okay.. ill swap the configs.
11:04 mtj make sense, yeah
11:05 use git on your zebra files
11:05 Waylon on its way.
11:05 mtj start fresh and functioning, then add your mod...
11:06 when it breaks, your last added mod was the problem
11:06 Waylon if this works, guess i will have to manually go through the marc setup.
11:15 jenkins_koha Project Koha_3.8.x build #175: SUCCESS in 1 hr 1 min: http://jenkins.koha-community.[…]b/Koha_3.8.x/175/
11:15 Chris Cormack: Bug 7409 : Fixing typo
11:15 huginn 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=7409 normal, P5 - low, ---, robin, Needs Signoff , Missing dependencies for Debian package
11:15 jenkins_koha Starting build #176 for job Koha_3.8.x (previous build: SUCCESS)
11:16 mtj hmm, usually no - but if youve heavily tweaked your zebra files and marc framework, …then perhaps?
11:57 Waylon mtj, koha master config, fails.
11:58 still no results
12:04 jcamins_away Sounds like you adjusted your Zebra configuration in a non-compatible way.
12:05 Waylon hrm.
12:05 jcamins_away Actually, looking at the output you pasted into the channel, sounds like Zebra isn't running.
12:05 Waylon i mean, koha master zebra config fails.
12:06 ah? zebra is running.
12:07 jcamins_away This bread is amazing.
12:08 Waylon huh?
12:08 jcamins_away In that case, I think I'm back to theory A: you made non-compatible changes to your Zebra config and are storing necessary data in strange places.
12:11 lodac joined #koha
12:11 lodac Morning
12:13 I work in the education sector (k-12). Any recommendation of some American based companies that would provide support to a koha user for a district?
12:13 paid of-course
12:13 jcamins_away support?
12:13 wahanui support is probably found at http://koha-community.org/support/
12:13 jcamins_away paid support?
12:13 wahanui please see http://koha-community.org/support/paid-support/ for a list of paid Koha support vendors.
12:13 jcamins_away ^^ there is a list, though not everyone is on it (I'm not, for example)
12:14 lodac I notice that list for US is 247 days old... so that is why I asked here
12:14 jcamins_away That list is kept up to date.
12:15 lodac jcamins_away: are you looking for customers?
12:15 jcamins_away lodac: responding off-channel
12:17 jenkins_koha Project Koha_3.8.x build #176: SUCCESS in 1 hr 1 min: http://jenkins.koha-community.[…]b/Koha_3.8.x/176/
12:24 Waylon any way to examine the contents of the zebradb?
12:24 without asking a specific query?
12:27 jcamins_away Waylon: not easily, no.
12:29 Waylon ooo.
12:29 got it working
12:29 in -v all
12:29 mode.
12:29 hmmmmm..
12:33 okay, yay. hmm
12:39 jcamins_away Waylon: what was the problem?
12:40 Waylon not sure. running it again with the old zebra config.
12:40 and reindexing
12:40 wajasu maybe you might want to look into the yaz-client?
12:40 jcamins_away ^^ good ides
12:40 *idea
12:40 yaz?
12:40 wahanui rumour has it yaz is from IndexData and the Koha XSLT filters are essentially copied from YAZ
12:41 jcamins_away yaz client?
12:41 troubleshooting with yaz client?
12:41 wajasu man yaz   and man yaz-client will help
12:42 jcamins_away understanding zebra indexing?
12:42 understanding zebra indexing is http://wiki.koha-community.org[…]ng_Zebra_indexing
12:42 yaz client is http://wiki.koha-community.org[…]ng_Zebra_indexing
13:24 cait joined #koha
13:27 jcamins_away mtj: 8210 is rebased
13:58 tcohen joined #koha
14:08 Waylon zebra?
14:08 wahanui it has been said that zebra is a fielded free text indexing and retrieval engine with a Z39.50 front-end. You can use any compatible, commercial, or freeware Z39.50 client to access data stored in Zebra. or the search engine koha uses
14:08 Waylon zebra troubleshooting is see [understanding zebra indexing] and [yaz client]
14:09 zebra troubleshooting?
14:09 wahanui well, zebra troubleshooting is see [understanding zebra indexing] and [yaz client]
14:09 Waylon okay, bed time.
14:09 laters all
14:24 drojf joined #koha
14:52 cait joined #koha
14:52 chris_n` joined #koha
14:55 cait left #koha
15:20 tcohen hi #koha
15:21 mtj, have you seen bug 8773?
15:21 huginn 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=8773 enhancement, P5 - low, ---, tomascohen, Needs Signoff , Add per-instance koha-index-daemon in .deb setup
15:56 tomas joined #koha
16:28 mib_3j8e4w joined #koha
17:09 cait joined #koha
17:25 mbalmer joined #koha
17:48 cait joined #koha
17:54 * cait waves
18:23 drojf1 joined #koha
18:31 mbalmer left #koha
18:44 cait hi drojf :)
19:24 rangi @wunder nzwn
19:24 huginn rangi: The current temperature in Wellington, New Zealand is 12.0°C (7:20 AM NZST on September 17, 2012). Conditions: Rain Showers. Humidity: 94%. Dew Point: 11.0°C. Pressure: 29.65 in 1004 hPa (Steady).
19:25 cait ew
19:25 @wunder Konstanz
19:25 huginn cait: The current temperature in Taegerwilen, Taegerwilen, Germany is 12.8°C (9:25 PM CEST on September 16, 2012). Conditions: Clear. Humidity: 88%. Dew Point: 11.0°C. Pressure: 29.98 in 1015 hPa (Steady).
19:29 wajasu i played with DBIx last night.  I used the DBIx::Class::Schema::Loader to completely generate DBIx classes for our schema. wrote some simple queries using the objects.
19:30 rangi Yep there's a branch with that all done
19:30 The schema is all that interests me
19:30 wajasu now i a thinking of using them to help write tests.
19:31 rangi Specially ::versioned
19:31 wajasu do you want to use the db schema migration stuff?
19:31 rangi Hmm I wouldn't ... You wouldn't be testing the actual queries if you did that
19:32 But yes instead of updatedatabase.pl and the .sql
19:32 Use versioned schema
19:35 wajasu plus it has that DateTime component.  it would be nice to have time/durections normalized so folks writing scheduling/calender sensitive stuff would have an easier time.
19:35 durections/durations
19:37 i was thinking if someone wrote a OO domain model, that used the DBIx underneath, we could write tests for all the DB layer and the OO domain and services. before the implementation
19:38 we could assign bugs to folks to code/wire up the implementations, and uncomment the tests as part of the bugs.  then we could get the tests written.
19:39 rangi Yep but in the mean time (next 3 feature releases at least) we need to go from 56 to close to 100
19:39 Coverage
19:39 Before we start a major rewrite
19:39 Or we will break tons more than we fix
19:39 cait good point
19:40 rangi Rewrites are fun
19:40 But gotta do the hard work first
19:40 wajasu ok. so that is the plan. i'm with you.  so as i get more familiar with the codebase, i should just write tests so we don't fall behind.
19:41 rangi That would be awesome
19:43 wajasu for consistency sake, i would like a nice new OO domain model in there.  I wish I could test against that with the implementation calling our current stuff. then let people rewrite the implementations, while keeping the tests passing.
19:45 rangi OO isn't a panacea and shouldn't be thrown at everything
19:45 Especially structures that you have to coerce into being an object
19:45 wajasu true. but encapsulation is the goal.  composition...
19:45 rangi But I mostly agree with u
19:46 Goal is a fast system for end users
19:46 Everything else is a means to that
19:47 wajasu thats why i want to set up a stack with and without layers (with erformance/profiler, etc).
19:47 rangi Fast and stable
19:49 wajasu i did a reverse engineer of the db a coupld of months ago in java/hibernate, and there a number of schema issues (nullable keys, etc). when i did the same with DBIx, those issue are still there.
19:50 so as the architects discover them, i guess they can write a bug and baby step the schema to where is need to be.
19:50 rangi Fixing kohastructure.sql would be the first step then
19:52 My stop bbiab
20:14 kathryn joined #koha
20:17 wajasu http://wiki.koha-community.org[…]Coding_Guidelines has a link under (PERL13) POD that is broken these days.
20:23 jcamins_away rangi: I think I have to call BS on rewrites being fun.
20:23 Rewrites suck, and make me grouchy.
20:23 rangi people should stop doing them then
20:23 or at least stop making them the first thing they do, rather than the last
20:24 cos every rewrite of a major feature in koha, to this point
20:24 has been a huge pita for the next at least 6 months
20:25 jcamins_away This is true. Unfortunately, C4::Search is still sitting there, mocking our attempts to make any arbitrary input from the user work.
20:25 cait jcamins_away: but you started with writing tests for it :)
20:25 * cait is optimistic
20:25 * magnuse too
20:25 jcamins_away cait: I did.
20:26 And it's a damn fine test, if I say so myself.
20:26 magnuse hehe
20:26 cait :)
20:26 hi magnuse :)
20:26 wajasu i also wish there was separate "test" dependencies.
20:27 magnuse hiya cait
20:27 wajasu if say i want to use Test::Spec for BDD and write 50 tests.  i wouldn't want that to affect production deps.
20:27 jcamins_away wajasu: add it as optional.
20:28 wajasu ahh
20:28 jcamins_away I don't see any problem with that.
20:28 rangi and make it not in t/
20:28 but lower
20:28 because if it is in t/
20:28 jcamins Right.
20:28 rangi its not optional it is mandatory
20:28 wajasu gotch. like db_dependent
20:29 rangi yep
20:30 jcamins Or t/bdd/
20:31 wajasu getting back to the DBIx test idea.  i want to use th DBIx::Class::Schema::Loader to generate  OO code that is independent from the DB (myslq/postgres), then call our code, but use the DBIx classes to inspect the results. so when we rewrite, only the current calls have to be coded in the given: when: then scenarios.
20:32 jcamins wajasu: if that technique can test functionality *now* it sounds like a fine idea.
20:32 wajasu and the tests are more db independent
20:33 i'll try it out on something simple,  then something complex and you let me know if its good to go.
20:33 jcamins wajasu: as long as the tests give meaningful results, I will support the inclusion in Koha.
20:37 wajasu ok.
20:40 oh. by the way tried that XML::Easy and replaced XML::Simple.  Did the load_testing/benchmark_staff.pl  and got the same results.
20:41 i did notice: the zebra config sections have XIncludes and go grab those files and parse them as well. (XML::Simple does I assume), not that it makes a difference.
20:42 jcamins wajasu: actually, the Zebra config sections are not used, I think.
20:43 marcelr just reported that.
20:43 wajasu i wonder if creation of a new db connection is the issue, or if the fact that many places don't dbh->disconnect, causes mysql to "timeout" before cleanup.
20:44 jcamins wajasu: huh?
20:44 the first question?
20:44 wahanui "What are you trying to do?"  "What is the goal?" or "What problem are you experiencing?"
20:46 wajasu i was in C4, and grepped for dbh->disconnect.    I read that CGI supposedly cleans up?  but i also read on a site that if we don't cleanup the resource at the end of scripts, the database may have to "timeout".  so since i was running the apachebench benchmark, i wonder.
20:46 jcamins wajasu: so what is the problem you've encountered?
20:47 wajasu i'm wondering why/how that bug wants to get more performance.
20:48 the removal of XML::Simple.   I understand about memcache probably taking care of it.
20:48 jcamins What bug? XML parsing has nothing to do with connecting to MySQL.
20:49 wajasu bug 7170.
20:49 wahanui bug 7170 is what I was looking at
20:49 huginn 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=7170 normal, P3, ---, paul.poulain, REOPENED , Remove use of XML::Simple
20:49 jcamins Right, that has nothing to do with MySQL.
20:49 That is about how long it takes to parse koha-conf.xml.
20:51 wajasu i left the XML::Simple in, and added the parsing with XML::Easy  and the benchmark ran with the same time.
20:51 jcamins Right, it's not an important bug.
20:55 wajasu i was trying to understand if there was a perfomance issue setting up Context.pm  "too many queries, plus perl startup, plus db connection(no connection pool). And if that was the driving force to plackify.  If so, we should code a plackified context and benchmark.
20:57 jcamins C4::Context is not very efficient, but the bigger issue is the overall load time.
20:58 The difference between 22ms and 20ms just isn't that big a deal when you're talking about a total load time of 400ms+.
20:59 If you want to see what I'm talking about, run the following command: perl -MDevel::NYTProf -e "use C4::Search; use C4::Circulation; print 'Hello, world!';"
20:59 Then take a look at the results.
21:00 Obviously the faster your computer the less dramatic it will be.
21:00 wajasu ok. i will.
21:01 you mean the load time for perl.  right?
21:01 jcamins Load time for Koha's modules.
21:01 wajasu ahh.
21:01 jcamins I think I rembered the correct modules for the most dramatic effect.
21:01 *remembered
21:02 Jared joined #koha
21:03 jcamins ^^ not me
21:03 rangi heh
21:04 Jared Hello, I'm looking for information on Koha - Zebra permissions.  I'm installing on Fedora and am getting "Search biblios ERROR 109" from zebrasrv.
21:05 jcamins Jared: have you reindexed yet?
21:06 Jared files in "/var/lock/koha/zebradb/" are owned by the system user "koha".  Is this the same user as what is in /etc/koha/zebradb/zebra-biblios.cfg?
21:07 Have I reindexed?  I think so.  I have run "/usr/share/koha/bin/migrat​ion_tools/rebuild_zebra.pl -v -v -b -a"  I can send the output if that is helpful.
21:07 jcamins Jared: no. Zebra user and system user are unrelated.
21:08 Jared This is a new install...not an upgrade.  I did put one card/item in the catalog.
21:08 jcamins Jared: stick the output in paste.koha-community.org.
21:08 Full disclosure: I dislike non-Debian systems because they don't play nicely with Koha.
21:09 pastebot "Jared" at 127.0.0.1 pasted "rebuild script output" (29 lines) at http://paste.koha-community.org/175
21:09 jcamins Umm, add another -v.
21:10 Jared jcamins, can you describe how the permissions work?  HTTPd runs as user "apache"...that then calls out to zebrasrv.  zebrasrv (somehow) connects to actual files on the filesystem.
21:11 I added another -v, output is the same.  I can re-paste
21:11 jcamins No need.
21:11 See above about my hatred of non-Debian systems. ;)
21:11 zebrasrv is running as your koha user.
21:11 Jared Is there any concern about using a version of zebra that is too new?
21:11 jcamins The CGI script connects via socket.
21:12 No.
21:12 Jared yes, zebrasrv is being run after "su koha -"
21:13 jcamins You must run rebuild_zebra as that same user.
21:14 All Zebra files must be owned by that user.
21:14 However, 109 isn't a permissions error, I don't think... that sounds like a "Zebra isn't being run with the correct configuration" error to me.
21:14 Jared I did run rebuild_zebra as that user.
21:15 as far as I can tell, everything under /var/*/koha is owned by koha.koha
21:15 jcamins Yeah, so I think the problem you're running into is that Zebra is failing to use your configuration file.
21:15 Wait, how are you starting Zebra?
21:16 Jared how am I starting zebrasrv?  For now just on the command-line: "/usr/local/bin/zebrasrv -v all -f /etc/koha/koha-conf.xml"
21:16 * jcamins adds for the benefit of those just joining it that "Jared" is not me.
21:17 jcamins Paste that into paste.koha-community.org?
21:17 *in
21:17 Jared I can paste the output of ls -l on /var/*/koha...but all of the permissions look ok
21:17 I'll paste the zebrasrv output first.
21:17 jcamins No, nothing to do with permissions.
21:17 You should be getting a ton of output from zebrasrv.
21:18 pastebot "Jared" at 127.0.0.1 pasted "zebrasrv output showing error 109 (Fedora)" (109 lines) at http://paste.koha-community.org/176
21:19 Jared Is debian the only "officially" supported OS distro for koha?
21:20 jcamins Jared: I don't know about "official," but certainly you'll get a lot more help with Debian/Ubuntu.
21:21 Jared: try using yaz client directly.
21:21 yaz client?
21:21 wahanui yaz client is http://wiki.koha-community.org[…]ng_Zebra_indexing
21:21 Jared same error if I use Yaz client.  I can do it again, but previously, I got identical stuff in the zebrasrv log
21:21 jcamins I want to know what it says *before* you do the search.
21:22 When you connect to the server and set the database.
21:24 Jared from the yaz-client?
21:24 jcamins Right.
21:24 wajasu http://koha.1045719.n5.nabble.[…]em-td3072111.html
21:24 jcamins It should give you some sort of diagnostics, as I recall.
21:25 Jared there is some extra info, but it appears (to me) to connect to zebrasrv ok
21:26 jcamins Jared: hm, nothing about unrecognized option?
21:27 Jared I did paste the yaz-client output...but didn't see the paste link.  I'll paste it again.
21:28 pastebot "Jared" at 127.0.0.1 pasted "yaz-client output" (24 lines) at http://paste.koha-community.org/178
21:32 jcamins Jared: try doing the database init thing.
21:32 You won't get any results, but you might not get the error after it's done.
21:32 faq?
21:32 wahanui well, faq is found at http://koha-community.org/documentation/faq/
21:32 Jared database init is the reindex_zebra script?
21:33 jcamins No.
21:33 At the end of that file it has a suggestion of resetting your Zebra indexes.
21:34 Under "I have double ups..."
21:34 Oh, the init was removed.
21:34 Jared can you clarify "the database init thing"  Are you referring to "koha-rebuild-zebra"?
21:35 jcamins So, run that drop command, then do: zebraidx -c /path/to/zebra-biblios.cfg -d biblios init
21:35 I am telling you what to do.
21:35 Then do the commit.
21:36 Jared ok.  Do this as the koha user, I assume
21:36 jcamins Yes.
21:36 What version of Koha are you using?
21:36 I should have asked this first.
21:40 pastebot "Jared" at 127.0.0.1 pasted "biblios rebuild" (48 lines) at http://paste.koha-community.org/179
21:40 jcamins Ah-ha.
21:40 This is helpful.
21:40 Let me figure out what it helped us find out.
21:41 Jared interestingly, it says there was no biblios db when dropping it.
21:41 I have installed Koha koha-3.08.04
21:42 rangi id do the create before rebuild_zebra see if that fixes it
21:42 wajasu database unavailable:  the user/pass OR the perms usually.    following the KOHA_CONF to the koha-conf.xml  /var/lib/koha/...  make sure the user you run zebrasrv as has perms to read/write all the way  down that heirarchy.
21:45 jcamins wajasu: this isn't the standard no permissions error, though, I don't think.
21:45 Jared: share ls -l /var/lib/koha?
21:45 Jared wajasu: Yes, everything under /var/lib/koha is koha.koha
21:45 jcamins ls -lR
21:45 pastebot "Jared" at 127.0.0.1 pasted "/var/lib/koha permissions" (65 lines) at http://paste.koha-community.org/180
21:47 jcamins Interesting way of doing ls -lR. :)
21:49 pastebot "jcamins" at 127.0.0.1 pasted "Jared (not me): try this" (2 lines) at http://paste.koha-community.org/181
21:50 jcamins Jared: as you probably gathered, my name is also Jared, and it's kind of throwing me. ;)
21:51 pastebot "Jared" at 127.0.0.1 pasted "Output of zebraidx commands. zebrasrv still returns error 109" (52 lines) at http://paste.koha-community.org/182
21:52 Jared It's good to know there's another Jared out there.  There aren't too many
21:53 jcamins When I was younger, I had a class with another Jared.
21:55 I have no idea what's going on there.
21:56 Jared So, I'm trying to recap.  You had be run 4 zebraidx commands in an attempt to rebuild  zebra-biblios and zebra-biblios-cfg
21:56 sorry, zebra-biblios and zebra-biblios-dom
21:57 jcamins The first set was incorrect.
21:57 I caught that after the fact.
21:57 It should have been zebra-biblios-dom all along.
21:57 Jared Some more context for you, I have fedora, have installed all of the perl modules (via cpan)
21:58 I have yaz-3.0.49-1.fc13.x86_64 instaled as an RPM via yum
21:58 I have idzebra-2.0.52 installed via a tarball
21:59 and I have koha 3.08.04 installed.  When installing, I accepted all of the defaults from Makefile.PL
22:00 jcamins Oh, I bet I know what it is.
22:00 Jared I did run the install twice (make uninstall and re-ran gunzip & tar)  Same effect both times.
22:00 jcamins Did you open up the zebra-biblios-dom.cfg file and make sure that all the paths listed match where your files ended up?
22:00 In particular, I think there's a modulePath directive that is likely to be wrong.
22:02 Jared yes that path is wrong
22:03 jcamins Well, it took a while, but I knew we'd find it eventually. :)
22:06 Jared still getting error 109
22:07 jcamins Well, yes, that wasn't what was causing the problem.
22:07 Jared sorry, I'm on the phone for a few minutes.... Appreciate your ideas.  The module path was definitely wrong
22:15 Hi, sorry about that.
22:15 jcamins We need a "select all" button in the webinstaller.
22:16 Jared Do I need to drop and rebuild the databases and rerun the rebuild_zebra script?
22:16 jcamins Or to make the test clickable.
22:16 Yeah, repeat the init thing.
22:16 Jared ok, will do
22:16 do authorites-dom and biblios-dom or all 4?
22:17 jcamins zebra-biblios-dom
22:17 The init and commit commands.
22:18 Hey, the password field on master is an actual password box.
22:18 Nice!
22:20 rangi 3.8.x too
22:20 jcamins Oh, I haven't created any new users in my 3.8.x installs.
22:21 pastebot "Jared" at 127.0.0.1 pasted "Rebuild steps" (3 lines) at http://paste.koha-community.org/183
22:21 Jared hmm, so despite the changes, I still get error 109.
22:22 jcamins And you got no output?
22:22 Jared one other thing I did notice, is that by default, stuff is installed to /usr/local/bin, which is not in the default path on fedora.
22:22 jcamins Also, try just those first two lines.
22:25 mib_05oev3 joined #koha
22:30 cait left #koha
22:31 Jared I think the takeaway is that this zebra stuff just doesn't work on fedora/centos/rhel.  I'd encourage you to document this somewhere
22:31 I'll have to setup a debian install and test it again there.
22:32 jcamins Jared: I think we've documented it repeatedly.
22:32 And it's not that it can't be made to work.
22:32 Jared then my apologies, I missed it.  What is the best supported distro...latest debian?
22:33 jcamins One developer uses Fedora.
22:33 Jared: no, that was documented, past tense. I don't think it's so much that you missed it as the "use Debian" recommendation was replaced with "here's how I got an old version of Koha to almost run on Fedora."
22:33 Yeah, Squeeze is the way to go.
22:33 packages?
22:33 wahanui packages is, like, at http://wiki.koha-community.org/wiki/Debian
22:34 jcamins ^^ follow that guide.
22:34 It's dead simple.
22:46 wajasu http://www.loc.gov/z3950/agenc[…]fns/bib1diag.html
22:46 i always have to run zebra as root.
22:47 jcamins wajasu: then you have your system set up wrong.
22:47 If you're satisfied with that, though, I suggest you just leave it.
22:47 wajasu i could not infer it fromthe INSTALL instructions. 4 years ago.
22:48 the problem was apache was so different from debian
22:49 none of the same command line tools that apache has.  but i was on archlinux.
22:49 i'm about to upgrade to 3.10 once that's released.
22:50 and run debian in a VM.
22:52 it would take 4hours to assemble dependencies from cpan, and build archlinux packages.  perl didn't have but a couple of koha's deps. so i saw the light. debian.
23:18 papa joined #koha
23:27 libsysguy joined #koha
23:30 libsysguy joined #koha
23:42 wajasu jcamins: that nyt report is great. thx
23:42 jcamins wajasu: you're welcome. Kind of extraordinary, isn't it, how long it takes for Koha modules to load?
23:43 wajasu yup.
23:48 i got 1.29secs total with koha running in a VM with /home/koha/kohadev in the VM filesystem and /home/koha/kohaclone sshfs mounted to my hostOS.
23:48 jcamins Heck of a lot faster than on my laptop.
23:48 2.57s.
23:49 wajasu so the more deps the slower.  but if they plackify, they are preloaded, and only what is needed is run in on plackified scripts. right ?
23:50 jcamins Right.
23:50 The BEGIN blocks are run exactly once under Plack.
23:54 wajasu i am really glad you are getting search up to par.   i hope with your future search plugins, you make a composable plugin, where one can stack them, and configure it so that (a) if no results, run the second, (b) run in parallel with immediate results from one, and asynchronous ajaxified rsults arriving right behind.
23:55 but i know there is alot of work to do before that.
23:55 jcamins I am designing the system so it would be possible to do that.
23:56 wajasu i could tell.

← Previous day | Today | Next day → | Search | Index

koha1