IRC log for #koha, 2016-05-05

All times shown according to UTC.

Time S Nick Message
00:07 rocio joined #koha
00:07 drab joined #koha
00:07 drab hello #koha
00:08 drab this other instance of koha I recently restored is having a weird problem - users/borrowers look good and login works as intra- does, but opac does not
00:09 drab with the exception of my account, which I've set to superlibrarian, however when I've set that permission on another Staff account it still could not login
00:12 drab nothing shows in /var/log/koha/library/opac-error.log when I try to login with an account that does not work
00:13 drab however when I try mine I see this: AH01215: [Wed May  4 17:13:06 2016] CGI::param called in list context from /usr/share/koha/opac/cgi-bin/opac/ line 392, this can lead to vulnerabilities. See the warning in "Fetching the value or values of a single named parameter" at /usr/share/perl5/ line 405.: /usr/share/koha/opac/cgi-bin/opac/
00:17 drab I'm actually exactly the same as this other user, same patron category, same permissions.. I don't see any differences, but I can login and he can't
00:18 drab and again only for opac, both users can login to the -intra and the for self checkout
00:18 drab it all goes to the borrowers table and we have the same permissions so I'm puzzled why this is happening
00:21 drab I've also tried to reset his password, no change
00:24 drab also this page https://wiki.koha-community.or[…]y:Troubleshooting suggests that adding ?debug=1 will give deubbing info, but I see nothing in the logs
00:30 kidclamp jsut to check drab - opacuserlogin is set to allow?
00:30 NateC joined #koha
00:31 drab kidclamp: good question, I thought that was default to on and I've actually never set it myself
00:31 drab where would that be?
00:31 drab and also, if it wasn't, why would I be able to login?
00:31 drab but still, worth checking
00:32 kidclamp if you were set as the SCO user
00:32 kidclamp its a system preference, should be searchable
00:33 drab ok, sec
00:34 kidclamp figure why not try the low hanging fruit first :-)
00:34 drab totally, looking for it
00:36 drab kidclamp: yeah, set to allow
00:38 kidclamp hhmm..odd
00:39 drab any clue about increasing logging/debuggin? would be great to get some dump from
00:39 drab to see what's it doing
00:40 drab that login screen is not even telling me wrong usernmame or password, nothing, just going back to it
00:40 drab so no clue if it's doing what/failing why
00:42 kidclamp that is odd, I don't what logging is actually done for the opac login, users aren't tracked, so if auth problem you may not get much
00:42 kidclamp check the apache logs too
00:42 drab yeah, I did, nothing there, just the hits to the pl
00:42 kidclamp do all user have unique userids?
00:43 kidclamp what version?
00:52 drab yes. 3.22.4
01:04 aleisha joined #koha
01:09 drab urm, something else is going on
01:09 drab I just tried to edit a patron and it gave me an error, cannot add patron, there are no patri categories defined
01:10 drab and then it has a link to "please add a patron category", but that has many already there
01:13 drab DBD::mysql::st execute failed: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'koha_library.categories.categorycode' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [for Statement ": /usr/share/koha/intranet/cgi​-bin/members/,
01:13 drab dang it
01:13 drab this looks like a problem with mysql 5.7 that ubuntu 16.04 ships with
01:14 drab as compared to 5.5 that 14.04 used to ship with and this instance used to run on :/
01:21 drab yep, ok, that takes care of that error
01:21 drab the "no patron categories" issue is gone
01:21 drab[…]ly_full_group_by/
01:21 drab in case anybody cares
01:21 drab basically remove ONLY_FULL_GROUP_BY from sql_mode
01:21 drab I still can't login in opac tho :(
01:25 geek_cl joined #koha
01:35 drab
01:36 drab I've also tried that, setting KOHA_CGI_DEBUG in apache, and still see nothing
01:36 drab no more lines/debugging than normal
01:39 irma joined #koha
01:51 kidclamp good luck drab, sorry I couldn't help more
01:51 kidclamp maybe throw this out on the list to see who can help?
01:53 dcook joined #koha
01:55 cdickinson joined #koha
02:02 irma joined #koha
02:12 dcook For all my Zebra skillz, I'm still stumped by why my dev install appears not to support 5=103...
02:12 dcook [120] Unsupported Truncation attribute -- v2 addinfo '103'
02:20 dcook Ohhh... I bet it's ICU...
02:22 dcook Ahhhhhhhhhhhhhh that was it
02:22 dcook Ahhhhhhh
02:22 * dcook writhes around
02:23 rocio left #koha
02:45 irma_ joined #koha
03:01 aleisha joined #koha
03:30 Francesca joined #koha
03:50 aleisha joined #koha
03:59 Oak joined #koha
04:24 JoshB joined #koha
05:41 drojf joined #koha
06:18 Oak joined #koha
06:36 aleisha joined #koha
06:44 Oak joined #koha
06:45 thd-away` joined #koha
07:10 aleisha joined #koha
07:53 aleisha joined #koha
08:09 catalyst_peter joined #koha
08:30 SamEEE joined #koha
09:01 cdickinson_ joined #koha
10:17 cait joined #koha
10:20 drab joined #koha
10:24 huginn New commit(s) kohagit: Bug 16429 - Fix root problem <[…]01efab81bca311588> / Bug 16429 - Going to circulation from notice triggers may change logged in branch <[…]8350674bee997cb6d>
10:35 Francesca joined #koha
10:59 tcohen joined #koha
11:40 oleonard joined #koha
11:40 oleonard Hi #koha
11:45 ericar joined #koha
11:46 nengard joined #koha
11:51 meliss joined #koha
11:58 cait hi oleonard :)
12:07 druthb oleonard!  cait!
12:12 oleonard Hi cait and druthb
12:13 cait druthb1
12:13 cait druthb!
12:13 druthb cait!
12:13 druthb :P
12:19 Dyrcona joined #koha
12:34 tcohen bonjour
12:35 cait morning tcohen :)
12:35 druthb Hi, tcohen! :)
12:43 tcohen hi cait, druthb
12:44 tcohen Joubu: around?
12:55 edveal joined #koha
12:56 Joubu tcohen: yep
12:57 tcohen Joubu: could you check a regression test i wrote makes sense?
12:57 tcohen :-D
12:58 pastebot "tcohen" at pasted "Joubu: this" (75 lines) at
13:00 Joubu tcohen: you will need to clean the cache
13:00 * tcohen knew had to ask Joubu
13:01 tcohen after ModBiblioframework?
13:01 Joubu tcohen: and you add a framework but use the default
13:02 tcohen nope, I call ModBiblioframework with $frameworkcode
13:03 tcohen i need to undef %default_values_for_mod_from_marc on on C4::Items, right?
13:04 Joubu are you writting tests for bug 13074?
13:04 huginn Bug[…]_bug.cgi?id=13074 normal, P5 - low, ---, jonathan.druart, Needs Signoff , C4::Items::_build_default_values_for_mod_marc should use Koha::Cache
13:04 tcohen yes
13:04 tcohen no
13:05 tcohen for bug 16428
13:05 huginn Bug[…]_bug.cgi?id=16428 normal, P5 - low, ---, jonathan.druart, Needs Signoff , The framework is not checked to know if a field is mapped
13:05 Joubu without 13074, it's the way to go
13:05 tcohen you made 13074 depend on 16428
13:05 Joubu after, you need the Koha::Cache->clear_from_cache('​default_values_for_something')
13:08 NateC joined #koha
13:08 tcohen Joubu: my problem is that the last test correctly fails without your patch
13:08 tcohen BUT
13:09 tcohen with your patch 'Subfield 3 is not mapped on the new framework' fails
13:09 tcohen can you spot what i'm missing about cleaning the cache?
13:10 Joubu tcohen: do you use memcache for the tests?
13:10 tcohen possibly
13:11 tcohen nop
13:12 tcohen if you prefer, I can attach my test to the bug and you fix it
13:12 Joubu echo $MEMCACHED_SERVER
13:12 Joubu yes please
13:13 tcohen empty
13:13 tcohen ok, that'd be faster
13:14 JoshB joined #koha
13:15 kmlussier joined #koha
13:16 * oleonard wonders why a change in the DOM would cause a form.submit() to fail
13:16 tcohen done
13:25 cait1 joined #koha
13:36 oleonard Can you really use automatic item modification by age to update items.itemnumber? biblioitems.marcxml?
13:41 mario joined #koha
13:41 amyk joined #koha
13:43 Joubu oleonard: it does not really make sense :)
13:51 tcohen oleonard: maybe we added some event listener later, and it is failing because of the DOM change?
13:54 oleonard Thanks tcohen, not that I can find. I worked around the problem by giving up on using submit()  :|
14:18 kidclamp joined #koha
14:20 * oleonard rediscovers Bug 7223
14:20 huginn Bug[…]w_bug.cgi?id=7223 enhancement, P5 - low, ---, paul.poulain, NEW , Move borrowerRelationship to Authorised Values list
14:20 oleonard Yeah, do that.
14:20 oleonard @seen sekjal
14:20 huginn oleonard: sekjal was last seen in #koha 1 year, 33 weeks, 5 days, 15 hours, 26 minutes, and 58 seconds ago: <sekjal> :)
14:21 oleonard I'm sure he'll get around to it.
14:27 amyk_ joined #koha
14:30 Oak joined #koha
14:31 * Oak waves
14:33 druthb_away joined #koha
14:38 Joubu tcohen: on D8 WARNING: You do not have upload_path in koha-conf.xml at t/db_dependent/Upload.t line 44.
14:39 tcohen yeah, that's marcel's fault
14:40 tcohen i asked for a followup, and then forgot about it before the 3.22 release
14:40 amyk joined #koha
14:48 rocio joined #koha
14:49 kylemhall joined #koha
14:55 navigator joined #koha
14:56 navigator Can someone help me figure out how to print a list of the books in my library and also the shelf order so we can do the end of the year inventory?
14:57 oleonard navigator: Have you checked the SQL reports library?
14:57 oleonard[…]L_Reports_Library
14:58 oleonard navigator: There is also Koha's built-in inventory tool, although I have not used it.
14:59 navigator We are very new to Koha so I'm not super familiar with it at all.  What is the SQL reports library?  And do you know where the built-in inventory tool is located in Koha?
14:59 Karl_H joined #koha
14:59 oleonard navigator: The SQL reports library is what I pasted the link to. You can use the information there to build custom reports.
15:00 oleonard The inventory tool can be found under "Tools"
15:00 oleonard Look for the "Inventory/stocktaking" link.
15:00 TGoat joined #koha
15:01 navigator Ah ha...I see the link now.  Okay, I'll look there.  Okay I also just found the inventory/stocktaking as well.  Thank you so much for your help!!!
15:03 Karl_H joined #koha
15:03 jls joined #koha
15:06 navigator Sorry..I'm back.  :)  Does anyone know how to get the list to print in the order it should appear on the shelf?  Right now it's showing chronological order of the barcodes.  I need it to show "FIC AAA THROUGH FIC ZZZ" AND THE NUMERICAL ORDER OF DEWEY DECIMAL FOR THE NON FICTION.  SORRY TO BOTHER YOU BUT I JUST CAN'T SEEM TO FIGURE IT OUT.
15:08 navigator wait, i may have figured it out.  you have to enter fic aaa - fic zzz and it shows the report in shelf order.  thanks anyways.
15:09 pianohacker joined #koha
15:12 Joubu Does someone use TagsExternalDictionary?
15:14 bag nope
15:14 bag morning Joubu
15:15 Oak someone could be using it bag
15:15 Oak :)
15:15 Oak not me though
15:16 bag yeah Oak - I meant not me ;)
15:16 bag heh
15:16 Joubu hi bag
15:16 Joubu Actually I think it's broken and does not work
15:16 bag I don’t use a dictionary - I just typo with the best of them ;0
15:16 Joubu since a while
15:17 bag Joubu what’s the git blame on that?
15:17 bag for a date I mean
15:18 Joubu It has been added to the script on commit 83b7624e133ea87d4455bd888595e12097d9f274 Date:   Mon Apr 21 16:22:35 2008 -0500
15:18 Joubu not recently...
15:19 bag I think this was a ptfs dev iirc
15:19 bag something in that release they called harley… supposed to use aspell iirc
15:20 bag but I am not sure if it ever really worked joubu
15:20 Joubu k, I will ping koha-devel. I don't know if I have to fix it or remove it...
15:36 Joubu Ha, it does not work under Plack, but work in CGI mode...
15:43 jls joined #koha
15:44 jls joined #koha
16:15 Joubu opened bug 16455 (for the record)
16:15 huginn Bug[…]_bug.cgi?id=16455 normal, P5 - low, ---, jonathan.druart, Needs Signoff , TagsExternalDictionary does not work under Plack
16:15 Joubu bye #koha
16:20 cait1 hm anyone seeing bug 16393?
16:20 huginn Bug[…]_bug.cgi?id=16393 major, P2, ---, koha-bugs, NEW , mysql  error 1171 in Web installer Step 3
16:39 kidclamp I did on Ubuntu 16.04 - but haven't done anything beyond hitting it
16:40 kidclamp cait^ but in meeting
16:46 oleonard Anyone know if Bug 16429 can be triggered in other ways besides the way it is mentioned in the test plan?
16:46 huginn Bug[…]_bug.cgi?id=16429 minor, P5 - low, ---, kyle, Pushed to Master , Going to circulation from notice triggers may change logged in branch
16:48 kidclamp oleonard:I played a little and didn't hit it anywhere else but I didn't test extensively
16:49 oleonard Just got a report from a librarian here describing a similar problem, but she wouldn't have been looking at notice triggers.
16:53 oleonard Why is disabling CircAutocompl part of the test plan for Bug 16429?
16:53 huginn Bug[…]_bug.cgi?id=16429 minor, P5 - low, ---, kyle, Pushed to Master , Going to circulation from notice triggers may change logged in branch
16:53 TGoat left #koha
16:53 TGoat joined #koha
16:55 kidclamp I think the code is different and you won't get it with auto complete
16:55 kidclamp the templates switch on it
16:58 chris_n joined #koha
17:00 oleonard kidclamp: Just FYI, the librarian reported that she logged in by setting a specific branch rather than leaving it at "my library." Then later the library setting changed to her home library.
17:00 oleonard I'm trying to find out more.
17:02 Karl_H joined #koha
17:12 talljoy joined #koha
17:17 talljoy1 joined #koha
17:57 oleonard Strange that the borrowerRelationship preference affects nothing besides the patron entry form. We save the guarantor relationship data but never display it anywhere.
18:19 aleisha joined #koha
18:24 oleonard Hi aleisha
18:24 aleisha hi oleonard
18:29 huginn New commit(s) kohagit: Bug 16315 - OPAC Shelfbrowser doesn't display the full title <[…]68681dcdec9f417e1> / Bug 16411: Make Hold.t not depend on two existing branches <[…]91df05880a663eb82>
18:30 geek_cl joined #koha
18:37 oleonard Why am I writing another patch for Haven't I learned anything?
18:39 huginn New commit(s) kohagit: Bug 16415 - Layout problem on staff client detail page if local cover images are... <[…]0d1898ea0147e3ab5> / Bug 15194 - Drop-down menu 'Actions' has problem in 'Saved reports' page with languag... <[…]74e440416d66140b4>
18:40 kidclamp oh, that reminds me oleonard, should I cleanup your follow up to the patron quicka dd?
18:42 oleonard Sorry kidclamp I've been distracted by other bugs. I didn't mean to foist that work onto you, but I don't object if you want to.
18:42 kidclamp whoever gets there first then :-)
18:42 kidclamp and no foisting, you were improving my sloppiness :D
18:43 blou joined #koha
18:43 francharb joined #koha
18:44 oleonard (one of 17 pending patches which affect!)
18:45 cdickinson_ joined #koha
18:57 oleonard Bye everyone. Send more patches for if you can. Can't have too many.
19:02 paul_p joined #koha
19:24 * cait1 sends oleonard cookies
19:29 huginn New commit(s) kohagit: Bug 16159 - guarantor section missing ID on patron add form <[…]3b22a953e3feca1e6>
19:30 nengard left #koha
19:46 kchris joined #koha
19:57 drab hi there, still trying to figure out what may be going on with this opac rejecting logins
19:57 drab I found that problem with mysql 5.7 yesterday on ubuntu and that fixed my patron categories issue, but still can't login with opac
19:57 drab sco and library-intra work just fine
19:58 drab but opac login fails for all but my user (and maybe another one I hven't found yet, but all the ones I tried don't work)
19:58 drab even after a password reset, still cannot login. users were able to login just fine on the previous installation (3.22.2). probably began after restore on a new box on 3.22.6
19:59 huginn New commit(s) kohagit: Bug 16439: Allow styling to button for upload local cover images (Font Awesome Icons) <[…]40a676dfdfa1875f4> / Bug 16445: Revert changes made by bug 12478 to Koha/ <[…]b3aa773f43fe84738> / Bug 16438: (followup) remove item where no single icon exis
20:07 cait1 drab: even a new user can#t log in?
20:08 cait1 are you using hte password and cardnumber/userid stored in Koha?
20:13 drab cait1: cardnumber? I'm login with userid/password if that's what you mean
20:13 cait1 both work
20:14 cait1 cardnumber + password and userid + password
20:14 cait1 well should work
20:14 drab I will try to add a new user, I haven't mostly because mine was already existing as the other Staff users were
20:14 drab I can't tell the difference between my user and say George, who's the guy primarily working in the library
20:15 drab even inside the database in the borrowers table they look exactly the same to me
20:15 drab but I'll try adding a user, sec
20:16 drab cait1: also note that the user that can't login to the opac, can login just fine to for self checkout and to the -intra
20:16 drab it's just opac that doesn't work
20:16 cait1 hm
20:16 cait1 it could be intentional
20:16 drab so user details must be correct, or at least I'd guess so
20:16 cait1 your self check permission user
20:16 cait1 is not supposed to log into the opac normally
20:17 cait1 you are supposed to use a dedicated staff user account for the web based self check in the opac
20:17 cait1 try to remove that permission from george
20:21 drab mmmh, it used to work that way tho, but I'll try that too
20:22 drab tryiung a new patron too now
20:23 drab urm, ok
20:23 drab newly created patron can login into opac
20:26 drab cait1: looks like you were right. I took george out of sco and he can now login on opac
20:26 drab I put in the sco the new user I just created that I logged into opac with for testing, and now it can't login anymore
20:26 cait1 the sco perm is new
20:26 cait1 it's to secure the feature a bit better
20:27 drab it seems tho it should say something somewhere
20:27 drab like maybe in the preference pane where you set it
20:27 drab "use a dedicated user that you don't login with", or something
20:27 cait1 i think the manual does maybe
20:28 cait1 that's not new... just the perm is
20:28 burdsjm joined #koha
20:28 cait1 but if you want you can file a bug for documentation or changing the perm description :)
20:28 drab :)
20:31 drab cait1: since you're so good hopefully you can enlighten me on this other issue too... it seems that we can't search library of congress or anything like that anymore
20:31 drab I think that's to do with zebra, but have never looked into that part
20:31 drab actually, nm, I hate it when ppl do that to me, lemme try to google something before :)
20:31 drab and if I can't figure it out I'll ask the channel again, bbl
20:33 Karl_H drab- could be a firewall issue, maybe Z39.50 port not open?
20:34 cait1 sorry, i stepped away
20:35 cait1 what Karl_H is the most likely issue
20:35 cait1 z39.50 uses some weird ports that sometimes are blocked
20:35 cait1 drab 1
20:35 drab it used to work tho, they could do it on the old instance
20:35 drab and fws haven't changed since then
20:36 drab so likely something with the new box or stuff I messed up in the restore
20:37 cait do you gt an error message on searching?
20:45 drab cait: nope, just nothing is found, searching for a title that should definitely be in the LOC, but returns no results
20:45 rocio_away left #koha
20:46 cait if you can share a screenshot of your z39.50 config we can compare that to one that works
20:46 cait hm or wait
20:48 cait that's my config
20:49 huginn New commit(s) kohagit: Bug 16325: Do not return all suggestions if search for STATUS='' <[…]f5497f67f58fd5baf> / Bug 16325: Add a test for SearchSuggestions when searching for STATUS='' <[…]4f62c56ac085703f5> / Bug 16452: Remove the warnings raised by PatronLists.t <http://git.koha
20:58 Francesca joined #koha
20:58 drab cait: yeah settings are the same
20:58 cait check the firewall
20:59 drab also nothing in the zebra logs that looks suspicious to me
20:59 cait hm another thing sometimes - check for spaces in the settings - they don't show but can cause a problem
20:59 drab nope, no spaces
21:05 drab is it possible tosearch LOC or something from yaz-client?
21:05 drab I found that while trying some deubgging, but unclear if that's about searching external dbs or just your own
21:10 wizzyrea hi
21:11 Francesca hey
21:29 huginn New commit(s) kohagit: Bug 16447: Remove occurrence of the borrow permission which does no longer exist <[…]d225b9093dc6e316a> / Bug 16448: Fix perlcritic errors introduced by 12478 <[…]1bf7e1fe7496a6714>
21:30 geek_cl Hi guys o/ , how to NOT display an item in the opac, when the item have damaged=1 and notforloan=1 ?
21:32 wizzyrea there's a syspref for damaged
21:32 wizzyrea I don't think there is one for notforloan, but you probably could use opachiddenitems
21:33 drab hello wizzyrea
21:34 geek_cl yeah i see that OpacHiddenItems
21:34 geek_cl OpacHiddenItems where are the values allowed for that ?
21:35 geek_cl can i use barcode: [1234567890] ?
21:37 cait geek_cl: there is some doc with examples on the wiki
21:38 cait geek_cl: i wouldn't use a barcode, i'd use an authorized value of some kind
21:38 cait damaged, notforloan, itemtype or something like that
21:38 geek_cl cait, yeah i create a auth value for that
21:38 geek_cl yes, notforloan = 1 , auth value NOT_LOAN
21:38 drab yeah, no I still can't find anything in LOC from cgi-bin/koha/cataloguing/
21:38 drab whatever I search for says nothing found
21:39 drab settings are ok and I don't see anything outgoing blockde on that port on the firewall (and it worked fine on the previous server)
21:39 drab so pretty sure it's something I'm missing with my settings somewhere
21:40 cait there is not much to the settings there
21:40 geek_cl cait, i see the example, now i got it ;)
21:40 drab You searched for: Raw (any): love <-- nothing found :(
21:40 drab no love indeed
21:40 cait try title instead
21:41 cait not all targets support raw i think
21:41 drab yeah, tried that too, will try again, it was only on one target earlier
21:42 drab cait: nope, still no love
21:42 cait my bet is still on firewall
21:43 drab urm, k, will go look at that again
21:43 cait ifit worked with the same settings on the old server
21:49 drab nope, nothing shows up on the firewall and I can see the traffic going out and back in from
21:49 drab so stuff seems to be flowing
21:49 wizzyrea are you in the wrong record type?
21:49 drab weird thing tho, tcpdump says loc is sending from port 50...
21:49 drab even tho setting says port 210
21:49 wizzyrea unimarc vs marc21
21:50 drab wizzyrea: how do you mean? I'm just the tech guy :( , lib guy not here right now
21:50 drab I clicked on cataglogueing, added something to et a screen that add the search z39.50 button
21:50 wizzyrea I mean in the z-target configuration screen
21:51 drab oh
21:51 drab I have marc21/usmark there
21:52 drab and nm about tcpdump, it's converting port numbers and showing z39.50, not port 50, traffic is correctly on 210
21:52 drab so nothing seems blocked
21:53 wizzyrea < is this the IP you are getting for
21:54 drab yes, that's the one
21:56 drab ok there's no question stuff is coming back
21:56 drab I changed my tcpdump to capture full packets and looked into it
21:56 drab there's definitely results there
21:56 drab I can see many books for the title love
21:59 drab so it gets the data back and somehow decides it's no good, I'm not sure, but it must be a decision it makes on the koha side, maybe because of some setting, no idea
21:59 geek_cl cait, wizzyrea:  work good, thanks you very much !
22:02 drab am I searching in the wrong place maybe? does it matter from where I'm opening that script?
22:02 dz512 joined #koha
22:17 reza joined #koha
22:22 NateC joined #koha
22:22 JoshB joined #koha
22:26 aleisha joined #koha
23:05 reza joined #koha
23:09 sjenson joined #koha
23:10 sterling joined #koha
23:25 kathryn joined #koha
23:36 amyk-away joined #koha
23:49 Francesca joined #koha
23:58 papa joined #koha

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