IRC log for #koha, 2022-06-28

All times shown according to UTC.

Time S Nick Message
01:01 wajasu joined #koha
01:21 alohabot 🎁 🦁 Koha '21.05.x' packages pushed to 'koha-staging' repo  ðŸ¥’🍇🍲
01:37 mkun joined #koha
01:38 koha-jenkins Project Koha_21.05_U20 build #201: SUCCESS in 39 min: https://jenkins.koha-community[…]ha_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[…]ha_21.05_D10/276/
01:57 koha-jenkins Project Koha_21.05_D12 build #127: SUCCESS in 55 min: https://jenkins.koha-community[…]ha_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[…]ha_21.05_U16/200/
02:12 koha-jenkins Project Koha_21.05_U18 build #190: SUCCESS in 37 min: https://jenkins.koha-community[…]ha_21.05_U18/190/
02:19 koha-jenkins Project Koha_21.05_D9 build #196: SUCCESS in 41 min: https://jenkins.koha-community[…]oha_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[…]ha_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.or[…]uto_increment_fix
03:13 koha-jenkins Project Koha_21.11_D10 build #115: STILL UNSTABLE in 35 min: https://jenkins.koha-community[…]ha_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[…]ha_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[…]oha_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[…]ha_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[…]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[…]ha_21.11_D11/128/
04:06 koha-jenkins Project Koha_21.11_U22 build #35: STILL UNSTABLE in 43 min: https://jenkins.koha-community[…]oha_21.11_U22/35/
04:19 koha-jenkins Project Koha_21.11_U20 build #100: STILL UNSTABLE in 58 min: https://jenkins.koha-community[…]ha_21.11_U20/100/
04:33 fridolin joined #koha
04:34 koha-jenkins Project Koha_22.05_U18 build #24: STILL UNSTABLE in 41 min: https://jenkins.koha-community[…]oha_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[…]oha_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:40 reiveune joined #koha
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.
06:52 liliputech joined #koha
07:46 cait joined #koha
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:00 alex_ joined #koha
09:19 mtj oops, false alarm magnuse
09:19 * mtj fixes his script
09:19 magnuse no new package pushed?
09:23 FlorianB joined #koha
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:30 alex_ joined #koha
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.or[…]_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 joined #koha
11:37 marcelr o/
11:38 magnuse joined #koha
11:41 marcelr bug 31055 for anyone wishing to join the discussion about koha-functions.sh
11:41 huginn Bug https://bugs.koha-community.or[…]_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.or[…]_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.or[…]_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[…]d94434260dcc76d48>
12:42 huginn News from kohagit: Bug 31058: Fix import AutoUnsuspendHolds <https://git.koha-community.org[…]3110b824ab3ac162c>
12:42 huginn News from kohagit: Bug 30939: Fix use statement for DelAuthority <https://git.koha-community.org[…]b2ba2e73caf8187bd>
12:42 huginn News from kohagit: Bug 30677: Use lookahead in regex for biblioitem replacement <https://git.koha-community.org[…]8eb64fa77fe9362f7>
12:42 huginn News from kohagit: Bug 30677: Add tests <https://git.koha-community.org[…]c7287ed942fa4bae8>
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.or[…]_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 simon_ joined #koha
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:05 Dyrcona joined #koha
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:16 Shane-S joined #koha
13:16 cait joined #koha
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.or[…]_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[…]a_Master_D9/2030/
13:27 koha-jenkins Project Koha_Master_D11_My8 build #889: SUCCESS in 44 min: https://jenkins.koha-community[…]ster_D11_My8/889/
13:29 cait magnuse: can you still add quotes?
13:30 cait https://bugs.koha-community.or[…].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 Shane-S joined #koha
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:39 lukeg joined #koha
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[…]Koha_Master/2082/
13:47 koha-jenkins Project Koha_Master_U22 build #112: SUCCESS in 1 hr 5 min: https://jenkins.koha-community[…]a_Master_U22/112/
14:04 lukeg joined #koha
14:05 cait I got a question about Koha and MySQL 5.8 - are we not supporting MySQL anymore officially? https://wiki.koha-community.or[…]d_recommendations
14:05 koha-jenkins Project Koha_Master_U20 build #460: SUCCESS in 38 min: https://jenkins.koha-community[…]a_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[…]1_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[…]a_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/mari[…]-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[…]a_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
15:04 reiveune left #koha
15:36 cait left #koha
15:41 lukeg joined #koha
16:02 koha-jenkins Project Koha_21.11_D10 build #116: STILL UNSTABLE in 36 min: https://jenkins.koha-community[…]ha_21.11_D10/116/
16:07 ashimema bug 29523 back to NQA
16:08 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=29523 major, P5 - low, ---, tomascohen, Signed Off , Add a way to prevent embedding objects that should not be allowed
16:10 FlorianB left #koha
16:10 koha-jenkins Project Koha_21.11_D12 build #91: STILL UNSTABLE in 44 min: https://jenkins.koha-community[…]oha_21.11_D12/91/
16:26 cait joined #koha
16:29 koha-jenkins Project Koha_21.11_D9 build #98: STILL UNSTABLE in 1 hr 2 min: https://jenkins.koha-community[…]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[…]ha_21.11_D11/129/
16:39 koha-jenkins Project Koha_21.11_U20 build #101: STILL UNSTABLE in 36 min: https://jenkins.koha-community[…]ha_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[…]ha_21.11_U18/108/
16:54 koha-jenkins Project Koha_21.11_U22 build #36: STILL UNSTABLE in 43 min: https://jenkins.koha-community[…]oha_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:46 lukeg joined #koha
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)
18:33 fridolin joined #koha
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:09 lukeg joined #koha
19:22 dpk joined #koha
19:34 lukeg joined #koha
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.or[…]ki/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.or[…]e_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.or[…]y_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?

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