Evergreen ILS Website

IRC log for #evergreen, 2013-09-12

| Channels | #evergreen index | Today | | Search | Google Search | Plain-Text | summary | Join Webchat

All times shown according to the server's local time.

Time Nick Message
02:06 Mark__T joined #evergreen
02:13 pinesol_green` joined #evergreen
03:40 paxed berick: http://bilious.alt.org/~paxed/eg/winlinux_diff.txt diff of osrfsys.log after reloading the patron reg in linux vs. windows staff client.
03:46 paxed berick: that's massaged a bit, to replace all variable numbers, such as timestamps, hash and array addresses, etc. with static values.
03:48 paxed berick: i don't know if that's helpful
03:49 paxed at least it clearly shows the locale difference - en-US from windows, fi-FI from linux
06:01 dboyle joined #evergreen
06:29 RBecker joined #evergreen
06:35 b_bonner joined #evergreen
06:35 mtcarlson_away joined #evergreen
07:49 Dyrcona joined #evergreen
07:50 jboyer-isl joined #evergreen
07:54 collum joined #evergreen
08:04 phasefx joined #evergreen
08:08 Dyrcona joined #evergreen
08:19 akilsdonk_ joined #evergreen
08:19 rjackson-isl joined #evergreen
08:36 kmlussier joined #evergreen
08:36 kbeswick joined #evergreen
08:50 Shae joined #evergreen
08:53 36DABFVPU joined #evergreen
08:53 timf joined #evergreen
08:58 mmorgan joined #evergreen
09:16 adbowling-isl joined #evergreen
09:26 ericar joined #evergreen
09:33 kmlussier1 joined #evergreen
09:40 csharp bshum: dbs: reading yesterday's scrollback on the KPAC stuff... PINES is going to implement KPAC in the near future, so with more adoption, it will hopefully stop being "the new craftsman" ;-)
09:41 yboston joined #evergreen
09:42 * csharp also presumes that KCLS will probably implement it after they upgrade to 2.4.X
09:42 csharp since they were another major funder of the project
09:46 kmlussier1 I know some of the MassLNC networks have talked about implementing it, but I don't know when.
09:55 bshum A few folks have asked us about the pictures used in our KPAC. Makes me wish we had gotten better (and resharable) stock images for the core build.
09:55 BigRig joined #evergreen
09:55 bshum So there is interest in varying stages of   poking at the images/config.
09:56 bshum I'm just a whiner.
09:56 bshum :P
09:57 mllewellyn joined #evergreen
09:57 csharp we have a huge set of images, but they are not licensed to be re-shared
09:58 csharp it would be great if we all used CC-licensed stuff, but those decisions are out of my control
09:59 bshum Likewise in our implementation. And out of my hands too.
10:01 Dyrcona I usually cc-sa-by for MVLC documents.
10:02 gmcharlt as a data point, the PaILS consortium is using KPAC; they've only *just* upgraded to 2.4, though, so haven't done much tweaking yet
10:03 DPearl joined #evergreen
10:04 bshum gmcharlt: Yay!
10:16 dbs Yay, more adoption is definitely good, particularly by sites that can contribute support etc :)
10:26 misilot joined #evergreen
11:01 kmlussier graced++ #IRC tutorial
11:01 kmlussier graced: I was planning to add a link to my quick start guide to the Evergreen IRC page. Can I link to your tutorial too?
11:02 graced kmlussier: happy to help any way I can - of course, link away!
11:02 graced kmlussier: I'll send you the follow up one as soon as I finish it.
11:10 * csharp adds a "how to get snarky with the bot" section
11:10 csharp pinesol_green`: am I right?
11:10 pinesol_green` csharp: Mr. Spock: Something fascinating just happened.
11:11 csharp @dunno
11:11 pinesol_green` csharp: Try restarting apache.
11:11 csharp @quote random
11:11 pinesol_green` csharp: Quote #35: "<tsbere> We have collective sanity left? We might want to double-check on that. ;)" (added by bshum at 05:00 PM, November 06, 2012)
11:15 Dyrcona csharp: I tried restarting apache, and it all it said was: [Thu Sep 12 11:03:41 2013] [warn] NameVirtualHost *:80 has no VirtualHosts
11:17 csharp ha!
11:18 csharp LOL IM IN UR APACHE STELING UR VIRTUALHOSTS
11:18 ktomita joined #evergreen
11:18 Dyrcona heh.
11:19 Dyrcona I'm setting up a SSL-only server and hadn't edited ports.conf, yet.
11:25 kbutler joined #evergreen
11:28 ktomita_ joined #evergreen
11:35 zerick joined #evergreen
11:37 ericar joined #evergreen
11:41 jdouma joined #evergreen
11:47 dbs ooh, seq scan on metabib.record_attr, that's fun
11:48 jeff ow
11:52 dbs http://explain.depesz.com/s/tdy1 -- that's the result of looking up a bookbag. spectacular plan!
11:55 * dbs wonders why the CTE is getting LEFT JOINed instead of INNER JOINed. That seems to be what's causing the damage.
11:56 jeff dbs: bunck os disk thrashing sorting on mrd.id also, it seems.
11:57 jeff bunch, even
11:57 dbs jeff: of course
11:57 jeff oh, which would probably be less if it weren't being left-joined.
11:58 dbs If I change the left join to an inner join, the run time drops to  0.960 ms
11:59 dbs http://pastebin.ca/2449017 for the raw stuff
12:00 * eeevil looks
12:01 paxed with his eeevil eye
12:01 fparks joined #evergreen
12:01 smyers_ joined #evergreen
12:01 eeevil :)
12:02 eeevil dbs: I have the same question about the outer join of container_x98568b0
12:04 * tsbere suspects he knows why on the container join
12:06 tsbere I had a use case when bouncing around in queryparser of "is not in this container but matches other stuff" and containers were hardcoded includes at the top level at the time, if I am not mistaken
12:06 dbs looks like it's hard-coded to always be a left join for containers
12:06 eeevil dbs: does the plan change from Bad(tm) if the container join is made INNER instead of (or in addition to) the mrd join?
12:06 dbs eeevil: if you mean s/LEFT JOIN
12:06 dbs / INNER JOIN/ then it goes from 21s to 1ms
12:07 eeevil yes, that's what I meant
12:09 dbs This is where I get that horrible feeling that I know how to fix this particular problem, but have no idea if a simple s/LEFT/INNER/ for that clause in line 1099 of Driver/Pg/QueryParser.pm is going to blow up other things.
12:09 eeevil tsbere: since there's always an "is not null" clause added the the where currently, let's make it inner. if that use case comes back, we can reinvestigate
12:09 eeevil I'm disappointed that PG isn't seeing the LEFT+NOT_NULL as an INNER, though
12:09 tsbere eeevil: Is that the case? If you use the actual container(blah,blah) format with an || does it still include an "is not null"?
12:10 * tsbere understands that bookbag loading always sticks the container() at the top level, which likely results in the "is not null", but the syntax can be used elsewhere
12:10 eeevil tsbere: looks to me like line 1104 is unconditional
12:11 tsbere eeevil: Change container(blah...) to !container(blah...)?
12:12 eeevil tsbere: that should be IS NULL, then. and could be made smarter easily. I'll offer a patch in a minute that won't break that
12:14 tsbere eeevil: For more fun, I would also like !(container(blah...) otherstuff) to continue to work....we have someone that wants "things that are in container 1 excluding any movies in container 2" fairly often. >_>
12:14 ktomita joined #evergreen
12:15 eeevil tsbere: I'll leave negated containers as LEFT joins is what I'm saying
12:15 eeevil but the common case, container(blah), can be optimized
12:15 acoomes joined #evergreen
12:15 eeevil as can the mrd join
12:16 tsbere eeevil: !(container(blah) otherstuff) is a non-negated container inside of a larger negated segment. I just want to make sure that your optimization takes that into account.
12:17 eeevil tsbere: is that in use today? "someone that wants" suggests no to me
12:18 RBecker joined #evergreen
12:18 tsbere eeevil: "someone that wants" = "I give them a stupid search query every other week because they can't get the syntax through their head"
12:18 tony_ joined #evergreen
12:19 * tsbere also has to regularly remind them to share the containers
12:19 ktomita_ joined #evergreen
12:20 tony_ I have a question that I know I've just overlooked something Why install Evergreen 2.4.2 as opensrf I'm getting this error during ./configure "configure: error: /bin/bash ./config.sub ./configure failed"
12:28 dboyle joined #evergreen
12:29 mrpeters joined #evergreen
12:29 mrpeters left #evergreen
12:30 mrpeters joined #evergreen
12:31 eeevil dbs: maybe this? http://pastebin.ca/2449039
12:32 eeevil tsbere: top_plan is a bigger hammer than I'd like, but will certainly preserve your desire
12:34 dbs eeevil: will give it a look-see
12:34 eeevil dbs: thankee
12:35 acoomes joined #evergreen
12:37 tony_ == I have a question that I know I've just overlooked something Why install Evergreen 2.4.2 as opensrf I'm getting this error during ./configure "configure: error: /bin/bash ./config.sub ./configure failed"
12:38 dbs eeevil: perl -c says "Useless use of not in void context at line 1099"
12:38 dbs tony_: need more info, can you paste more of the failure log?
12:39 tony_ dbs_: ./configure: line 1945: config.log: Permission denied
12:40 dbs tony_: okay, sounds like you ran configure under a different user before?
12:40 * dbs typically uses the "evergreen" user to do everything
12:41 tony_ I did it under the opensrf I thought maybe did it under root...  not sure....  Okay what would be the best plan of attack to fix this... should I rerun opensrf 2.2.0 all over and just the Evergreen side
12:42 tony_ "or just Evergreen"
12:42 paxed sudo chown -R tony.tony *
12:43 tony_ paxed_ and then run it as myself?
12:43 paxed configure can be run as user with no root privs.
12:45 eeevil dbs: doh, operator precedence ... my $optimize_join = 1 if $self->top_plan and !$NOT; # more readable
12:45 tony_ paxed_ tried your idea and the system throw another error "configure: error: /bin/bash ./config.sub ./configure failed"
12:46 tony_ paxed_ "thru"
12:46 dbs tony_: still need more of the failure log
12:47 tony_ _dbs okay hang-on let me pull the logs
12:47 dbs tony_: well, even just the last 10 lines that were printed to the screen
12:47 dbs eeevil++ # that looks better. now to give it a shot on our test server...
12:48 eeevil dbs: thanks, man!
12:52 tony_ dbs_ Sep 11 18:10:22 finish-install: info: Running /usr/lib/finish-install.d/07brltty Sep 11 18:10:22 finish-install: cat: read error: Is a directory Sep 11 18:10:22 finish-install: sh: you need to specify whom to kill Sep 11 18:10:22 finish-install: info: Running /usr/lib/finish-install.d/07preseed Sep 11 18:10:22 finish-install: info: Running /usr/lib/finish-install.d/07speakup Sep 11 18:10:22 finish-install: info: Running /usr/l
12:53 tony_ dbs_ Sep 11 18:10:22 finish-install: Disabling CD in sources.list Sep 11 18:10:22 finish-install: info: Running /usr/lib/finish-install.d/10clock-setup Sep 11 18:10:22 anna-install: Installing os-prober-udeb Sep 11 18:10:22 os-prober: File descriptor 3 (pipe:[1247]) leaked on lvs invocation. Parent PID 28714: log-output Sep 11 18:10:22 os-prober: File descriptor 4 (/dev/pts/0) leaked on lvs invocation. Parent PID 28714: log-output
12:53 dbs tony_: uh, that's a different log I think :)
12:54 tony_ dbs_ I need to go to bed-- I'm giving you the syslog
12:54 dbs tony_: yeah, that's not going to help, sorry :/
12:54 Rish joined #evergreen
12:55 tsbere tony_: config.log might be a better place to look if configure is failing
12:58 akilsdonk_ joined #evergreen
12:59 tony_ tsbere_ the config logs aren't in there..
13:04 tony_ tsbere which directory should I be looking into
13:05 paxed in the same dir as configure
13:05 tony_ paxed I thought that is where I just looked and couldn't find it
13:05 tony_ paxed let me look again
13:06 dbs eeevil: /me can confirm that bookbags are now crazy-fast as expected with that patch in place
13:08 dbs alternately, not as crazy slow :)
13:09 gmcharlt dbs: I do believe crazy-fast bookbags would be the ones that self-populate with recommendied reading ;)
13:11 tony_ dbs what parts of this log do you want...
13:11 tony_ dbs can't believe how many times I looked at this file and just couldn't see it
13:13 eeevil dbs: wheeee.... I'll toss it on LP
13:13 tony_ dbs here you go: ## ----------- ## ## Core tests. ## ## ----------- ##  configure:2342: checking for a BSD-compatible install configure:2410: result: /usr/bin/install -c configure:2421: checking whether build environment is sane configure:2471: result: yes configure:2612: checking for a thread-safe mkdir -p configure:2651: result: /bin/mkdir -p configure:2664: checking for gawk configure:2694: result: no configure:2664: checking fo
13:14 tony_ configure:2680: found /usr/bin/mawk configure:2691: result: mawk configure:2702: checking whether make sets $(MAKE) configure:2724: result: yes configure:2842: checking build system type configure:2853: error: /bin/bash ./config.sub ./configure failed
13:14 dbs tony_: when you run ./configure --whatever, just the last screen or two of whatever gets printed to the screen. And ideally paste to http://pastebin.ca or the like
13:18 tony_ dbs did that work for you
13:21 eeevil dbs: separately, we should probably move the mrd join up to immediately after the core table
13:22 dbs tony_: sorry, that didn't really help :/
13:26 tony_ dbs okay whatelse would be helpful
13:32 eeevil dbs: https://bugs.launchpad.net/evergreen/+bug/1224593
13:32 pinesol_green Launchpad bug 1224593 in Evergreen 2.4 "Optimize container filters in QueryParser" (affected: 1, heat: 6) [Undecided,New]
13:34 bshum eeevil++ dbs++
13:36 pinesol_green [evergreen|Bill Erickson] LP1193095 lineitem batch actions sanity filters - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=a9d8827>
13:41 tony_ dbs thank you for all your help.. I found my own error and I would call the error (User Error)
13:42 pinesol_green [evergreen|Thomas Berezansky] Add Zoom support to browser views - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=8f3ced2>
13:42 pinesol_green [evergreen|Bill Erickson] LP#1084758 store staff client tpac (etc) zoom pref - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=2e447f3>
13:43 stevenyvr2 joined #evergreen
13:46 pinesol_green [evergreen|Mike Rylander] Optimize container filters in QueryParser - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=d1d41d1>
13:48 eeevil grabbing 0826
13:48 dbs tony_++
13:49 dox joined #evergreen
13:49 dox evergreen is beautiful. trying to get the school i contract for to drop follett
13:52 phasefx dox: :-)
13:53 dox just wondering how generally difficult it is to get up and going, but i still have to read thru the documentation
13:54 dox doesnt look difficult at all
13:54 bshum Famous last words?  :)
13:54 dox probably, haha
13:55 pinesol_green Showing latest 5 of 7 commits to Evergreen...
13:55 pinesol_green [evergreen|Jason Etheridge] internal: an alternative to default_focus - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=35bbeae>
13:55 pinesol_green [evergreen|Jason Etheridge] internal: JSAN socket library - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=6de0fc1>
13:55 pinesol_green [evergreen|Jason Etheridge] JSAN module autoloader for "add-ons" - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=8095a2e>
13:55 pinesol_green [evergreen|Jason Etheridge] P.V. SUPA GoodStuff integration - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=c31c7ab>
13:55 pinesol_green [evergreen|Mike Rylander] Stamping P.V. SUPA upgrade scripts - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=5d546cc>
13:56 bshum But seriously, dox, that's awesome.  And we do try to keep good notes on how to get Evergreen installed.
13:56 dox yeah the documentation is excellent ;D
13:56 bshum From there, you might find some good tips from the book of evergreen to get started too
13:56 bshum http://evergreen-ils.org/dokuwiki/do​ku.php?id=books:evergreen_in_action
13:56 eeevil grabbing 0827
14:00 paxed dbs: some of the Fez puzzles are fiendish!
14:03 pinesol_green [evergreen|Remington Steed] Allow action trigger events to be repeated - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=86db717>
14:03 pinesol_green [evergreen|Remington Steed] Release notes for Action Trigger Event Repeatability - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=085fb6c>
14:03 pinesol_green [evergreen|Mike Rylander] Stamping upgrade script for repeatable events - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=75817fa>
14:13 bshum B&T--
14:13 bshum The saga continues!
14:13 kmlussier What now?
14:14 bshum Just weird PO JEDI wackiness
14:14 bshum Due to their request to add some more kludges to the template to handle orders special.
14:19 dox do you guys have any users that have converted/migrated their library collection from follett to evergreen? just wondering how smooth/difficult it may be...
14:21 bshum Some of our school libraries in our consortium migrated from Follett to Evergreen a couple years ago.  We actually contracted with a third party vendor to help perform the migration for us.
14:22 bshum As far as I know everything was converted nicely.
14:24 dox ah ok, i see
14:26 bshum My sense is that it largely depends on what sort of data you want to retain.
14:28 jeffdavis Some legacy ILSs are easier to get data out of than others.
14:29 bshum I think in our case, the school only opted to transfer their bibs and item holdings
14:29 bshum And then we loaded new student data exported from their student database from scratch
14:29 bshum So we didn't bring over any circulation information.
14:30 GeoffSams joined #evergreen
14:33 gsams joined #evergreen
14:39 jeffdavis dox: We've done a few Follett migrations as well. I didn't work on them myself but I don't recall any unusual difficulties (we have a lot of migration experience).
14:39 bshum senator++ # edi madness has ended :)
14:39 bshum (for now)
14:39 berick gmcharlt: look familiar?  http://guardianlv.com/2013/09/grotesqu​e-blobfish-proclaimed-ugliest-animal/
14:40 * gmcharlt twitches uncontrollably
14:41 berick it's official.  The "MARC Blob" is the world's ugliest creature
14:41 dox thanks for the advise- i doubt they will pick evergreen because of the sysadmin necessities but who knows
14:41 dox advice*
14:41 gmcharlt berick++
14:46 tater mrpeters: the eg-stats-collector is licensed. You can view it at http://git.evergreen-ils.org/?p​=contrib/equinox.git;a=summary
14:47 mrpeters thanks.   actually, none of the files actually have a license, nor does the README so i just wanted to confirm.
14:48 gmcharlt the LICENSE file at the top level of the repo applies to its contents, unless a different license is mentioend  by a specific file
14:49 mrpeters gmcharlt: ah, i see.  thanks.
15:10 mrpeters fwiw, why I was asking --- http://git.evergreen-ils.org/?p=workin​g/Evergreen.git;a=shortlog;h=refs/head​s/user/mrpeters/check_pgbackup_nagios
15:10 mrpeters hope that's kosher....i borrowed some date variable setting code from parse-eg-stats.pl
15:18 akilsdonk_ joined #evergreen
15:25 jboyer-isl joined #evergreen
15:28 paxed arrrgghh
15:32 tony_ Could someone help me with a postgres 9.1 issue -- I'm getting this ERROR:  could not open extension control file "/usr/share/postgresql/9.1/​extension/plperl.control": No such file or directory
15:32 tony_ I don't know the best process to clear this up
15:34 senator tony_: dpkg -l | grep postgresql-contrib-9.1
15:34 senator does that return anything?
15:34 senator err, hang on, i typo'd
15:34 tony_ senator: no it didn't return anything
15:35 senator dpkg -l | grep postgresql-plperl-9.1
15:35 senator ^-- that's what i actually meantm
15:35 dMiller_ joined #evergreen
15:35 tony_ ^--- so do you think that did the trick or was I expectin something
15:36 senator that command doesn't fix anything, it just tells you what you're missing
15:36 senator the second one returns nothing too?
15:36 tony_ senator what other one
15:37 senator the version where i corrected myself and replaced 'contrib' with 'plperl'
15:38 tony_ ^-- Oh I didn't see that one
15:38 senator if that one also yields no output, it suggests steps missed during evergreen installation
15:39 tony_ It returned nothing..  so re-do the install for Evergreen or just Postgres
15:39 senator the prerequisites installer, the bits about "Makefile.install"
15:40 tony_ Okay let me try that
15:40 senator postgres by itself would be super easy
15:40 senator these are steps from the evergreen docs i mean
15:40 hopkinsju Hi Everyone! Quick question about these upgrade scripts (yes, I'm still working on that)... Going from 2.3.3. to 2.4.1: Should I run 2.3-2.4.0-upgrade-db.sql, 2.3-2.4-supplemental.sh, 2.4.0-2.4.1-upgrade-db.sql in that order?
15:40 tony_ I understood
15:52 csharp hopkinsju: yes, I think so
15:52 hopkinsju csharp++ Thanks!
16:13 AnoopGatewayChec joined #evergreen
16:14 AnoopGatewayChec left #evergreen
16:35 pinesol_green [evergreen|Pasi Kallinen] Allow translation of acq.cancel_reason texts. - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=777798d>
16:43 pinesol_green [evergreen|Bill Erickson] LP#856688 OUS to disable org unit as hold pickup lib - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=33206c4>
17:01 bshum dbwells++ # got the LDAP test script to authenticate with the right credentials.  Very handy, thank you sir!
17:10 mmorgan left #evergreen
17:13 hopkinsju joined #evergreen
17:18 mrpeters left #evergreen
17:26 dMiller_ joined #evergreen
18:16 pinesol_green [evergreen|Pasi Kallinen] Fix PCrudFilterPane generating illegal queries when using the "not like" and "not between" operators. - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=052d0ee>
18:49 Guest31777 joined #evergreen
18:53 RBecker_ joined #evergreen
19:15 zerick joined #evergreen
19:22 RBecker joined #evergreen
19:23 stevenyvr2 left #evergreen
19:50 RBecker joined #evergreen
20:47 RBecker joined #evergreen
21:12 shadowspar joined #evergreen
21:38 RBecker joined #evergreen
22:26 zerick joined #evergreen
23:11 stevenyvr2 joined #evergreen
23:11 stevenyvr2 left #evergreen
23:29 misilot joined #evergreen
23:49 tony_ joined #evergreen
23:51 tony_ can someone tell me how to fix fopen: Permission denied when installing ejabberd..  I've done a --purge ejabberd and I get this error at that time and when I do an apt-get install I get the same error

| Channels | #evergreen index | Today | | Search | Google Search | Plain-Text | summary | Join Webchat