Evergreen ILS Website

IRC log for #evergreen, 2016-01-28

| 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
00:14 bmills joined #evergreen
00:16 bmills1 joined #evergreen
01:16 bmills joined #evergreen
02:17 bmills joined #evergreen
04:05 bmills joined #evergreen
05:11 Slava_ joined #evergreen
05:29 Slava_ joined #evergreen
05:53 bmills joined #evergreen
07:11 kmlussier Good morning #evergreen
07:11 kmlussier @coffee someone
07:11 * pinesol_green brews and pours a cup of Ethiopia Yirgacheffe Beloya Selection 8, and sends it sliding down the bar to someone
07:11 kmlussier heh, looks like I'm in need of coffee
07:12 kmlussier @coffee [someone]
07:12 * pinesol_green brews and pours a cup of Ethiopia Yirgacheffe Beloya Selection 8, and sends it sliding down the bar to phasefx
07:12 kmlussier @tea [someone]
07:12 * pinesol_green brews and pours a pot of Bi Luo Chun Green Tea (Pi Lo Chun), and sends it sliding down the bar to mnsri_away (http://ratetea.com/tea/teavivre/bi-l​uo-chun-green-tea-pi-lo-chun/6490/)
07:38 rjackson_isl joined #evergreen
07:41 JBoyer joined #evergreen
07:41 bmills joined #evergreen
07:56 mrpeters joined #evergreen
08:01 ericar joined #evergreen
08:31 Stompro joined #evergreen
08:32 remingtron joined #evergreen
08:46 Dyrcona joined #evergreen
08:48 RBecker joined #evergreen
09:08 jwoodard joined #evergreen
09:08 mmorgan joined #evergreen
09:26 JBoyer I accidentally bought some Rooibos red tea and I think I've stumbled onto a terrorist plot. It smells like a cup of cigarettes and tastes like tobacco and licorice.
09:26 maryj joined #evergreen
09:26 csharp @quote add < JBoyer> I accidentally bought some Rooibos red tea and I think I've stumbled onto a terrorist plot. It smells like a cup of cigarettes and tastes like tobacco and licorice.
09:26 pinesol_green csharp: Error: You must be registered to use this command. If you are already registered, you must either identify (using the identify command) or add a hostmask matching your current hostmask (using the "hostmask add" command).
09:27 csharp @quote add < JBoyer> I accidentally bought some Rooibos red tea and I think I've stumbled onto a terrorist plot. It smells like a cup of cigarettes and tastes like tobacco and licorice.
09:27 pinesol_green csharp: The operation succeeded.  Quote #138 added.
09:27 JBoyer At least some good can come of the whole ordeal.
09:28 csharp JBoyer: I had that reaction when I gave up caffiene several years ago - it was a very poor replacement for morning coffee (I've since moved to decaf coffee and tea), but the taste has grown on me ;-)
09:28 bmills joined #evergreen
09:28 csharp caffeine?
09:29 csharp one product of getting into my 40s is that my internal autocorrect is faulty
09:29 * csharp relies on google/spellcheck constantly nowadays
09:30 JBoyer My caffeine free tea of choice is peppermint. as for spell checking, is that not an option for your IRC client? I love it in mine.
09:30 JBoyer (Though "auto-correct spelling errors" is not a good idea in IRC.)
09:30 csharp probably - I use irssi and there's a plugin for pretty much anything you can think of
09:33 yboston joined #evergreen
09:46 tsbere JBoyer / csharp: I know some people that swear by "Teafee" - Half Coffee, half Tea
09:49 JBoyer That initially sounds like something I would swear /at/, but I did just finish an entire mug of Mail Pouch and Red Vines, so I should probably at least try it.
09:49 dbwells joined #evergreen
09:49 csharp JBoyer++
09:50 csharp tsbere: yowza
09:52 jonadab The only tea (well, "tea" -- it's an herbal) that I've had that I really disliked was chamomile.
09:52 tsbere Apparently the tea in "Teafee" is nearly-coffee-strength black tea or something like that
09:53 Dyrcona JBoyer: Mail Pouch? When I hear Mail Pouch as a brand name, I think of chewing tobacco.
09:53 JBoyer See my description of that tea, above.
09:54 JBoyer There's about to be a giveaway.
09:56 JBoyer (Though I did reference both cigs and chewing tobacco, I suppose that's confusing. I couldn't think of a cig brand that sounded as good.)
09:57 JBoyer Dyrcona: I was just thinking about you recently. Do you know if anyone has implemented the SHAREit XML API to include search results in their local catalogs? I'm reading the docs and it sounds like a proper ordeal.
09:57 JBoyer I was curious if anyone has gone to the trouble, which would be a little bit surprising.
09:57 Dyrcona JBoyer: We're using Z39.50.
09:57 Dyrcona or, rather, they are...
09:58 Dyrcona Hence all the discussion last week about z39.50 and it doing quoted searches.
09:58 berick gmcharlt: I didn't have much in the way of sqitch slides.  most of what I conveyed at the hackaway can be found at https://bugs.launchpad.net/evergreen/+bug/1521693 and http://wiki.evergreen-ils.​org/doku.php?id=dev:sqitch
09:58 pinesol_green Launchpad bug 1521693 in Evergreen "Investigate using Sqitch for database change management" [Wishlist,New] - Assigned to Bill Erickson (berick)
09:58 JBoyer I mean the other way, including ComCat results in local opacs. Something like "Couldn't find what you need? try this..."
09:58 gmcharlt berick: thanks (and that's ultimately what I pointed the person to)
09:58 berick gmcharlt: awesome
09:59 Dyrcona JBoyer: Oh, no. No one has done that. We added a link to go to the ILL search, though.
09:59 Dyrcona As an aside, I hate how library vendors still call passwords/phrases, "PINs."
10:00 Dyrcona "Are patrons required to enter PINs?"
10:01 Bmagic There must be something we are missing for PG 9.3 - it's definatly slower than 9.2. I just loaded 29k bibs on two identical DB's one 9.2 and the other 9.3. 9.3 took 100 minutes longer!
10:01 Dyrcona I feel like saying, "Yes, but it's a passphrase as complicated as they like and may contain characters that will cause your current system to barf all over itself, and btw, mine actually contains a character that precludes me from using SIP2."
10:01 Dyrcona Bmagic: Did you tune it?
10:01 Bmagic Dyrcona: yes
10:02 Dyrcona Bmagic: Tune it some more. :)
10:02 JBoyer That's what I thought. Given the two options it's 1000x easier to put together a URL that performs the same search again on their system, but we're hoping to have search results ready to go, so a-toiling-I-go.
10:02 Bmagic Dyrcona: I assume you mean pgtune - I also decided to change some of the settings that pgtune created to match closer to what we had in 9.2
10:02 Dyrcona JBoyer: I don't think we perform the search for them. It just dumps them on the search page.
10:02 Dyrcona Bmagic: Oh hells now. pgtune sucks.
10:03 Bmagic Dyrcona: that's what I've learned here, so we don't rely on it. Here are the major final settings: shared_buffers = 8GB work_mem = 224MB
10:04 JBoyer Oh, there's a simple way to use some URL params to take them right to a results page. That's what we'll probably distribute to several of our smaller ILS users. It's still searching again, but at least you might not have to type everything twice.
10:04 Dyrcona JBoyer: yeah, i didn't pay too much attention to it. tsbere set it up.
10:04 Bmagic Dyrcona: the hardware has 224GB RAM and the DB on disk is 80GB
10:05 Dyrcona Bmagic: When I need to tune a Pg installation, I usually spend days pouring over wiki pages and conference slides, and then twiddle things until it is "fast enough."
10:05 csharp Bmagic: do you have more than one RAID controller?
10:05 csharp Dyrcona: that's my current method too ;-)
10:05 Bmagic Dyrcona: what method do you use to test speed?
10:06 tsbere JBoyer: For reference, I found that "search in their system" and "login to their system" didn't play nice together in the same link. So I skipped the "search" part.
10:06 csharp Bmagic: http://www.postgresql.org/docs/9.3/s​tatic/runtime-config-connection.html and following explain every setting in pretty good detail
10:06 Dyrcona Bmagic: None that's worth mentioning.
10:07 Bmagic csharp: ty
10:07 Dyrcona I might time some scripts, etc.
10:08 JBoyer I'd like to someday pull an entire day's worth of queries from the logs, keep the dump from that day; clean up any that don't play nice, then see how long it takes to replay that day on a fresh reload. It would be easy to see how big an impact settings changes make across that level of activity. It's more difficult to improve everything when you can only really test this or that slow query.
10:08 csharp Bmagic: check 'top' for high wait when things are slow - it might mean you need to reevaluate your disk setup - we're on SSDs now, but when we were on spinning disks, adding a second RAID controller solved all our problems
10:08 Bmagic csharp: changing hardware isn't in the cards right now. The fact is, 9.2 was faster
10:08 Bmagic on the same hardware
10:08 csharp Bmagic: understood
10:09 Dyrcona Trouble is, you can't really just copy someone else's config, even if they're roughly the same size as you.
10:09 Dyrcona The use patterns may be very different.
10:10 Bmagic Dyrcona: right, I understand that for sure
10:10 Bmagic Dyrcona: But we basically copied the config from 9.2 to 9.3
10:10 csharp Bmagic: check for new settings in 9.3 config that are at the default values
10:11 * csharp found vimdiff to be extremely helpful doing that
10:11 Bmagic csharp: yeah, that thought crossed our mind - looking into that
10:11 Dyrcona csharp++ # I was 'bout to recommend something similar.
10:12 JBoyer tsbere: That makes sense, I think users would rather re-search than login again.
10:12 csharp Bmagic: the settings I would scour first are Resource Consumption ( http://www.postgresql.org/docs/9.3/​static/runtime-config-resource.html ) and Query Planning ( http://www.postgresql.org/docs/9.3​/static/runtime-config-query.html )
10:13 csharp also I recommend pg_top (apt-get install pgtop on debian/ubuntu)
10:13 csharp and, of course pgbadger for log sifting/analysis
10:18 Bmagic thanks all - good suggestions
10:19 Bmagic Dyrcona++ csharp++
10:20 miker Bmagic: higher load than 9.2?
10:21 Bmagic miker: yes - we had to turn of autosuggest to calm it down
10:22 Bmagic miker: but now, it's definatly apparent that the db is simply slower than 9.2 with that expierement mentioned above with reguard to bib load
10:22 miker Bmagic: possibly relevant solution point in a PG thread.  I suggest starting at the beginning of that thread and reading through the whole thing: http://www.postgresql.org/message-i​d/CAP=oouH0tXbA-4qw0Hd0tbJV2wj1Lp8A​=UaSf-dvV2-soap5jA@mail.gmail.com
10:23 miker csharp: this may also be relevant to your interests
10:23 Bmagic miker++
10:26 krvmga joined #evergreen
10:52 csharp miker: thanks - I'll take a look
10:55 csharp interesting - I was reading about THP issues last week regarding this issue
10:55 * csharp has too many "issue"s
10:56 JBoyer I've got more issues than National Geographic.
10:58 krvmga JBoyer: that's the best one of those i've heard...better than Vogue or Time.
10:59 JBoyer Also, now that it's owned by Murdoch, it's all very meta.
11:00 krvmga https://xkcd.com/917/
11:00 krvmga obligatory xkcd reference
11:02 JBoyer krvmga++
11:02 Christineb joined #evergreen
11:02 JBoyer It took two readthroughs, but only two.
11:03 JBoyer xkcd++
11:08 RoganH joined #evergreen
11:08 csharp GNU's Not Unix, y'all
11:09 JBoyer GNUy's Not Unix, y'all see?
11:11 krvmga JBoyer++
11:11 krvmga csharp++
11:11 RoganH I clearly haven't had enough coffee yet this AM.
11:11 kmlussier @coffee RoganH
11:11 * pinesol_green brews and pours a cup of El Salvador Finca Siberia Pacamara, and sends it sliding down the bar to RoganH
11:13 bmills joined #evergreen
11:14 mmorgan joined #evergreen
11:17 JBoyer An Example of the <SOMEXMLSOAPELEMENT> is shown below:
11:17 JBoyer (A bunch of WSDL spew)
11:17 JBoyer Me: THAT'S NOT WHAT EXAMPLE MEANS.
11:17 * jeff carefully backs away from JBoyer
11:18 * jeff makes mental note to inquire at his next physical about getting his SOAP booster shot
11:19 Dyrcona JBoyer: Perhaps XML examples are not quite exemplary?
11:19 JBoyer jeff: I've been transcribing WSDL definitions into actual examples for an XML API that I'm trying to learn more about. The only thing more annoying than it being specified in copy/pasted chunks of WSDL obviously taken from IE is the inaccuracies between the prose and screenshots.
11:20 JBoyer Dyrcona: evidently not.
11:21 Dyrcona WSDL rings some long silent bells in mind....As if I had to use it briefly once, and chose to forget about it later.
11:22 JBoyer I've only ever seen it used in web services implemented in an MS .Net language. I think everyone else gave up and moved on to REST.
11:23 Dyrcona Yes, that sounds about right, something I was doing with IIS back in 2002 or so before I wised up, left that place, and worked as UNIX sysadmin.
11:25 sandbergja joined #evergreen
12:22 geoffsams joined #evergreen
12:31 bmills joined #evergreen
12:34 jihpringle joined #evergreen
12:51 Dyrcona @decide make new test accounts or crack passwords on existing test accounts?
12:51 pinesol_green Dyrcona: go with crack passwords on existing test accounts?
12:56 RoganH Clearly that would take less time.  Or at least be less tedious.  One of those.
12:58 Dyrcona Assuming that the majority of the test accounts have four digits for the password, yes.
12:58 Dyrcona And by test account, I mean "not real patrons used for testing purposes."
13:02 Dyrcona And now, I apparently don't have to....
13:03 Dyrcona We apparently already sent this information, and I was just given the spread sheet that was sent previously.
13:03 Dyrcona Oh well, it could have been a "fun" way to spend the afternoon.
13:09 * tsbere cracked the passwords on a few thousand accounts just to test some code he provided to Dyrcona for possibly cracking existing accounts >_>
13:09 jeff yeah. it takes about 27ms to generate hashes for four digit pins.
13:09 jeff and that's with storing them in a temp table for reuse.
13:10 jeff for one, it's actually faster to skip the temp table.
13:10 jeff ~19ms
13:10 pinesol_green Factoid '19ms' not found
13:10 tsbere I don't store them, but I think PG generates them once for all the comparisons.
13:19 jeff for extra fun, count the number of active users by group and/or limit to those with a work_ou.
13:19 jeff (then disable and/or educate those users with great haste)
13:23 jeff defaults have power.
13:31 Dyrcona Hmm. Cronscript.pm could probably use a public accessor for the options.....
13:32 Dyrcona $object->{opts_clean} is too dangerous.
13:32 Dyrcona And $object->MyGetOptions() can only be done once before you do anything that calls it internally.
14:00 kmlussier @developer
14:00 pinesol_green kmlussier: Communication:11, BigPicture:13, DetailOriented:16, KungFu:9, GetsStuffDone:13, FlakeFactor:11, JavaAvoidance:8
14:06 Dyrcona @librarian
14:06 pinesol_green Dyrcona: Management:17, Cataloging:11, Acquisitions:13, Reference:7, Circulation:10, Systems:13, Research:7, Custodial:11
14:13 kmlussier Dyrcona: Nice high score on acquisitions!
14:13 kmlussier dbwells++ # Continuing the good fight with negative balance issues.
14:13 Dyrcona Yeah, well, Dr. Sineath would be proud of the Management score. :)
14:14 Dyrcona dbwells++
14:23 bmills dbwells++ thanks for the help with the listserv post!
14:41 afterl joined #evergreen
15:04 mmorgan left #evergreen
16:00 jlitrell joined #evergreen
16:14 afterl left #evergreen
16:34 Dyrcona Nothing like doing a git gc to slow down your backups. :)
16:39 jwoodard @librarian
16:39 pinesol_green jwoodard: Management:15, Cataloging:13, Acquisitions:15, Reference:12, Circulation:9, Systems:14, Research:13, Custodial:14
16:40 jwoodard circulation is an accurate reflection atm
16:50 maryj joined #evergreen
17:22 bmills joined #evergreen
17:24 kmlussier Since I've been filing so many web client bugs this week, I also want to add a gmcharlt++ miker++ berick++ for all of the work they've put into bringing the web client along this far.
17:25 berick kmlussier++ right back atcha
17:32 gmcharlt indeed
17:32 gmcharlt kmlussier++
18:05 jihpringle joined #evergreen
18:12 dcook joined #evergreen
18:54 csharp kmlussier++ gmcharlt++ berick++ miker++
18:54 csharp allyall++
18:54 * gmcharlt remembers that I am, after from, from PA
18:54 gmcharlt yous++
18:54 gmcharlt ;)
18:54 csharp heh
21:54 * csharp plays with pg_prewarm
21:56 * dcook would love to hear gmcharlt say yous in real life :P
22:04 bmills joined #evergreen

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