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?