Time Nick Message 01:21 alohabot 🎠🦠Koha '21.05.x' packages pushed to 'koha-staging' repo 🥒ðŸ‡ðŸ² 01:38 koha-jenkins Project Koha_21.05_U20 build #201: SUCCESS in 39 min: https://jenkins.koha-community.org/job/Koha_21.05_U20/201/ 01:38 mkun hi! i'm getting "Zebra error 10004" and i can't find anything about it. any ideas how to troubleshoot or where i can find the log? 01:52 koha-jenkins Project Koha_21.05_D10 build #276: UNSTABLE in 53 min: https://jenkins.koha-community.org/job/Koha_21.05_D10/276/ 01:57 koha-jenkins Project Koha_21.05_D12 build #127: SUCCESS in 55 min: https://jenkins.koha-community.org/job/Koha_21.05_D12/127/ 01:59 wajasu mkun: maybe /var/log/koha/<kohadb> 02:05 wajasu whilst progressing with my updatedatabase.pl from 3.10 but since i am running latest mariadb, a database ALTER suggestions choked with default 0000-00-00 value. 02:06 wajasu wonders if the codebase has been switched to NULL/undef by now so I can switch default to NULL. 02:08 wajasu i'll look at the initial database sql 02:08 koha-jenkins Project Koha_21.05_U16 build #200: STILL UNSTABLE in 1 hr 8 min: https://jenkins.koha-community.org/job/Koha_21.05_U16/200/ 02:12 koha-jenkins Project Koha_21.05_U18 build #190: SUCCESS in 37 min: https://jenkins.koha-community.org/job/Koha_21.05_U18/190/ 02:19 koha-jenkins Project Koha_21.05_D9 build #196: SUCCESS in 41 min: https://jenkins.koha-community.org/job/Koha_21.05_D9/196/ 02:26 mkun resolved the zebra error. wrong password in the koha-conf.xml for zebradb. thank you 02:47 tuxayo wajasu: would MariaDB 10.1 still choke on that? 02:47 tuxayo It's easy to get 10.1 02:47 tuxayo with ktd 02:55 koha-jenkins Yippee, build fixed! 02:55 koha-jenkins Project Koha_21.05_D11 build #228: FIXED in 58 min: https://jenkins.koha-community.org/job/Koha_21.05_D11/228/ 02:55 wahanui Congratulations! 03:03 wajasu i'm finding lots of missing fields, tables, 0000-00-00 and such as far back as 3.01, though I run at systempreferences.variable='Version' => 3.100200 03:04 wajasu i am thinking of just getting the updatedatabase.pl to make it to 20.05. 03:05 wajasu then possible export the biblios, authorities, patrons to mrc files. create a new 20.5 system and import the marc records. 03:07 wajasu tommorow, i'll work through this investigation. 03:11 mtj hi wajasu, 20.05 is not supported now - perhaps try 21.05/oldoldstable 03:11 wajasu ok. 03:13 davidnind[m] there was also a DBMS auto increment issue when upgrading at some stage in the process - I don't really know anything about it, except I think it was "painful" https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix 03:13 koha-jenkins Project Koha_21.11_D10 build #115: STILL UNSTABLE in 35 min: https://jenkins.koha-community.org/job/Koha_21.11_D10/115/ 03:14 wajasu i see that many database changes didnt happen way back before 3.10, so I have multiple issues. i might do this investigation with mysql8 or set looser rules that i saw somewhere. i have multiple issues. 03:14 wajasu thank goodnes that i can stand up the ktd and start fresh. 03:14 mtj @later tell liliputech: can you push up a v21.11.09 tag, merci 03:14 huginn mtj: The operation succeeded. 03:16 wajasu has anyone ever exported there biblios, authorities, patrons into external files and import them into a new latter version. 03:16 wajasu there/their 03:17 wajasu i have 30000 biblios 03:17 davidnind[m] I think I've seen it recommended if you don't mind loosing the history for circulation and things like that 03:19 wajasu i may not need circulation info. its a small college. student out for summer. will talk to the librarian. 03:21 koha-jenkins Yippee, build fixed! 03:21 koha-jenkins Project Koha_21.05_D10 build #277: FIXED in 53 min: https://jenkins.koha-community.org/job/Koha_21.05_D10/277/ 03:21 wahanui Congratulations! 03:22 koha-jenkins Project Koha_21.11_D12 build #90: STILL UNSTABLE in 44 min: https://jenkins.koha-community.org/job/Koha_21.11_D12/90/ 03:32 mkun hi! after updating the opac site shows me the site title 3x and the message under home also 3x. is that a known bug? 03:36 davidnind[m] Have you cleared the browser cache, on the server side ran flush_memcached and restart_all (depending on how you installed Koha). Also, do you have any UserJS and HTML customisations? I haven't seen something like this on the mailing list lately... 03:46 mkun yes i did that, also tried different brwoser/device. no html customizations. not user how to check userjs 03:52 koha-jenkins Project Koha_21.11_U18 build #107: STILL UNSTABLE in 38 min: https://jenkins.koha-community.org/job/Koha_21.11_U18/107/ 03:55 koha-jenkins Project Koha_21.11_D9 build #97: STILL UNSTABLE in 1 hr 16 min: https://jenkins.koha-community.org/job/Koha_21.11_D9/97/ 04:02 koha-jenkins Project Koha_21.11_D11 build #128: STILL UNSTABLE in 1 hr 6 min: https://jenkins.koha-community.org/job/Koha_21.11_D11/128/ 04:06 koha-jenkins Project Koha_21.11_U22 build #35: STILL UNSTABLE in 43 min: https://jenkins.koha-community.org/job/Koha_21.11_U22/35/ 04:19 koha-jenkins Project Koha_21.11_U20 build #100: STILL UNSTABLE in 58 min: https://jenkins.koha-community.org/job/Koha_21.11_U20/100/ 04:34 koha-jenkins Project Koha_22.05_U18 build #24: STILL UNSTABLE in 41 min: https://jenkins.koha-community.org/job/Koha_22.05_U18/24/ 05:12 koha-jenkins Project Koha_22.05_D11 build #27: STILL UNSTABLE in 1 hr 9 min: https://jenkins.koha-community.org/job/Koha_22.05_D11/27/ 06:20 davidnind[m] mkun: check system preference OPACUserJS, OPACUserCSS, and Tools > Additional tools > HTML customizations 06:20 davidnind[m] also, maybe mention the version you are now on and upgraded from 06:21 davidnind[m] someone else may have a better idea than me on what to look for/how to troubleshoot 06:44 mkun Found the issue. After the upgrade it has added three 'opacheader' items and 3 'mainuserblock' items. They can be individually deleted 06:46 davidnind[m] excellent! 06:46 wahanui darn tootin' it is. 07:47 cait good morning #koha 07:56 ashimema Morning 08:11 alohabot 🎠🨠Koha '22.05.x' packages pushed to 'koha' repo 🥇ðŸŒðŸš€ 08:12 magnuse \o/ 08:12 magnuse mtj++ 09:19 mtj oops, false alarm magnuse 09:19 * mtj fixes his script 09:19 magnuse no new package pushed? 09:23 FlorianB hello Koha! 09:24 mtj hi FlorianB 09:25 FlorianB Say, would anyone know where does the "CAN_user_borrowers_edit_borrowers" boolean come from? Trying to fiddle with the headers and it features everywhere but i can't find its source or what it's used for 09:27 mtj magnuse: no, only pushed to a local repo... i still manually run rsync to update the kc.org repo, just in case of some automated mistake 09:27 cait CAN is always a permission 09:27 cait or more CAN_user.... 09:27 cait it's borrowers module, sub permission edit_borrowers 09:27 cait FlorianB: 09:35 FlorianB Ah, found it, thank you 09:35 FlorianB cait: 09:40 cait np 10:03 FlorianB Curious, it seems the members pages use a different 'patron-search' header compared to the other pages. 10:23 oleonard FlorianB: Various pages have different combinations of search tabs depending on the page's purpose 10:54 tcohen hola #koha 11:03 oleonard Hi tcohen 11:06 alohabot 🎠🻠Koha '21.11.x' packages pushed to 'koha' repo 🥈🌎🚀 11:21 oleonard When an item is deleted does the itemnumber field in old_issues get set to NULL ? 11:26 oleonard Oh of course, because the flange on the flexonitor pops the chassis up and ejects the particulate 11:32 ashimema bug 30677 11:32 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30677 critical, P5 - low, ---, nugged, Failed QA , Unknown column 'biblioitem.title' in 'where clause' 500 error in API /api/v1/acquisitions/orders 11:32 tcohen why is it failed? marcelr? 11:32 ashimema can someone QA it please.. kinda silly that a critical has been held up with style 11:33 ashimema I added a follow-up today to fix the style 11:33 ashimema tests all still pass 11:33 ashimema and make sense 11:33 ashimema which to me means it's solid now 11:33 tcohen please mark it SO and I'll QA it 11:33 ashimema thanks dude 11:37 marcelr o/ 11:41 marcelr bug 31055 for anyone wishing to join the discussion about koha-functions.sh 11:41 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31055 enhancement, P5 - low, ---, koha-bugs, Needs Signoff , Move koha-functions to /usr/sbin instead of koha/bin 11:42 magnuse huh, trying to test ill with ktd, i get "Can't locate Koha/Illbackends/Libris/Base.pm in @INC" and right enough, the path set in backend_directory in koha-con.xml is missing from @INC. how to fix that? 11:42 tcohen magnuse: have you restarted memcached? 11:43 magnuse i thought i had... 11:43 tcohen because koha-conf.xml is cached 11:43 tcohen memcached + plack 11:43 tcohen you should run restart_all 11:44 magnuse yeah, did that now, but it didn't help 11:44 magnuse also restarted memcached explicitly 11:45 tcohen and what is the path you're using? 11:45 tcohen I usually set 11:45 magnuse here: /kohadevbox/koha/Koha/Illbackends 11:45 tcohen PLUGIN_REPO=/home/tcohen/git/koha-plugins 11:46 tcohen then use ktd --plugin up -d 11:47 tcohen and then point koha-conf.xml to /kohadevbox/koha_plugin/my-plugin/Koha/Illbackends 11:47 tcohen is it master? 11:49 ashimema marcelr++ 11:51 magnuse tcohen: do you mean ktd master? 11:52 tcohen Koha's 11:53 magnuse no, trying to get 21.11 up and running 11:53 tcohen what Koha (and its corresponding KTD images) version 11:53 magnuse um, how do i check? 11:53 magnuse (the ktd stuff) 11:55 tcohen docker ps on hte host? 11:55 tcohen just trying to understand the context, really 11:56 tcohen I assume you're working on master 11:56 tcohen and as I work on ILL, on master with no issues, trying to find the differences 12:02 marcelr who would be willing to test bug 30933 (not too hard, lists stuff) 12:03 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30933 enhancement, P5 - low, ---, m.de.rooy, Needs Signoff , Add a designated owner for shared and public lists at patron deletion 12:03 ashimema ooh, that one was already on my list 12:03 pastebot "magnuse" at 127.0.0.1 pasted "docker ps" (6 lines) at https://paste.koha-community.org/10437 12:03 marcelr cool ashimema 12:03 magnuse tcohen: ^ 12:04 marcelr magnuse: cert problems.. 12:04 ashimema i was about to dig back in to bug 29523 to remind myself where it got to 12:04 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29523 major, P5 - low, ---, tomascohen, ASSIGNED , Add a way to prevent embedding objects that should not be allowed 12:04 ashimema but I can have a quick look at yours first 12:04 marcelr great 12:42 huginn News from kohagit: Bug 30677: Cleanup <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=667722daa34ce6acaf47f2bd94434260dcc76d48> 12:42 huginn News from kohagit: Bug 31058: Fix import AutoUnsuspendHolds <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=6c315c164dbcf3e05fcfe4a3110b824ab3ac162c> 12:42 huginn News from kohagit: Bug 30939: Fix use statement for DelAuthority <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=df393b38b8102b4d304b79cb2ba2e73caf8187bd> 12:42 huginn News from kohagit: Bug 30677: Use lookahead in regex for biblioitem replacement <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=be3bd8af8b1f2dbff33d2228eb64fa77fe9362f7> 12:42 huginn News from kohagit: Bug 30677: Add tests <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=de4fcc91f02e7d8da645388c7287ed942fa4bae8> 12:44 Joubu tcohen, ashimema: re bug 28911, and the encryption_key question from Sat 25th on the ML - how do we update the xml config when upgrading using debian packages? 12:44 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28911 normal, P5 - low, ---, koha-bugs, NEW , Bcrypt settings are required for pseudonymization but are not set on upgrade 12:47 tcohen Joubu: we cannot 12:47 tcohen let's add a script that spits an encryption key? 12:50 Joubu no way to automate it? 12:51 tcohen the only config file we dared to touch in koha-common.postinst is log4perl.conf 12:52 simon_ hi! 12:52 tcohen maybe time for a base config we can patch and just keep koha-conf.xml as an override? 12:53 simon_ our koha server suddenly displays high memory usage by a single process: (..)/intranet/cgi-bin/catalogue/itemsearch.pl 12:53 simon_ any idea what could trigger this behaviour? 12:53 simon_ ~12gb memory 12:55 Joubu simon_: see "all" of a huge item search? 12:55 mtj hi magnuse, i think your problem is that you need to switch to 21.11 branch in ktd, to test 21.11 codebase 12:56 magnuse mtj: i am seeing the same problem when i run koha master and straight "ku" 12:56 magnuse ...with an updated ktd 12:56 Joubu tcohen: is the upgrade adding new entries to koha-conf? I think so but cannot remember if it's correct 12:57 tcohen we don't as far as I can tell 12:57 tcohen you mean a packages upgrade? 12:58 marcelr I thought it did not 12:58 magnuse i have never seen an upgrade add to/change koha-conf.xml, as far as i know 12:59 mtj agreed ^ 12:59 marcelr Joubu you should have a safe way to insert secrets into koha-conf 13:00 tcohen lets' add a config.yaml file, that we can patch on upgrade and users are advised not to tweak because it will get overwritten 13:00 tcohen and make C4::Context->config 13:00 mtj simon_: what koha and os version? 13:00 tcohen load it, and merge koha-conf.xml on top of it 13:00 tcohen what do you think? 13:01 marcelr surely you could patch a .xml file too :) 13:01 magnuse @quote get 123 ;-) 13:01 huginn magnuse: (quote get [<channel>] <id>) -- Gets the quote with id <id> from the quote database for <channel>. <channel> is only necessary if the message isn't sent in the channel itself. 13:01 magnuse @quote get 123 13:01 huginn magnuse: Quote #123: "rangi: #thingsihavelearnt if there is a mad scheme a library somewhere will be doing it ... except madder" (added by wizzyrea at 09:20 PM, March 30, 2011) 13:01 wahanui i already had it that way, huginn. 13:01 mtj magnuse: whats the process for testing ILL?, i have not done any... 13:02 tcohen marcelr: yes, but it sounds risky to me 13:03 marcelr yeah could be 13:03 mtj magnuse: is only ILL broken? - or all of koha? 13:04 simon_ @Joubu how do i see "all"? :D 13:04 huginn simon_: I'll give you the answer just as soon as RDA is ready 13:04 wahanui i already had it that way, huginn. 13:05 simon_ @mtj: 21.11.06.000 / Apache/2.4.53 (Debian) 13:05 huginn simon_: I'll give you the answer just as soon as RDA is ready 13:05 wahanui i already had it that way, huginn. 13:06 mtj magnuse: do the ILL tests pass on your ktd?.. they are on jenkins 13:09 Joubu simon_: have a lot of items in your DB, go to /cgi-bin/koha/catalogue/itemsearch.pl, search for a generic term that will return a lot of result, "a" for instance. Select 'All' in "Show x entries" at the top of the table => BOOM 13:09 Joubu (don't do it) 13:10 simon_ let's crash the test system ;) 13:10 Joubu do it if you are using a test system! :D 13:10 Joubu have a kill command ready :) 13:14 simon_ i dont have a show x entries option it seems 13:18 magnuse mtj: tcohen is helping me figure it out 13:19 Shane-S I added a cover image to a mark record, but added items don't have cover images. Is there a setting to use the Cover Image for all items? 13:20 alohabot 🎠🦄 Koha 'master' packages pushed to 'koha-staging' repo 🥖🥨🩠13:20 Shane-S I say mark record..but maybe biblio is more accurate 13:21 magnuse Shane-S: cover images are connected to marc records/biblios, not to items. do you not see the cover image at all? 13:22 Shane-S I do see it in Intranet above the items, and for 1 record I manually added the same cover and that shows in the table of items 13:23 Joubu simon_: https://snipboard.io/dUmB2e.jpg 13:23 Joubu "Show <20> entries" 13:23 Shane-S subsequent items do not have it, just wanted to make sure they will on catalog search side 13:24 Shane-S err not side, but for staff, they are electronic devices, so I want a visual image for staff to make sure they match the picture 13:25 Shane-S I should have screen shot before I got on chat...have to use hotspot as IRC is blocked internally :( 13:25 Joubu Shane-S: which version of Koha? 13:25 wahanui which version of Koha are you using? How did you install 13:25 Joubu yes please, a screenshot 13:26 Shane-S Whatever the current packages are, I just built it from them last night. 13:26 Joubu There was a bug recently about cover images attached on items: bug 30234 13:26 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30234 major, P5 - low, ---, jonathan.druart+koha, Pushed to stable , Serial local covers don't appear in the staff interface for other libraries with SeparateHoldings 13:26 Shane-S okay I will have to disconnect and be back. 13:26 koha-jenkins Project Koha_Master_D9 build #2030: SUCCESS in 42 min: https://jenkins.koha-community.org/job/Koha_Master_D9/2030/ 13:27 koha-jenkins Project Koha_Master_D11_My8 build #889: SUCCESS in 44 min: https://jenkins.koha-community.org/job/Koha_Master_D11_My8/889/ 13:29 cait magnuse: can you still add quotes? 13:30 cait https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30196#c10 Joubu: I stopped being afraid of Koha code, I sleep better now :D 13:30 huginn Bug 30196: enhancement, P5 - low, ---, philippe.blouin, Failed QA , Odd number of elements warning caused by dt_from_string 13:31 magnuse @quote add Joubu: I stopped being afraid of Koha code, I sleep better now :D 13:31 huginn magnuse: Error: You must be registered to use this command. If you are already registered, you must either identify (using the identify command) or add a hostmask matching your current hostmask (using the "hostmask add" command). 13:31 magnuse @quote add Joubu: I stopped being afraid of Koha code, I sleep better now :D 13:31 huginn magnuse: Error: You must be registered to use this command. If you are already registered, you must either identify (using the identify command) or add a hostmask matching your current hostmask (using the "hostmask add" command). 13:32 Shane-S Okay back...so I have a cover image...just the table has a spot and it is empty (all Intranet / Staff side) : https://snipboard.io/bpweY5.jpg 13:33 Shane-S The place I was expecting an image was the search: https://snipboard.io/hTBOp6.jpg 13:34 wajasu painstakingly updatedatabase.pl from 3.10. Now at 17.12 13:35 oleonard Shane-S: Cover images don't show up in the cataloging search results, just in regular catalog search results. 13:35 wajasu painstakingly applying updatedatabase.pl from 3.10. Now at 17.12 13:35 oleonard Shane-S: (I guess that's just because no one has ever asked for them there?) 13:36 Joubu I didn't get the question, thanks oleonard for jumping in! 13:37 oleonard wajasu: We're all rootin' for ya 13:37 Shane-S Okay, well at least when they click it they can see it...was just looking for more visual aids for my technicians 13:38 Shane-S Moving away from Snipe-IT, lovely system...but not so good when I need to check in 400+ devices in 2 days...a lot of clicking compared to a barcode scan 13:40 magnuse @quote add Joubu: I stopped being afraid of Koha code, I sleep better now :D 13:40 huginn magnuse: Error: You must be registered to use this command. If you are already registered, you must either identify (using the identify command) or add a hostmask matching your current hostmask (using the "hostmask add" command). 13:40 magnuse i give up 13:43 Shane-S Thank you all for the help. Perhaps I will have to feature request that be a setting to enable for cataloging. 13:43 magnuse tcohen++ 13:43 koha-jenkins Project Koha_Master build #2082: STILL UNSTABLE in 44 min: https://jenkins.koha-community.org/job/Koha_Master/2082/ 13:47 koha-jenkins Project Koha_Master_U22 build #112: SUCCESS in 1 hr 5 min: https://jenkins.koha-community.org/job/Koha_Master_U22/112/ 14:05 cait I got a question about Koha and MySQL 5.8 - are we not supporting MySQL anymore officially? https://wiki.koha-community.org/wiki/System_requirements_and_recommendations 14:05 koha-jenkins Project Koha_Master_U20 build #460: SUCCESS in 38 min: https://jenkins.koha-community.org/job/Koha_Master_U20/460/ 14:05 cait like... at all? 14:11 koha-jenkins Project Koha_Master_D11_MDB_Latest build #978: SUCCESS in 43 min: https://jenkins.koha-community.org/job/Koha_Master_D11_MDB_Latest/978/ 14:12 mtj magnuse: cait, you need to msg huginn, with 'identify magnuse YourPassword' 14:14 mtj @quote get 355 14:14 huginn mtj: Quote #355: "Joubu: I stopped being afraid of Koha code, I sleep better now :D" (added by mtj at 02:10 PM, June 28, 2022) 14:18 wajasu is deletedborrowers a duplicate holding table for borrowers? i want to update the debarred field from 0000-00-00 to NULL for those entries in deletedborrowers so my updatedatabase.pl will continue. acceptable? 14:20 cait thx mtj :) 14:20 mtj cait: re mysql-5... we are not testing it with jenkins, just mysql-8 14:20 cait wajasu: don't use 0000-00-00 14:20 cait it's an invalid date 14:21 cait set to NULL 14:21 wajasu ok. cleaning it up. 14:21 cait oh, I misread... yes I guess that makes sense then :) 14:21 oleonard-away wajasu: And deletedborrowers is a duplicate of borrowers but for... deleted borrowers. 14:21 mtj cait: im not sure that its been dropped 'offically', but we are not testing with it 14:22 cait yeah I think I have not seen any official note 14:22 mtj mysql5 has been dropped from debian9/stretch, but is in ubuntu 18.04-lts 14:24 cait ah, that explains 14:31 mtj cait: i think it would be interesting to add mysql5 back, to see if anything explodes (at least) 14:35 cait if we support the Ubuntu LTS it would make sense 14:35 cait we usually recommended to stick with whatever dbms version/system the OS ships with 14:37 mtj yuss agree 14:37 mtj tcohen: a good idea? ^ 14:38 tcohen I'm not sure. It is EOL and also has the AUTOINCREMENT issue 14:38 tcohen maybe we can add it 14:39 tcohen but we could add anything too 14:39 marcelr so nice these sql differences ;) was just struggling with regexp difference between mysql and mariadb ouch 14:42 mtj aah yes, AUTOINCREMENT stuff... 14:42 mtj https://packages.ubuntu.com/bionic/mysql-server 14:43 koha-jenkins Yippee, build fixed! 14:43 koha-jenkins Project Koha_Master_D10 build #702: FIXED in 38 min: https://jenkins.koha-community.org/job/Koha_Master_D10/702/ 14:43 wahanui Congratulations! 14:43 mtj mysql5 had AUTOINCREMENT problems when restarted, is that correct? 14:44 tcohen it doesn't persist the AUTOINCREMENT 14:44 tcohen gets recalculated 14:45 tcohen and MariaDB fixed it in 10.2.4 or so 14:45 tcohen https://mariadb.com/kb/en/mariadb-1024-release-notes/#:~:text=MariaDB%2010.2%20is%20the%20current,Release%20Candidate%20(RC)%20release. 14:45 tcohen so anything below that, needs hacks to work properly 14:46 mtj ah yep.. https://github.com/KohaAloha/koha-mysql-init 14:46 tcohen \o/ 14:46 mtj does mysql-8 still have the auto_incr problem? 14:47 tcohen https://dev.mysql.com/worklog/task/?id=6204 14:47 mtj gosh, that was a stupid bug 14:48 mtj Fixed in 8.0.0 by WL#6204. 14:48 wajasu ok. made it through 17.05. whoops. made it through 22.0600008. 14:48 tcohen \o/ 14:49 tcohen you went too far LOL 14:49 mtj wajasu++ :p 14:49 mtj folks, lets not recommend mysql-5 :) 14:49 wajasu yes. but better be here then where i was. missing tables, bad dates. 14:49 wajasu now i'm going to dump the mysql database for backup. 14:50 tcohen this is a testing instance, right 14:50 tcohen ¡? 14:50 wajasu then startup the memcached-1 and try hitting the web interface 14:50 wajasu yes testing instance 14:52 wajasu i'm using it to migrate from 3.10 forward. i lost the server that was running for many years. but had backups to a second drive for the database. 14:52 tcohen so you're saving the queries you're running to fix things 14:53 wajasu let me check my mysql history. 14:53 koha-jenkins Project Koha_Master_D12 build #185: SUCCESS in 1 hr 5 min: https://jenkins.koha-community.org/job/Koha_Master_D12/185/ 14:55 tcohen :-D 14:55 wajasu i'll paste it 14:56 wajasu later i want to use a mysql schema diff tool 14:59 cait the versions are ont he wiki - when the bug was fixed 14:59 cait oh... scroll down first 14:59 cait referring to the earlier discussion about the auto-incrmeent 15:04 reiveune bye 16:02 koha-jenkins Project Koha_21.11_D10 build #116: STILL UNSTABLE in 36 min: https://jenkins.koha-community.org/job/Koha_21.11_D10/116/ 16:07 ashimema bug 29523 back to NQA 16:08 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29523 major, P5 - low, ---, tomascohen, Signed Off , Add a way to prevent embedding objects that should not be allowed 16:10 koha-jenkins Project Koha_21.11_D12 build #91: STILL UNSTABLE in 44 min: https://jenkins.koha-community.org/job/Koha_21.11_D12/91/ 16:29 koha-jenkins Project Koha_21.11_D9 build #98: STILL UNSTABLE in 1 hr 2 min: https://jenkins.koha-community.org/job/Koha_21.11_D9/98/ 16:32 koha-jenkins Project Koha_21.11_D11 build #129: STILL UNSTABLE in 1 hr 6 min: https://jenkins.koha-community.org/job/Koha_21.11_D11/129/ 16:39 koha-jenkins Project Koha_21.11_U20 build #101: STILL UNSTABLE in 36 min: https://jenkins.koha-community.org/job/Koha_21.11_U20/101/ 16:44 koha-jenkins Project Koha_21.11_U18 build #108: STILL UNSTABLE in 1 hr 17 min: https://jenkins.koha-community.org/job/Koha_21.11_U18/108/ 16:54 koha-jenkins Project Koha_21.11_U22 build #36: STILL UNSTABLE in 43 min: https://jenkins.koha-community.org/job/Koha_21.11_U22/36/ 17:42 wajasu ok. got my staff web interface and logged in. tried a search. i think i need to run/force a zebra index job to reindex 17:49 wajasu should i run koha-zebra -f kohadev in my ktd to hopefully reindex 17:49 wajasu or as root 17:52 oleonard wajasu: In ktd 17:52 wajasu yes 17:52 oleonard koha-rebuild-zebra -f -v [instance name] 17:52 wajasu i just ran as root 17:52 wajasu kshell 17:52 wajasu lets see 17:53 oleonard It prefixes the command with "sudo" in the wiki, but I don't ever need to when I'm in ktd using kshell 18:01 wajasu koha-rebuild-zebra -f kohadev worked 18:02 wajasu i get results from my search. yay. 3.10 -> 21.11 migration looking promising. will have to look for issues. 18:05 tuxayo > when I'm in ktd using kshell 18:05 tuxayo Which user ? Because 1st use of kshell goes in the container as root. And 2nd use goes to the use kohadev or something like that. So it's not clear wajasu and oleonard if you talk about the same kshell and thus user. 18:08 wajasu i tried becoming kohadev-koha, but koha-rebuild-zebra was not on the path. 18:08 wajasu my kshell user showed root@kohadevbox:mysql(master)$ 18:10 oleonard I kshell into the container, then I koha-rebuild-zebra without "sudo." 18:17 wajasu so far just unitialized values warnings in plack-error.log when searching. 18:17 wajasu i'll paste my effort notes if someone wants to refer to it. 18:20 pastebot "wajasu" at 127.0.0.1 pasted "My notes for my migrating a 3.10 era koha database backup to the latest 2022 koha. For reference ONLY." (307 lines) at https://paste.koha-community.org/10449 18:22 wajasu does ktd have crontab jobs running? i don't want overdue notices running in my ktd. 18:25 wajasu now i'm going to let my librarian mess around in the ktd since i have a mysqldump, i'll put that in my final production deb11,mariadb10 VPS. 18:31 tuxayo wajasu: «i tried becoming kohadev-koha, but koha-rebuild-zebra was not on the path.» So you an run as root. (1st kshell) 19:00 wajasu all seems to be working. librarian will play in the testing environment and give me feedback. 19:02 wajasu now with a reference environment, i'll see if i can get a placker/qemu/kvm libvirt working with generic/cloud image to deploy to linode. 19:03 wajasu no more baby sitting hardware for me. 19:04 wajasu maybe i should use memcached this time around 19:05 wajasu does memcached cache cover art? 19:40 davidnind[m] wajasu: I'm glad you got there! 19:44 davidnind[m] I'm sure you've seen https://wiki.koha-community.org/wiki/Koha_on_Debian (I think plack and memcached are installed as part of koha-common - it's been a very long time since I've tried to install Koha) 19:46 wajasu if i get a placker.io/terraform/cloud-init script going, i'll paste it for reference. then folks can tweak to deploy to selfhosted qemu/kvm, linode, AWS, etc 19:47 davidnind[m] You also get all the commands provided by the packages https://wiki.koha-community.org/wiki/Commands_provided_by_the_Debian_packages 19:49 wajasu i need to script it these days. putting in firewall, letsencrypt, SPF, DKIM, DMARC. 19:50 wajasu the docker test environment is awesome. i'll work some signoffs once i get my library deployed again. 19:50 davidnind[m] memcached and plack help a lot with performance 19:50 davidnind[m] wajasu++ 19:50 wajasu it's snappier 19:53 wajasu gonna deploy on a 1GB RAM nano if I can. I see in docker stats, that mem jumps in koha-koha-1 when i export all the biblios/auths. but is faster subsequent times. probably memcached those queries. 20:58 davidnind[m] cool, oleonard is down to just one bug needing signoff! (the one left requires valid Baker & Taylor credentials) 20:58 davidnind[m] Link: https://bugs.koha-community.org/bugzilla3/buglist.cgi?bug_status=Needs%20Signoff&email1=oleonard%40myacpl.org&emailassigned_to1=1&emailtype1=substring&list_id=415309&query_format=advanced 22:57 tcohen hi 22:57 tcohen the koha-* commands need to be run as root, either with sudo from a sudoer or just from the root user 22:58 tcohen and KTD usually lets you run things as root, but messes with permissions 22:58 tcohen but that's only because the root env is configured 22:58 tcohen that won't happen in production 22:59 tcohen so the koha-shell is the way to run things for a named instance 23:48 * nugged building intermediate community/22.05.x to test on our preprods and then prods. 23:48 nugged have this: 23:48 nugged ``` 23:48 nugged [2022/06/29 02:33:08] [WARN] Database update needed, redirecting to Installer. Database is 22.0500001 and Koha is 22.0501000 at /usr/share/koha/lib/C4/Auth.pm line 782. 23:48 nugged ``` 23:48 nugged seems installer/data/mysql/db_revs/220501000.pl file missing in branch community/22.05.x 23:48 nugged in ff757ca1 23:48 nugged Increment version for the 22.05.01 release 23:48 nugged Signed-off-by: Lucas Gass <lucas@bywatersolutions.com> 23:48 nugged ... can it be the cause? Did I guessed that right?