Time Nick Message 02:48 Oak kia ora #koha 02:49 Oak no discussion going on... so i can post a joke then. 02:49 Oak A young lady was on vacation in the depths of Louisiana. She wanted a pair of genuine alligator shoes in the worst way, but was very reluctant to pay the high prices the local vendors were asking. 02:49 Oak After becoming very frustrated with the "no haggle" attitude of one of the shopkeepers, the young lady shouted, "Maybe I'll just go out and catch my own alligator so I can get a pair of shoes at a reasonable price!" 02:49 Oak The shopkeeper said, "By all means, be my guest. Maybe you’ll luck out and catch yourself a big one!" 02:49 Oak Determined, the young lady turned and headed for the swamps, set on catching herself an alligator. Later in the day, the shopkeeper is driving home, when he spots the young woman standing waist deep in the water, shotgun in hand. Just then, he sees a huge 9– foot alligator swimming quickly toward her. 02:49 Oak She takes aim, kills the creature and with a great deal of effort hauls it on to the swamp bank. Lying nearby were several more of the dead creatures. The shopkeeper watches in amazement. 02:49 Oak Just then the young lady flips the alligator on its back, and frustrated, shouts out, 02:50 Oak "Dang it, this one isn’t wearing any shoes either!"" 02:59 ago43 Oak++ 03:00 ago43 how about this: what do you call a man with a spade in his head? 03:00 ago43 Doug. 03:01 ago43 What do you call a man who's been dead and buried for 10,000 years? 03:01 ago43 Pete. 03:01 ago43 Good night. 03:05 cait_m hi #koha 05:12 Oak kia ora #koha 06:19 * cait-m__ waves 06:25 alex_a bonjour 06:26 alex_a and hello cait-m__ :) 06:27 cait-m__ hi alex 06:33 rakesh hi 06:35 rakesh hi any 1 there 06:37 rakesh i installed koha on ubuntu 06:37 rakesh and now i get an error of the module temolate 06:37 rakesh srrt template' 06:37 rakesh failed to create context: failed to create context: failed to load Template/Stash/XS.pm: Couldn't load Template::Stash::XS 2.24: 06:37 rakesh this comes 06:37 rakesh moreover 06:38 rakesh Can't load '/usr/local/lib/perl/5.14.2/auto/Template/Stash/XS/XS.so' for module Template::Stash::XS: /usr/local/lib/perl/5.14.2/auto/Template/Stash/XS/XS.so: wrong ELF class: ELFCLASS32 at /usr/lib/perl/5.14/DynaLoader.pm line 184. at /usr/local/lib/perl/5.14.2/Template/Stash/XS.pm line 31. BEGIN failed--compilation aborted at /usr/local/lib/perl/5.14.2/Tem 06:41 rakesh any 1 06:56 cait-m__ @wunder frankfurr 06:56 huginn cait-m__: Error: No such location could be found. 06:56 cait-m__ @wunder frankfurt 06:56 huginn cait-m__: The current temperature in Frankfurt, Germany is 20.0°C (8:50 AM CEST on July 04, 2012). Conditions: Clear. Humidity: 78%. Dew Point: 16.0°C. Pressure: 29.98 in 1015 hPa (Steady). 07:00 rakesh hi any one that can help me 07:01 mattsz hi ! 07:01 rakesh i installed koha on my server 07:02 rakesh and it gives the following error ' 07:02 rakesh Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/koha/lib/C4/Context.pm line 758. 07:02 rakesh i have also given a password to mysql while installation 07:02 rakesh could this be a problem 07:03 rakesh :( 07:05 rakesh any 1 07:05 rakesh onl9 07:10 gaetan_B hello #koha! 07:26 cait-m__ morning paul 07:36 cait-m__ @quote random 07:36 huginn cait-m__: Quote #150: "<libsysguy> jcamins is the wizard that forges queries in the deep fires of zebra" (added by wizzyrea at 03:07 PM, August 30, 2011) 07:36 wahanui i already had it that way, huginn. 07:38 paul_p good morning #koha 08:09 gaetan_B can someone using a translated Koha in another language than French confirm that the "0" tab is not displaying properly in MARCdetail.pl ? i think the problem comes from the translation tool (it's a single and lonely "0" lost in an <a> and it's not showing up in the .po file) 08:32 rangi hmm i wonder if im the only one that thinks trying to run dspace, vufind and Koha on the same server is a bad idea 09:07 drojf good day #koha 09:42 Amit_Gupta hi koha 10:20 eythian http://zareason.blogspot.co.uk/2012/05/lllovely-linux-laptop-loaners.html <-- for libraries 10:42 drojf eythian: i like the idea. but it might be a lot more work for the "in-house geek" in the end. 10:42 eythian Maybe, it'd depend how you do it. Apparently it works in some places. 10:43 eythian It'd be simple enough to re-image them each time, maybe run weekly classes for an hour or two covering what people might like to know. 10:43 drojf we could have a "wipe/reformat on check-in" function in koha ;) 10:43 eythian heh 10:53 drojf if you make them boot from some flash memory card and loan those too (or sell them), people could continue to work with their own environment and stuff when they get a laptop again later. and you could have some formatted memory cards ready so you can "wipe" a laptop in a second 10:57 eythian Yeah, Mandrake (when it was a thing) had a function to that. It could run off a USB stick and save files etc. to it. 10:58 drojf you can do that with debian too 10:59 eythian I'm not surprised. 10:59 eythian It's not something I've looked into since mandrake days. 11:36 paul_p Thanks EU ! (for rejecting ACTA a few hours ago) 11:36 paul_p (478 against, 39 for, 16 abstaint) 11:38 drojf we get ipred2 now 11:41 drojf still good that they rejected it though 13:19 * jcamins is reminded that proprietary OSes exist. 13:19 * jcamins is not appreciative of this reminder. 13:22 drojf reminded means you have to deal with them? or is it merely their existence? 13:22 jcamins drojf: I need to try packing a Perl script for Windows. 13:23 jcamins (in case you couldn't tell, this sour expression on my face is not because I ate a lemon, it's because I have to figure out how to do this) 13:23 drojf packing like in "zip" or like in "provide a perl environment also to run it"? 13:24 drojf i remember i had to install activeperl or something like that just to run a script at one of my jobs 13:26 jcamins The latter. 13:27 jcamins Apparently Strawberry Perl+PAR::Packer can produce an EXE with the entire runtime. 13:27 jcamins That noise you hear? It is weeping. 13:28 drojf poor jcamins 13:28 drojf have a chocolate cookie 13:30 jcamins Thanks. 13:30 jcamins I think getting Windows running the rasberry pi would be more pleasant, 'cause at least it's geekily cool. 13:30 jcamins *running on 13:31 drojf heh i will never try that :D 13:31 jcamins Nor will I. 13:31 drojf i think somebody did it in a virtual machine on the pi 13:31 jcamins Hehe. 13:32 drojf i think it is asked quite often if its possible. we live in a sad world 13:33 jcamins We do indeed. 13:34 drojf i tend to forget how many people still use windows because i dont know many of them. even my mum can use debian and its her first computer ever, she's > 60 years 13:36 jcamins Heh. 13:41 drojf 1.2. How difficult is it to install Koha on Windows? 13:41 drojf […] To be clear, it is not yet as simple as a single install. But it no harder than installing on a Linux box. 13:41 drojf well that sounds like a valid reason 13:42 jcamins That is not true anymore. 13:43 jcamins chris_n finally gave up on getting modern versions of Koha running under Windows. 13:43 jcamins I think. 13:43 jcamins Fortunately I don't need Koha to run under Windows. 13:43 jcamins Just one script. 13:44 jcamins paul_p: I had a question for you, but I can't remember what it was anymore. 13:44 jcamins paul_p: oh, I remembered. 13:44 paul_p jcamins = the answer is 42 then 13:44 paul_p :D 13:44 jcamins I figured I'd remember if I said something about it. :) 13:45 jcamins Do we have any guidelines for indenting TT files? 13:45 paul_p jcamins nope, and I feel that would be hard to have some. But if you have ideas, you're more than welcomed !!! 13:45 jcamins paul_p: I don't... that's why I was hoping you would have some. :P 13:46 jcamins BTW, happy uppity colony day. :) 13:46 drojf jcamins: of course that is not true anymore, it's from this ancient koha on windows website :D but it was no valid reason back then either 13:46 jcamins Oh, yeah, the site that the owner has abandoned but refuses to take down? 13:47 drojf i think there are several, this has no download links anymore at least 13:47 jcamins Oh, that is better than some of the others. 13:47 drojf or rather the links are down 13:48 drojf Uploaded Content Removed The uploaded content has been removed and is no longer available. 13:48 drojf that was about koha 2.9 on windows 13:48 jcamins Heh. I'm pretty sure there was no Koha 2.9. 13:49 drojf maybe it was windows-only :D 13:57 Herwig Hey all 13:57 Herwig a non technical question the singer on Kohacon12 who was that (i did forget his name) 14:00 cait-m__ hi all 14:01 Herwig hey 14:02 eythian Herwig: http://manran.co.uk/wp/ 14:02 Herwig aha :) thx 14:06 mtompset Greetings, #koha. 14:06 mtompset Greetings, Herwig 14:18 Herwig hey hey 14:23 * mtompset is waiting for his backup scripts to be tested. 14:23 jcamins What backup scripts? 14:23 mtompset I suppose I could have triggered them in a crontab job earlier, but I'm too lazy to edit the file twice. :) 14:24 mtompset scripts that mount an encrypted volume on a remote data site. 14:24 mtompset then rsync over. 14:24 mtompset and then unmount it. 14:24 jcamins Ah. 14:25 mtompset In this case... it's rsync'ing a mysql dump of koha. :) 14:25 mtompset and a few other directories which I thought good. :) 14:26 mtompset enough to basically, dump them all back into place, and I should have a working koha. 14:26 huginn New commit(s) kohagit: Bug 8202 follow-up UNIMARC authority support <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=74f6e97396eb7368fb4e408bcf00ca9ff399c5a3> / Bug 8202: Add authority export to tools/export.pl <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=986b887159f3878a87238cf473979d76e411fae0> / bug 7630 follow-up : welcome #186 Mark Tompsett <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=d 14:26 * jcamins guesses you didn't see koha-dump and koha-restore. 14:26 jcamins Congratulations. 14:27 mtompset Yes, I did see the note from paul_p. 14:27 mtompset I was rather happy to be #186. :) 14:28 mtompset If this backup prototype works... 14:28 mtompset I'll be back to follow up on the other bug reports I made. 14:28 mtompset make sure they get through. 14:29 mtompset There's a couple that fell back and needed tweaks. 14:29 mtompset Like yours! 14:29 mtompset You failed the QA on my id rename. :P 14:29 jcamins mtompset: yes, it messed up the layout. 14:30 jcamins Should be an easy fix, I think. 14:30 mtompset Should be. 14:30 mtompset Have to figure out why it mess up the layout though. 14:31 mtompset was the mess up on the first screen after login? or the login screen itself? 14:31 mtompset Because there was some over-riding going on in the login screen. 14:32 jcamins The first screen after login. 14:33 jcamins The login information wasn't right justified and grouped together. 14:33 jcamins I tried it without any cached CSS, too. 14:35 jenkins_koha Starting build #772 for job Koha_master (previous build: SUCCESS) 14:36 mtompset And it updated both the header.inc file and the staff-global.css right? 14:36 mtompset probably just needs a tweak to the staff-global.css 14:38 jcamins Yeah. I'm sure it's something small with staff-global.css, but I couldn't see anything wrong with it, so I decided to leave it for you, since you presumably had figured out how to make it work properly on your server. 14:39 mtompset good point... I should compare those files next time, to make I got it right. ;) 14:39 mtompset -- to make sure --- 14:41 mtompset [Wed Jul 04 15:53:02 2012] [error] [client 192.168.100.2] script not found or unable to stat: /usr/share/koha/intranet/cgi-bin/cataloging, referer: https://...:8080/cgi-bin/koha/cataloguing/moveitem.pl?biblionumber=12866 14:41 jcamins Uh-oh. That doesn't look good. 14:41 mtompset I can't figure out what might have triggered this error. 14:41 jcamins Wait. 14:41 jcamins It's misspelled. 14:41 jcamins It should be cataloguing not cataloging. 14:42 mtompset hmm... okay good point... I'll grep for that. 14:43 jcamins Found it. 14:43 jcamins One of the first lines in koha-tmpl/intranet-tmpl/prog/en/modules/cataloguing/moveitem.tt 14:44 mtompset you might also want to check out linkitem.tt 14:45 * jcamins wasn't going to submit a patch for it right now. 14:45 jcamins I'm just quick on the grep. 14:45 mtompset Too bad you can't spin your fingers like guns.;) 14:45 mtompset Happy Independence Day, BTW. 14:46 jcamins lol 14:46 jcamins Thanks. You missed my earlier wish that everyone have a happy Uppity Colony Day. :P 14:46 mtompset That might be the world's perception of it. ;) 14:48 mtompset Okay... I guess I can work on a patch for those while waiting for the cronjob to hopefully succeed. 14:48 jcamins :) 14:49 mtompset That was the ONLY error triggered today in our 3.6.3 system. :) 14:50 mtompset YAY! 14:53 mtompset Were you grep'ing 3.8.X or 3.9.X? 14:56 jcamins Good question. 14:56 jcamins Actually, I'm on 3.6.x. 14:56 jcamins Whoops. 15:04 drojf wow, there a lot people voting for kohacon 2013 15:04 mtompset Seeing as I won't be able to go, I figure no sense voting. 15:05 jcamins drojf: where are you seeing the number of votes? 15:05 drojf goodness 15:05 drojf the noew ones are all for nigeria 15:05 drojf haha 15:05 drojf new 15:07 mtompset That's actually a bad idea. Hard to do banking transactions there safely. :) 15:10 mtompset .my word! 15:10 mtompset The bug is in the latest version. 15:10 mtompset how could a typo be missed for so long? 15:11 jcamins mtompset: no one ever clicks that link? 15:12 jcamins I guess? 15:14 mtompset We did, because our data needed cleaning. :) 15:18 mtompset I always have a hard time selecting the component for the bug report. 15:18 huginn New commit(s) kohagit: Permission for change password button in members toolbar should be borrowers instead... <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=ce138ac96f3a5a729568f6d7db2e50ce3653b7bb> / Bug 5981 follow-up DBrev number <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=459efb364a12edc004914289181d50156d53e391> / Bug 5981 - OPAC: Add limits to search history <http://git.koha-community.org/gitweb/?p=ko 15:20 mtompset Are the .tt files templates? 15:20 jcamins Yes. 15:20 mtompset Okay... I report it under templates then. 15:25 jenkins_koha Project Koha_master build #772: SUCCESS in 49 min: http://jenkins.koha-community.org/job/Koha_master/772/ 15:25 jenkins_koha * m.de.rooy: 3280 Followup for privacy issue on X-Orig-IP in mail header 15:25 jenkins_koha * mtompset: Bug 7630 - Warning on moremember.pl about param without key Move "$error => 1," to its own conditional $template->param() 15:25 jenkins_koha * paul.poulain: bug 7630 follow-up : welcome #186 Mark Tompsett 15:25 jenkins_koha * jcamins: Bug 8202: Add authority export to tools/export.pl 15:25 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7630 minor, P5 - low, ---, mtompset, Pushed to Master , Warning on moremember.pl about param without key 15:25 jenkins_koha * paul.poulain: Bug 8202 follow-up UNIMARC authority support 15:25 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8202 enhancement, P5 - low, ---, jcamins, Pushed to Master , Add authorities to export tool 15:25 jenkins_koha Starting build #773 for job Koha_master (previous build: SUCCESS) 15:29 mtompset bug 8356 15:29 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8356 major, P4, ---, oleonard, Needs Signoff , moveitem.tt and linkitem.tt have cataloging typo 15:30 mtompset submitted and patch provided. 15:30 mtompset Now to check if my scripts worked. 15:33 mtompset YAY! They did. 15:33 mtompset Now to fix the bug on our production system and go to bed. 15:36 gaetan_B bye ! 15:54 rakesh hi 15:54 rakesh to all 15:56 rakesh any 1 there who can help me 15:57 jcamins rakesh: it depends what your question is. 15:57 rakesh lol 15:57 rakesh i successfuly installed koha on ubuntu 15:57 rakesh server' 15:57 rakesh and now but when opening the web installer 15:58 rakesh it says Access denied for user 'koha'@'localhost' (using password: YES) at /usr/share/koha/lib/C4/Context.pm line 758. Compilation failed in require at /usr/share/koha/lib/C4/Auth.pm line 31. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Auth.pm line 31. Compilation failed in require at /usr/share/koha/intranet/cgi-bin/mainpage.pl line 25. BEGIN 15:58 rakesh please help 15:58 jcamins That means you have the wrong password set up in MySQL. 15:58 jcamins If you take a look at INSTALL.debian, it explains how to give your user the appropriate privileges in MySQL. 15:59 rakesh it was given in ubuntu guide also 16:00 rakesh anf for the password i left it blank' 16:00 rakesh i followed each step 16:00 jcamins You can't have a blank password. 16:00 jcamins You'll need to set it to something, then change your koha-conf.xml file to match what you set it to. 16:01 rakesh kk' 16:01 rakesh let me open 16:01 rakesh where is the file? 16:01 wahanui the file is, like, not big but it is taking too much time to import thats the problem 16:02 jcamins Probably /etc/koha/koha-conf.xml, but it depends where you installed it. 16:02 jcamins wahanui: forget the file 16:02 wahanui jcamins: I forgot file 16:02 jcamins file? 16:02 jcamins the file? 16:02 jcamins (wahanui is a bot, and he sometimes remembers silly things) 16:03 rakesh i mean the location' 16:04 jcamins Oh. If you search for <pass> you'll find it. 16:04 jcamins It's near the bottom. 16:05 rakesh kk 16:07 rakesh see 16:08 rakesh when i installeds mysql then i lift the password blank 16:08 rakesh and while installing koha 16:08 rakesh i have given a password there' 16:08 jcamins Yes, you have to give the same password to MySQL and Koha. 16:08 rakesh okk 16:08 jcamins And I don't think it can be blank. 16:08 rakesh but now it is giving error in context.pm file 16:09 rakesh and as far i know it is of cpan' 16:09 jcamins You should not be using CPAN at all. 16:09 jcamins If you used CPAN in the installation, I really can't help you. 16:09 rakesh no i didnt use it 16:09 jcamins Okay, good. That means your computer probably isn't messed up. 16:09 rakesh ya 16:10 rakesh so shuld i change the pass 16:10 jcamins The error message you got is because the password for MySQL that you gave Koha doesn't work to access the MySQL server. So you need to set the password for the koha user in MySQL. That's all. 16:10 jcamins Yes. 16:11 * mtompset waves. "Good day (24 hour period), #koha." 16:13 rakesh how do i change the mysql pass 16:15 jenkins_koha Project Koha_master build #773: SUCCESS in 49 min: http://jenkins.koha-community.org/job/Koha_master/773/ 16:15 jenkins_koha * alex.arnaud: Bug 5981 - OPAC: Add limits to search history 16:15 jenkins_koha * paul.poulain: Bug 5981 follow-up DBrev number 16:15 jenkins_koha * koha: Permission for change password button in members toolbar should be borrowers instead of staffaccess 16:15 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5981 normal, P5 - low, ---, alex.arnaud, Pushed to Master , OPAC: Add limits to search history 16:15 jcamins http://lmgtfy.com/?q=change+mysql+user+password 16:24 rakesh kk it changed but now it gives a new error 16:24 jcamins What's the error? 16:25 rakesh Global symbol "$db_user" requires explicit package name at /usr/share/koha/lib/C4/Context.pm line 759. 16:26 jcamins What version of Koha did you install? 16:26 rakesh 3.8.1 16:26 jcamins Where did you find the installation instructions? 16:26 rakesh koha-wiki 16:27 jcamins Okay, that should be fine. 16:27 jcamins When you run koha_perl_deps.pl -m do you get any output? 16:28 rakesh no 16:28 rakesh there are no modules missisng 16:28 jcamins Hm. I have absolutely no idea what that error could mean. 16:29 rakesh :( 16:29 jcamins As far as I can see, the only way to get that error message would be to edit the code. 16:30 rakesh ya i edited it and in line 759 16:30 rakesh there is i shall show u 16:30 rakesh just a sec 16:30 jcamins Why did you edit the code? 16:30 jcamins There is absolutely no reason for you to be editing the code. 16:31 jcamins No one can help you if you edit the code. 16:31 jcamins Really. 16:32 rakesh no i didnt change anything 16:32 rakesh i just saw it bro 16:32 jcamins So you did not edit the code? 16:33 jcamins The only file you changed was koha-conf.xml? 16:33 jcamins You have not edited any other file that came with Koha? 16:33 rakesh hey it worked 16:33 rakesh no error but it says koha offline for mintainence' 16:34 jcamins You need to access the staff client in order to go through the installer. 16:35 rakesh but i have a different ip adress as i have a server 16:35 rakesh how to do cia the ip adress i have 16:36 rakesh srry ' 16:36 jcamins I have no idea what you mean. 16:36 rakesh no i have a static ip adress 16:37 rakesh my own ip adress so how to run staff client on it 16:37 jcamins What do you mean? You just access the staff client with your web browser. 16:37 rakesh kk 16:37 rakesh just a second 16:38 jcamins The instructions on the wiki walked you through setting it up to be accessiblw. 16:38 jcamins *accessible 16:39 rakesh ys but it shows the apache default web page 16:39 rakesh i have followed each and every instructiob 16:39 rakesh *instruction 16:39 drojf sudo a2dissite default 16:40 drojf disables the apache default page 16:41 rakesh it now says required url not found 16:42 jcamins rakesh: are you sure you are accessing the correct URL? 16:42 jcamins Maybe you should try localhost:8080? 16:42 drojf hm there is no default page on 8080 anyway 16:43 rakesh no 16:44 rakesh 8080 16:44 rakesh dowsnt work' 16:44 jcamins I don't have any more suggestions, sorry. It sounds like Apache is not configured correctly, and I'm not an Apache expert. 16:45 rakesh kk ' 16:48 rakesh hey it worked on 8080 16:48 rakesh but after entering my ip adress 16:48 rakesh thnx bro 16:49 jcamins You're welcome. 16:51 jcamins Yet another livecd. Ugh. 16:51 rakesh :) 16:51 drojf yeah, something that is old forever in a few weeks 16:52 drojf Build on Ubuntu 10.04 LTS 16:52 drojf sorry but sometimes i think they are just making fun of us 16:54 jcamins It does seem like that, doesn't it? 16:54 rakesh hey i wanna ask u 1 thng 16:55 rakesh how to disiable the grant tables option in mysql 16:55 jcamins You'll need to look that up online. 16:55 rakesh kk 17:34 eythian jcamins: rakesh: that SQL error is something I diagnosed this afternoon that applies to the ubuntu version of mysql 17:34 eythian the problem is that'%' isn't considered a wildcard in a hostname any more 17:35 jcamins eythian: in this case the problem was that the password wasn't set. 17:35 eythian it's not, it's that the host wildcard doesn't apply in ubuntu 17:35 jcamins You can't not have a password with the way Koha logs into MySQL. 17:35 eythian the password is set 17:36 eythian I had this happen to be about an hour ago :) 17:36 jcamins eythian: the instructions with Ubuntu have you set it explicitly to localhost. 17:36 jcamins eythian: you encountered another problem. 17:36 eythian but that was done with the packages 17:36 * jcamins encountered that problem too. 17:36 jcamins Right. With packages, you'll get the same error from a different problem. 17:36 eythian and his error was: Access denied for user 'koha'@'localhost' (using password: YES) at /usr/share/koha/lib/C4/Context.pm line 758. 17:36 eythian which is what the packages do on ubuntu 12.04 17:37 jcamins Yes, that's the same error you get when you didn't set a password in MySQL, though. 17:37 eythian I know, but you don't have to set a password because koha-create does it for you 17:37 jcamins Right. 17:37 jcamins That's why everyone should use packages. ;) 17:37 eythian but that doesn't work on 12.04 17:37 eythian because you can't log in because the wildcard no longer works 17:37 jcamins In fact, maybe I should update the Ubuntu page to say "go use the packages." 17:38 eythian well, I'd wait until this issue is fixed. After that it should work fine :) 17:38 jcamins Right. I reported a bug for that, then decided it was my fault and marked it invalid. I guess it wasn't. 17:38 jcamins Ah, good call. 17:38 eythian no, it's an issue with the mysql version I think 17:38 eythian I just need to add an extra create user 17:38 eythian that uses 'localhost' rather than '%' 17:39 drojf i had that problem on debian 17:39 * jcamins will consider that a high priority fix and include it in the next 3.6. 17:40 eythian drojf: what debian version? 17:40 wahanui debian version is 1.4.2 17:40 eythian err 17:40 eythian what mysql version? 17:40 eythian no wahanui, debian version is 6.0 17:40 wahanui okay, eythian. 17:41 jcamins 1.4.2? I wonder what that was even referring to. 17:41 drojf i think it happened on the raspi with squeeze and also on my regular machine with testing 17:42 drojf hm dont know mysql version it was, i got rid of it on the notebook 17:43 jcamins Testing has 5.5. 17:43 jcamins I am hoping that they did not keep the new default allowed anonymous logins. 17:44 drojf yes its 5.5, did not get rid of it heh 17:45 drojf mysql-server/squeeze uptodate 5.1.63-0+squeeze1 says the pi 17:46 jcamins eythian: by the way, I revised your csvtomarc.pl script a bit, so it will handle 00x fields, reducing multiple lines of a CSV to one record, and running on systems without a Koha installation. 17:46 eythian oh good. Those are all things I've been meaning to make it do. 17:46 eythian That and indicators 17:46 jcamins eythian: https://www.gitorious.org/~jcamins/koha-toolbox/cpbibliography-koha-migration-toolbox 17:46 jcamins Indicators are still to do. 17:46 jcamins I also changed the logic so it always edits the most recently created field when it's editing stuff. 17:47 jcamins (should work exactly the same unless you use --reduce) 17:48 jcamins (at which point it will work properly) 17:48 jcamins Oh, and the leader can now be set by the user, so it can be used for authorities. 17:48 tcohen jcamins: i understand you made a presentation of analytical records in koha during kohacon12 17:49 jcamins tcohen: I did. I still haven't found a permanent home for the videos, but I'll e-mail you the link to where they are now. 17:49 tcohen is there a place I can download the slides/video of that? 17:49 tcohen oh, thanks 17:50 jcamins Sent. 17:51 tcohen downloading, thanks! 17:53 jcamins You're welcome. 17:57 jcamins Wow... CPAN is painfully slow on Windows. 17:57 tcohen Winwhat? 17:58 jcamins tcohen: I'm trying to pack a Perl script into an exe. 17:58 jcamins It is staggeringly painful. 17:58 jcamins I have had CPAN going for forty-five minutes, and I've only managed to install *three* packages. 17:58 tcohen have never done that, just used installshield and such 17:59 jcamins The script needs to run on a computer where the user isn't allowed to install anything. 18:00 jcamins I've been led to understand that a single EXE would be okay (since the source code will come with it) but this means I must create a single EXE and can't just say "install Strawberry Perl." 18:02 jcamins (and another half dozen modules via CPAN) 18:03 tcohen so, a user without privileges can install perl modules using CPAN 18:03 tcohen guess they can install in their own profile 18:03 jcamins Only if they have Perl. 18:06 jcamins I haven't used Windows in so long that I wouldn't be able to provide instructions. 18:10 jcamins Well, the good news is that the script compiled fine. 18:11 jcamins The bad news is that thanks to line endings, it won't read my CSV. 18:17 tcohen unix2dos 18:19 jcamins Actually, maybe the problem is that Text::CSV_XS doesn't work on Windows... 18:23 tcohen is perl working at all? 18:23 jcamins Yup. It reads in one line. 18:39 jcamins Figured it out. 18:39 jcamins Text::CSV_XS gets very confused when you specify what the line endings will be, apparently. 19:35 jenkins_koha Starting build #80 for job Koha_3.8.x (previous build: SUCCESS) 19:42 * cait waves 19:44 drojf hi cait :) 19:44 cait hi drojf 20:01 rangi hi cait and drojf 20:03 rangi hmm bug 8242 20:03 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8242 minor, P5 - low, ---, koha, Pushed to Master , Permission for "change password" button in members toolbar should be "borrowers" instead of "staffaccess" 20:03 rangi i think thats ok to push to 3.8.x 20:07 * rangi tests 20:07 rangi ohh i see mtj has picked up 7818 for qa, would love that pushed, or ill have to revert it out 20:09 cait morning rangi 20:12 rangi morning kathryn 20:12 kathryn morning rangi :) 20:13 kathryn and morning all from GREY wellington 20:13 * liw waves to wonderful Wellington 20:14 * kathryn waves back at liw (if you can see us through the cloud that is) 20:14 rangi kathryn: liw is in the UK they are used to cloud :) 20:16 kathryn true! I'm just grumbling it's not so bad... 20:16 liw I've lived through Wellington's winter, it's not too bad 20:17 kathryn :) 20:18 cait hi kathryn - raining here. so not much better 20:18 cait oh, and it's night, so dark too :) 20:18 kathryn hey cait, but it's nearly dark here!!! 20:19 * kathryn just wants to complain 20:19 * cait wants to complain too 20:19 cait who brings the cookies? 20:20 kathryn I will! (but I don't know how to make your favourite bot-snacks) 20:20 * cait is not a bot, so that will be ok :) 20:21 * cait will bring cookies too 20:21 cait I just had a long day, got up 3:45 am and was back home at 9:30 pm 20:21 kathryn :) 20:22 rangi liw: coming from a finnish winter ... i suspect most places are pretty warm compared to that :) 20:22 kathryn oh cait your deserve lots of cookies and have max complaining rights 20:22 cait yay! 20:27 liw rangi, I'm totally enjoying the southern European warm, sunny weather in Manchester 20:27 jenkins_koha Project Koha_3.8.x build #80: SUCCESS in 52 min: http://jenkins.koha-community.org/job/Koha_3.8.x/80/ 20:27 jenkins_koha * mtompset: Bug 7630 - Warning on moremember.pl about param without key Move "$error => 1," to its own conditional $template->param() 20:27 jenkins_koha * paul.poulain: bug 7630 follow-up : welcome #186 Mark Tompsett 20:27 jenkins_koha * alex.arnaud: Bug 5981 - OPAC: Add limits to search history 20:27 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7630 minor, P5 - low, ---, mtompset, Pushed to Stable , Warning on moremember.pl about param without key 20:27 jenkins_koha * Chris Cormack: Fixing version number 20:27 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5981 normal, P5 - low, ---, alex.arnaud, Pushed to Stable , OPAC: Add limits to search history 20:35 jenkins_koha Starting build #81 for job Koha_3.8.x (previous build: SUCCESS) 20:57 drojf @wunder berlin, germany 20:57 huginn drojf: The current temperature in Prenzlauer Berg, Berlin, Germany is 22.0°C (10:42 PM CEST on July 04, 2012). Conditions: Clear. Humidity: 61%. Dew Point: 14.0°C. Pressure: 29.98 in 1015 hPa (Steady). 20:58 cait no rain drojf? 20:58 cait @wunder Konstanz 20:58 drojf that would be warm during the day :D 20:58 huginn cait: The current temperature in Taegerwilen, Taegerwilen, Germany is 17.8°C (10:55 PM CEST on July 04, 2012). Conditions: Rain. Humidity: 92%. Dew Point: 16.0°C. Pressure: 29.95 in 1014 hPa (Steady). 20:58 rangi @wunder nzwn 20:58 huginn rangi: The current temperature in Wellington, New Zealand is 11.0°C (8:00 AM NZST on July 05, 2012). Conditions: Scattered Clouds. Humidity: 82%. Dew Point: 8.0°C. Pressure: 29.89 in 1012 hPa (Steady). 20:58 drojf but its midnight soon 20:58 drojf cait: no, perfect summer night 20:58 drojf just came back from a walk 20:58 cait :) 20:59 drojf good morning rangi 21:00 drojf there is no wind whatsoever, it feels much warmer than 22° 21:02 drojf under what circumstances should memcached be used or not used? it seems like everything takes 10 seconds longer when i use it on the raspberry pi 21:03 rangi drojf: you are using plack? 21:03 rangi dont use memcached with that 21:04 rangi unless you have a cluster of raspberrypi 21:04 rangi sharing a cache 21:04 cait don't give him ideas heh 21:04 rangi hehe 21:04 drojf i would if i could :D 21:04 rangi with the CHI stuff pushed to master 21:04 rangi you could use in ram caching 21:04 rangi i forget what its called, jcamins_away will know 21:05 drojf yeah i think i will try the chi stuff to, i was missing some packages and too lazy toi build them earlier 21:06 drojf but i tried memcached with the normal apache setup and not plack, did not work so well 21:06 rangi memcached is for scalability, not speed 21:06 drojf ok 21:06 drojf then i wait for the first rack of pis 21:07 jcamins_away You mean fastmmap? 21:07 jcamins_away Don't use that on a raspberry pi. 21:07 drojf now that you say that about scalability, i think i was told that before :D 21:07 jcamins_away Not worth it. 21:08 drojf why? 21:09 jcamins_away With 256MB of RAM, it'll force Plack processes into swap. 21:09 jcamins_away You could use fully-inprocess cache, I guess ("Memory" driver). 21:10 rangi yeah, probably on the pi caching wins you very little 21:11 rangi (under plack) 21:11 jcamins_away That's my feeling. 21:11 drojf hm yeah it is amazing how well it works with plack now so i should maybe be happy for now :) 21:27 jenkins_koha Project Koha_3.8.x build #81: SUCCESS in 51 min: http://jenkins.koha-community.org/job/Koha_3.8.x/81/ 21:27 jenkins_koha koha: Bug 8242 : Permission for change password button in members toolbar should be borrowers instead of staffaccess 21:27 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8242 minor, P5 - low, ---, koha, Pushed to Stable , Permission for "change password" button in members toolbar should be "borrowers" instead of "staffaccess" 22:55 rangi oooohh 22:55 rangi its a holiday 22:55 rangi in US .. no wonder its quiet 23:01 ibeardsl1e are you saying 'mericans are noisy? 23:02 rangi specially on 4th july 23:02 rangi fireworks and bbqs :) 23:02 * ibeardsl1e wonders what his Dad is up to .. and if he celebrated yesterday (in .au) 23:35 tomascohen hi #koha 23:35 tomascohen need some advice 23:35 tomascohen i'm trying to migrate a 3.1.x f*d up koha install 23:35 tomascohen to 3.8 23:36 tomascohen I fixed the DB structure, and upgrade went smooth 23:36 tomascohen but I get this weird error i cannot correctly debug 23:36 tomascohen DBD::mysql::st execute failed: Table 'marc_subfield_structure' was not locked with LOCK TABLES at /usr/share/koha/lib/C4/Context.pm line 918 23:37 tomascohen anyone? 23:40 rangi hmmm 23:40 rangi check your table structure, is it innodb? 23:40 rangi show create table marc_subfield_structure 23:40 tomascohen marc_subfield_structure} 23:40 rangi shoudl show you 23:41 rangi in the db 23:41 tomascohen ENGINE=InnoDB 23:42 rangi hmm that looks ok 23:42 rangi so where does that error manifest? 23:43 tomascohen trying to circulate an item 23:43 rangi weird 23:43 tomascohen irculation.pl: DBD::mysql::st fetchrow failed: fetch() without execute( ) at /usr/share/koha/lib/C4/Context.pm line 919., referer: http://biblio-admin.uesiglo21.edu.ar/cgi-bin/koha/circ/circulation.pl 23:43 tomascohen circulation.pl: Can't call method "subfield" on an undefined value at /u sr/share/koha/lib/C4/Biblio.pm line 2965., referer: http://biblio-admin.uesiglo21.edu.ar/cgi-bin/koha/circ/circulation.pl 23:44 tomascohen those are the subsquent errors 23:44 rangi there is data in that table? 23:44 rangi and what happens when you try to check koha marc structure? (in admin) 23:45 tomascohen invalid auth references in some analytics framework 23:45 tomascohen i'll delete it 23:45 rangi select frameworkcode,kohafield,tagfield,tagsubfield from marc_subfield_structure where kohafield > '' 23:46 rangi is the query its trying to run 23:46 tomascohen yeap , read it 23:46 rangi so have you tried running that in mysql? 23:46 rangi thats where you got the LOCK message? 23:46 mtj tomascohen: if in doubt - try loading fresh data in marc_subfield_structure? 23:46 rangi yeah, id do that, dump that table as a backup 23:46 rangi and load in the data from in installer/ 23:46 mtj ie: load the marc_subfield_structure table from a fresh koha install 23:47 tomascohen lets see 23:47 mtj and hi #koha :) 23:47 mtj and then - do a zeb-rebuild after that 23:48 rangi well id first check that query works 23:48 rangi no point waiting for a rebuild if its still borked :) 23:48 rangi i suspect the table as it exists is totally busted 23:48 tomascohen 622 rows 23:49 tomascohen i'll truncate it and reload clean data 23:49 mtj theres a small chance your 3.1 framework tables didnt get updated correctly 23:50 rangi i woudlnt expect that to throw a LOCK error tho 23:50 tomascohen mtj: true 23:50 mtj so, grab the new tables, and try loading them into yr db 23:50 rangi that feels more like something borked lower down the stack than Koha 23:51 rangi ie its mysql throwing an error, not koha 23:51 mtj yeah, i agree, its a low-level mysql eror 23:51 rangi so truncate might not bethe way to go 23:51 rangi id dump the data, just in case 23:52 rangi then drop that table 23:52 rangi and recreate it 23:52 rangi (cut and paste from kohastructure.sql) then load in the fresh data 23:57 tomascohen its late right now, thanks for the help 23:57 tomascohen i'm getting mysql errrors lading data 23:57 tomascohen so i'll try again when I get home 23:57 tomascohen thanks 23:58 rangi yeah, it sounds like your db is pretty messed up im afraid