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