Evergreen ILS Website

IRC log for #evergreen, 2013-11-06

| 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
01:54 Mark__T joined #evergreen
01:54 Mark__T joined #evergreen
01:56 jeffdavis joined #evergreen
02:56 kollex joined #evergreen
05:17 kollex left #evergreen
07:05 timlaptop joined #evergreen
07:26 ningalls joined #evergreen
07:52 csharp @quote random
07:52 pinesol_green csharp: Quote #40: "The best book on programming for the layman is Alice in Wonderland ; but that's because it's the best book on anything for the layman." (added by Dyrcona at 12:14 PM, January 02, 2013)
07:56 misilot left #evergreen
08:23 akilsdonk joined #evergreen
08:29 collum joined #evergreen
08:32 Dyrcona joined #evergreen
08:32 kbeswick joined #evergreen
08:33 Dyrcona Well, the "toaster" toasted itself.
08:33 Dyrcona The audio only has left channel output.
08:33 Dyrcona Must have melted the solder on the right channel connection.
08:34 kbeswick joined #evergreen
08:34 mrpeters joined #evergreen
08:45 RoganH joined #evergreen
08:46 Dyrcona It's warming up, get your muffins ready!
08:46 Dyrcona ;)
08:48 Dyrcona Dell is so funny: Offering Windows software as add-ons to a system that comes with Ubuntu pre-installed...
08:48 csharp Dyrcona++
08:49 csharp "Prerequisites: wine"
08:49 RoganH I was fumbling with a Windows box yesterday for a presentation and it crashed on me twice trying to run powerpoint.  I ended up getting my laptop and setting it up.  I hate windows.
08:50 Dyrcona Running SonicWall via wine would prove interesting.
08:52 Dyrcona This is the XP 13 ultrabook, it has no internal optical drive. You'd think that they'd have a USB optical drive as an option, but no.
08:52 Dyrcona XPS 13....
08:52 RoganH It has USB ports though I assume so you could add a third party one right?
08:52 Dyrcona Of course, but they offer a 1 TB external HD, so....
08:53 RoganH me is a dinosaur and still likes his main laptop having a DVD drive.
08:53 RoganH There should have been a forward slash there.  :)
08:54 dbwells RoganH: Transformers taught me that dinosaurs always refer to themselves as 'me'
08:54 RoganH dbwells: Grimlock was awesome.  me am child of 80s.
08:54 * Dyrcona wonders if the boss will complain if he.... "Order all the adapters!"
08:55 Dyrcona An extra power adapter is always nice if you use your laptop at a desk frequently.
08:56 Dyrcona The VGA adapter is necessary if I want to use my old monitor as a second monitor or plug in to the projector in the meeting room.
08:56 Dyrcona The HDMI adapter is needed because you never know what you'll find at the remote site.
08:56 Dyrcona Maybe I'll skip the power adapter for the car.
08:57 Dyrcona Don't hack and drive. :)
08:57 RoganH I keep a VGA and HDMI in my bag.  VGA gets more use.  I've only needed the car one once but it was worth every penny and the extra places I've dragged it to when I did.
08:57 RoganH I once got pulled over by a cop a few years ago because I had the laptop in the passenger seat running a long jailbreak on an iphone though I wasn't interacting with it.
08:58 RoganH He ended up getting me to give him websites to show him how to jailbreak his.
08:58 Dyrcona RoganH: I'll leave the car adapter selected.
08:58 Dyrcona Which reminds me, I've been meaning to order a USB power adapter and cradle for my phone for the car.
08:59 Dyrcona Makes it easier to use the GPS app and Goolgle maps while you're driving.
09:00 RoganH Dyrcona : much easier
09:00 Dyrcona Then they don't pull you over for texting. :)
09:00 Dyrcona They just assume its your GPS.
09:00 * csharp tried to get the XPS 13 with Ubuntu as his work laptop, but ended up with a decently-provisioned mid-range ASUS instead
09:00 rfrasur joined #evergreen
09:01 Dyrcona csharp: I considered getting the ASUS, if I were spending my own money.
09:01 Dyrcona At MVLC, we pretty much only buy Dell.
09:01 * RoganH asked for a quad i7 macbook with 16 gigs of ram and was very happy when it showed up on my desk
09:01 rfrasur spending_ones_own_money--
09:01 Dyrcona Central Site that is.
09:01 mmorgan joined #evergreen
09:01 rfrasur RoganH: nice
09:02 RoganH rfrasur: to be fair this is everything machine and I work it a lot.  two years old now and I'm still very happy with it though.
09:03 rfrasur RoganH: You def don't need to justify it to me. I'm of the firm belief that people should have the right tools for their job.
09:04 RoganH My argument was 'give me what I want and I'll make things you want to happen even if you don't know it yet', they did, I do, we're all happy.
09:04 rfrasur yep, exactly.
09:05 RoganH Actually, I hear people surprised all the time that despite facing the same challenges others do we're pretty happy in SCLENDS.
09:05 rfrasur I don't understand why they're surprised.  There are challenges everywhere.  That's part of the fun of living.
09:06 rfrasur btw, jboyer-isl, thank you beyond measure for the recurring report advice.  It's a whole new world.
09:06 jboyer-isl Cool. Glad I could help.
09:08 rfrasur and I learned EG does something that I didn't know about.  I didn't know that when it emails you a notification of a run report...there's a link that opens in the browser, so you don't ahve to fire up the staff client to get to the results.
09:10 kmlussier joined #evergreen
09:12 RoganH rfrasur: yep. we use that a lot and list emails for those to receive it who only have view permissions.  So, I have a holds threshold report that goes out to a whole collection development list and they have a common account with no reporting permission but view for the login.
09:12 RoganH rfrasur: so I set it up and run and don't have to touch it again, they just get it each week
09:13 rfrasur RoganH: that's a pretty cool use of the feature.  I'll have to think about it and play around with it and see if it'll do our library any good.
09:21 Dyrcona RoganH: On the VGA/HDMI thing: I was at a site recently where they only had a television in their meeting room with HDMI input and no VGA. Chances are, I'll be going there again.
09:22 Dyrcona RoganH++ # For giving me a ah ha! with that holds report. We should do the same thing here.
09:22 RoganH Dyrcona: I suspect that will be increasingly common.  For the forums I do it's mostly VGA projectors (no DVI or HDMI option).  I think if you're presenting in libraries the TV scenario will be increasingly common.
09:22 Dyrcona Yep.
09:25 bshum Dyrcona: For my XPS13, the thing I find most valuable has been my gigabit ethernet USB adapter.  Not having it built-in sucks sometimes.
09:25 bshum (actually it just sucks all the time)
09:26 timf joined #evergreen
09:26 jeff rfrasur: thinking back to your in list / not in list from last night, i think both lists were the same because they were both wrong -- are you trying to get patrons who only owe for one kind of thing, and don't owe at all for anything else?
09:26 RoganH bshum: That's made me hesitant about the macbooks right after mine.  I have the last one with built in ethernet.  Having to use a thunderbolt connector for ethernet seems like total bull$#@$ to me.
09:26 bshum RoganH: It's just a "when you need it, you really, really need it" sort of thing.
09:27 jeff as someone with a macbook air for work... what's an ethernet port?
09:27 Dyrcona bshum: Good to know, I'll consider getting one of those. I don't recall seeing that as an option from Dell.
09:27 RoganH When I'm moving big chunks of data to my drobo I want ethernet.  :)
09:27 bshum jeff: Don't lie Jeff, you remember our first conference where you had the adapter and I didn't?  I was so bummed.  :)
09:28 jeff heh
09:28 Dyrcona bshum: I was going to ask your opinion on getting one of the sleeves. I plan to reuse my existing backpack. I went ahead and added the nylon sleeve to my order.
09:28 bshum Dyrcona: I'm lazy and didn't order anything to wrap the laptop with.  The bags I have work fine enough.
09:30 Dyrcona oh good. my browswer doesn't want to work any more.
09:31 rfrasur jeff: yes!
09:32 rfrasur do you know how to do that?
09:32 jeff not in the reporter. let me look at some of the views that are exposed.
09:32 Dyrcona Dell doesn't offer a USB Ethernet adapter as an option either, but they have printers and monitors.
09:33 yboston joined #evergreen
09:35 * rfrasur reads back
09:37 rfrasur hmm, dunno if this means anything to anyone, but I had to buy an HDMI to VGA adaptor to use with the Raspberry Pi.
09:37 rfrasur maybe I should buy another one?
09:37 rfrasur (duh, of course you should)
09:39 * rfrasur waits with baited breath for Jeff's db magic.
09:39 jbfink joined #evergreen
09:39 rfrasur (and that's not sarcastic)
09:43 csharp okay - maybe resurrecting a dead horse here, but we continue to get reports of what appear to be staff session timeouts when doing catalog searches in the client
09:44 csharp the complaints mainly come from catalogers, who keep multiple tabs open, at least one of which is for searching
09:44 csharp they work along, then attempt a search and it no longer displays the "staff" OPAC view
09:45 Dyrcona csharp: That bug is still there. Cause still largely unknown.
09:45 csharp but they are able to continue doing other things requiring auth
09:45 Dyrcona Or at least, the solution is unknown to me.
09:45 Dyrcona There's a Launchpad Bug....
09:46 csharp yeah - just found it (again)
09:46 bshum https://bugs.launchpad.net/evergreen/+bug/1036318
09:46 pinesol_green Launchpad bug 1036318 in Evergreen 2.4 "OPAC timeout within the client" (affected: 13, heat: 68) [Medium,Confirmed]
09:46 csharp looks like I'm already on it
09:46 bshum Jeff commented on it last night I think
09:46 * csharp notices jeff 's comment ;-)
09:47 csharp Dyrcona: thanks
09:48 Dyrcona csharp: de nada.
09:52 * phasefx_ likes Jeff's db-backed auth session idea
09:52 jeff csharp: the behavior i observed was not the same as that you just described, so we might be seeing different issues. in the non-tpac interfaces/tabs, did your catalogers receive a prompt to re-authenticate?
09:53 _bott_ joined #evergreen
09:54 Dyrcona Yeah, I was gonna say my thought is that the TPAC timeout is shorter, so maybe the session is being expired early, or perhaps there is an occasional difficulty retrieving a staff client auth token from the TPAC.
09:54 Dyrcona I've not seen evidence on our system of memcached exhaustion, but I've also not looked that hard for it.
09:55 csharp jeff: no, though we saw that a lot in 2.1
09:55 csharp at least on one is reporting it to me
09:55 csharp s/on/no/
09:55 jeff the symptom in the logs for me that pointed to memcached eviction was that the auth token received in the morning and used all day until the afternoon was then used a short time later (less than half the time of the authtime) and not found.
09:56 jeff so that tells me the client didn't "forget" the token anywhere, the server no longer found it in memcached -- and there was no stray logout for that auth token.
09:56 jeff (and no general memcached restart/flush around that time)
09:57 jeff sessions that had been more recently active were not affected, and that meshes with the way that memcached evicts when it runs out of room in a slab.
09:57 jeff first it looks for expired things, then it looks at unexpired things in an Least Recently Used fashion.
09:57 csharp interesting
09:58 jeff if your staff had only their tpac sessions lose login, but their other tabs remained okay, and they received no prompts to re-authenticate, that sounds different.
09:58 jeff csharp: 2.4 for you guys now, or 2.3?
09:59 phasefx_ csharp: may be worth seeing if anyone is using Operator Change as well; that could be a thrown wrench
10:00 csharp jeff: 2.3
10:00 jeff and my next question is that which phasefx_ just asked -- are they using operator change at all, or did they use operator change during that session at all?
10:00 csharp phasefx_: yeah - we had a ticket a while back that was very hard to suss out until we learned that operator change was in the mix ;-)
10:01 RoganH joined #evergreen
10:01 csharp I'm pretty sure that's not a factor
10:01 csharp in the current situation
10:02 jeff csharp: if you can, i'd start with finding the "successful login" log entry for the user + workstation in question for the day that they had the problem, then look at log entries having that auth token.
10:03 jeff in your case, it sounds like it will be a little noisy due to their xul interfaces still working.
10:04 jeff oh.
10:04 jeff hey, this might be it.
10:04 jeff how long is your staff login timeout?
10:05 jeff can you trace apache access logs back to individual machines, or are they all behind NAT with a bunch of other machines?
10:06 jeff say your staff login timeout is 3600 seconds. tpac pages will all get a meta refresh tag that redirects to the logout page after 3600 seconds.
10:06 jeff if they have a tab open and idle for an hour, it'll log their tpac session out, killing the cookie.
10:07 jeff even if they have been active in another tpac tab during the meantime.
10:09 jeff so if you can go from individual machine to apache log entries, i'll bet you see a logout.
10:09 jeff (a tpac logout url request from the client)
10:10 jeff if your timeout is so long that they couldn't possibly have had a tpac tab open and idle for that long after logging in, then that's probably not it.
10:11 jeff arguably, staff tpac pages shouldn't have that meta refresh, and also shouldn't have a logout link.
10:15 pinesol_green [evergreen|Dan Wells] Improve locale picker positioning - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=4a6345d>
10:16 jeff @monologue
10:16 pinesol_green jeff: Your current monologue is at least 14 lines long.
10:17 * rfrasur was reading it
10:31 rfrasur think I can put together a security system w/ cameras for our library?
10:31 rfrasur (of course you can)
10:32 jeff sure, all depends on your budget and what you need.
10:33 rfrasur I need to catch whoever is stealing our dvds and music without going to the expense of a gate system or RFID
10:33 rfrasur and flog them
10:33 Dyrcona csharp: On the notebook/laptop front, you might find this site interesting: http://rjtech.com/
10:34 Dyrcona They offer barebones and complete laptops from the original design manufacturers.
10:34 dbs anyone who really wants to steal stuff can easily defeat gates / RFID
10:35 * dbs puts on his tinfoil hat to shield the RFID tag attached to his skull
10:35 * Dyrcona though csharp might be interested because he mentioned ASUS, who actually manufactures there only laptops.
10:35 Dyrcona heh.
10:35 Dyrcona oof.
10:35 Dyrcona s/there only/their own/
10:35 Dyrcona Please keep up with me fingers....
10:36 rfrasur dbs: my thoughts exactly.  I just wanna see their grubby little fingers take the stuff.
10:36 rfrasur and then flog them...maybe in the streets...as they cry out "thief! thief!"
10:36 jeff csharp: let me know when you've had time to go over my thoughts above on the logout issue. i'd be interested in confirmation of likelihood. :-)
10:37 Dyrcona rfrasur: Out source your security: stream the cameras over the web.
10:37 Dyrcona jeff: What you described fits with what we've observed and been considering as the cause.
10:37 rfrasur I'm thinking that's what it's going to be, although Logitech has a system that does it...but not sure I wanna deal with the admin.
10:39 * rfrasur calls the professionals
10:39 jeff Dyrcona: cool. i'll add my thoughts to the bug in a bit here.
10:40 Dyrcona I'm not sure of the exact scenario, but it looks like they have a tpac tab open and it gets logged out.
10:41 Dyrcona Then tpac asks them to login again, and I'm not sure if the staff client does or not.
10:41 * Dyrcona fires up the staff client to try it out.
10:45 csharp jeff: sorry - got pulled away
10:46 jeff csharp: understood!
10:46 jeff so there are two scenarios here. might be worth two bugs.
10:47 jeff scenario 1: tpac in staff client is no longer logged in as staff, but other staff (xul especially) interfaces work fine
10:48 jeff scenario 2: all staff interfaces are no longer logged in, xul interfaces prompt to re-login.
10:48 jeff i think 1 is due to the idle tpac tab cause theorized above, and i think 2 is likely memcached eviction.
10:48 jeff we can fix 1 pretty easily.
10:50 jeff but again, let me know if what i described above sounds possible. if your staff login timeout is 12 hours and the staff member logged in at 9am and had the problem at 9:30, it's likely back to the drawing board on the theory. :-)
10:50 csharp let me investigate - I think I can get that information
10:50 jeff great!
11:03 mrpeters1 joined #evergreen
11:03 csharp Dyrcona: thanks for the link!
11:05 RoganH joined #evergreen
11:06 mrpeters joined #evergreen
11:13 jboyer-isl rfrasur: Putting together an Axis system is easy (pover over ethernet, woo!), just a little pricy. I think their site is axiscommunications.com, and CDWG-G sells them (not a huge duscount, but anything helps.)
11:14 rfrasur jboyer-isl: thank you.  we're going to get a quote from Koorsen and then compare it with a build-yer-own.
11:14 rfrasur They had to go and steal the Bruno Mars CD.  Now it's war.
11:15 jboyer-isl If they're higher it may still be worth it, I threw my hands up and had someone else do the wiring. Buildings with 3-4 renovations over the course of 100 years aren't easy to cable.
11:16 rfrasur no, and there's no way I'm climbing our rickety 14 ft. ladder to piece something together that hopefully works.
11:19 jboyer-isl Are the only options having someone else do it, or you do it yourself? (Not familiar with your staff size.)
11:20 jboyer-isl That's poorly worded. I meant, outside contractor or you as the director do the work, are those the only 2 options?
11:20 rfrasur well, I could get a little support from our IT contractor.  But other than that...yeah.  The dude we contract with for maintenance isn't particularly technologically savvy.
11:21 rfrasur I have 9 employees, all 25 hrs a week or less.
11:22 rfrasur (until we implement the long range plan of awesomeness that calls for two new full-time positions...after I find the money)
11:22 jboyer-isl Maybe setting up something in house isn't ideal. To really do it right takes a dedicated server in addition to all new wiring and switches to power everything. Sometimes trading money for time is a good investment.
11:35 rfrasur my thoughts exactly jboyer-isl
11:36 timhome joined #evergreen
11:45 rfrasur on a completely nontechnological note (dunno if that's a word), my staff is getting pretty excited about having a library mascot.
11:49 jeff a mascot?
11:50 bshum At one point, we jokingly referred to jventuro's dog as our company mascot.
11:50 rfrasur yep, as cheesy as it sounds
11:50 rfrasur bshum++
11:50 bshum "The Biblio Beagle"
11:51 jeff mmm... bagels.
11:51 rfrasur we don't have a name yet, but it's gonna be the tiger from kung fu panda dressed up in local attire (except at Christmas...then it's gonna be Tiger Claus)
11:51 jeff oh, you said beagle. oops. carry on.
11:53 rfrasur I figure, why be subtle and classy when you can be obnoxious.
11:53 rfrasur My plan is to get the morph suit kids to wear the costume.
12:00 paxed they still wear those? i would've thought that fad had passed.
12:01 rfrasur it's midwestern America, our fads are usually out of date...and it's particularly obnoxious so it gets a lot of traction with a subset of our teen population.  The obnoxious subset.
12:02 mrpeters joined #evergreen
12:04 paxed i'm supposed to code some new functionality into eg before next monday. unfortunately my morale is so very low.
12:05 rfrasur Have you eaten dinner yet?
12:06 paxed yes
12:06 rfrasur attended to other basic functions?
12:06 paxed low morale is due to now 9th week of faffing at work.
12:07 * rfrasur thinks
12:07 paxed hm. i guess that needs "about" in there somewhere.
12:07 paxed it's a "evergreen or koha" -thing.
12:08 rfrasur gotcha.  do you have a start on the functionality?
12:08 paxed yea.
12:08 paxed still need to write sql function for ingesting, and OPAC parts.
12:10 rfrasur I'd quit for the night and pretend that Monday is nonexistent and then ignore everyone that's killing productivity for the next couple days (or five).
12:10 rfrasur and buy nice coffee
12:19 dbwells paxed: On a positive note, I finished my box of "Salmiakki" yesterday, so at least that's over with ;)
12:19 paxed blegh. :P
12:19 * Dyrcona laughs.
12:20 paxed i'm in this camp: http://www.salmiyuck.com/
12:20 rfrasur salty black licorice?
12:22 rfrasur jboyer-isl: I suspect you're seeing this EI network stuff?
12:22 jboyer-isl Just recently, yes.
12:22 * rfrasur just saw the onslaught of emails.
12:23 Dyrcona "onslaught of emails" does not sound good.
12:24 * rfrasur shrugs
12:24 rfrasur It's SOP here.  Everyone starts running toward the cliff.
12:27 jboyer-isl FUN TIMES when an ldirector VM goes down.
12:29 * rfrasur is not panicked.
12:29 jboyer-isl And half a dozen others.
12:29 Dyrcona At least no one was in the middle of open heart surgery when the lights went out.
12:29 rfrasur Dyrcona: exactly.
12:30 jboyer-isl rfrasur: Nothing bad happened, really. If you were on the right network it would seem like nothing happened at all. It just so happens that that network doesn't extend outside the datacenter.
12:30 jboyer-isl Things coming back up at their own pace. :/
12:31 rfrasur lol, well...like I said.  There was no panic here.  I'm sure I dunno why people don't just report outages and go to stand alone without screaming fire from the rooftops
12:32 rfrasur (that plumber that just treated me like a bothersome fly, however, should panic)
12:32 csharp @blame panic
12:32 pinesol_green csharp: panic is NOT CONNECTED TO THE NETWORK!!!
12:32 csharp pinesol_green: ha! good choice
12:32 pinesol_green csharp: I see nothing, I know nothing!
12:32 rfrasur csharp: I think that was problem!  w00t!
12:38 jboyer-isl SWEET. re-restarting. I guess it's time to take this show on the road. :/
12:40 rfrasur jboyer-isl
12:40 rfrasur jboyer-isl++ #even
12:40 rfrasur pardon.  swearing about plumbers
12:43 dbs paxed++
12:44 rfrasur agreed
12:44 * dbs misses salmiakki
12:44 rfrasur gross
12:45 csharp paxed++
12:46 stevenyvr2 joined #evergreen
12:52 jbfink joined #evergreen
12:58 smyers_ joined #evergreen
13:11 rfrasur Is it plausible that a printer not working with a computer nicely has do with a 32 vs 64 bit system?
13:11 timf joined #evergreen
13:16 Dyrcona rfrasur: That is plausible as are many other reasons.
13:17 jasonb-iph joined #evergreen
13:17 rfrasur If printers didn't print so well, I'd hate them.
13:17 pinesol_green [evergreen|Bill Erickson] Default per-request TPAC locale - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=859d49c>
13:18 pinesol_green [evergreen|Bill Erickson] Remove manual TPAC locale applications - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=67a2d15>
13:23 RoganH joined #evergreen
13:46 ktomita joined #evergreen
13:56 bshum dbwells: I'm going to set the milestones for two bugs marked "fix committed" to 2.5.0 since that release will happen before the set value of 2.5.1.  Just while the milestone is still open.
13:57 bshum Err, for two bugs currently targeted at 2.5.1 but have already been fix committed that is.
13:58 bshum Just housekeeping
13:59 smyers_ joined #evergreen
14:01 kbeswick_ joined #evergreen
14:02 kmlussier joined #evergreen
14:06 csharp I was just given an SQL-created report of circulations from an Evergreen system and there are many timestamps that look like this: "43:18.6
14:06 csharp "
14:07 csharp since that doesn't look valid, has anyone else seen that?
14:07 jeff what does the query look like?
14:07 csharp SELECT * FROM action.circulation WHERE duration IS NULL AND recurring_fine IS NULL AND max_fine IS NULL;
14:07 jeff and that's it?
14:08 jeff that looks like a partial timestamp value, with at least the first part chopped off.
14:08 jeff how was the output obtained?
14:08 csharp it was by direct SQL/psql, I think
14:09 csharp I know that this EG instance suffered a data loss event some time back
14:09 csharp I was wondering if this is data corruption from whatever it was that happened
14:10 jeff sure something didn't wrap? if you investigate a single record by id with a timestamp that looks like that in your output, what do you see?
14:10 jeff i'm just wondering if somewhere between the output being generated and being given to you some mangling happened due to long lines, wrapping, mis-parsing by pasting into something like a spreadsheet app, etc.
14:12 csharp yeah maybe, but I don't think so
14:13 csharp lemme try and pastebin something
14:14 csharp http://pastebin.com/ggutDa2J
14:14 csharp not pretty, but should illustrate what I'm seeing
14:17 rfrasur jboyer-isl++ #putting out fires
14:17 jeff csharp: data corruption or possibly just bad migrated data?
14:17 jeff csharp: might depend on the nature of the data loss "event"
14:17 csharp yeah - I was wondering that too
14:17 dbwells bshum: thanks
14:18 csharp I believe the "event" was an errant DROP CASCADE that blew away the actor schema
14:18 jeff it seems too "clean and neat" to be corruption. i'd guess migration or odd bug first.
14:18 csharp I also believe that the library in question pulled in data from an older system to rebuild
14:19 * csharp is short on specifics, but has been assisting this library for one-off issues here and there
14:19 Dyrcona Will postgresql even take 43:18.6 as a timestamp?
14:19 csharp I've never seen anything like it
14:20 dbs csharp: really does look like the timestamp was truncated to minutes:seconds
14:20 csharp okay - that was my thought too
14:20 csharp thanks everyone for looking
14:20 dbs Would be nice if the original SQL was available
14:20 csharp yeah - I'll see what I can get ;-)
14:21 dbs SELECT '48:16.6'::timestamp; -- errors out
14:21 csharp yeah - I can see why these are causing them issues
14:22 Dyrcona csharp: Do you have access to the database to run the query yoursef? (I'm guessing no.)
14:23 dbs or access to the psql history
14:26 csharp Dyrcona: no, I'm abstracted by several layers - I'm dealing with a librarian who has to relay my SQL queries back and forth to/from their IT staff :-/
14:26 csharp needless to say, my help is slow-going
14:27 csharp something I could probably fix within a matter of hours takes weeks ;-)
14:27 jeff the org setting auth.temp_timeout seems to still be in use, but remains undefined in config.org_unit_setting_type -- does that ring any bells for folk? I thought there was a bug with switch user and that setting, and thought (incorrectly, it seems) that it was added to stock data.
14:28 rfrasur okay, the csharp++ for being nice
14:28 * csharp considers that "community support" ;-)
14:28 csharp Dyrcona++
14:28 * rfrasur is feeling less than charitable right now and would consider it something else.
14:29 mmorgan csharp: if I download rows from action.circilation as a .csv file and open in Excel, I get values like you see.
14:29 Dyrcona Well, corroborating what dbs said: I created a table with a timestamp column and a plain text column. When I try to insert those "truncated" timestamps into the column, psql reports a syntax error.
14:33 Dyrcona excel--
14:34 bshum Well, I've had some really weird junk in my postgres timestamps before.  I call that the curse of strange migrated data.  Still not entirely sure how they ended up so screwy.
14:35 csharp mmorgan: ah - interesting - thanks for testing
14:35 csharp yeah my working assumption is that the SQL-to-spreadsheet transfer may be the culprit
14:36 csharp they really need a competent support vendor
14:41 * Dyrcona has a hunch who that is and a clue who the library might be, but isn't sure.
14:43 kmlussier I'm thinking 2 p.m. Eastern Tuesday is probably the best bet for a dev meeting. http://doodle.com/n9avnst6nvs2342g
14:48 smyers__ joined #evergreen
14:51 mjingle joined #evergreen
15:07 rangi` joined #evergreen
15:17 rfrasur jboyer-isl++ x infinity
15:18 jasonb-iph joined #evergreen
15:34 jboyer-isl rfrasur: to be fair, I had to have a lot of help with this one. my Xen power is weak.
15:34 rfrasur give me names and I'll give them karma
15:34 rfrasur rjackson-isl++
15:34 rfrasur adbowling-isl++
15:34 jboyer-isl mrpeters coming through with the support today.
15:34 jboyer-isl mrpeters++
15:34 rfrasur mrpeters++
15:35 mrpeters we're not out of the woods
15:35 rfrasur doesn't matter
15:35 mrpeters utility server is still goofed
15:35 rfrasur speaking of servers....iot.....
15:36 jboyer-isl No word yet
15:36 rfrasur good grief.  but they'll make money.
15:38 rfrasur (or rather...tax money would be shifted from one agency to another)
15:45 mrpeters ok, now you are out of the woods ;)
15:45 mrpeters someone did an umount of the root partition while the machine was live
15:45 mrpeters to fsck it
15:45 mrpeters not so good ;P
15:46 rfrasur I don't know what that means other than it sounds like heart surgery without the patient being put under.
15:46 mrpeters good analogy
15:47 * rfrasur would pass out, too.
15:47 rfrasur (or die from a heart attack)
15:47 rfrasur either way, thank you all for fixing it.
15:48 jeff Waiting for bugs.launchpad.net...
15:49 jeff and third time's a charm.
15:49 rfrasur blech, have I mentioned how much I hate the way the ledger looks near the end of the budget year?
15:49 bshum Sorry, sorry
15:50 * rfrasur shudders
15:50 bshum I'm finally taking a breather to poke at open "new" bugs and put statuses
15:50 bshum I'm only a third of the way through.  I slacked off too much I guess :(
15:51 rfrasur lol, bshum, "slacker" isn't really a word I've ever heard attributed to you.
15:52 bshum I feel like a slacker.
15:53 rfrasur that's diff.  :D
15:54 * rfrasur feels like an 18 year old supermodel.
15:54 rfrasur :D, reality & feeling are not necessarily the same thing
15:55 bshum jeff: Oh thanks alot jeff.  Adding bugs on top of the bug queue, I see how it is!!
15:55 bshum :D
15:55 jeff if you would prefer that they remain unreported...
15:57 bshum jeff: No, I'm just poking at what seems like a really large wall of text
15:57 jeff :-)
15:57 bshum I'll feel happier when dbwells releases 2.5.0 and we can fix release tons of bugs into quiet bliss
15:59 dbwells bshum: It will happen very soon...
16:06 bshum dbwells++
16:08 kmlussier remingtron: I'm getting a 403 error when I try accessing the link to the style guide.
16:11 remingtron kmlussier: Yes, that's the old DocBook style guide link. I shouldn't have put that link first, sorry. The other link is the new draft.
16:13 kmlussier remingtron: Oh, yes. It helps if I read the e-mail before clicking on the link. ;)
16:14 jasonb-iph joined #evergreen
16:14 kmlussier remingtron: I don't know about the DocBook style guide, but we created some basic style rules when doing Evergreen In Action that might be helpful. I'll need to dig a bit to remember where we put them.
16:15 kmlussier remingtron: Thanks for doing this! When I was revising some acq docs a few months ago, I was wishing for a style guide to consult.
16:15 kmlussier remingtron++
16:17 dbs kmlussier: did we stick those in a pirate pad... somewhere?
16:18 kmlussier dbs: Yes, I think it was piratepad.
16:21 * dbs finds http://evergreen-ils.org/irc_logs/evergr​een/2013-06/%23evergreen.14-Fri-2013.log and laughs
16:22 dbs "2013-06-14T14:34:08  <kmlussier> dbs: Since you're around, you wouldn't happen to have any old piratepad URL's saved anywhere. I was trying to track down the one with our style guide, but didn't have any luck."
16:22 kmlussier Heh
16:23 kmlussier I think that was the day I was working on those acq docs I mentioned above. :)
16:35 dbwells kmlussier: speaking of docs, I think it is time to clean out the RELEASE_NOTES_NEXT directory.  Any objections?
16:35 kmlussier No, not at all.
16:36 dbwells kmlussier: thanks, consider it done
16:36 kmlussier Sorry. I was supposed to do that after my last changes to the release ntoes.
16:36 kmlussier /s/ntoes/notes
16:38 dbwells kmlussier: would you prefer that I leave the subfolders, or delete them as well?  I think those were added ad-hoc, but it might make sense to just leave them there for next time.
16:39 kmlussier dbwells: Actually, I think the SIP one was the only one that was added ad-hoc. I think it's useful to keep them there.
16:39 dbwells kmlussier: Ok, sounds good.
16:43 _bott_ left #evergreen
16:43 * dbwells would have eventually spotted the DONOTREMOVE files strewn about
16:45 jeff added another wall of text to bug 1036318
16:45 pinesol_green Launchpad bug 1036318 in Evergreen 2.4 "OPAC timeout within the client" (affected: 13, heat: 68) [Medium,Confirmed] https://launchpad.net/bugs/1036318
17:07 pinesol_green [evergreen|Dan Wells] Delete separate NEXT release notes - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=af83a16>
17:07 sip_ joined #evergreen
17:07 sal_ joined #evergreen
17:11 edoceo joined #evergreen
17:13 mmorgan left #evergreen
17:20 Dyrcona Are we still backporting to rel_2_3?
17:21 jeff i believe so.
17:23 sal_ SIP question, of course--are renewals of rental items (via 29) broken in 2.4.1?  (It works in 2.3.2...)
17:23 jeff i'm guessing that you're seeing that they're broken?
17:23 sal_ Yep.
17:23 sal_ SIP server disconnects.
17:25 sal_ I don't see anything in the SIP log--it starts processing the request, and then nothing (except for 99s from another client)
17:27 sal_ circ log starts a rollback based on fee, even though 29 is sent with BOY...
17:28 jeff sal_: does the renewal occur in evergreen, regardless of the sip hangup?
17:28 jeff you'd see "OILS: Renewal failed" or "OILS: Renewal succeeded" in logs.
17:28 jeff (if logging at info or higher)
17:29 sal_ Which logs should I be looking at (currently looking at SIP and Circ)
17:29 pinesol_green [evergreen|Dan Wells] Fix typos in 2.5 release notes - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=ec745cd>
17:30 jeff sal_: you should see those lines in the sip logs -- where your SIPServer.pm log lines typically go.
17:31 jeff also, check the due date of the item -- was it renewed, etc.
17:31 jeff also, does the renewal work in the staff client?
17:32 jeff a quick glance didn't show anything recent changing with regard to renew, other than the addition of renew all support. it's possible that something changed in evergreen that the evergreen sip driver needs to be taught to support.
17:32 jeff we're not currently using 29/30, but i might take a look later tonight.
17:34 sal_ Hmm.  I'm seeing renewal reports in 2.3.2 SIP log, but not 2.4.1 SIP log.
17:38 sal_ 2.3.2 is not renewing based on the fee, but isn't disconnecting from the client.  I'm going to try a non-feed item in both...
17:43 sal_ (as soon as I figure out who I put them on hold for ;-) )
17:49 sal_ For items with no fee, no problem
17:50 sal_ Renewals work fine on 2.4.1.
17:50 sal_ But the 29 + BOY seems to make the newer? SIP server unhappy.
18:28 sal_ jeff:similarly, can renew rental items using 11 + BOY.  (Can understand why 29 might not work, but it shouldn't drop the SIP connection :-( )   I'll check in again tomorrow--gotta scoot.  Thanks!
20:01 mjingle left #evergreen
20:26 jbfink joined #evergreen
22:04 stevenyvr2 joined #evergreen
22:04 stevenyvr2 left #evergreen
22:06 zerick joined #evergreen

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