IRC log for #koha, 2012-10-15

All times shown according to UTC.

Time S Nick Message
00:10 druthb joined #koha
00:10 druthb o/
01:26 druthb left #koha
02:06 srikanth joined #koha
02:06 schnydszch joined #koha
02:06 schnydszch good morning koha users, where do i change the meta tag of my koha website?
02:07 eythian "meta tag"?
02:08 schnydszch yap
02:08 eythian as in, in the HTML header?
02:08 schnydszch yap
02:08 schnydszch is it in the opac header
02:08 eythian you'd have to modify the template, I guess.
02:08 schnydszch in the global references? so that crawlers can properly index my site
02:08 schnydszch where and what to modify?
02:09 eythian I didn't think crawlers paid much attention to meta headers these days.
02:09 eythian it depends how you installed Koha, and keep in mind that customisations are likely to go away when you upgrade.
02:10 eythian but, it looks like it's defined in
02:10 schnydszch that's what i'm thinking, as much as possible, i don't want to customize codes (e.g. CSS codes), if it can be work out in the database, much better
02:11 schnydszch installed koha in /usr/share/koha
02:11 eythian In that case, I'd look into making a system preference to allow custom HTML to be included in the header, or something along those lines.
02:11 schnydszch where's that
02:11 eythian dunno, depends how you installed things.
02:11 eythian I'd use the 'locate' command to find it.
02:13 jcamins_away schnydszch: what crawlers are you concerned about?
02:15 schnydszch google :)
02:16 schnydszch so when search <insert name of institution> online public access catalog, 1st in the search result is our library's opac
02:16 schnydszch or are there other ways to do this?
02:17 eythian nobody searches for "online public access catalog"
02:17 eythian they search for "<name> library" I think.
02:18 rangi make sure you libraryName systempreference is set
02:18 jcamins_away schnydszch: I'm 99% sure that Google ignores all meta headers at this point.
02:18 rangi yep
02:18 rangi title it looks at
02:18 rangi and if LibraryName is set, that's in title
02:18 eythian yeah, in the late 90's everyone filled the meta headers up with crap, making them largely useless.
02:18 rangi and then you just need time and people linking to it, to make it move up the rankings
02:18 schnydszch yeah, it's set to our library name
02:21 schnydszch so i won't concern myself with the meta thing then..
02:43 eythian Symphony seems to call issues "charges." Is this a real thing, or just it being weird?
02:44 eythian (i.e. is the funny naming actually a name some people use for issues?)
02:48 jcamins_away eythian: I've heard it.
02:49 eythian OK cool.
02:49 eythian I can see how it could make sense, just never heard of it in this context before.
03:05 jenkins_koha joined #koha
03:19 sl joined #koha
03:33 BobB_ joined #koha
03:43 sl joined #koha
03:46 horacio joined #koha
03:46 horacio left #koha
03:46 BobB joined #koha
03:47 horiveira joined #koha
03:48 horiveira what's up koha!
03:49 rangi hi horiveira
03:49 horiveira I'm having an issue with installation on Ubuntu Server 12.04 - I'm not able to access the administration website to install the software
03:53 stefan-l joined #koha
03:55 cait joined #koha
04:07 horiveira Would someone be able to help me with an installation issue?
04:08 eythian that entirely depends if someone knows the answer to your question.
04:09 eythian wahanui: ask
04:09 wahanui Don't ask to ask, just ask.
04:09 horiveira i did, no one replied
04:09 eythian oh, you did too
04:09 eythian I might just be blind.
04:10 eythian how are you installing it?
04:10 eythian Why aren't you able to access the administration page?
04:11 horiveira i got stuck on the step right before the web installer
04:11 horiveira I can't access
04:11 eythian How are you installing koha?
04:11 eythian sounds like using the packages?
04:11 horiveira yeah, i'm using the packages
04:12 eythian you have no DNS set up for that hostname
04:12 horiveira would i fix that in the koha-sites.conf?
04:13 horiveira I'm not intending for folks to use it outside of the network just yet.
04:13 horiveira if that matters at all...
04:13 eythian Well, for real life, you'd need to get whoever does the DNS for to set it up for you.
04:14 eythian For local purposes, you can edit your hosts file so your local computer pretends like it's set up, keeping in mind that it'll only work on that one computer.
04:16 horiveira I've edited the host files, but I still can't access it.
04:16 eythian what happens when you try?
04:19 horiveira I get the system maintenance message
04:20 eythian which one?
04:20 wahanui hmmm... which one is 3.6.x?
04:20 eythian does running "sudo koha-enable <instancename>" make a difference?
04:20 horiveira System maintance: The Koha online catalog is offline for system maintenance. We'll be back soon
04:21 eythian oh right
04:21 eythian you're hitting the OPAC.
04:21 eythian Most likely you didn't have koha-sites.conf configured correctly when you ran koha-create
04:22 eythian you should check your /etc/apache2/sites/<instancename> file and correct the ServerName directives.
04:22 eythian (remember to restart apache when you're done)
04:28 cait-m joined #koha
04:30 horiveira I edited the ServerName lines under the OPAC and Intranet sections
04:30 eythian yep
04:30 eythian hi cait-m
04:31 horiveira restarted apache, and pointed to (with replacing the names i applied) and still get the same message
04:32 horiveira well, get presented with the same system maintenance page
04:32 eythian can you put your apache config in a pastebin?
04:32 eythian wahanui: paste
04:32 wahanui paste is found at
04:43 cjh joined #koha
04:57 cait-m joined #koha
05:05 horiveira i'm not able to copy apache config at the moment
05:05 horiveira would you help me look for what could be the problem in the apache config?
05:06 eythian as far as I can tell, you have your ServerName for your intranet client incorrect, or you are accessing it with the wrong URL. Because they don't match up, you are getting the first virtual host in apache, which is the OPAC.
05:06 eythian I can't look at it without seeing your config.
05:18 horiveira is there anyway to access the admin/setup using IP instead?
05:20 druthb joined #koha
05:20 eythian No, it's managed by cirtual hosts.
05:20 eythian *virtual
05:23 horiveira alright. It's rather late where I am - I appreciate the help. Do you think I would be able to come back and get a response from someone? Or is there a way to stay in contact with you regarding this issue when I have more time?
05:23 eythian my time zone doesn't suit that, but I expect Europe to be waking up in not too long.
05:25 horiveira cool. many thanks!
05:26 eythian np
05:43 yesan joined #koha
05:43 yesan Hello Folks
05:44 yesan i have a problem in koha cataloguing, holding details are not shown although items details are entered.
05:45 yesan can someone out there to help me.
05:46 yesan Hello
05:47 yesan joined #koha
05:48 yesan hello folks, i have a problem in cataloguing, holding details are not shown, even though I have the item details are entered in the 952tags
05:49 yesan i do not know if this question has been asked by someone.
05:49 yesan hello gmcharlt
05:58 yesan bye
05:58 yesan all busy
06:08 magnuse kia ora #koha!
06:10 druthb joined #koha
06:19 papa joined #koha
06:33 alex_a joined #koha
06:33 alex_a bonjour
06:33 wahanui privet, alex_a
06:34 marcelr joined #koha
06:34 marcelr hi #koha
06:41 alex_a joined #koha
06:43 druthb joined #koha
06:55 asaurat joined #koha
06:55 sophie_m joined #koha
06:57 cait joined #koha
06:58 * cait waves
06:59 reiveune joined #koha
06:59 reiveune hello
07:00 laurence joined #koha
07:01 cait bonjour reiveune
07:01 reiveune slut cait :)
07:01 sophie_m hello #koha
07:01 julian_m joined #koha
07:01 cait reiveune: that was not exactly nice ;)
07:02 reiveune SALUT cait ;)
07:02 * cait guesses you meant salut
07:02 cait ;)
07:03 WaqarAzeem joined #koha
07:04 gaetan_B joined #koha
07:04 gaetan_B hello
07:13 cait joined #koha
07:17 laurence joined #koha
07:21 cait bug 3652
07:21 huginn Bug[…]w_bug.cgi?id=3652 critical, P1 - high, ---, oleonard, ASSIGNED , XSS vulnerabilities
07:21 cait bug 3652
07:22 magnuse nastiness
07:26 rangi evening
07:26 cait t
07:29 magnuse kia ora rangi!
07:31 cait evening rangi
07:50 cait joined #koha
07:51 * cait waves again
07:51 WaqarAzeem hello
07:52 WaqarAzeem any with regular expressions?
07:52 WaqarAzeem me looking for the meaing of this
07:52 WaqarAzeem m/^.*(\s.*\s*|\s&|\<.*\>)$/;
07:55 WaqarAzeem This is the line i found at pdf creation. when long text is arranged in multiple lines to adjust in textbox.
07:59 WaqarAzeem I need to change it little bit, if pipe sign i.e. | in text then break it from this point as well.
08:00 cait-m joined #koha
08:01 cait-m_ joined #koha
08:01 magnuse hehe, cait is busy today :-)
08:02 cait-m_ hm?
08:02 magnuse lots of coming and going
08:03 cait-m_ ah sorry
08:15 jenkins_koha joined #koha
08:17 francharb joined #koha
08:18 francharb hello
08:20 rangi hi francharb
08:20 magnuse bug 3652
08:20 huginn Bug[…]w_bug.cgi?id=3652 critical, P1 - high, ---, oleonard, Signed Off , XSS vulnerabilities
08:20 rangi yay
08:20 magnuse :-)
08:20 rangi[…]=refs/heads/3.8.x  <-- all on 3.8.x already
08:21 rangi but that last patch is needed on master still
08:21 magnuse the one i just signed off too?
08:21 rangi yep
08:21 magnuse ah
08:22 magnuse that's what i call quick! :-)
08:26 francharb joined #koha
08:39 mtompset joined #koha
08:42 mtompset Greetings, #koha.
08:42 mtompset I'm glad I had an extra pair of eyes look over my instructions... found a couple typos and an instruction or two that wasn't clear.
08:51 cait-m joined #koha
09:45 gerundio joined #koha
10:11 huginn New commit(s) kohagit: Bug 8791: OPAC UNIMARC XSLT details: subject with subfield 3 <[…]ac4d5177d9657f266> / Bug 8873 - JavaScript error in Opac displaying tag cloud <[…]d8d29311c6d5d0cd9> / Bug 8793 - Fix materialTypeCode/typeOf008 icons for NORMARC XSLT <http://git.koha-community
10:14 jenkins_koha Project Koha_master build #879: FAILURE in 31 sec: http://jenkins.koha-community.[…]/Koha_master/879/
10:18 gerundio hi, can anyone help me setup LDAP authentication in koha?
10:19 gerundio I've followed the available documentation but it seems I've reached an dead-end
10:19 mtompset Sadly, I have never done it, so I can't help. :(
10:20 gerundio thanks anyway mtompset
10:22 gerundio I'll wait until someone who does has time to reply :)
10:29 jenkins_koha Project Koha_master build #880: STILL FAILING in 31 sec: http://jenkins.koha-community.[…]/Koha_master/880/
10:43 jenkins_koha Project Koha_master build #881: STILL FAILING in 9.8 sec: http://jenkins.koha-community.[…]/Koha_master/881/
10:58 jenkins_koha Project Koha_master build #882: STILL FAILING in 9.8 sec: http://jenkins.koha-community.[…]/Koha_master/882/
11:01 mtompset Poor, Jenkins. I think something about the build environment must have changed and broken the process. :( Of course, I could be wrong.
11:13 jenkins_koha Project Koha_master build #883: STILL FAILING in 8.9 sec: http://jenkins.koha-community.[…]/Koha_master/883/
11:15 laurence joined #koha
11:20 gerundio got another problem at hands
11:21 gerundio how can I set koha to send mails via a given SMTP server?
11:27 jwagner joined #koha
11:28 jenkins_koha Project Koha_master build #884: STILL FAILING in 8.6 sec: http://jenkins.koha-community.[…]/Koha_master/884/
11:33 mtompset I have yet to succeed at configuring mail. :( Though, there was an interesting link to do it via gmail on the list a while back.
11:37 IvY joined #koha
11:43 jenkins_koha Project Koha_master build #885: STILL FAILING in 8.3 sec: http://jenkins.koha-community.[…]/Koha_master/885/
11:45 nengard joined #koha
11:57 balin joined #koha
11:58 jenkins_koha Project Koha_master build #886: STILL FAILING in 9.2 sec: http://jenkins.koha-community.[…]/Koha_master/886/
12:01 balin Hi. Started Playing with Koha. Have some conceptional issues: imported throug z3950 something from LOC and now it's not showing in the catalogue!? When exporting the entry shows up in the resulting marc text file ... confused.
12:06 stefan-l left #koha
12:13 jenkins_koha Project Koha_master build #887: STILL FAILING in 8.9 sec: http://jenkins.koha-community.[…]/Koha_master/887/
12:14 oleonard joined #koha
12:18 nengard balin you probably don't have your search engine running
12:19 nengard you need to have the reindexer running so that you can find the records you've added
12:20 oleonard Hi #koha
12:20 nengard morning oleonard
12:20 balin nengard: Switchable on where
12:21 nengard it's a server thing
12:21 nengard which gets a bit out of my area of expertise
12:21 nengard you need to have the indexer running on a cron job
12:21 mtompset What does "ps aux | grep zebra" give you?
12:21 nengard ^^
12:21 nengard :)
12:22 balin
12:22 mtompset Okay, your zebra server is running. You did a packages-based install?
12:23 balin yes.
12:23 balin Debian
12:23 mtompset are you using UNIMARC or MARC21?
12:23 paul_p joined #koha
12:23 balin MARC21
12:24 mtompset I'm out of ideas.
12:24 mtompset Oh... how about "ps aux | grep cron"?
12:24 balin ps aux | grep cron root      1900  0.0  0.0   7596   808 pts/0    S+   12:21   0:00 grep cron
12:24 mtompset If cron isn't running, the reindexer won't run. :)
12:24 mtompset That's all?!
12:24 mtompset The problem is your cron daemon isn't running.
12:25 slef first question?
12:25 wahanui "What are you trying to do?"  "What is the goal?" or "What problem are you experiencing?"
12:25 slef second question?
12:25 wahanui it has been said that second question is "What is the exact error message?"
12:25 slef third question?
12:25 wahanui i heard third question was "What version of Koha are you using?"[…]ion-koha-running/
12:25 slef fourth question?
12:25 wahanui it has been said that fourth question is "Are we there yet?"
12:25 mtompset slef: He's added records.
12:25 mtompset They aren't showing up in the search
12:25 mtompset He did a packages install on Debian.
12:26 slef mtompset: don't mind me. I was replying to email from Yesan Sellan
12:26 mtompset I don't know why cron wouldn't be running though.
12:26 mtompset Ah... yes, okay. :)
12:26 mtompset I believe cron is a service, so I think, "sudo service cron start" should work.
12:27 mtompset Then wait 5 minutes.
12:27 balin Ha! You put me on the right track ... ps aux | grep cron root 1900 0.0 0.0 7596 808 pts/0 S+ 12:21 0:00 grep cron --> so it's running ...
12:27 slef no, that's the grep
12:27 slef it's better to say "pgrep cron"
12:27 slef if it's running, it will return a number
12:27 slef if it is not, it will return nothing
12:27 slef if pgrep isn't installed, it will show an error :)
12:28 balin Right - me stupid.
12:28 slef dpkg -l '*cron*'
12:28 slef see if it's even installed
12:28 slef but I would expect the koha-common package to depend on it
12:28 slef but I've not checked that
12:28 jenkins_koha Project Koha_master build #888: STILL FAILING in 9.1 sec: http://jenkins.koha-community.[…]/Koha_master/888/
12:28 balin BUT: You put me on the right track: this is a lxc install and does NOT have corn installed by default ... so triggering the cron script made the entry show up ... cron installed now, so I should be peachy (in this respect).
12:29 mtompset you'll know in 5 minuts.
12:29 mtompset you'll know in 5 minutes.
12:29 balin no. already know as I triggered the job cron-independently ...
12:29 mtompset Okay... glad to help. :)
12:29 mtompset Thanks for the improved answer, slef. :)
12:30 balin Where do I report bugs? deb's should be dependent on cron!
12:30 mtompset bugs?
12:30 wahanui i think bugs is found at Please fix any bugs you find. :) or reporting them is helpful, too.
12:31 slef mtompset: no worries, pgrep and pkill are underknown tools.
12:32 Oak joined #koha
12:33 * Oak waves
12:33 reiveune1 joined #koha
12:34 mtompset Greetings, Oak. Bonjour, reiveune et reiveune1?!
12:34 Oak hello mtompset.
12:34 Oak magnuse
12:34 Oak hello rangi
12:35 Oak Bonjour alex_a
12:35 alex_a Oak: coucou
12:40 IvY left #koha
12:43 jenkins_koha Project Koha_master build #889: STILL FAILING in 9.3 sec: http://jenkins.koha-community.[…]/Koha_master/889/
12:50 ago43 joined #koha
12:54 * paul_p feel we will have a lot of jenkins builts that fail in the next hours, until rangi is awake :(
12:54 jcamins Good morning, #koha.
12:54 marcelr hi jcamins
12:54 oleonard Hi paul_p and jcamins
12:54 paul_p FATAL: hudson.plugins.git.GitSCM$4.<init>(Lhudson/p​lugins/git/GitSCM;Ljava/lang/String;Lhudson/​model/BuildListener;Lhudson/EnvVars;Lhudson/​plugins/git/Revision;Ljava/lang/String;Ljava​/util/List;Ljava/lang/String;ILhudson/plugin​s/git/util/BuildData;Lhudson/FilePath;)V
12:54 paul_p java.lang.NoSuchMethodError: hudson.plugins.git.GitSCM$4.<init>(Lhudson/p​lugins/git/GitSCM;Ljava/lang/String;Lhudson/​model/BuildListener;Lhudson/EnvVars;Lhudson/​plugins/git/Revision;Ljava/lang/String;Ljava​/util/List;Ljava/lang/String;ILhudson/plugin​s/git/util/BuildData;Lhudson/FilePath;)V
12:54 paul_p at hudson.plugins.git.GitSCM.​checkout(
12:54 paul_p at hudson.model.AbstractProject.che​ckout(
12:54 paul_p at hudson.model.AbstractBuild$AbstractBuildExecu​tion.defaultCheckout(
12:54 paul_p at jenkins.scm.SCMCheckoutStrategy.che​ckout(
12:54 paul_p at hudson.model.AbstractBuild$AbstractBuil​
12:54 paul_p at hudson.model.Run.execute(
12:54 paul_p at hudson.model.FreeStyleBuild.​run(
12:55 paul_p at hudson.model.ResourceController.ex​ecute(
12:55 paul_p at
12:55 jcamins Yikes.
12:55 paul_p :((((((((((((
12:55 paul_p hi marcelr & jcamins & oleonard & others
12:55 marcelr hi paul_p oleonard
12:55 mtompset Greetings, jcamins paul_p and oleonard.
12:56 jcamins String freeze is going to be a bit late this month.
12:56 mtompset How so?
12:57 jcamins Instead of starting tonight it'll start tomorrow.
12:58 mtompset Oh, a bit delayed meant two or three days in my mind. One isn't so bad. :)
12:58 jcamins For two reasons. 1) I need gmcharlt's help so that I can push to, and 2) I found a bunch of XSS vulnerabilities in Koha, and the string freeze is waiting until I determine that they won't affect strings.
12:58 jenkins_koha Project Koha_master build #890: STILL FAILING in 10 sec: http://jenkins.koha-community.[…]/Koha_master/890/
12:59 paul_p jcamins = what are you talking about (string freeze) ?
12:59 paul_p jcamins are you talking to me ?
12:59 jcamins paul_p: 3.6.10.
13:00 paul_p ok, gotcha
13:00 jcamins It's my last release of 3.6.x, so the XSS vulnerabilities take priority over the planned string freeze date.
13:00 edveal joined #koha
13:01 mtompset Does the same vunerabilities exist on 3.8.x and master?
13:01 jcamins Yes.
13:01 jcamins Patch forthcoming.
13:02 oleonard More template filter issues jcamins?
13:03 tcohen joined #koha
13:03 jcamins oleonard: yup.
13:04 * oleonard had a great fix pending approval for that... under HTML::Template::Pro :P
13:09 laurence joined #koha
13:13 jenkins_koha Project Koha_master build #891: STILL FAILING in 10 sec: http://jenkins.koha-community.[…]/Koha_master/891/
13:16 jcamins !jenkins pause
13:16 jenkins_koha jcamins did you mean me? Unknown command 'pause'
13:16 jenkins_koha Use '!jenkins help' to get help!
13:16 jcamins !jenkins help
13:16 jenkins_koha Available commands:
13:16 jenkins_koha abort <job> - specify which job to abort
13:16 jenkins_koha alias [<alias> [<command>]] - defines a new alias, deletes one or lists all existing aliases
13:16 jenkins_koha botsnack [<snack>] - om nom nom
13:16 jenkins_koha build <job> [now|<delay>[s|m|h]] [<parameterkey>=<value>]* - schedule a job build, with standard, custom or no quiet period
13:16 jenkins_koha cb - list jobs which are currently in progress
13:16 jenkins_koha comment <job> <build-#> <comment> - adds a description to a build
13:16 jenkins_koha currentlyBuilding - list jobs which are currently in progress
13:16 jenkins_koha h [<job>|-v <view>] - show the health of a specific job, jobs in a view or all jobs
13:16 jenkins_koha health [<job>|-v <view>] - show the health of a specific job, jobs in a view or all jobs
13:16 jenkins_koha jobs [<job>|-v <view>] - show the status of a specific job, jobs in a view or all jobs
13:16 jenkins_koha q - show the state of the build queue
13:16 jenkins_koha queue - show the state of the build queue
13:16 jenkins_koha s [<job>|-v <view>] - show the status of a specific job, jobs in a view or all jobs
13:16 jenkins_koha schedule <job> [now|<delay>[s|m|h]] [<parameterkey>=<value>]* - schedule a job build, with standard, custom or no quiet period
13:16 jenkins_koha status [<job>|-v <view>] - show the status of a specific job, jobs in a view or all jobs
13:16 jenkins_koha testresult [<job>|-v <view>] - show the test results of a specific job, jobs in a view or all jobs
13:16 jenkins_koha userstat <username> - prints information about a Jenkins user
13:18 trea joined #koha
13:20 gerundio joined #koha
13:25 gerundio mtompset, I was out for lunch just saw your answer regarding email configuration now
13:26 gerundio can you give the direct URL for the list archive were that topic is discussed?
13:26 mtompset Perhaps one of the folks that showed up recently have a better answer regarding configuring the mailing stuff.
13:27 gerundio ok, I'll just paste the question again
13:27 gerundio how can I set koha to send mails via a given SMTP server?
13:27 alex_a_ joined #koha
13:28 jcamins gerundio: you have to set up a mail server on the Koha machine that forwards through the mail server you're interested in forwarding through.
13:28 jcamins I prefer postfix for my mail.
13:28 jcamins Other people prefer exim.
13:28 jcamins I have never met anyone who preferred sendmail. ;)
13:28 gerundio that was the answer I was afraid :p
13:28 jenkins_koha Project Koha_master build #892: STILL FAILING in 9.2 sec: http://jenkins.koha-community.[…]/Koha_master/892/
13:28 gerundio thanks anyway
13:29 gerundio postfix it is then
13:29 reiveune joined #koha
13:29 jcamins postfix?
13:29 wahanui postfix is probably found at (but you probably can skip the SASL stuff) or at
13:29 jcamins ^^ that first link will have you ready to go in about ten minutes.
13:29 jcamins oleonard: you did opac-showmarc, right?
13:31 jcamins Oh, never mind. I figured it out.
13:31 gerundio jcamins, btw, do you know how to setup LDAP auth?
13:31 jcamins gerundio: no.
13:31 gerundio too bad
13:31 jcamins There was a blog post about that on ByWater's blog not long ago.
13:32 nengard
13:32 nengard and/or[…]work-in-koha-3-4/
13:32 gerundio thanks
13:33 gerundio I found this one too
13:33 oleonard jcamins: I didn't write, but I made the template work the way it does now
13:34 jcamins oleonard: I was getting weird XSLT errors, but I figured them out.
13:34 maximep joined #koha
13:35 tcohen greetings mtompset
13:35 mtompset Greetings, tcohen.
13:36 tcohen been out for a week almost
13:36 tcohen how is #koha going?
13:37 mtompset Well, today a nasty build glitch developed in Jenkins.
13:37 jcamins tcohen: 3.6.10 will have a late string freeze.
13:37 tcohen hi jcamins, so we're not on string freeze yet
13:39 jcamins Nope. I expect I will announce the 3.6.x freeze tomorrow.
13:39 gerundio jcamins, I came to the same conclusion regading LDAP
13:40 jcamins gerundio: what conclusion? I haven't come to any conclusions about LDAP.
13:40 jcamins Well, I suppose I've concluded that I'd prefer not to use it.
13:40 gerundio the C4::Auth module assumes that binding is done with uid
13:40 gerundio in my case I think our LDAP server binds with user's CN
13:41 gerundio basically the post on Bywater solutions' blog states that for these cases: "(...) you should contact your closest developer to help you patch to fit your situation."
13:41 jcamins Ah.
13:42 * jcamins recuses himself from this development, pleading blind hatred of C4::Auth*
13:43 gerundio I've already looked into that code last Friday :)
13:43 alex_a joined #koha
13:43 gerundio always a bad sign when we have to change source code like that
13:43 jenkins_koha Project Koha_master build #893: STILL FAILING in 11 sec: http://jenkins.koha-community.[…]/Koha_master/893/
13:44 paul_p joined #koha
13:44 jcamins gerundio: why do you think I have a blind hatred of C4::Auth*? :P
13:44 gerundio I'm still going to look for a workaround
13:45 reiveune1 joined #koha
13:46 santy joined #koha
13:47 laurence joined #koha
13:50 balin Something entirely different: How does one conceptually go about implementing a field like media type with defined terminology (hard cover, soft cover, boardbook, ...) ... ?
13:50 sophie_m joined #koha
13:51 jcamins balin: you link a MARC field to an authorized value list.
13:52 jcamins balin: it's under "more constraints."
13:56 balin Ok. Will try that. Can those things be constraint by item type (may "Book" have a different authorized value list than "Music")?
13:58 paul_p_ joined #koha
13:58 alex_a_ joined #koha
13:58 jenkins_koha Project Koha_master build #894: STILL FAILING in 13 sec: http://jenkins.koha-community.[…]/Koha_master/894/
13:59 laurence1 joined #koha
13:59 reiveune joined #koha
14:00 julian_m joined #koha
14:04 gerundio I have 2 languages available on the I18N/L10N preferences
14:05 gerundio I chose both for users to select which they want on the admin interface
14:05 gerundio but still I only see English a no language selector
14:05 gerundio I've logged out and back in and everything still remains unchanged
14:05 gerundio any idea?
14:09 julian_m joined #koha
14:13 paul_p__ joined #koha
14:13 alex_a joined #koha
14:14 reiveune1 joined #koha
14:15 jenkins_koha Project Koha_master build #895: STILL FAILING in 23 sec: http://jenkins.koha-community.[…]/Koha_master/895/
14:15 laurence joined #koha
14:16 stgomez91 joined #koha
14:16 rambutan joined #koha
14:27 rambutan does everybody else see those ping timeouts? What causes the disconnect, something on the oftc server or something on the client side?
14:28 jenkins_koha Project Koha_master build #896: STILL FAILING in 13 sec: http://jenkins.koha-community.[…]/Koha_master/896/
14:29 jcamins rambutan: client side. You can tell because it was all of BibLibre.
14:42 logbot joined #koha
14:42 Topic for #koha is now Welcome to #koha this channel is for discussion of the Koha project and software The next general meeting is 7 November 2012 2:00 UTC
14:43 jenkins_koha Project Koha_master build #897: STILL FAILING in 11 sec: http://jenkins.koha-community.[…]/Koha_master/897/
14:44 jcamins !jenkins abort Koha_master
14:44 jenkins_koha jcamins: how do you intend to abort a build that isn't building?
14:44 jcamins !jenkins abort 497
14:44 jenkins_koha jcamins: unknown job '497'
14:44 jcamins !jenkins abort Koha_master/497
14:44 jenkins_koha jcamins: unknown job 'Koha_master/497'
14:44 jcamins !jenkins abort 897
14:44 jenkins_koha jcamins: unknown job '897'
14:44 mtompset Have a good day (24 hour period), #koha.
14:44 mtompset 898 now, perhaps, jcamins?
14:45 jcamins !jenkins abort 898
14:45 jenkins_koha jcamins: unknown job '898'
14:45 * jcamins shrugs.
14:46 nengard sam75 this might help:[…]-same-column-of-t
14:46 nengard or easier
14:48 nengard can anyone tell me how i should document the new search engine preference - is this still experimental? does it require changes on the server - or is it as simple as changing the preference and ta da! you have solr?
14:48 jcamins nengard: it is still highly experimental, and should not be used in production.
14:49 jcamins I know that much.
14:49 nengard okey dokey
14:49 nengard I'll add the preference to the manual with that IMPORTANT note
14:49 nengard and then we can expand upon it as things change
14:49 jcamins It requires that you install solr, and probably requires some configuration on that end, too.
14:54 jcamins nengard: you might want to note that if you _do_ enable it, authorities won't work at all.
14:54 nengard good to know
14:56 nengard next doc question - can someone show me how to use the 'field separator' in csv profiles? the rest I understand - but i need to see a sample of the field separate in a profile
14:56 jcamins I think you documented CSV profiles somewhere already.
14:56 nengard I did
14:57 nengard but not the field separator - not with an example
14:57 jcamins Ah.
14:57 nengard I'm looking at the manual :)
14:57 nengard I'm updating this section to make it clearer
14:57 jcamins Ah.
14:57 jcamins I only know what the manual says about CSV profiles.
14:57 nengard there are 2 new preferences that effect this section so I wanted to update the section first
14:57 nengard :) no prob
14:58 jenkins_koha Project Koha_master build #898: STILL FAILING in 8.5 sec: http://jenkins.koha-community.[…]/Koha_master/898/
14:59 jcamins !jenkins q
14:59 jenkins_koha build queue is empty
14:59 jcamins !jenkins s
14:59 jenkins_koha status of all projects:
14:59 jenkins_koha 3_6_Packages: last build: 21 (1 mo 1 day ago): SUCCESS: http://jenkins.koha-community.[…]/3_6_Packages/21/
14:59 jenkins_koha 3_8_packages: last build: 133 (1 day 6 hr ago): SUCCESS: http://jenkins.koha-community.[…]3_8_packages/133/
14:59 jenkins_koha Koha_3.2.x(disabled) : last build: 36 (10 mo ago): UNSTABLE: http://jenkins.koha-community.[…]ob/Koha_3.2.x/36/
14:59 jenkins_koha Koha_3.4.x(disabled) : last build: 80 (7 mo 27 days ago): UNSTABLE: http://jenkins.koha-community.[…]ob/Koha_3.4.x/80/
14:59 jenkins_koha Koha_3.6.x: last build: 59 (23 days ago): UNSTABLE: http://jenkins.koha-community.[…]ob/Koha_3.6.x/59/
14:59 jenkins_koha Koha_3.8.x: last build: 203 (1 day 6 hr ago): SUCCESS: http://jenkins.koha-community.[…]b/Koha_3.8.x/203/
14:59 jenkins_koha Koha_Docs: last build: 207 (2 days 22 hr ago): FAILURE: http://jenkins.koha-community.[…]ob/Koha_Docs/207/
14:59 jenkins_koha Koha_master: last build: 898 (25 sec ago): FAILURE: http://jenkins.koha-community.[…]/Koha_master/898/
14:59 jenkins_koha Master_Packages: last build: 97 (2 days 16 hr ago): SUCCESS: http://jenkins.koha-community.[…]ster_Packages/97/
15:00 santy joined #koha
15:02 nengard I think I get it
15:08 gerundio I've downloaded the latest available translations files for pt-PT
15:08 gerundio is it normal for the source text to contain Norwegian strings?
15:11 jcamins Yes, that's from the NORMARC file.
15:13 jenkins_koha Project Koha_master build #899: STILL FAILING in 8.3 sec: http://jenkins.koha-community.[…]/Koha_master/899/
15:18 santy joined #koha
15:28 jenkins_koha Project Koha_master build #900: STILL FAILING in 9.4 sec: http://jenkins.koha-community.[…]/Koha_master/900/
15:31 laurence left #koha
15:33 nengard jcamins you signed off on bug 7986 - i'm trying to find where on the circulation page this option to export is and i don't see it ? what page and I looking on? and where do I look for the export option?
15:34 huginn Bug[…]w_bug.cgi?id=7986 enhancement, P5 - low, ---, jonathan.druart, Pushed to Master , Export issues
15:34 nengard I looked at circ history on the patron record, the checkout tab and the details tab ? I'm not seeing it
15:34 jcamins When I tested it, it was right on the checkout tab.
15:35 oleonard "If at least one of both sysprefs (ExportRemoveFields and ExportWithCsvProfile) is filled, the export link is displayed"
15:35 oleonard Is that the case nengard?
15:35 nengard oh
15:35 nengard well duh
15:35 nengard :)
15:35 nengard trying agian
15:35 nengard trying again
15:35 cait joined #koha
15:36 nengard okay, I see it now - going to update those preferences to explain a bit more what they do - patch coming
15:36 jcamins This is weird.
15:36 jcamins Can anyone get an error message out of by giving it invalid formats?
15:36 nengard does anyone know why the Tools tab was added to the preferences?
15:37 oleonard ?
15:37 nengard cgi-bin/koha/admin/
15:37 nengard it has one preference on it - and it's really just a circ preference, not a Tools preference
15:38 talljoy joined #koha
15:38 oleonard Yeah that doesn't seem useful
15:38 nengard okay i'm gonna update it
15:38 nengard along with the preference description
15:38 jcamins @marc 502
15:38 huginn jcamins: The designation of an academic dissertation or thesis and the institution to which it was presented. (A note that describes the relationship of a work to a dissertation or thesis is recorded in field 500). (Repeatable) [a,6,8]
15:43 jenkins_koha Project Koha_master build #901: STILL FAILING in 9.2 sec: http://jenkins.koha-community.[…]/Koha_master/901/
15:46 mib_1zx3qr joined #koha
15:46 mib_1zx3qr Hello - is there anyone around who has implemented CAS with Koha?
15:48 trea left #koha
15:51 julian_m joined #koha
15:58 jenkins_koha Project Koha_master build #902: STILL FAILING in 8.2 sec: http://jenkins.koha-community.[…]/Koha_master/902/
16:07 melia joined #koha
16:09 jcamins Okay, the only remaining XSS vulnerabilities that I have identified are in the Javascript on
16:10 jcamins Unfortunately, I can't figure out how to solve them.
16:10 oleonard What's the issue?
16:10 wahanui i think the issue is the one described in bug 6997.
16:10 huginn Bug[…]w_bug.cgi?id=6997 normal, PATCH-Sent (DO NOT USE), ---, jcamins, RESOLVED FIXED, koha-remove leaves system in inconsistent state if there is an error
16:13 oleonard wizzyrea: is Bug 8922 specific to 3.6.x?
16:13 huginn Bug[…]w_bug.cgi?id=8922 minor, P5 - low, ---, gmcharlt, NEW , Can't sort Holds to Pull report on any field besides title
16:13 jenkins_koha Project Koha_master build #903: STILL FAILING in 9.6 sec: http://jenkins.koha-community.[…]/Koha_master/903/
16:15 jcamins oleonard: I think the problem is that I don't understand how the vulnerability works.
16:15 wajasu joined #koha
16:15 * jcamins is trying to figure that out.
16:15 wizzyrea I have only observed it in 3.6
16:16 jcamins wizzyrea: in what version of 3.6 did it appear?
16:16 jcamins I'll revert whatever commit caused it.
16:18 cait joined #koha
16:19 * oleonard growls "You give da woid sugar and that commit sleeps with da fishes"
16:19 jcamins Hehe.
16:20 wizzyrea 3.6.4
16:20 wizzyrea lol.
16:20 jcamins It worked in 3.6.3?
16:20 jcamins Okay, that might be long enough ago that I can't just revert the commit.
16:20 wizzyrea i'm not sure, what I know is that it is currently not working on 3.6.4
16:22 jcamins So it's actually possible that the sorting never worked in 3.6.x.
16:22 wizzyrea yea, could be
16:22 drojf joined #koha
16:23 wizzyrea there was a patch that fixed the sorting by title
16:23 drojf good evening #koha
16:23 wizzyrea hi :)
16:24 * drojf drowns in a flood of emails
16:24 drojf i've only been away for 3 days :/
16:24 slef drojf: checked the wiki for vector logo? I think someone found a better one that we remade, in the end.  I can upload ours and calyx's if you want them for some reason.
16:25 jcamins Okay, figured out the problem.
16:25 slef drojf:[…]s_and_Explanation
16:25 jcamins Do a search for "something';[javascript]"
16:25 drojf slef: there was a svg in the koha sources that will do i think
16:25 cait drojf: you have been away?
16:25 cait slef: I would like to see the others somewhere
16:25 slef drojf: hrm, the SVG is missing from that page. Could you link across to it, please?
16:26 drojf cait: looks like you missed me a lot :P
16:26 cait drojf: how do you figure?
16:26 drojf slef: will do later
16:26 slef cait: ok... it'll happen during the kohacon12 cleanup (ongoing... :-/ ) unless you need it for a particular date.
16:27 oleonard jcamins: Can you be more specific?
16:27 cait slef: no hurry - but I think it will be great to finally have one :)
16:28 jcamins oleonard: it allows you to inject Javascript.
16:28 jcamins I'm patching it.
16:28 jenkins_koha Project Koha_master build #904: STILL FAILING in 9.1 sec: http://jenkins.koha-community.[…]/Koha_master/904/
16:29 jcamins I just couldn't find the XSS vulnerability before.
16:29 oleonard jcamins: Can you give an example of a search string with javascript that demonstrates the problem?
16:29 jcamins oleonard: I'm working on getting the javascript to actually work.
16:31 wizzyrea oh there's actually quite a bit wrong with that, now that I poke at it
16:32 jcamins Ooh, good news!
16:32 wahanui good news is it looks like it's running properly.
16:32 jcamins It looks like you can't run arbitrary javascript directly.
16:32 jcamins The worst you can do is cause a syntax error.
16:36 jcamins How serious is a syntax error?
16:36 wizzyrea it looks like someone intended to put a branch filter on this as well, but didn't get to it?
16:36 jcamins I'm thinking not that serious.
16:37 oleonard It does interrupt the parsing of the rest of the JavaScript for the page
16:37 asaurat left #koha
16:37 jcamins oleonard: yeah, but the solution I have adds a new dependency, so I'm thinking the fix can be held for 3.8 and master.
16:38 gerundio I have 2 languages available on the I18N/L10N preferences
16:38 gerundio I chose both for users to select which they want on the admin interface
16:38 gerundio but still I only see English and no language selector
16:39 gerundio I've logged out and back in and everything still remains unchanged
16:39 wizzyrea the second question?
16:39 wahanui the second question is "What is the exact error message?"
16:39 gerundio any ideas?
16:39 wahanui any ideas are welcome :)
16:39 wizzyrea the third question
16:39 wahanui the third question is, like, "What version of Koha are you using?"[…]ion-koha-running/
16:39 wizzyrea that's what I was looking for.
16:43 jenkins_koha Project Koha_master build #905: STILL FAILING in 9 sec: http://jenkins.koha-community.[…]/Koha_master/905/
16:58 jenkins_koha Project Koha_master build #906: STILL FAILING in 8.8 sec: http://jenkins.koha-community.[…]/Koha_master/906/
17:06 reiveune joined #koha
17:07 * magnuse waves
17:09 magnuse wassup, jenkins? failing in 9 seconds, eh?
17:09 oleonard jcamins: After Bug 8678, <img> tags are no longer self-closed, resulting in non-standard-compliant markup
17:09 huginn Bug[…]w_bug.cgi?id=8678 major, P5 - low, ---, jcamins, Pushed to Master , XSLT stylesheets output XML, but HTML is needed
17:10 oleonard What non-standard-compliant markup was fixed by the bug? That weird Firefox one the multiple spans?
17:13 YoungPublicLibrarian joined #koha
17:14 YoungPublicLibrarian Good morning everyone (or evening if you are in another part of the world...)
17:15 jenkins_koha joined #koha
17:16 gerundio joined #koha
17:22 jcamins oleonard: the self-closed spans.
17:22 jcamins Yes.
17:26 oleonard I guess having the page work is a reasonable trade-off for making the template invalid :(
17:27 oleonard Not that we win any prize for validity
17:28 jcamins oleonard: it's possible there's an xhtml target, somewhere.
17:28 jenkins_koha Starting build #60 for job Koha_3.6.x (previous build: UNSTABLE -- last SUCCESS #58 1 mo 1 day ago)
17:28 jenkins_koha Starting build #204 for job Koha_3.8.x (previous build: SUCCESS)
17:29 jcamins But- I still haven't managed to push to 3.6.x.
17:31 YoungPublicLibrarian Anyone have a moment and is willing to take a look at a report and tell me what I screwed up on it? :/
17:32 magnuse YoungPublicLibrarian: just ask - don't ask to ask :-)
17:32 cait-m joined #koha
17:33 YoungPublicLibrarian Lol, okay. The report is the one I'm posting now...
17:33 pastebot "YoungPublicLibrarian" at pasted "SELECT b.surname, b.firstname," (12 lines) at
17:33 gaetan_B bye
17:34 YoungPublicLibrarian Its a mash up of two different reports, so may have multiple problems because I don't have the greatest grasp of SQL...
17:37 libsysguy joined #koha
17:38 jcamins joined #koha
17:39 koyauni joined #koha
17:41 koyauni hi guys, my Liberian asking for tag 805 for shelf number which is not seen in our koha, how can we get this to appear
17:43 slef isn't shelf number an item-level thing?
17:45 koyauni why it does not apear in our record
17:46 koyauni how do I make it apear
17:59 YoungPublicLibrarian So should I take the silence as no one having ideas for the report? lol
18:01 koyauni no one is here I guess
18:02 YoungPublicLibrarian lol, oh well. I will try again later in the day...
18:06 koyauni it is night here :)
18:06 koyauni Do you know how to add tag 805 to the system
18:06 gaetan_B joined #koha
18:12 YoungPublicLibrarian I don't unfortunately. I'm merely a circulation assistant at my library. I know nothing about cataloging or the programming of the Koha system...
18:15 koyauni it does not seams I can find any source on line
18:20 cait joined #koha
18:21 drojf koyauni: i would assume it is in the koha manual
18:23 YoungPublicLibrarian The people here are usually really great at helping. I think we just hit a time when everyone's busy or not one...
18:23 YoungPublicLibrarian *on
18:23 slef koyauni: you could change the stylesheet, you could change the Koha-MARC mapping, you could do it multiple ways. But it is hard to know what is the correct one for your situation.
18:24 slef YoungPublicLibrarian: what happens when you run that report?
18:25 slef YoungPublicLibrarian: you've an extra , after ni.date_due which might break it.
18:25 YoungPublicLibrarian Slef: Nothing, it returns no results at all. Just shows the report text above where the results would normally be...
18:26 slef YoungPublicLibrarian: if you have access to a mysql command-line, then testing the report there may give more informative errors.
18:26 cait if you can only test it in the reports interface you will not get the mysql errors
18:26 slef cait: is there any reason for that (security?), or just that no-one has coded an error display for the reports yet?
18:26 YoungPublicLibrarian Hmm...I'll look into getting a MySQL command-line program then
18:26 slef YoungPublicLibrarian: try removing that extra , first?
18:27 cait i am ont sure if there is a good reason, I don't know one
18:27 rambutan joined #koha
18:27 YoungPublicLibrarian Okay, one moment...
18:27 cait slef: maybe security, not sure
18:28 slef cait: but really, if someone evil has access to the reports creation interface, you're probably dead.
18:28 slef cait: yet another thing to ask some time :)
18:28 cait lol
18:28 cait I don't think it has to get that far
18:28 slef bbl
18:29 YoungPublicLibrarian okay, removing the "," didn't help...
18:29 rangi Morning
18:29 wahanui hmmm... Morning is a state of mind. or whenever the cat wants breakfast.
18:30 rambutan afternoon rangi
18:32 rangi Slef only reason is it's tricky to get useful error messages but definitely not impossible I'd sign off your patch :)
18:34 rangi I may have fixed Jenkins
18:34 rangi It got confused by git
18:35 magnuse rangi++
18:36 rangi We'll see
18:37 rangi If anyone is using chromium
18:37 rangi There is a Jenkins notifier
18:39 YoungPublicLibrarian Does anyone know a good mysql command line tool that I could install on a USB stick to test my reports and see what errors they give?
18:41 cait hm
18:41 cait I think the problem is you don't have that kind of access to the server
18:41 oleonard Wouldn't that require that you have MySQL and your database installed on the memory stick YoungPublicLibrarian ?
18:41 libsysguy ^^
18:41 cait and I can't think of a tool that will test for mysql errors without having a database to run it against
18:43 YoungPublicLibrarian I was actually wondering about those too, but was hoping they could be worked around. I just want something to be able to test the syntax on...
18:43 libsysguy what I would do is dump the db and import it on something else
18:43 libsysguy if you want to just test things on it
18:44 wizzyrea well plus, you'd have to have a database because without the tables and fields, how would your tool know what valid syntax even is?
18:44 YoungPublicLibrarian Libsysguy: Great idea, unfortunately I don't know how to do that and I doubt I have permissions to do that...
18:45 rangi I think that's the crux of your problem
18:45 rangi Your boss needs to give you permission
18:46 drojf the point where the reports module is not enough is when you have grown up to play with the real sql ;)
18:46 rangi Tech solutions to politics problems = mess
18:46 YoungPublicLibrarian yeah, i can't get permissions...I've already requested it a dozen times...
18:47 libsysguy what is your library YoungPublicLibrarian?
18:48 YoungPublicLibrarian Because of the politics involved I'd rather not say. The upper management of my library is very illiterate and already thinks I'm insubordinate because of how well I work with the computers...
18:48 drojf YoungPublicLibrarian: escalate your unsolvable reports to somebody who has permission until they give in?
18:49 wizzyrea YoungPublicLibrarian: isn't that why they have a support company?
18:50 oleonard Using [off] allows your comment to be left out of the IRC log
18:50 rangi 2 weeks wizzyrea!
18:50 wizzyrea oh yes oh yes
18:50 wizzyrea last week at NEKLS
18:50 * libsysguy puts on his jealous eyes and looks at wizzyrea
18:51 * jcamins gives wizzyrea the same jealous look.
18:51 rangi We are rearranging level 7
18:51 * wizzyrea drowns in a sea of green
18:51 YoungPublicLibrarian Drojf: I've tried that, nothing happens until I pick up the slack again. We didn't send out Overdues for 6 weeks... Jcamins: I would love to do that, but then its grounds for termination...
18:51 oleonard @later tell gmcharlt If you can configure the wiki to allow it I can upload an svg version of the Koha logo
18:51 huginn oleonard: The operation succeeded.
18:51 wizzyrea oooo
18:51 rangi Not sure where you will end up, somewhere near me of Kathryn
18:52 wizzyrea it's all good :)
18:52 rangi And kristina will be on 7 too
18:52 wizzyrea WOOT. All of these people I like. :)
18:52 YoungPublicLibrarian Wizzyrea: We have a support company, but the library consortium is too cheap to let us use it unless its a huge emergency...
18:52 * oleonard cheers wizzyrea's exciting move even though he's jealous too
18:53 melia yay wizzyrea! :)
18:54 rangi Maybe you will be at media's old desk
18:54 rangi Hehe
18:54 wizzyrea hehe
18:54 jcamins rangi: is it full of CDs, DVDs, and VHSes now? :)
18:54 melia it was a good desk. in the corner, with a window. :)
18:54 rangi Actually telecom team are moving
18:54 rangi To 4 I think
18:55 YoungPublicLibrarian Drojf: Thanks for the thoughts...I've been meddling through okay. But the fines and fees notices have got me stumped...
18:55 rangi Lol
18:56 rangi Stupid autocorrect
18:56 rangi Melia knew what I meant
18:56 * jcamins did too.
18:56 melia yep :)
18:56 jcamins But it was too great an autocorrect error to leave uncommented-on. :)
18:56 oleonard Under what circumstances is  bug 6976 fixed?
18:56 huginn Bug[…]w_bug.cgi?id=6976 major, P1 - high, ---, colin.campbell, RESOLVED FIXED, User hold limit can be avoided by users in OPAC
18:57 rangi Ok my stop bbiab
18:57 oleonard I can go to the OPAC, select a whole page of search results, and place 20 holds on something which has a 5-hold limit
18:57 oleonard That is, 20 holds on DVDs when there is a 5-hold limit on DVDs
18:58 jcamins oleonard: I think that's the maxholds bug, and there's another for circ rules.
18:58 oleonard Isn't Bug 4045 the maxholds bug?
18:58 huginn Bug[…]w_bug.cgi?id=4045 critical, P5 - low, ---, gmcharlt, In Discussion , No check for maximum number of allowed holds.
18:58 * wizzyrea wonders where he took the brake.
18:59 jcamins oleonard: oh, never mind, then.
19:01 drojf wizzyrea: he took it outside of the picture i think
19:01 magnuse hehe
19:04 oleonard This is America wizzyrea, we spell how we want. This is your last chance to enjoy it.
19:04 jcamins lol
19:05 cait lol
19:06 rangi back
19:06 wizzyrea ha.
19:12 trea joined #koha
19:15 NateC joined #koha
19:15 NateC left #koha
19:15 NateC joined #koha
19:15 NateC left #koha
19:18 cait joined #koha
19:18 nengard other than the tables that start with 'aq' - if i wanted to wipe out all acq data from my system and start fresh what tables do i have to clear? I dont' want to mess things up
19:20 rangi hey trea
19:20 trea hi rangi
19:21 tcohen hi rangi
19:22 rangi hi tcohen
19:29 rangi nengard: that should be it
19:29 nengard thanks rangi
19:32 oleonard Either way, Nate looks very dapper
19:32 rangi he does dapper well
19:32 jenkins_koha Project Koha_3.8.x build #204: SUCCESS in 2 hr 3 min: http://jenkins.koha-community.[…]b/Koha_3.8.x/204/
19:32 rangi w00t
19:32 wizzyrea heyyyyy
19:32 wizzyrea good stuff!
19:33 cait yay :)
19:34 cjh morning )
19:34 cjh did that build take 2 hours and 3 minutes? :o
19:34 gmcharlt oleonard: should be set up for you now
19:34 nengard rangi how do i drop those tables with all the links they have to other tables?
19:35 oleonard Thanks gmcharlt
19:35 nengard aqbooksellers and aqbaskets for example
19:35 nengard is there a - drop cause i know best clause? :)
19:35 jcamins gmcharlt: any chance you could add an SSH key for me?
19:35 jcamins Also, hello.
19:36 cjh nengard: if you use `DROP tablename CASCADE;` it will also delete any row in another table that references this one, is that what you want?
19:36 * wizzyrea waves enthusiastically to gmcharlt
19:36 nengard yes i think i do
19:36 cjh nengard: if the data is important, please back it up :)
19:36 nengard already backed up :)
19:37 rangi cjh: it got jammed, 3 builds running at once
19:37 cjh nengard++
19:38 rangi bug 3652
19:38 huginn Bug[…]w_bug.cgi?id=3652 critical, P1 - high, ---, oleonard, Needs Signoff , XSS vulnerabilities
19:38 magnuse again? :-)
19:39 gmcharlt jcamins: sure -- please try now
19:39 jcamins rangi: if you want to take a stab at the Javascript vulnerabilities, please be my guest.
19:39 rangi i was gonna ask cjh to do that
19:39 jcamins gmcharlt++
19:40 jcamins Worked perfectly.
19:40 rangi i was gonna sign off the patches there, and then get cjh too try to fix the javascript one
19:40 rangi its in the logs eh?
19:41 jcamins What's in the logs?
19:41 jenkins_koha Project Koha_3.6.x build #60: STILL UNSTABLE in 2 hr 12 min: http://jenkins.koha-community.[…]ob/Koha_3.6.x/60/
19:41 jcamins Still unstable?
19:41 wahanui unstable is sid
19:41 jenkins_koha Starting build #61 for job Koha_3.6.x (previous build: STILL UNSTABLE -- last SUCCESS #58 1 mo 1 day ago)
19:41 nengard cjh for some reason the booksellers just won't delet
19:41 nengard delete
19:41 jcamins How did it get unstable?
19:41 cjh nengard: are you getting an error message?
19:42 rangi jcamins: its a test failing because the db is in a master state, false positive
19:42 nengard checking now
19:42 jcamins Oh, okay.
19:42 nengard ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails
19:43 magnuse poor jenkins getting all confused
19:43 rangi jcamins: can you ping cjh in a pm and let him know where the js xss problem is
19:43 rambutan joined #koha
19:43 jcamins Will do.
19:43 cjh ty :)
19:54 trea joined #koha
19:57 rangi ahh smart fix for the opac-export jcamins
19:57 jcamins rangi: thanks. That was a tough one.
19:57 rangi that xss was a great example of how trying to save time typing, bites you in the ass
20:01 jcamins I suspect we'll have the same problem elsewhere, but I haven't found it yet.
20:01 cjh oh wow, in mysql CASCADE does nothing :(
20:02 rangi *nod*
20:03 nengard cjh i got it sorted out
20:03 nengard turned off warnings - it's my own local install so i wasn't too worried about bad practices :)
20:04 jcamins nengard: then you just have to make sure you get all the aq tables, since MySQL won't catch it for you.
20:04 nengard looks like i idid
20:04 oleonard rangi: Did you ponder how Bug 8917 could be made to work with OPACSearchForTitleIn?
20:05 huginn Bug[…]w_bug.cgi?id=8917 enhancement, P5 - low, ---, oleonard, Needs Signoff , Track clicks to links external to Koha
20:05 cjh nengard: heh, what was the command you used? `set FOREIGN_KEY_CHECKS=0` ?
20:05 reiveune bye
20:05 reiveune left #koha
20:05 rangi oleonard: nope
20:05 nengard yeah
20:05 jcamins oleonard: TT filter?
20:06 cjh awesome, glad you got it working. Sorry I wasnt more help, I know postgres better than mysql.
20:07 rangi oleonard: the feature is only for 856u (under xslt) and any links in the biblio or item in normal view.. ill do the xslt for normac and unimarc too when i figure it out
20:07 rangi so it does links in the biblio and the item
20:07 nengard no problem cjh, you got me pointed in the right direction
20:07 rangi the use case is to track the usage of catalogued electronic items
20:07 jenkins_koha Yippie, build fixed!
20:07 jenkins_koha Project Koha_master build #907: FIXED in 2 hr 53 min: http://jenkins.koha-community.[…]/Koha_master/907/
20:08 rangi (it logs the biblionumber and itemnumber (if applicable))
20:08 oleonard rangi, it sounds very useful. I was just curious about the other searches because that was the first external link that came to mind
20:08 rangi i guess it could be extended for other links
20:08 rangi *nod*
20:08 rangi it could track that too
20:08 rangi but not for the amount i quoted the client :-)
20:09 oleonard In fact it would be nice to have the feature NOW because we debating whether it's worth it to have MARC records in the catalog for our ebooks from OverDrive.
20:09 rangi oleonard: thats exactly the use case
20:09 rangi and external databases
20:09 rangi cataloguing them then you can see if ppl actually visit them
20:10 wizzyrea cataloging your databases is a cool idea
20:10 wizzyrea i kind of wonder if you can't get similar metrics from piwik or GA though?
20:10 wizzyrea don't they usually measure clickthroughs?
20:10 wizzyrea maybe harder to find.
20:11 jcamins wizzyrea: that's what I told Waylon to do- just use piwik.
20:11 jcamins He wanted scads of analytics.
20:12 wizzyrea seems silly to build analytics into koha
20:12 wizzyrea where there are such fab tools for that
20:13 oleonard See ya #koha
20:15 rangi no piwik cant track that
20:15 rangi what if i click on a link to the db from the results page
20:16 rangi it has no idea what biblionumber that link was from
20:16 rangi also piwik has opt out features
20:16 wizzyrea true
20:16 rangi which is great
20:17 rangi and it cant track link clicks without js either
20:17 rangi its a different beast, for a totally different use case
20:17 rangi maybe for what waylon wanted, but not for tracking usage of catalogued materials
20:21 wizzyrea right, makes sense like that
20:22 rangi also, piwik and GA get blocked by firewalls/proxies sometimes
20:22 rangi for an approximation, they are good tools
20:29 rangi coffee time
20:30 rambutan its always coffee time
20:38 jenkins_koha Project Koha_3.6.x build #61: STILL UNSTABLE in 57 min: http://jenkins.koha-community.[…]ob/Koha_3.6.x/61/
20:38 jenkins_koha * meenakshi.r: Bug 6655 - Sorting order of serial issues in OPAC
20:38 jenkins_koha * elliott: Bug 8421 : Added a URI filter to encode a cardnumber for borrowers as to not break
20:38 jenkins_koha * dcook: Bug 8455 - Check ins processed through "Check Out" tab of the Patron Record ignore Circulation System Preferences
20:38 jenkins_koha * veron: Bug 7628 - Required format is not enforced for Patron Categories
20:38 huginn Bug[…]w_bug.cgi?id=6655 trivial, P5 - low, ---, meenakshi.r, RESOLVED FIXED, Sorting order of serial issues in OPAC
20:38 jenkins_koha * jonathan.druart: Bug 7628: Escape '+' characters for categorycode
20:38 jenkins_koha * mtompset: Bug 8172 - Missing dereference marker for buildQuery parameter in Added a dereference to an array parameter of buildQuery.
20:38 jenkins_koha * fridolyn.somers: Bug 8576: Software error on authority edition when using merge
20:38 jenkins_koha * robin: Bug 8162: allow packages to work on Ubuntu Precise
20:38 jenkins_koha * kyle: Bug 8533 - Non-numeric cardnumbers screw up autoMemberNum
20:38 huginn Bug[…]w_bug.cgi?id=8421 minor, P5 - low, ---, elliott, RESOLVED FIXED, patron images fail when barcode for patron has a +
20:38 huginn Bug[…]w_bug.cgi?id=8455 normal, P5 - low, ---, dcook, RESOLVED FIXED, Check ins processed through "Check Out" tab of the Patron Record ignore Circulation System Preferences
20:38 jenkins_koha * robin: Bug 8646 - prevent the highlighter from going infinite loop
20:38 jenkins_koha * ruth: Bug 8012: default values for defaultSortField/defaultSortOrder NULL on install
20:38 jenkins_koha * mtompset: Bug 4064 - Uninitialized variable errors in
20:38 jenkins_koha * robin: Bug 8594 - prevent the report system from breaking some subqueries
20:38 huginn Bug[…]w_bug.cgi?id=7628 normal, P3, ---, veron, RESOLVED FIXED, Required format is not enforced for Patron Categories
20:38 huginn Bug[…]w_bug.cgi?id=8172 major, P5 - low, ---, gmcharlt, RESOLVED FIXED, Missing dereference marker for buildQuery parameter in
20:38 jenkins_koha * jcamins: Bug 8678: XSLT stylesheets output XML, but HTML is needed
20:38 jenkins_koha * melia: Bug 7143: Adding Kathryn Tyree to the history and About page.
20:38 jenkins_koha * mjr: Bug 7068 - autobarcode not working when duplicating patrons
20:38 jenkins_koha * robin: Bug 8716 - make the routing list reordering function work
20:38 jenkins_koha * oleonard: Bug 8677 - table overlapping to the right on holds waiting
20:38 jenkins_koha * mtompset: Bug 8339 - div id="login" should be id="login_controls" in
20:38 huginn Bug[…]w_bug.cgi?id=8576 critical, P2, ---, fridolyn.somers, RESOLVED FIXED, Software error on authority edition when using merge
20:38 huginn Bug[…]w_bug.cgi?id=8162 critical, P3, ---, robin, RESOLVED FIXED, packaging scripts create user incorrectly
20:38 jenkins_koha * oleonard: Bug 8730 - browse overlaying powered by
20:38 jenkins_koha * fridolyn.somers: Bug 8071: link between bib and authorities with the authid
20:38 jenkins_koha * jcamins: Bug 8447: Make sure we have enough subfields for broader_headings
20:38 jenkins_koha * colin.campbell: Bug 6976 Close loophole allowing borrowers extra holds via opac
20:39 jenkins_koha * jcamins: Bug 8743: ZOOM error when merging authority change to biblios
20:39 jenkins_koha * Paul Poulain: Bug 8743 follow-up, throw a more explanatory error message
20:39 jenkins_koha * fridolyn.somers: Bug 8705: Software error on help of main page
20:39 jenkins_koha * mtompset: Bug 8714 - Poorly ordered and triggers warning in
20:39 huginn Bug[…]w_bug.cgi?id=8533 minor, P5 - low, ---, koha-bugs, RESOLVED FIXED, Non-numeric cardnumbers screw up autoMemberNum
20:39 huginn Bug[…]w_bug.cgi?id=8646 minor, P5 - low, ---, robin, RESOLVED FIXED, Certain search terms cause browser "script taking too long" error
20:39 jenkins_koha * fridolyn.somers: Bug 7690: hidelostitems not working in Normal Display
20:39 jenkins_koha * mtompset: Bug 8713 - Warning message triggered by clicking Keywords to MARC mapping
20:39 jenkins_koha * fridolyn.somers: Bug 8275: xml parsing error when the webservice GetPatronInfo/show_loans is called
20:39 jenkins_koha * Katrin.Fischer.83: Bug 3782: Remove broken z39.50 targets from sample files
20:39 jenkins_koha * nengard: Bug 8721: Fixes minor typo in AllowItemsOnHoldCheckout
20:39 jenkins_koha * fridolyn.somers: Bug 8702: System preferences search does not allow accented letters
20:39 huginn Bug[…]w_bug.cgi?id=8012 trivial, P5 - low, ---, ruth, RESOLVED FIXED, defaultSortOrder and OPACdefaultSortOrder are set to "ascending" on install
20:39 huginn Bug[…]w_bug.cgi?id=4064 normal, P5 - low, ---, mtompset, RESOLVED FIXED, Uninitialized variable errors in
20:39 jenkins_koha * maxime.pelletier: Bug 8659 Remove and readd the inactive funds in javascript to make it work in all browsers
20:39 jenkins_koha * mtompset: Bug 8350: warning in logs when searching for nonexistent ISBN
20:39 jenkins_koha * jcamins: Bug 8744: Thesaurus in authorities should not lock fields
20:39 jenkins_koha * mtj: Bug 7589 - tinymce editor broken in .deb packages - in 'en' templates
20:39 jenkins_koha * veron: Bug 8810 - Opac: Cart should display branchname instead of branchcode
20:39 jenkins_koha * fridolyn.somers: Bug 8497: Strange behavior when modifying the timeout system preference
20:39 jenkins_koha * veron: Bug 8796 - patron cards not starting on designated card
20:39 jenkins_koha * oleonard: Bug 6037 [Follow-up] Invalid markup, missing breadcrumbs on Keyword to MARC Mapping page
20:39 huginn Bug[…]w_bug.cgi?id=8594 normal, P5 - low, ---, robin, Pushed to Master , A report containing a subquery that has a 'limit' will have that limit stripped out
20:39 jenkins_koha * mtompset: Bug 8772 - Uninitialized variable triggers error log entry in
20:39 jenkins_koha * Chris Cormack: Bug 3652 : [SIGNED-OFF] [SECURITY] XSS vulnerability
20:39 huginn Bug[…]w_bug.cgi?id=8678 major, P5 - low, ---, jcamins, Pushed to Master , XSLT stylesheets output XML, but HTML is needed
20:39 jenkins_koha * Chris Cormack: Bug 3652: XSS vulnerability in page numbering
20:39 jenkins_koha * Chris Cormack: Bug 3652 XSS vulnerability in facets
20:39 jenkins_koha * robin: Bug 8806 - [3.6.x] Update changelog for 3.6.5-3.6.9, dependencies.
20:39 huginn Bug[…]w_bug.cgi?id=7143 trivial, P5 - low, ---, katrin.fischer, Passed QA , Bug for tracking changes to the about page
20:39 huginn Bug[…]w_bug.cgi?id=7068 major, P5 - low, ---, mjr, RESOLVED FIXED, autobarcode not working when duplicating patrons
20:39 huginn Bug[…]w_bug.cgi?id=8716 normal, P4, ---, robin, RESOLVED FIXED, Reordering of routing list entries doesn't work
20:39 huginn Bug[…]w_bug.cgi?id=8677 minor, P5 - low, ---, oleonard, RESOLVED FIXED, table overlapping to the right on holds waiting
20:39 huginn Bug[…]w_bug.cgi?id=8339 minor, P5 - low, ---, mtompset, RESOLVED FIXED, div id="login" should be id="login_controls" in
20:39 huginn Bug[…]w_bug.cgi?id=8730 minor, P5 - low, ---, oleonard, RESOLVED FIXED, browse overlaying powered by
20:39 huginn Bug[…]w_bug.cgi?id=8071 blocker, P1 - high, ---, fridolyn.somers, RESOLVED FIXED, link beween bib and authorities with the authid
20:39 huginn Bug[…]w_bug.cgi?id=8447 critical, P1 - high, ---, gmcharlt, RESOLVED FIXED, can't save new records / indicator error
20:39 huginn Bug[…]w_bug.cgi?id=6976 major, P1 - high, ---, colin.campbell, REOPENED , User hold limit can be avoided by users in OPAC
20:39 huginn Bug[…]w_bug.cgi?id=8743 critical, P3, ---, jcamins, RESOLVED FIXED, ZOOM error when merging authority change to biblios
20:39 huginn Bug[…]w_bug.cgi?id=8705 normal, P5 - low, ---, fridolyn.somers, RESOLVED FIXED, Software error on help of main page
20:39 huginn Bug[…]w_bug.cgi?id=8714 trivial, P5 - low, ---, mtompset, RESOLVED FIXED, Poorly ordered and triggers warning in
20:39 huginn Bug[…]w_bug.cgi?id=7690 minor, P5 - low, ---, fridolyn.somers, RESOLVED FIXED, hidelostitems not working in Normal Display
20:39 huginn Bug[…]w_bug.cgi?id=8713 trivial, P5 - low, ---, mtompset, RESOLVED FIXED, Warning message triggered by clicking keyword to marc mapping.
20:39 huginn Bug[…]w_bug.cgi?id=8275 normal, P5 - low, ---, fridolyn.somers, RESOLVED FIXED, xml parsing error when the webservice GetPatronInfo/show_loans is called
20:39 huginn Bug[…]w_bug.cgi?id=3782 normal, P5 - low, ---, katrin.fischer, RESOLVED FIXED, delivered z39.50 targets wrong for NY Public Library and NY University Library
20:39 huginn Bug[…]w_bug.cgi?id=8721 minor, P5 - low, ---, nengard, Pushed to Stable , typo in  AllowItemsOnHoldCheckout
20:39 huginn Bug[…]w_bug.cgi?id=8702 normal, P5 - low, ---, fridolyn.somers, Pushed to Stable , System preferences search does not allow accented letters
20:39 huginn Bug[…]w_bug.cgi?id=8659 normal, P5 - low, ---, pelletiermaxime, Pushed to Stable , Inactive funds in neworderempty not disabled in IE/Opera
20:39 huginn Bug[…]w_bug.cgi?id=8350 normal, P5 - low, ---, mtompset, Pushed to Stable , Searching for a 10 or 13 digit string (with a number in it) that does not exist in one's catalog will fail to affect SQL statement correctly in C4::Breeding
20:39 huginn Bug[…]w_bug.cgi?id=8744 normal, P5 - low, ---, jcamins, Pushed to Stable , Thesaurus in authorities should not lock fields
20:39 huginn Bug[…]w_bug.cgi?id=7589 blocker, P1 - high, ---, robin, Pushed to Stable , tinymce editor broken in .deb packages - in 'en' templates
20:39 huginn Bug[…]w_bug.cgi?id=8810 normal, P3, ---, veron, Pushed to Stable , Opac: Cart should display branchname instead of branchcode
20:39 huginn Bug[…]w_bug.cgi?id=8497 critical, P5 - low, ---, fridolyn.somers, Pushed to Stable , Strange behavior when modifying the 'timeout' system preference.
20:39 huginn Bug[…]w_bug.cgi?id=8796 normal, P5 - low, ---, veron, Pushed to Stable , patron cards not starting on designated card
20:39 huginn Bug[…]w_bug.cgi?id=6037 normal, P5 - low, ---, oleonard, Pushed to Stable , Invalid markup, missing breadcrumbs on Keyword to MARC Mapping page
20:39 huginn Bug[…]w_bug.cgi?id=8772 trivial, P5 - low, ---, mtompset, Pushed to Stable , Uninitialized variable triggers error log entry in
20:39 huginn Bug[…]w_bug.cgi?id=3652 critical, P1 - high, ---, oleonard, Signed Off , XSS vulnerabilities
20:39 huginn Bug[…]w_bug.cgi?id=8806 enhancement, P5 - low, ---, robin, Needs Signoff , Debian packaging updates
20:40 jcamins Sorry, folks.
20:40 jcamins 3.6.10 is a pretty big release.
20:40 jcamins It contains everything that would've been a candidate for 3.6.11, too.
20:42 rangi :)
20:46 maximep o_O
20:49 rangi jcamins: don't forget to string freeze
20:53 jcamins rangi: yeah, I'm announcing it once I'm sure I'm not breaking it again with additional XSS fixes.
20:53 jcamins I'm pretty sure I will not be.
20:55 rangi yeah
20:57 jcamins Lucky libsysguy.
20:58 libsysguy_phone_with_paychex heh yeah i know right :-/
20:59 wizzyrea oof.
21:00 drojf1 joined #koha
21:16 eythian @later tell tcohen most likely yes.
21:16 huginn eythian: The operation succeeded.
21:27 srikanth joined #koha
21:39 rambutan joined #koha
21:56 edveal left #koha
22:24 maximep left #koha
22:30 rangi bug 8890 really needs a sign off
22:30 huginn Bug[…]w_bug.cgi?id=8890 blocker, P5 - low, ---, koha-bugs, Needs Signoff , Packages can't be built on master, db dependent test
22:31 stefan-l joined #koha
22:39 NateC joined #koha
22:56 stefan-l joined #koha
23:09 rambutan joined #koha
23:28 rambutan left #koha
23:48 NateC left #koha

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