Open Source Integrated Library System

Evergreen on IRC

#evergreen Logs for Tuesday, February 23rd, 2010

< Monday, February 22nd, 2010Raw Log FileWednesday, February 24th, 2010 >
#TimeNickMessage
#00:01:03jeffmaybe configuring the guest to expose its filesystem to a windows host via smb, or sshfs for a linux host...
#00:01:28jeffbut then we're getting overly complex. *shrug*
#00:01:58dbsahh, false alarm
#00:02:08pmplett has quit IRC
#00:02:09dbsexport drops it down to 505MB
#00:02:35dbs blames the ice dancing that was on in the background for lowering his iq
#00:02:56pmplett has joined #evergreen
#00:12:56mck9 has left #evergreen
#00:20:21dbs has quit IRC
#00:49:42pmplett has quit IRC
#05:37:30brendan_bywater has quit IRC
#06:09:41brendan_bywater has joined #evergreen
#07:33:22brendan_bywater has quit IRC
#07:55:02mck9 has joined #evergreen
#08:14:51bshum has joined #evergreen
#08:30:40atheos has joined #evergreen
#08:31:04sfortin has joined #evergreen
#08:48:39brendan_bywater has joined #evergreen
#09:05:09rsinger has joined #evergreen
#09:15:00jenny has joined #evergreen
#09:21:50atz has joined #evergreen
#09:24:36dchristens has joined #evergreen
#09:25:52atz has left #evergreen
#09:37:09Meliss has joined #evergreen
#10:08:47Dmagick has quit IRC
#10:09:39Dmagick__ has quit IRC
#10:10:0516SAAGED4 has joined #evergreen
#10:10:2216SAAGED4 is now known as Dmagick
#10:25:52jenny has quit IRC
#10:31:04rsinger has quit IRC
#10:36:20jenny has joined #evergreen
#11:01:35phasefx@later tell dbs SimpleText++
#11:01:35pinesolphasefx: The operation succeeded.
#11:01:42rsinger has joined #evergreen
#11:09:52dbs has joined #evergreen
#11:11:44dbsWeird. O:A:Demo:SimpleText is wreaking havoc with open-ils.actor - and only open-ils.actor. introspect open-ils.actor is showing all of O:A:Demo:SimpleText's methods instead. but open-ils.cat, etc are all fine
#11:12:16dbsheh, thanks phasefx
#11:13:32dbsoh, IDIOT
#11:13:46dbsperhaps if you point simpletext at a different SOCKET. duh
#11:14:02atheostrying to look at the table in our postgres box, and getting an error. anyone seen this?
#11:14:03atheosevergreen-# \d actor.usr_setting
#11:14:03atheosERROR: column t.tgconstraint does not exist
#11:14:03atheosLINE 3: WHERE t.tgrelid = '19196' AND t.tgconstraint = 0
#11:14:51senatoratheos: the 'evergreen-#' prompt means psql thinks you're still in the middle of some query you started earlier
#11:15:02senatoryou may want to hit ctrl-c until you get 'evergreen=#'
#11:15:30senatorthen \d actor.usr_setting should work fine
#11:15:33atheosthanks, issue still exists though.
#11:15:33atheosevergreen=# \d actor.usr_setting
#11:15:34atheosERROR: column t.tgconstraint does not exist
#11:15:34atheosLINE 3: WHERE t.tgrelid = '19196' AND t.tgconstraint = 0
#11:15:49atheosI can \d other tables without incident
#11:17:27senatorweeeirrd. mine doesn't do that, so i'll defer to others...
#11:18:22phasefxright version of psql compared to server?
#11:18:56atheosphasefx - probably not. that might be it, I'm connecting remotely from our phone system. good call
#11:19:33dbsatheos: newer versions of psql should be able to connect to older servers without incident; other way around is bad news
#11:20:58atheoshey, I get an error on startup that I didn't observe before
#11:20:59atheosWARNING: You are connected to a server with major version 8.2,
#11:20:59atheosbut your psql client is major version 8.3. Some backslash commands,
#11:20:59atheossuch as \d, might not work properly.
#11:21:19atheoswell, smack me.
#11:22:22dbsheh - okay, newer -> older has some incidents I guess :)
#11:22:41dbsanother mystery solved by the #eg gang!
#11:23:20atheosyou guys are nice too, any other channel I'd be flamed to no end :P
#11:24:34phasefxatheos: use phppgadmin you noob
#11:24:49atheosthat's more like it
#11:25:11dbsgah, ack... phppgadmin
#11:25:32atheosI mean the flaming, not using phpgadmin
#11:26:29dbsI know :)
#11:32:45lisah__ is now known as lisah_
#11:44:35lisppaste3 has quit IRC
#11:44:38lisppaste3 has joined #evergreen
#11:47:34jamesrf has joined #evergreen
#11:49:53branflakes has quit IRC
#11:58:24branflakes has joined #evergreen
#12:03:19dbs has quit IRC
#12:05:10rsinger has quit IRC
#12:18:38natschil has joined #evergreen
#12:53:42phasefxgrabbing 0169
#13:09:56atz has joined #evergreen
#13:12:11atz has left #evergreen
#13:28:48phasefxgrabbing 0170
#13:32:30dbwellsHello folks. I have a question about logging, specifically OpenSRF gateway logging.
#13:32:41jamesrf has quit IRC
#13:33:29dbwellsWe have a custom authentication service running, but if we set gateway logging above WARN, we get user credentials in our logs (not good).
#13:33:48agJohn has joined #evergreen
#13:34:13dbwellsCan the gateway be told to log different services differently?
#13:35:57dbwellsor not at all?
#13:38:07phasefxwhat's the surrounding the text for the log entry? I can grep the source for it and ponder
#13:40:40miker_ is now known as spaceisntsyntax
#13:41:32berickdbwells: not currently
#13:42:41dbwellsberick: thanks for the confirmation. Is anything like this even on the radar?
#13:44:14berickdbwells: no, not the i'm aware of
#13:44:33berickwould not be a big job though to configure a set of services whose params are obfuscated
#13:44:57berickbear in mind the data may be showing up in osrfsys log as well
#13:46:08berickand if it's not now, it's not rediculous to think it might show up in the future (it definitely will for c services)
#13:46:32bericks/will for c services/does for c services/
#13:47:15dbwellsI don't see it showing up in there now, but that's good to know.
#13:47:35jamesrf has joined #evergreen
#13:47:58branflakesAre there any masters of Postgres-pattern-matching-fu on the channel right now?
#13:48:21spaceisntsyntaxbranflakes: perhaps
#13:48:27spaceisntsyntax is now known as miker_
#13:48:31phasefx can stumble through things, but antipython is better
#13:49:17natschilis there a function somewhere in c to compare two jsonObject* s to see whether they have the same values or not?
#13:49:43pmplett has joined #evergreen
#13:50:01branflakesCOALESCE(SUBSTRING(frp.value FROM '\\\\d+'),'9999')
#13:50:29branflakesI'm trying to figure out what the slashes do, and the Postgres documentation is not being at all helpful
#13:50:56miker_branflakes: they're just escaping the slashes
#13:51:12miker_when PG gets the query, it needs 2 slashes
#13:51:12branflakesSo the value is \d+
#13:51:22miker_which, themselves must be escaped
#13:51:23miker_right
#13:52:11miker_now, you could replace '\\\\d+' with $re$\d+$re$ (probably ... need to test that)
#13:52:18sfortin has quit IRC
#13:52:38natschil decides to write a jsonObject* comparing function, as there seems to be none in osrf_json.c
#13:53:45bshumHas anyone seen in the staff client a way to display the in-house usage circulation information? I've seen that there is a "# of uses" column in the dropdown list to pick from the item details window, but this isn't showing us anything. Checking against our database, we find that in-house is being recorded in the table properly, but just nothing showing up in the interface.
#13:55:08phasefxnatschil: it was very naive of me, but my first thought was to stringify and compare strings :)
#13:55:55natschilphasefx: yeah, something like that. I might make it compare the object types too though so it doesn't need to allocate memory for the stringified strings.
#13:55:57phasefxbshum: there's a lot of column definition re-use going on, and if that UI was more polished, the column wouldn't be there
#13:57:16phasefxnatschil: the problem with comparing json as strings is that field order is probably indeterminate unless we code in some sorting behavior
#13:57:39phasefxI could also imagine some escaped characters that are identical, just encoded differently
#13:58:32bradl'escaped characters' could describe a whole slew of folks around here. just sayin
#13:58:43natschilphasefx: yes, but I think that the actual string data from a c jsonObject* is stored as an unencoded string, though I might be wrong.
#13:59:04phasefxsome with first names sounding like JSON
#14:01:53bradl blinks at phasefx
#14:01:55bshumphasefx: So you're suggesting that we don't go with that route of retrieving the information then. Does that mean there's another way to find out in-house circ stats?
#14:03:09miker_bshum: there's reporting
#14:03:53bshummiker_: A report. That should be interesting.
#14:04:24miker_natschil: for everything but hashes, string comparison should work fine, but the key order within a hash bucket is insertion-order dependent, IIRC
#14:06:11natschilmiker_: ok. How can I get a list of keys of json hash?
#14:07:04miker_I'll look ... sec. unless berick or mck9 know OTTOTHs
#14:08:26miker_well.. you could use an itterator
#14:09:03sfortin has joined #evergreen
#14:09:14miker_osrfStringArray* osrfHashKeys( osrfHash* hash ) {
#14:09:41natschilmiker_: I could, but to compare two JSON_OBJECTS, I thought to take the list of all the keys, sort them, compare and then if all went well compare all of the values.
#14:09:43miker_returned osrfStringArray is in insertion order
#14:11:01natschilmiker_: ok. To run it on the jsonObject, do I run it on object->__jsonValue.h ?
#14:11:41miker_natschil: 1) test type (if not a hash, compare strings) 2) if hash, test size 3) if sizes match, itterator over one, looking for matches in the second (recursively)
#14:12:04miker_that's be my approach
#14:12:06natschilmiker_: good idea! that should work.
#14:12:36natschilmiker_: I could replace 1) with something that compares the actual values for efficiency.
#14:13:21miker_well, you can reliably compare stringified arrays
#14:14:04miker_so, to simplify the code, I'd just stringify everything but hashes, making them the one special case
#14:14:57natschildo I get the actual osrfHash* from object->__jsonValue.h ?
#14:15:07miker_instead of using a different comparison for each type... I'd prefer ease of maintenance and use of existing API abstraction over pure raw speed
#14:15:26miker_no, just use an osrfIterator
#14:16:07natschilmiker_: this is true, though the differences aren't too big... do you mean osrfHashIterator?
#14:16:09miker_use the apis that exist. then if we change the internal representation (which we have ... at least twice) your code wont break
#14:16:46miker_there's a unified iterator api, I think ... if not, then yes, osrfHashIterator
#14:17:10natschilmiker_: or maybe jsonIterator
#14:18:18miker_perhaps that's what I'm thinking of, yes
#14:27:10berickstrcmp(jsonObjectToJSON(o1), jsonObjectToJSON(o2)) == 0 ;)
#14:27:41berickoh, the hash key order problem..
#14:28:46miker_berick: right ... a recursive func that special-cases hashes and uses an iterator should "just work", eh?
#14:30:13natschil has quit IRC
#14:30:37berickmiker_: yeah
#14:31:04natschil has joined #evergreen
#14:32:56agJohn has quit IRC
#14:35:45natschil has quit IRC
#14:41:06moodaepoHello all, Is it ok to do a pg_dump when an vacuum-analyze metabib.real_full_rec is running on the db or should we wait for it finish?
#14:42:16mrpeters-islguys, if a patron exceeds one of the thresholds (too many items overdue, etc.) and they try to login they are getting the event "opac.dtd:<!ENTITY login.account.inactive "This account has been deactivated. Please contact your local library.">"
#14:42:46moodaepomrpeters-ils: This has been fixed in the new revs.
#14:42:57moodaepoOh wait that was for wrong password
#14:43:15miker_moodaepo: should be fine. might block vac though
#14:43:20moodaepo goes to check bugs
#14:43:34moodaepomiker_ thanks
#14:44:13mrpeters-islthat doesn't seem right...can we define a new custom event to say the potential reasons why they might be blocked for
#14:44:54phasefxmrpeters-isl: I don't think a circ or hold block should affect login at all
#14:45:11mrpeters-islim being told that it does
#14:45:19mrpeters-islim trying to get myself within the threshol to test now
#14:45:23phasefxmy bet is that the password is incorrect
#14:45:36phasefxor the account really is marked inactive
#14:45:41mrpeters-islthis was a library staff member, a pretty competent one infact
#14:45:44phasefxbarring might do it, I'm unsure
#14:45:47mrpeters-islso i doubt the password reset
#14:47:13moodaepomrpeters-isl: Actually reset the password and try with new password should say it's not the password : )
#14:47:14mrpeters-islok, my mistake..i.ts not the login
#14:47:21mrpeters-islits the renewal
#14:48:07moodaepoIsn't there rules which govern that? Maybe the patron is over their number of renewals.
#14:48:17moodaepos/isn't aren't/
#14:48:18mrpeters-islright, but why should it tell the patron their account is inactive
#14:48:29mrpeters-islwhen really, its that they have too many overdues so they lost the privelage to renew
#14:50:06mrpeters-islok, login "This account has been deactivated. Please contact your local library"
#14:50:09mrpeters-isli know my own password :)
#14:50:28mrpeters-island i exceed the billing threshold,, try to login from my opac...i get this message
#14:50:44phasefxthat's sucky, IMO :)
#14:51:56mrpeters-islah, that was a result of some deactivating barcodes actually
#14:52:04mrpeters-islbut, the situation still exists on the renewal
#14:52:15atz has joined #evergreen
#14:52:28mrpeters-islbah, back to the drawing board for more information
#14:52:32jenny has quit IRC
#14:53:13atz has left #evergreen
#14:54:13phasefxas a reference point, using in-db circ or scripts?
#14:55:43mrpeters-islthe in db
#14:55:52mrpeters-islstanding penalties
#14:58:21sfortin has quit IRC
#15:01:06phasefxin trunk, I get the title of the book, and "The system is unable to renew the selected item at this time. This usually means the item is needed to fulfill a hold. Please see a librarian for further help."
#15:01:25phasefxwith legacy script, trying in-db
#15:03:51phasefxha, with in-db circ, I was able to renew
#15:04:17phasefxguess I have to set up some rules
#15:04:42mrpeters-islyeah, see we still use some of the legacy scripts too
#15:04:50mrpeters-islas far as i can tell
#15:05:17moodaepomrpeters-ils: Interesting might have to bug you sometime about mixing them and why : )
#15:05:27phasefxI'd be surprised if you guys migrated from legacy scripts to in-db without a lot of testing and back & forth and bug finding
#15:06:25phasefxwell, I have no idea how to use in-db circ, moving on
#15:11:28miker_phasefx: the penalties are /only/ in-db now
#15:11:52miker_mrpeters-isl is using scripts for circ and hold
#15:12:22phasefxmiker_: the script test must have blocked the renewal based on permissability then
#15:13:17phasefxbut..
#15:13:22phasefxthat doesn't seem true
#15:13:57miker_the hold permit script would say "no" if you lack renewals
#15:14:09miker_but the "why" is not specified to the client
#15:14:25miker_phasefx: so, what you saw is correct
#15:15:03phasefxfor my test, I billed the patron $50, checked out a pre-cat. With legacy_script_support = true, I got an expected failure trying to renew in the OPAC. with legacy_script_support = false, I was able to renew
#15:15:52phasefxbut my circ_permit_renew.js has no logic in it, and circ_permit_patron.js appears to be only checking for barred, and a max items out threshold
#15:17:12miker_phasefx: I could by lying about the js chekcing, that may be happening in the perl, before the script
#15:17:22phasefxmy circ_groups.js does have a fineThreshold of 10, but you say that's no longer used at all
#15:17:50phasefxhrmm
#15:18:40miker_phasefx: I'm not sure if that's used or not ... but the actual in-db penalty uses the group setting to clac the penalty
#15:18:45miker_calc
#15:19:27phasefxa group setting where, in the db?
#15:19:59miker_yeah
#15:20:35miker_there's a new ui for group penalty thresholds
#15:22:09phasefxso, I do have a penalty in actor.usr_standing_penalty, and I was wrong about what happened. With legacy script support off, the item is not getting renewed, but the UI alert is telling me the renewal was successfull
#15:22:11sfortin has joined #evergreen
#15:27:11Meliss has quit IRC
#15:27:21phasefxilsevent: null, textcode: "no_user"
#15:28:48phasefx tries a real item
#15:34:08phasefxit's the pre-cat
#15:34:26phasefxget the expected penalty event with a cataloged item
#15:34:31mrpeters-islmine was a precat item too
#15:34:40mrpeters-isli didnt think to try a real cataloged item
#15:34:49rjackson-isl has joined #evergreen
#15:38:50miker_hrm... placing a hold on a precat item?
#15:38:58miker_sorry .. renew
#15:38:59miker_nm
#15:40:02dchristens has quit IRC
#15:41:19lisppaste3phasefx pasted "in-db circ renewals, pre-cats versus cataloged" at http://paste.lisp.org/display/95505
#15:42:29mrpeters-islyeah, it actually let me renew the precat
#15:42:37mrpeters-islbut it shouldnt have, since i was over the penalty threshold
#15:44:19phasefxmrpeters-isl: did it "really" renew
#15:44:26phasefxas in, did the Number of Renewals counter go down
#15:45:01atz has joined #evergreen
#15:45:05lisah_ has left #evergreen
#15:45:35atz has left #evergreen
#15:54:19pmplett has quit IRC
#16:05:34mrpeters-islany ldirectord whizzes around?
#16:05:49mrpeters-islwhen i hit the public IP of a new ldirector, i just see an "inactive" connection but can't ever get it to forward to the two servers i am attempting to balance. i can access each of those directly (from the ldirector server by their private IP)
#16:05:49mrpeters-islim just stuck with a SYN_ACK connection
#16:24:07Dyrcona has joined #evergreen
#16:24:41Dyrcona has quit IRC
#16:25:05Dyrcona has joined #evergreen
#16:35:21pmplett has joined #evergreen
#16:38:04jenny has joined #evergreen
#16:38:44Dyrcona suddenly has a Tomm Tutone song stuck in his head.
#16:41:03DyrconaI am trying to figure out why keyword searching isn't working in my opac after a fresh load.
#16:41:31DyrconaLast time this happened it was a problem with the hierarchy, but I've since fixed that.
#16:48:01mrpeters-isl has quit IRC
#16:48:08mrpeters-isl has joined #evergreen
#16:55:59wlayton has joined #evergreen
#17:07:25brendan_bywater has quit IRC
#17:07:53branflakesmrpeters-isl: sitka doesn't use ldirector, but we do use lvs which underlies it; i might be able to help you out
#17:10:15branflakesFrom the documentation I can find about ldirectord, you have to manually create the virtual servers using ipvsadm, and then point them at the real servers. I'm assuming that step is done and you are still having problems?
#17:19:24Dyrcona has quit IRC
#17:20:24brendan_bywater has joined #evergreen
#17:37:59jenny has left #evergreen
#18:01:44bshum has quit IRC
#18:04:53mck9 has quit IRC
#18:06:46sfortin has quit IRC
#18:09:13wlayton has quit IRC
#19:26:13jamesrf has quit IRC
#20:07:15grantjohnson has joined #evergreen
#20:16:42pmplett has quit IRC
#21:22:47wlayton has joined #evergreen
#22:06:59wlayton has quit IRC
#22:20:44Dmagick_ has joined #evergreen
#22:21:16Dmagick has quit IRC
#23:57:48branflakes has quit IRC
< Monday, February 22nd, 2010Raw Log FileWednesday, February 24th, 2010 >