Open Source Integrated Library System

Evergreen on IRC

#evergreen Logs for Monday, November 14th, 2011

< Sunday, November 13th, 2011Raw Log FileTuesday, November 15th, 2011 >
#TimeNickMessage
#00:24:45youdonotexist has joined #evergreen
#00:31:37youdonotexist has quit IRC
#04:41:36adm_ils has joined #evergreen
#04:49:11adm_ilsi have setup an action trigger with hook hold .capture in my staff client,n now when i am capturing that item,i should recive an mail ,for this purpose i even has setup my mail server ,but i am not receiving any mail yet.i have check in error.log file and i am getting one error over there that is : [error][client 192.168.1.66] File does not exist :/openils/var/web/xul/red_2_1_0/server/util/print_custom.js , the ip in error is of s
#06:58:57lisppaste has quit IRC
#07:11:21adm_ilsne1 can ans me plz?
#07:16:16Helenbeanits still really early
#07:24:54adm_ilshelenbean-means?
#07:25:53Helenbeanthe time of day. meaning I see much more chat at later hours.
#08:10:54fortin has joined #evergreen
#08:20:21adm_ilsne1 now can ans me plz
#08:38:02AaronZ-PLS has joined #evergreen
#08:42:08Dyrcona has joined #evergreen
#08:46:03dbwells_ is now known as dbwells
#08:49:55Dyrcona has quit IRC
#09:01:31dbwells has quit IRC
#09:04:22Callender has joined #evergreen
#09:04:27adm_ilsne1 can ans me plz
#09:18:57dbwells has joined #evergreen
#09:19:36Meliss has joined #evergreen
#09:21:41Meliss has joined #evergreen
#09:30:56jenny has joined #evergreen
#09:31:19adm_ils has quit IRC
#09:32:14jenny1 has joined #evergreen
#09:35:45jenny has quit IRC
#09:41:39tecoripa has joined #evergreen
#09:48:28mrpeters-isl has joined #evergreen
#10:00:10Dyrcona has joined #evergreen
#10:15:22moodaepo has left #evergreen
#10:19:47moodaepo has joined #evergreen
#10:28:39mrpeters-isl has quit IRC
#10:28:49mrpeters-isl has joined #evergreen
#11:17:05dbs has joined #evergreen
#11:56:34sal_ has joined #evergreen
#12:00:03Dyrcona has quit IRC
#12:09:14mrpeters-islSQL stumper -- anything stick out as wrong in my query to cause this to return both rows, rather than grouping on the money.payment.id? http://pastie.org/2862613
#12:10:17mrpeters-islthe most recent "last_billing_type" in money.billable_xact_summary is the "Lost Materials Processing Fee". I'm not sure why it's trying to create a second duplicate result for the "Lost Materials" bill.
#12:10:44tsbereGroup by 12 is causing the two lines. One for Lost Materials, one for Lost Materials Processing Fee.
#12:12:22tsbereSo you are getting 1 row for each billing type associated with the transaction
#12:12:51mrpeters-isloh, crap
#12:12:52mrpeters-islok
#12:12:53tsbereYou will get the same issue for multiple note values on the billings of the transactions
#12:12:57tsbereetc and so forth
#12:13:07mrpeters-islyeah, ok
#12:13:10tsbereProbably for multiple payment note values too ;)
#12:13:14mrpeters-islyep
#12:14:45dbseeevil: Your attachment for the 880 stuff didn't come through, I think
#12:18:57mrpeters-islso, if i dump those i get "ERROR: column "mb.note" must appear in the GROUP BY clause or be used in an aggregate function LINE 3: mb."note" AS "Bill Note". what am i missing there?
#12:20:31bgoble has joined #evergreen
#12:21:37mrpeters-islsounds like it is not permissible to include column names in a SELECT clause that are not referenced in the GROUP BY clause. is there a workaround?
#12:23:18mrpeters-islthe key i guess is getting just the most recent note, btype, etc.
#12:25:37mrpeters-islill just wrap those columns in a max()
#12:35:45tsberemrpeters-isl: You could add to your join clauses to include, say, the max billing date, or max payment date
#12:44:42Dyrcona has joined #evergreen
#12:44:42edoceoDid my install to /opt/open-ils/ - just for grins - noticed that some things had to be manually updated to work properly (setting paths &c) -
#12:47:48dbsedoceo: that's why we still recommend /openils/ - there are open bugs for making it truly relocatable awaiting patches
#12:48:13jeffedoceo: There are probably several gotchas with that. I admire your desire to test -- patches welcome! :-)
#12:48:22edoceo heads to LP
#12:48:57jeffedoceo: (or heck, even bug reports if you find issues that aren't covered by an existing bug)
#12:49:32dbs fails to find said bugs
#12:49:41edoceome too
#12:50:02edoceoBut I know they are there, due to my recent experience
#12:50:12dbsedoceo: I know they are there due to my ancient experience
#12:50:23edoceoSo...one bug per incident or one bug for all the stuff I can find at this time?
#12:50:26dbsand bjwebb knows there are there from his summer experience
#12:50:44dbsedoceo: I would suggest one bug, unless you have separate patches for separate issues.
#12:52:09edoceoI don't know what I got just yet...this is an install from 2.0.1a; so I'll likely have to get the git-master, -> autogen -> configure make & make install for that huh?
#12:53:27dbsideally, yeah
#12:54:13eeevildbs: heh, yeah, just noticed that :)
#12:57:36edoceoSo along with paths, perhaps there is some hard coded database names ("evergreen") too?
#12:58:47dbsedoceo: I don't think so
#12:59:05dbsedoceo: and there shouldn't be many hard-coded paths left
#12:59:16dbsthe "opensrf" user is very hardcoded though
#13:00:40edoceoWhen I run the settings_tester.pl I see an error from app_settings trying to get to dbi:Pg:dbname=evergreen ( but else where its dbi:Pg:dbname=openils
#13:01:30dbsedoceo: oh, settings-tester. True, that might be afflicted.
#13:05:40edoceoOh, I found it... qstore in opensrf.xml didn't have their database stuff updated
#13:15:22dbsedoceo: yeah, never does because qstore isn't actually used in Evergreen. That said, I think we smartened settings-tester up in master
#13:24:47pmpcat has joined #evergreen
#13:38:50matt_carlson has joined #evergreen
#13:40:41dbsaha! naco_normalize is messing things up (re: indexing words like "t'aime" which gets converted to "taime" before being passed onto the PostgreSQL FTS stuff)
#13:43:04dbs$txt =~ tr/\'\[\]\|//d; -- finally tracked it down
#13:47:44sal_ has quit IRC
#13:55:12kmlussier has joined #evergreen
#13:58:51dbsgmcharlt: would love to hear what you think about breaking NACO rules and instead of simply stripping apostrophes, leaving them in and letting the pgsql FTS tokenizer deal with them
#14:00:02dbsfwiw, with the corresponding change in O:U:Normalize.pm and a restart of open-ils.search results seem to be good (e.g. search for either "t'aime" or "aime" works because the phrase "t'aime" gets tokenized as "t aime"
#14:03:56mrpeters-islwhat's wrong with this picture -- TORNADO WATCH for Indiana in NOVEMBER!
#14:04:21Dyrconamrpeters-isl: global warming.
#14:05:07mrpeters-isllol i guess man...i thought sure it was a snow storm warning when it popped up in firefox
#14:05:38Dyrconadbs: re: your later: we get the records from the vendor with just a " " for indicator 2 in the 856.
#14:05:39mrpeters-islbut sure enough...some nasty storms developing...thats what you get when it drops from near 80 to 40 degrees
#14:05:56dbsDyrcona: bad, non-compliant vendor
#14:06:08dbs gets a zap collar for said vendor
#14:06:13Dyrconadbs: standard says " " is allowed, but meaningless.
#14:06:19dbsDyrcona: exactly
#14:06:38dbswhich is why no located URI gets generated. meaningless in, nothing out :)
#14:06:43Dyrconadbs: anyway, my real question is it intentional that URLS only show in TPac when there is a located URI?
#14:06:45dbs calls in the Vendor Whisperer
#14:07:02Dyrconadbs: the " " isn't the issue, I can change those easily enough.
#14:07:42dbsDyrcona: that's certainly my intention. The JSPac dates back to a time before located URIs, so rather blindly threw 856s out for consumption.
#14:08:13Dyrconadbs: thanks. that's what I wanted to know. so I need to modify our records for tpac.
#14:08:31dbs is just one dev, though, and not much of one recently at that :(
#14:08:57Dyrconadbs: that should definitely be in the release notes when tpac becomes "official."
#14:09:54dbsDyrcona: oh - wait, I might have answered hastily, I don't think we intend to require located URIs - but certainly a second indicator of 0 or 1 should be the minimum bar
#14:10:32dbs could easily waffle on that front - if somebody catalogs Wikipedia, do we really want to have to specify $9 CONS ?
#14:10:44gmcharltdbs: since NACO normalization as originally conceived is fundamentally about matching headings, not search normalization per se, I'm open to judicious deviations from the spec
#14:10:45Dyrconadbs: even with id2 = 0 they don't show up unless I add the $9.
#14:11:01gmcharltthough we should keep a strict version of the routine around for, well, normalizing authorized headings
#14:11:15dbsDyrcona: right, so the ind2 = ' ' is a complete red herring in this discussion
#14:11:25dbslet us speak of it no more
#14:11:29Dyrconadbs: right at this point.
#14:11:58dbsgmcharlt: create a naco_normalize_mostly() variant? :)
#14:13:11gmcharltdbs: heh. default_search_normalize() might be a better name, though
#14:13:34gmcharltor even default_search_normalize(lang, text)
#14:13:56gmcharltalthough that sticks us in a morass
#14:14:15dbsgmcharlt: yeah, us academics with our mixed english/french/german/latin/arabic collections
#14:14:49dbsI'm definitely down with adding default_search_normalize() and appropriate usage thereof as another commit on my head-scratching apostrophe search
#14:14:53gmcharltdbs: and big publics, and special libraries, etc. -- you academic types don't get to claim *all* the credit for making things complicated ;)
#14:15:14DyrconaCJK!
#14:15:27gmcharltand V!
#14:16:31Dyrconaooh, yeah, vietnamese records were so much fun during our migration.
#14:29:39berickDyrcona: dbs: i thought i had a pullrequest for this.. guess not http://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/collab/berick/tpac-unadorned-856-record-details-rebase
#14:29:54edoceoHm, is there a rule about tabs-vs-space chars in the code?
#14:30:18dbsedoceo: best to avoid starting up that discussion again
#14:31:02edoceoI don't want I discussion, I just want to know which way I should do it to be consistent with the community
#14:31:19edoceoProblem is that in some files there is a combination of tabs and/or four-space chars...
#14:32:42dbsedoceo: "Try to make your changes as readable as possible by following the surrounding code-layout conventions. This makes it easier for the reviewer, and there's no point in trying to layout things differently. Also avoid unnecessary white space changes because they just distract the reviewer, and formatting changes will likely be removed by the committing core team member."
#14:32:55dbsFrom http://evergreen-ils.org/dokuwiki/doku.php?id=contributing#submitting_code_to_the_project
#14:34:12dbsthere is also http://evergreen-ils.org/dokuwiki/doku.php?id=code_formatting_standards but as noted it is not official
#14:34:32edoceoOh, yes...
#14:35:19dbsedoceo: but basically - submit a working fix in and it will be appreciated
#14:35:43edoceok, I'm a four-space kind of guy, so I'll be following that guidance
#14:37:00edoceoOk, one more ... how about distribution specific code-branches (like with make or the settings-tester.pl ?)
#14:42:02eeevildbs: fwiw, I've complained about the lack of non-located uris in tupac :)
#14:42:25mrpeters-isllol, tupac...nice
#14:42:50dbsedoceo: I don't understand what you're asking
#14:43:27dbseeevil: yeah, that makes sense. again, fuzzy head, I was conflating ind2 = ' '-ness with non-located uris
#14:43:35jamesrfif it's called tupac can we call the ajax pac biggie?
#14:44:04eeeviljamesrf: it's an apt description, so I'm for it
#14:44:09edoceolike, in settings-tester.pl for example, the checks for libdbipgsql fail, even if libdbd and libdbipgsql are proper
#14:44:29mrpeters-islimagine the outrage if we called it tupac
#14:44:39edoceoso the test would operate slightly different on Gentoo - so there would be some ugly if ( -e /etc/gentoo-release ) { # branch to test on Gentoo
#14:45:10gmcharltthe one problem with the nickname is that it suggests is that the transition to its ultimate successor could be ... interesting
#14:47:28tsbereedoceo: I would aim to find out why they work in some distros but not others, and change them to work in all whenever possible (say, using calls to get paths in a generic fashion and such) rather than having distro-specific code branches.
#14:48:12phasefxgmcharlt: Huayna Capac?
#14:48:22dbsedoceo: what tsbere said - the libdbi checks were quick hacks to ensure that they were compiled from source, not distro packages, back in the days when Debian Etch ruled supreme
#14:49:10edoceoOk, cause they look in "/usr/local/libdbi/dbd/", but now could/should look in regular location? Or should we make it check additional location?
#14:49:26edoceoMine are in /usr/lib64/dbd for example
#14:51:18tsbere isn't sure how to best check for libraries.....not having ever looked into it, he might be tempted to do a ldconfig -p piped into a grep
#14:52:12dbsedoceo: I think we still require compile from source on debian lenny, at least
#14:53:08dbsedoceo: a better test would probably be to compile a binary and test for the specific condition that is satisfied by the source package. maybe in configure.ac.
#14:54:49tecoripa has left #evergreen
#14:55:54edoceoWell, I'll come back to that, and those path issues I found....
#14:56:02sal_ has joined #evergreen
#14:57:18moodaepodbs++ # Been seeing the naco_normalize errors after our update from 2.0.6 to 2.0.10
#14:57:28senator has quit IRC
#14:58:01senator has joined #evergreen
#14:58:37moodaepoShould I try the transform you posted earlier before "# leading and trailing spaces" in Normalize.pm?
#14:59:46moodaepo goes to test it out
#15:02:13dbsmoodaepo: we might be working on different problems here!
#15:02:54moodaepoYa you are probably right (as usual)
#15:03:12moodaepoI am seeing some interesting error messages though
#15:03:50edoceoI'm trying to run `autogen.sh -u` and getting an "No Response from settings server...going to sleep" message - seeing this in the logs: [INFO:8215:Server.pm:628:] server: no request was received in 1 seconds, exiting stateful session
#15:05:27akilsdonk has joined #evergreen
#15:05:42matt_carlson has quit IRC
#15:10:33dbs has the radical idea of not relying on naco_normalize() at all for normalizing text for search and indexing purposes /because that's the job of PostgreSQL FTS/
#15:13:42bgoble has quit IRC
#15:30:26eeevildbs: I'd be all for a parser that could do the things we want, but only when we want them ... for instance, date range splitting (but only when it's date-ish data, and not, say, issn)
#15:49:57dbseeevil: heh, sure - step 1 is getting naco_normalize() and its ilk out of the equation, there's still lots of other specialized parsing to do that naco_normalize plays no part in
#15:51:34eeevildbs: some of what naco_norm does still needs to happen, so sharding that (and providing a wrapper that stacks them all back together) seems reasonable
#15:52:00dbsoh the mystery
#15:52:08eeevileh?
#15:54:23eeevilanyway, I think naco_norm() is orthogonal to creating an EG tsearch parser ... unless we're talking past each other (again ;) )
#16:00:45Meliss has quit IRC
#16:02:50edoceoOk, so I can osrf_ctl start_all, there are no warnings or errors in the logs, srfsh allows me to login as the evergreen admin OK but autogen.sh -u gets timeout errors
#16:04:18dbs blames ipv6
#16:05:06edoceoHmm, yes I do have ipv6 on this system
#16:09:57akilsdonk has quit IRC
#16:11:52tsbere_ has joined #evergreen
#16:13:58tsbere has quit IRC
#16:14:01tsbere_ is now known as tsbere
#16:28:56kmlussier has quit IRC
#16:29:31_bott_ has quit IRC
#16:30:13_bott_ has joined #evergreen
#16:39:53fortin has quit IRC
#16:46:05bwicksall has quit IRC
#16:49:39dbsuser/dbs/fix-nonfiling-titles now has a search_normalize() variant and (I think) uses it appropriately throughout; eyeballs / testing welcome
#16:53:34akilsdonk has joined #evergreen
#16:56:30wlayton2 has joined #evergreen
#17:05:16wlayton2 has quit IRC
#17:06:44matt_carlson has joined #evergreen
#17:25:36DyrconaSomeone asks "I would like to get the circulation modifier parameters specific for [my library]."
#17:26:28Dyrcona nearly falls out of his chair.
#17:26:40Dyrcona couldn't even do that well in Horizon.
#17:27:00DyrconaJust thought I'd end the day with a laugh.
#17:27:29jeffDyrcona: as in "i only want to see circ modifiers in the item attribute editor that apply to my library", or something else?
#17:28:10Dyrconajeff: As in I want to see how the circ_modifiers are configured for my library in circ_matrix_matchpoint and hold_matrix_matchpoint, etc.
#17:28:49DyrconaWe're not using circ_modifiers the way they expect. We're using marc types and then use the modifiers as modifiers.
#17:29:07DyrconaAnd then, we're using fall-thru.....
#17:29:44phasefxneed a Render Flow-Chart function
#17:29:48DyrconaAnd then even in our previous ILS where this was all done by "itype", there are no good tools to list that, and the interactions are incredible.
#17:30:21DyrconaI think I'll just send them my master XLS with 5+ worksheets of everyone's parameters and say, "Enjoy!"
#17:30:32Dyrconatime to go.
#17:30:36Dyrconabbl.
#17:30:40Dyrcona has quit IRC
#17:30:42Helenbean has quit IRC
#17:30:43jeffDyrcona: ah. i understand what you were describing now.
#17:32:29jenny1 has left #evergreen
#17:35:50akilsdonk has quit IRC
#17:39:57sal_edoceo: Double-check the settings in /etc/ejabberd/ejabberd.cfg (step 6 of opensrf installation.) I ran into this exact problem because I had *not* configured all the settings as described.
#17:41:48dbs has quit IRC
#17:50:51pmpcat has quit IRC
#17:59:02wlayton has joined #evergreen
#18:13:25Dyrcona has joined #evergreen
#18:20:15matt_carlson has quit IRC
#18:59:03Dyrconasshfs++
#18:59:07Dyrcona@karma sshfs
#18:59:08pinesol_greenDyrcona: Karma for "sshfs" has been increased 1 time and decreased 0 times for a total karma of 1.
#19:14:49wlayton has quit IRC
#19:16:51matt_carlson has joined #evergreen
#19:25:52matt_carlson has quit IRC
#19:59:54sal_ has quit IRC
#20:18:32DyrconaGotta love circular references.
#20:18:46DyrconaCan't delete auricnm because auri still exists.
#20:19:00DyrconaCan't delete auri cause auricnm still exists.
#20:19:16DyrconaNot with CStoreEditor anyway.
#20:19:21Dyrcona:(
#20:22:46DyrconaIf anyone cares: http://pastebin.com/Tq4ygdBc
#20:25:05DyrconaThink a reference or trigger might need to be deferred.
#20:29:47edoceodbs, sal_: I double checked my ejabberd.cfg and also killed ipv6 from my kernel - `autogen.sh -u` still throws that 'No Response from settings server....'
#20:31:02edoceoBut just noticed this: ERR :1766:osrf_system.c:401:] Child process 1767 (app opensrf.math) killed by signal 15
#20:36:01edoceoBut: srfsh# request opensrf.math add 2 4 still works properly
#20:45:40edoceoWhen I run `ejabberctl connected_users some are registerd at 'localhost' and some are using the system hostname (ils-server)
#20:45:56Dyrcona has quit IRC
#20:50:15edoceoOr, what ever this means: opensrf@private.localhost/open-ils.auth_listener_ils-server_1321347218.059586_2381
#20:52:20edoceoLogs: http://pastebin.com/cJhWT2qi
#21:46:57dbs has joined #evergreen
#22:56:47finnx has quit IRC
< Sunday, November 13th, 2011Raw Log FileTuesday, November 15th, 2011 >