← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| 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 | 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 | 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/b[…]ytx4hLVytjtPPO4xo |
| 13:56 | 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 | thus making the image url : http://www.libcat.eoe.nhs.uk/g[…]ytx4hLVytjtPPO4xo | |
| 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 | http://www.libcat.eoe.nhs.uk/googlebooksapi/ is just a reverse proxy (using mod_proxy) to bks2.books.google.com | |
| 13:58 | 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 | 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 | 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 | ( i think that's default behavior, but I haven't set up proxies on 2.2) | |
| 14:05 | lloyd_ | lemme show |
| 14:06 | http://pastebin.com/m5e0c448c | |
| 14:06 | 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 | so if you wanted to hack the static js, you could just edit that file I referenced | |
| 14:08 | and do a js regexp to get what you want | |
| 14:08 | but this is a compound proble, I think | |
| 14:08 | *problem | |
| 14:08 | you have the image request... but first you have the "index" request | |
| 14:08 | that returns the URL of the image | |
| 14:09 | 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 | I would like the fix/workaround to be available to the community | |
| 14:11 | atz | there are 2 options for broader integration |
| 14:12 | 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 | 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 | 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 | 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 | I think it's a problem with the ISBN being used in the shelf browser loop? | |
| 14:31 | 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 | 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 | owen: ok, enabled (and the system recognized it, put it in the OPAC ta | |
| 14:36 | *tab | |
| 14:36 | where do I find it in the opac though? | |
| 14:37 | ah... "Browse Shelf" perhaps | |
| 14:37 | owen: what is your image source? | |
| 14:38 | 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 | 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 | 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 | :) | |
| 14:45 | or something equally obscure/old | |
| 14:46 | owen | http://oleonard.dev.kohalibrar[…]=943#shelfbrowser |
| 14:46 | With Google Jackets now. Why does the cover show above, but not in the browser? | |
| 14:46 | I guess because the isbn isn't sanitized in the shelf browser. | |
| 14:47 | atz | good question.... looks inadequately sanitized |
| 14:47 | (as you just said) | |
| 14:48 | i have trouble believing that library data *today* still has trouble specifying ID numbers w/o interjecting other crap into it... | |
| 14:48 | shouldn't there be a spec that says "in this field/subfield, here liveth the ID and naught else" | |
| 14:51 | 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 | clean_isbn is better, i believe... | |
| 14:59 | my $xisbn=$dat->{'isbn'}; | |
| 14:59 | $xisbn =~ /(\d*[X]*)/; | |
| 14:59 | $template->param(amazonisbn => $1); # FIXME: so it is OK if the ISBN = 'XXXXX' ? | |
| 14:59 | my ($clean, $amazonisbn); | |
| 14:59 | $amazonisbn = $1; | |
| 14:59 | # these might be overkill, but they are better than the regexp above. | |
| 14:59 | if ( | |
| 14:59 | $amazonisbn =~ /\b(\d{13})\b/ or | |
| 14:59 | $amazonisbn =~ /\b(\d{10})\b/ or | |
| 14:59 | $amazonisbn =~ /\b(\d{9}X)\b/i | |
| 14:59 | ) { | |
| 14:59 | $clean = $1; | |
| 14:59 | $template->param(clean_isbn => $1); | |
| 14:59 | } | |
| 15:00 | 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 | owen: looks like the unsanitized isbn has a line break in it | |
| 15:05 | 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 | though koha should be consistent in any case | |
| 15:14 | lloyd_ | atz or owen |
| 15:14 | either of you fancy replacing google-jackets.js on your dev system with this : http://www.libcat.eoe.nhs.uk/g[…]-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 | should be 72.232.235.42 | |
| 15:21 | 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 | 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 | 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 | 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 | just another directory though afaik | |
| 16:54 | owen | Hmm... Taking that out doesn't affect the display of Google book jackets |
| 16:56 | 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 | 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 | Maybe that's a good reason to use lloyd's proxy system | |
| 18:27 | ryan | i'm not sure of the requirements |
| 18:27 | 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 | 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 | 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 | one of them comparing it to the explosive | |
| 20:45 | 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 | it all sounds a little "made up" to me. | |
| 20:53 | pianohacker | Huh |
| 20:53 | chris | well seeings as i named it |
| 20:53 | 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 | C3 was supposed to have been released about 3 years before .. never was | |
| 20:54 | so i jokingly named it C4 | |
| 20:55 | pianohacker | Hah |
| 20:55 | and the Koha name came along later? | |
| 20:55 | chris | yeah Koha came along when we released it |
| 20:56 | it was called Kumara for a while there too | |
| 20:56 | in fact i still have hte old Kumara cvs repo | |
| 20:56 | it went C4 -> Kumara -> Koha | |
| 20:57 | 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 | http://www.teara.govt.nz/1966/K/Kumara/Kumara/en | |
| 21:00 | Katipo has a tradition of using K words | |
| 21:00 | Koha, Kea, Kete etc | |
| 21:01 | russel | Konae was another one |
| 21:01 | chris | ahh yep |
| 21:01 | my first opensource release .. timesheeting software .. never really went anywhere tho | |
| 21:01 | i think Katipo and Face use it still though | |
| 21:11 | 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 | We think we deleted or changed a bunch of libraries or branches while also changing category codes | |
| 22:06 | 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 | 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 | 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 | 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 | >.< this is only the 2nd time he's buggered it in a month (LOL) | |
| 22:19 | ok, tyvm for the ideas, I'm going to have to go as well, you'll probably hear more from me tomorrow. | |
| 22:19 | 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 | http://www.libcat.eoe.nhs.uk/g[…]-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. |
← Previous day | Today | Next day → | Search | Index