IRC log for #koha, 2012-07-04

All times shown according to UTC.

Time S Nick Message
00:24 janPasi_ joined #koha
00:25 ibeardsl1e joined #koha
00:25 clrh_ joined #koha
00:25 lamiette joined #koha
00:25 dpavlin_ joined #koha
00:25 fredericd joined #koha
00:26 dpavlin_ joined #koha
00:26 clrh_ joined #koha
00:26 clrh joined #koha
01:00 mattsz joined #koha
02:04 cait joined #koha
02:16 ago43 joined #koha
02:48 Oak joined #koha
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:03 cait_m joined #koha
03:05 cait_m hi #koha
03:17 cait_m1 joined #koha
03:33 mib_cait joined #koha
03:37 kathryn joined #koha
03:52 mib_cait joined #koha
04:45 BobB joined #koha
05:12 Oak joined #koha
05:12 Oak kia ora #koha
06:18 cait-m__ joined #koha
06:19 * cait-m__ waves
06:25 alex_a bonjour
06:26 alex_a and hello cait-m__ :)
06:26 hdl joined #koha
06:27 cait-m__ hi alex
06:28 cait-m__ joined #koha
06:33 rakesh joined #koha
06:33 rakesh hi
06:35 rakesh hi any 1 there
06:35 laurence joined #koha
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/ 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/a​uto/Template/Stash/XS/' for module Template::Stash::XS: /usr/local/lib/perl/5.14.2/a​uto/Template/Stash/XS/ wrong ELF class: ELFCLASS32 at /usr/lib/perl/5.14/ line 184.  at /usr/local/lib/perl/5.14.2/Template/Stash/ line 31.  BEGIN failed--compilation aborted at /usr/local/lib/perl/5.14.2/Tem
06:41 rakesh any 1
06:47 sophie_m joined #koha
06:55 julian_m joined #koha
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 joined #koha
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/ 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:05 hdl joined #koha
07:07 julian_m joined #koha
07:09 asaurat joined #koha
07:10 gaetan_B joined #koha
07:10 gaetan_B hello #koha!
07:15 hdl joined #koha
07:16 hdl joined #koha
07:23 paul_p joined #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:37 asaurat joined #koha
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 ? 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:09 laurence1 joined #koha
08:20 papa joined #koha
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
08:51 mveron joined #koha
09:02 eythian joined #koha
09:07 drojf joined #koha
09:07 drojf good day #koha
09:09 mveron joined #koha
09:11 mveron joined #koha
09:20 asaurat1 joined #koha
09:41 Amit_Gupta joined #koha
09:42 Amit_Gupta hi koha
10:20 eythian[…]ptop-loaners.html <-- for libraries
10:30 mib_7zaey5 joined #koha
10:42 laurence1 left #koha
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:00 davidnind joined #koha
11:04 asaurat joined #koha
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
11:55 tcohen joined #koha
12:13 davidnind left #koha
12:19 asaurat joined #koha
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 maximep joined #koha
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 joined #koha
13:57 Herwig Hey all
13:57 Herwig a non technical question the singer on Kohacon12 who was that (i did forget his name)
13:59 cait-m__ joined #koha
14:00 cait-m__ hi all
14:01 Herwig hey
14:02 eythian Herwig:
14:02 Herwig aha :) thx
14:06 mtompset joined #koha
14:06 mtompset Greetings, #koha.
14:06 mtompset Greetings, Herwig
14:07 alex_a1 joined #koha
14:17 gaetan_B joined #koha
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 <[…]bcf00ca9ff399c5a3> / Bug 8202: Add authority export to tools/ <[…]473979d76e411fae0> / bug 7630 follow-up : welcome #186 Mark Tompsett <[…];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 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] script not found or unable to stat: /usr/share/koha/intranet/cgi-bin/cataloging, referer: https://...:8080/cgi-bin/koha/catalo​guing/
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/
14:44 mtompset you might also want to check out
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:50 cait-m__ joined #koha
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:03 cait-m__ joined #koha
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... <[…]7db2e50ce3653b7bb> / Bug 5981 follow-up DBrev number <[…]9181d50156d53e391> / Bug 5981 - OPAC: Add limits to search history <
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.[…]/Koha_master/772/
15:25 jenkins_koha * 3280 Followup for privacy issue on X-Orig-IP in mail header
15:25 jenkins_koha * mtompset: Bug 7630 - Warning on 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/
15:25 huginn Bug[…]w_bug.cgi?id=7630 minor, P5 - low, ---, mtompset, Pushed to Master , Warning on about param without key
15:25 jenkins_koha * paul.poulain: Bug 8202 follow-up UNIMARC authority support
15:25 huginn Bug[…]w_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 Bug[…]w_bug.cgi?id=8356 major, P4, ---, oleonard, Needs Signoff , and 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:42 tcohen joined #koha
15:54 rakesh joined #koha
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/ line 758. Compilation failed in require at /usr/share/koha/lib/C4/ line 31. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/ line 31. Compilation failed in require at /usr/share/koha/intranet/cgi-bin/ 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 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.[…]/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 Bug[…]w_bug.cgi?id=5981 normal, P5 - low, ---, alex.arnaud, Pushed to Master , OPAC: Add limits to search history
16:15 jcamins
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/ 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 -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 NateC joined #koha
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:36 asaurat left #koha
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:15 cait-m__ joined #koha
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/ 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 rakesh joined #koha
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 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:[…]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:26 cait-m__ joined #koha
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.
18:49 cait-m__ joined #koha
19:31 chris_n` joined #koha
19:35 jenkins_koha Starting build #80 for job Koha_3.8.x (previous build: SUCCESS)
19:36 chris_n` joined #koha
19:38 cait joined #koha
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 Bug[…]w_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:11 kathryn joined #koha
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.[…]ob/Koha_3.8.x/80/
20:27 jenkins_koha * mtompset: Bug 7630 - Warning on 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 Bug[…]w_bug.cgi?id=7630 minor, P5 - low, ---, mtompset, Pushed to Stable , Warning on about param without key
20:27 jenkins_koha * Chris Cormack: Fixing version number
20:27 huginn Bug[…]w_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:38 sophie_m left #koha
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:25 cait left #koha
21:27 jenkins_koha Project Koha_3.8.x build #81: SUCCESS in 51 min: http://jenkins.koha-community.[…]ob/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 Bug[…]w_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:11 drojf joined #koha
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:04 maximep left #koha
23:13 papa joined #koha
23:34 tomascohen joined #koha
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/ 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 DBD::mysql::st fetchrow failed: fetch() without execute( ) at /usr/share/koha/lib/C4/ line 919., referer: http://biblio-admin.uesiglo21.[…]rc/
23:43 tomascohen Can't call method "subfield" on an undefined value at /u sr/share/koha/lib/C4/ line 2965., referer: http://biblio-admin.uesiglo21.[…]rc/
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 Irma joined #koha
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

| Channels | #koha index | Today | | Search | Google Search | Plain-Text | plain, newest first | summary