Time Nick Message
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 sco.pl 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] opac-user.pl: CGI::param called in list context from /usr/share/koha/opac/cgi-bin/opac/opac-user.pl 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/CGI.pm line 405.: /usr/share/koha/opac/cgi-bin/opac/opac-user.pl
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 sco.pl 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.org/wiki/Category: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: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 opac.pl
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: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 memberentry.pl: 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/memberentry.pl,
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 http://www.anujgakhar.com/2015/12/23/mysql-error-caused-by-sql_modeonly_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:35 drab https://perldoc.koha-community.org/C4/Debug.html
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: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?
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
10:24 huginn New commit(s) kohagit: Bug 16429 - Fix root problem <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=640b9585f82ff898bebcebd01efab81bca311588> / Bug 16429 - Going to circulation from notice triggers may change logged in branch <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=56f65a9d0af39059d516a058350674bee997cb6d>
11:40 oleonard Hi #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: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: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 127.0.0.1 pasted "Joubu: this" (75 lines) at http://paste.koha-community.org/438
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 04Bug http://bugs.koha-community.org/bugzilla3/show_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 04Bug http://bugs.koha-community.org/bugzilla3/show_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 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:16 * oleonard wonders why a change in the DOM would cause a form.submit() to fail
13:16 tcohen done
13:36 oleonard Can you really use automatic item modification by age to update items.itemnumber? biblioitems.marcxml?
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:20 * oleonard rediscovers Bug 7223
14:20 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_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:31 * Oak waves
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: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 http://wiki.koha-community.org/wiki/SQL_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 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: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: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: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 updatedatabase.pl 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...
16:15 Joubu opened bug 16455 (for the record)
16:15 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_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 04Bug http://bugs.koha-community.org/bugzilla3/show_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 04Bug http://bugs.koha-community.org/bugzilla3/show_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 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16429 minor, P5 - low, ---, kyle, Pushed to Master , Going to circulation from notice triggers may change logged in branch
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
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: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: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 <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=67f91f24e537ef93d0c121b68681dcdec9f417e1> / Bug 16411: Make Hold.t not depend on two existing branches <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=aec623576235e8a8253ee8691df05880a663eb82>
18:37 oleonard Why am I writing another patch for memberentrygen.tt? 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... <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=31a0691a112b48f7462dc210d1898ea0147e3ab5> / Bug 15194 - Drop-down menu 'Actions' has problem in 'Saved reports' page with languag... <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=de98a936751efc00d893f6e74e440416d66140b4>
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:44 oleonard (one of 17 pending patches which affect memberentrygen.tt!)
18:57 oleonard Bye everyone. Send more patches for memberentrygen.tt if you can. Can't have too many.
19:24 * cait1 sends oleonard cookies
19:29 huginn New commit(s) kohagit: Bug 16159 - guarantor section missing ID on patron add form <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=553d06073b8af0ab6ed33393b22a953e3feca1e6>
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) <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=6003c6b320a4fec0be37b4940a676dfdfa1875f4> / Bug 16445: Revert changes made by bug 12478 to Koha/Database.pm <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=9b154f8bc086cec3984d3f6b3aa773f43fe84738> / 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 sco.pl 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 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: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 [off] http://librarygeekgirl.de/pics/pic_828b40.png
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='' <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=44e0cb2895f5e9fbf541603f5497f67f58fd5baf> / Bug 16325: Add a test for SearchSuggestions when searching for STATUS='' <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=cb912decef4ffa56c93920e4f62c56ac085703f5> / Bug 16452: Remove the warnings raised by PatronLists.t <http://git.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 <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=c4eabeda0b1ca6b856483b3d225b9093dc6e316a> / Bug 16448: Fix perlcritic errors introduced by 12478 <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=f4936b57632bf6306dbc09c1bf7e1fe7496a6714>
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/z3950_search.pl
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 lx2.loc.gov
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 140.147.55.32 < is this the IP you are getting for lx2.loc.gov?
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 z3950.pl script?