Time Nick Message
13:24 danny good morning #koha
13:25 ryan hi danny
13:25 owen Hi danny, ryan
13:31 lloyd_ atz, you around?
13:44 lloyd_ lists.koha.org down?
13:45 masonj hmm, could be..
13:48 lloyd_ looks like it then :)
13:49 atz lloyd_: what's up?
13:52 lloyd_ Owen said you might have done some work on googlejackets?
13:54 hdl hi
13:54 hdl lloyd_: yes.
13:55 lloyd_ well... I'm looking for a way to play with the returned urls a little
13:55 atz lloyd_: that's true. we have amazon, baker & taylor and google as possible image sources
13:55 lloyd_ atm it returns a url like this : http://bks2.books.google.com/books?id=PZ2UHgAACAAJ&printsec=frontcover&img=1&zoom=5&sig=V8KhZiWBLUytx4hLVytjtPPO4xo
13:56 lloyd_ I need to be able to tweak it some how so the domain name changes from bks2.books.google.com to http://www.libcat.eoe.nhs.uk/googlebooksapi/
13:56 lloyd_ thus making the image url : http://www.libcat.eoe.nhs.uk/googlebooksapi/books?id=PZ2UHgAACAAJ&printsec=frontcover&img=1&zoom=5&sig=V8KhZiWBLUytx4hLVytjtPPO4xo
13:57 atz is this for caching? or just your own image source?
13:57 lloyd_ best way to explain why I need this is, some of our internal site dont have access to the internet, but do have access to www.libcat.eoe.nhs.uk
13:58 lloyd_ http://www.libcat.eoe.nhs.uk/googlebooksapi/ is just a reverse proxy (using mod_proxy) to bks2.books.google.com
13:58 lloyd_ you follow?
13:58 hdl lloyd_ : optic fiber cable was torn.
13:59 lloyd_ I hate that.. It's even worse when they get stuck in the cabinet door and you ruin them
14:01 atz lloyd_: i'm not sure how is best to address that as a long term fix.
14:01 lloyd_ indeed
14:01 atz the google js code is locally koha-tmpl/opac-tmpl/prog/en/js/google-jackets.js
14:02 lloyd_ I suspect others will have the problem and need the work around
14:02 atz this is the kind of thing I categorize as "not a koha problem", meaning it falls to system integrator type ppl (like myself)
14:02 lloyd_ if it's possible to make a syspref to hack the url, I could write up a howto on setting up a reverse caching proxy in apache
14:04 lloyd_ I agree, it's not a koha problem. but lots of sites will suffer from the same problem. Like all UK schools and UK Hospitals
14:04 lloyd_ so having a work around, feature, setting could be useful?
14:04 atz lloyd_: are you at least sending X-REQUESTED_BY headers via apache?
14:05 atz ( i think that's default behavior, but I haven't set up proxies on 2.2)
14:05 lloyd_ lemme show
14:06 lloyd_ http://pastebin.com/m5e0c448c
14:06 lloyd_ the config could obviously be made a little better, using bks1-9.books.google.com and loadbalancing over them
14:07 atz right
14:07 atz so if you wanted to hack the static js, you could just edit that file I referenced
14:08 atz and do a js regexp to get what you want
14:08 atz but this is a compound proble, I think
14:08 atz *problem
14:08 atz you have the image request... but first you have the "index" request
14:08 atz that returns the URL of the image
14:09 atz so you would need a second proxy setup
14:09 lloyd_ yes, for books.google.com
14:09 atz right
14:09 lloyd_ then a function to rewrite the url after it's returned
14:09 atz and, in fact, if you proxy that, you might not need the later one, if you care to hack the response
14:10 lloyd_ Seeing how to do it isn't a problem
14:10 lloyd_ I would like the fix/workaround to be available to the community
14:11 atz there are 2 options for broader integration
14:12 atz one is to move the js file into a dynamic position where it gets processed instead of served statically: then you could have some syspref take effect
14:12 hdl lloyd_: why don't you use mod proxy for your purpose ?
14:13 lloyd_ hdl, I am :p
14:14 atz the other is to copy the 50 line file to "google-jackets-proxy.js". edit it to your liking and allow a syspref to select the google js file.
14:15 lloyd_ I think the first way is best?
14:16 atz lloyd_: i actually prefer the second, but if you're doing the work, you get to pick
14:16 owen The advantage to having the js file served statically is that it can be cached by the browser
14:16 atz right
14:16 lloyd_ well hmmz
14:16 atz (or any other cache)
14:17 lloyd_ linking to a seperate google-jackets.js file, would mean another file you have to retain when upgrading versions
14:18 atz lloyd_: it would be like a local CSS file
14:18 lloyd_ so, hack the .js and add syspref option to change the location of google-jackets-proxy.js
14:20 lloyd_ doesnt feel right :)
14:21 atz i used to support libraries in juvenile prisons where their network was thoroughly locked down
14:21 owen atz, what are the prefs required for Baker and Taylor images? I nuked my system prefs yesterday by accident and now they're not there
14:21 atz owen: i think they all moved to "enhanced content" tab
14:22 atz w/ the other jacket image stuff
14:22 owen Yeah, I don't have any B&T stuff listed there
14:23 atz odd.. i have a B&T tab still, but it's empty
14:23 lloyd_ If I hack the .js and write howto on setting it up (posting on the wiki), is someone up for adding the syspref for google-jacket-proxy.js location?
14:23 hdl lists.koha.org is back
14:24 atz lloyd_: can't promise any kind of timeline, but I'd be willing to do it
14:26 lloyd_ ok... I'm not sure what's involved but it'd be nice to get it done before B3
14:26 atz owen: for me they show up in Enhanced Content tab still
14:26 atz not sure what's up there
14:29 owen atz, do you have more time for book cover talk?
14:30 atz ok
14:30 owen The book covers aren't working for me in the shelf browser now
14:31 owen I think it's a problem with the ISBN being used in the shelf browser loop?
14:31 owen It's another place where the book cover image choices come into play
14:32 atz do I have to enable that?
14:33 owen Yes. Do you have an OPACShelfBrowser preference?
14:33 owen I didn't, after my system prefs debacle. I had to add it by hand.
14:33 atz i don't have one... rebased yesterday
14:36 atz owen: ok, enabled (and the system recognized it, put it in the OPAC ta
14:36 atz *tab
14:36 atz where do I find it in the opac though?
14:37 atz ah... "Browse Shelf" perhaps
14:37 atz owen: what is your image source?
14:38 atz right now I'm getting B&T ok.
14:38 owen I've just tried Google and B&T with no success
14:38 atz do you have a B&T account?
14:39 owen kados gave me some credentials so I could test
14:40 owen I'll check my copy of opac-detail.tmpl. Maybe its something I changed.
14:41 atz and you just updated in the past day or so?
14:41 atz we should have the same version then...
14:44 owen Hm, It was just the luck of the draw, and I just wasn't getting images.
14:45 atz test search "modern phrenology"
14:45 atz :)
14:45 atz or something equally obscure/old
14:46 owen http://oleonard.dev.kohalibrary.com/cgi-bin/koha/opac-detail.pl?biblionumber=461&shelfbrowse_itemnumber=943#shelfbrowser
14:46 owen With Google Jackets now. Why does the cover show above, but not in the browser?
14:46 owen I guess because the isbn isn't sanitized in the shelf browser.
14:47 atz good question.... looks inadequately sanitized
14:47 atz (as you just said)
14:48 atz i have trouble believing that library data *today* still has trouble specifying ID numbers w/o interjecting other crap into it...
14:48 atz shouldn't there be a spec that says "in this field/subfield, here liveth the ID and naught else"
14:51 atz oh well...
14:51 owen It doesn't seem like MARC is known for its data cleanliness...
14:51 atz owen: opac-search.pl creates a "clean_isbn" field for hit results
14:52 slef hi all
14:52 atz greets slef
14:56 owen atz, what's the difference between clean_isbn and amazonisbn?
14:57 atz probably not much
14:57 owen In the template, Amazon and Google use amazonisbn, B&T uses clean_isbn
14:58 atz actually... i already injected a FIXME at 228 of opac-detail
14:58 atz clean_isbn is better, i believe...
14:59 atz my $xisbn=$dat->{'isbn'};
14:59 atz $xisbn =~ /(\d*[X]*)/;
14:59 atz $template->param(amazonisbn => $1); # FIXME: so it is OK if the ISBN = 'XXXXX' ?
14:59 atz my ($clean, $amazonisbn);
14:59 atz $amazonisbn = $1;
14:59 atz # these might be overkill, but they are better than the regexp above.
14:59 atz if (
14:59 atz $amazonisbn =~ /\b(\d{13})\b/ or
14:59 atz $amazonisbn =~ /\b(\d{10})\b/ or
14:59 atz $amazonisbn =~ /\b(\d{9}X)\b/i
14:59 atz ) {
14:59 atz $clean = $1;
14:59 atz $template->param(clean_isbn => $1);
14:59 atz }
15:00 atz and there should be many more, unfortunately
15:01 owen Shouldn't that isbn processing be a function that can be re-used?
15:01 atz yeah
15:05 atz owen: looks like the unsanitized isbn has a line break in it
15:05 atz before the "(pb"
15:05 owen Yeah, I don't even know how that would happen
15:06 atz so that *could* be addressed w/ data cleanup
15:06 atz though koha should be consistent in any case
15:14 lloyd_ atz or owen
15:14 lloyd_ either of you fancy replacing google-jackets.js on your dev system with this : http://www.libcat.eoe.nhs.uk/google-jackets-proxy.js
15:16 owen lloyd_, I'll take it for a whirl
15:16 lloyd_ *bites nails*
15:20 owen atz, gmcharlt, ryan: Should I be worried that WinSCP is warning me about arwen's host key changing?
15:20 atz ip address?
15:21 atz should be 72.232.235.42
15:21 atz hrm... i just got the warning myself
15:22 gmcharlt owen, atz: probably related to Debian OpenSSH bug
15:22 atz gmcharlt: the key changed... what did it?
15:22 gmcharlt atz: clay cleaning up after the bug, I assume
15:22 owen gmcharlt: ignore?
15:23 gmcharlt atz: fix includes regenerating ssh keys
15:23 atz i see... this will screw up many many things
15:24 gmcharlt owen: ignore - I confirmed that Clay has in fact changed the key
15:24 atz ok, thx gmcharlt
15:44 atz owen: got a patch for you to try out on your shelfbrowser problem
15:45 owen thanks atz
15:48 atz let me know if that helps at all
16:17 owen Looks like that did help, atz
16:18 owen Now the new issue: The cover image for the current title doesn't show in the shelf browser... I'm guessing because they have identical IDs?
16:18 atz owen: ah right... they would.
16:45 owen atz, what does the greybox stuff have to do with Google Jackets?
16:48 atz owen: don't know what you mean
16:49 owen <!-- TMPL_IF NAME="GoogleJackets" --><script type="text/javascript">
16:49 owen var GB_ROOT_DIR = "/intranet-tmpl/prog/en/lib/greybox/"; ...etc.
16:50 atz cute name. "it's not a black box... it's a *grey* box."
16:51 atz just another directory though afaik
16:54 owen Hmm... Taking that out doesn't affect the display of Google book jackets
16:56 owen I wonder if there was something else planned that required the greybox library...
16:59 atz not sure... maybe to allow staff to compare image sources
17:59 owen Hi bb_marblehead
17:59 bb_marblehead Hi owen
18:23 ryan owen et al, speaking of external content, how does that affect ssl ?
18:24 ryan i see i get a warning in my browser on an ssl site, i assume it's the external links that are causing it
18:24 owen Yeah. Would the browser show the same warning if you were showing content from two different secure connections?
18:26 owen Maybe that's a good reason to use lloyd's proxy system
18:27 ryan i'm not sure of the requirements
18:27 ryan it would be nice to get rid of that error though
18:27 owen ryan, you have a client who requires a secure connection for their opac?
18:28 ryan no, the staff client.
18:28 ryan yes, that'd be good
18:55 tim I get an error about an unknown column 'done' in a where clause when I run missing090field.pl. This is from a git pull less than an hour ago.
18:55 tim It's looking for the 'done' column in the 'zebraqueue' table.
20:42 pianohacker Just out of completely random curiousity, why is the Koha module namespace named C4?
20:44 gmcharlt pianohacker: I've heard different stories
20:45 gmcharlt one of them comparing it to the explosive
20:45 gmcharlt but don't know definitively
20:49 acmoore kados seemed to have a story involving an application C2 that replaced something (C, maybe?). The next one was going to be C3, but they may have skipped that in order to make a good joke.
20:49 acmoore it all sounds a little "made up" to me.
20:53 pianohacker Huh
20:53 chris well seeings as i named it
20:53 chris i can tell ya why
20:53 acmoore aha!
20:53 pianohacker Yay
20:53 chris they indeed were running a system called C2
20:54 chris C3 was supposed to have been released about 3 years before .. never was
20:54 chris so i jokingly named it C4
20:55 pianohacker Hah
20:55 pianohacker and the Koha name came along later?
20:55 chris yeah Koha came along when we released it
20:56 chris it was called Kumara for a while there too
20:56 chris in fact i still have hte old Kumara cvs repo
20:56 chris it went C4 -> Kumara -> Koha
20:57 chris never got round to renaming the package space though :)
20:57 gmcharlt chris: what's a kumara?
20:57 chris sweet potato
20:57 pianohacker Bahaha
20:57 chris was the staple source of starch/carbohydrates for maori
20:58 chris http://www.teara.govt.nz/1966/K/Kumara/Kumara/en
21:00 chris Katipo has a tradition of using K words
21:00 chris Koha, Kea, Kete etc
21:01 russel Konae was another one
21:01 chris ahh yep
21:01 chris my first opensource release .. timesheeting software .. never really went anywhere tho
21:01 chris i think Katipo and Face use it still though
21:11 chris hey nicole
22:02 liz question... we have done something to our koha3 that has locked out all of our users, it's technically ok since it's only a test server, but we'd really rather not dump the database... is there anything we can do?
22:03 liz We think we deleted or changed a bunch of libraries or branches while also changing category codes
22:06 liz well bummer, guess everybody went home. I'll ask again tomorrow
22:11 gmcharlt liz: I'll be leaving soon, but could you provide some more details about what you were doing?
22:12 liz the sad thing is that I wasn't standing there when it happened, but as I understand it the user was deleting libraries/branches and changing category codes
22:13 liz my guess is that he changed the home library that his user was affiliated with and now... who knows which library he is a patron of
22:13 liz but the kohadmin user can't log in either
22:15 gmcharlt liz: hmm - one thing to try is doing a query to see if any branchcodes still exist in the staff patron records that don't have branches defined, then adding those codes back temporarily
22:15 gmcharlt i.e., select distinct branchcode from borrowers;
22:15 liz oh good idea
22:16 gmcharlt since kohaadmin can't log in for some reason, adding the missing branches can be done via SQL -> just insert into the branches table
22:16 liz interesting, the previous command brings back only ONE branchcode
22:17 liz >.< this is only the 2nd time he's buggered it in a month (LOL)
22:19 liz ok, tyvm for the ideas, I'm going to have to go as well, you'll probably hear more from me tomorrow.
22:19 liz thanks for the help
22:19 gmcharlt yw, good luck
09:37 mc hello koha people
09:38 chris hi mc
10:52 lloyd_ night
11:49 lloyd_ http://www.libcat.eoe.nhs.uk/google-jackets-proxy.js - For anyone that will find it useful. I've written a howto and once the patch for customisable google-jackets.js location is submitted i'll put it on the wiki.