kohadevbox:mysql(master)$bywatersolutions.com>← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | 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 | 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 | 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 | wonders if the codebase has been switched to NULL/undef by now so I can switch default to NULL. | |
| 02:08 | 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 | Project Koha_21.05_U18 build #190: SUCCESS in 37 min: https://jenkins.koha-community[…]ha_21.05_U18/190/ | |
| 02:19 | 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 | It's easy to get 10.1 | |
| 02:47 | with ktd | |
| 02:55 | koha-jenkins | Yippee, build fixed! |
| 02:55 | 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 | i am thinking of just getting the updatedatabase.pl to make it to 20.05. | |
| 03:05 | then possible export the biblios, authorities, patrons to mrc files. create a new 20.5 system and import the marc records. | |
| 03:07 | 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 | 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 | there/their | |
| 03:17 | 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 | 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 | 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 | 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 | Project Koha_21.11_U22 build #35: STILL UNSTABLE in 43 min: https://jenkins.koha-community[…]oha_21.11_U22/35/ | |
| 04:19 | 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 | 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 | also, maybe mention the version you are now on and upgraded from | |
| 06:21 | 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 | 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 | or more CAN_user.... | |
| 09:27 | it's borrowers module, sub permission edit_borrowers | |
| 09:27 | FlorianB: | |
| 09:30 | alex_ joined #koha | |
| 09:35 | FlorianB | Ah, found it, thank you |
| 09:35 | 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 | 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 | I added a follow-up today to fix the style | |
| 11:33 | tests all still pass | |
| 11:33 | and make sense | |
| 11:33 | 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 | memcached + plack | |
| 11:43 | you should run restart_all | |
| 11:44 | magnuse | yeah, did that now, but it didn't help |
| 11:44 | also restarted memcached explicitly | |
| 11:45 | tcohen | and what is the path you're using? |
| 11:45 | I usually set | |
| 11:45 | magnuse | here: /kohadevbox/koha/Koha/Illbackends |
| 11:45 | tcohen | PLUGIN_REPO=/home/tcohen/git/koha-plugins |
| 11:46 | then use ktd --plugin up -d | |
| 11:47 | and then point koha-conf.xml to /kohadevbox/koha_plugin/my-plugin/Koha/Illbackends | |
| 11:47 | 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 | (the ktd stuff) | |
| 11:55 | tcohen | docker ps on hte host? |
| 11:55 | just trying to understand the context, really | |
| 11:56 | I assume you're working on master | |
| 11:56 | 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 | News from kohagit: Bug 31058: Fix import AutoUnsuspendHolds <https://git.koha-community.org[…]3110b824ab3ac162c> | |
| 12:42 | News from kohagit: Bug 30939: Fix use statement for DelAuthority <https://git.koha-community.org[…]b2ba2e73caf8187bd> | |
| 12:42 | News from kohagit: Bug 30677: Use lookahead in regex for biblioitem replacement <https://git.koha-community.org[…]8eb64fa77fe9362f7> | |
| 12:42 | 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 | 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 | any idea what could trigger this behaviour? | |
| 12:53 | ~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 | ...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 | 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 | 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 | 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 | (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 | 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 | "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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | @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 | it's an invalid date | |
| 14:21 | 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 | we usually recommended to stick with whatever dbms version/system the OS ships with | |
| 14:37 | mtj | yuss agree |
| 14:37 | tcohen: a good idea? ^ | |
| 14:38 | tcohen | I'm not sure. It is EOL and also has the AUTOINCREMENT issue |
| 14:38 | maybe we can add it | |
| 14:39 | 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 | https://packages.ubuntu.com/bionic/mysql-server | |
| 14:43 | koha-jenkins | Yippee, build fixed! |
| 14:43 | 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 | gets recalculated | |
| 14:45 | and MariaDB fixed it in 10.2.4 or so | |
| 14:45 | https://mariadb.com/kb/en/mari[…]-release-notes/#:~:text=MariaDB%2010.2%20is%20the%20current,Release%20Candidate%20(RC)%20release. | |
| 14:45 | 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 | 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 | you went too far LOL | |
| 14:49 | mtj | wajasu++ :p |
| 14:49 | folks, lets not recommend mysql-5 :) | |
| 14:49 | wajasu | yes. but better be here then where i was. missing tables, bad dates. |
| 14:49 | now i'm going to dump the mysql database for backup. | |
| 14:50 | tcohen | this is a testing instance, right |
| 14:50 | ¡? | |
| 14:50 | wajasu | then startup the memcached-1 and try hitting the web interface |
| 14:50 | yes testing instance | |
| 14:52 | 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 | 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 | oh... scroll down first | |
| 14:59 | 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 | 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 | Project Koha_21.11_U20 build #101: STILL UNSTABLE in 36 min: https://jenkins.koha-community[…]ha_21.11_U20/101/ | |
| 16:44 | 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 | 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 | 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 | kshell | |
| 17:52 | 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 | 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 | 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 | my kshell user showed rootkohadevbox: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 | 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 | 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 | 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 | no more baby sitting hardware for me. | |
| 19:04 | maybe i should use memcached this time around | |
| 19:05 | 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 | 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 | 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 | wajasu++ | |
| 19:50 | wajasu | it's snappier |
| 19:53 | 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 | Link: https://bugs.koha-community.or[…]y_format=advanced | |
| 22:57 | tcohen | hi |
| 22:57 | the koha-* commands need to be run as root, either with sudo from a sudoer or just from the root user | |
| 22:58 | and KTD usually lets you run things as root, but messes with permissions | |
| 22:58 | but that's only because the root env is configured | |
| 22:58 | that won't happen in production | |
| 22:59 | 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 | ``` | |
| 23:48 | [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 | ``` | |
| 23:48 | seems installer/data/mysql/db_revs/220501000.pl file missing in branch community/22.05.x | |
| 23:48 | in ff757ca1 | |
| 23:48 | Increment version for the 22.05.01 release | |
| 23:48 | Signed-off-by: Lucas Gass <lucasbywatersolutions.com> |
|
| 23:48 | ... can it be the cause? Did I guessed that right? |
← Previous day | Today | Next day → | Search | Index
