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