IRC log for #koha, 2024-03-13

← Previous day | Today | Next day → | Search | Index

All times shown according to UTC.

Time Nick Message
02:19 tcohen @later tell cait I have raised the VPS issue to Contabo as there's a storage server issue on the Jenkins/Wiki server
02:19 huginn` tcohen: The operation succeeded.
04:05 schnydszch joined #koha
06:24 lmstrand joined #koha
07:04 schnydszch joined #koha
07:26 reiveune joined #koha
07:27 reiveune hello
07:30 Joubu things still down even with the server up again, we need tcohen back
07:40 magnuse \o/
07:54 thibaud_g joined #koha
07:58 lds joined #koha
08:00 fridolin joined #koha
08:00 fridolin hellow
08:00 https://jenkins.koha-community.org/ problem ?
08:00 I get PR_CONNECT_RESET_ERROR
08:02 schnydszch joined #koha
08:02 cait joined #koha
08:03 Joubu yes fridolin, jenkins, wiki, everything that is hosted on the portainer server
08:04 cait good morning all
08:04 tcohen left me a note that he has raised an issue with the hoster (wiki, jenkins)
08:05 let's hope they resolve it soon
08:05 Joubu it's solved
08:06 the server is back, but I don't know how to restart the web server
08:07 fridolin great
08:07 Bug 36215 needs a review, unless I'm wrong
08:07 huginn` 04Bug https://bugs.koha-community.or[…]_bug.cgi?id=36215 normal, P5 - low, ---, martin.renvoize, Pushed to master , Bookings calendar only shows bookings within RESTdefaultPageSize
08:09 cait fridolin: i think you are right, Nick caught the second, but not the first occurrence
08:09 I'll do a follow-up in a bit
08:10 fridolin great
08:11 cait frido, there is a patch for a database update I messed up on top of master - can you please take care it gets into next release?
08:12 36232 - I know you are workign through all of them just don't want that to be lost (feeling responsible)
08:17 fridolin Bug 36232
08:17 huginn` 04Bug https://bugs.koha-community.or[…]_bug.cgi?id=36232 blocker, P5 - low, ---, mhby87, Pushed to master , Error fixing OAI-PMH:AutoUpdateSetsEmbedItemData syspref name on the DB
08:17 fridolin Yep seen it :D
08:19 And pushed for 23.11.04
08:21 cait thanks :) you are the best!
08:24 fridolin++
08:34 magnuse fridolin++ cait++
08:53 davidnind FYI - I don't know much about security for the web, but the recently released "Copenhagen Book" (an open source guide on implementing auth for the web) may be of use as a general reference for developers. It covers sessions, CSRF protection, passkeys, OAuth, 2FA, email verification, and password reset. https://thecopenhagenbook.com/
09:46 eugene_ joined #koha
10:26 fribeiro joined #koha
10:38 magnuse davidnind: cool project!
10:49 philor joined #koha
10:57 paulderscheid[m] morning #koha
11:00 cait bit late :D
11:00 paulderscheid[m] Thanks for the resource davidnind-away :D __Go__od read
11:01 Yeah, worked too long yesterday.
11:01 Crunch time
11:01 cait your breakfast is my lunch time :) bbiab!
11:03 paulderscheid[m] o/
11:08 Zahid[m] joined #koha
11:08 Zahid[m] hi everyone
11:13 my old koha server was running koha 16.05 version it creating mail logs file in var/log/mail.log and mail.err and it is increasing every minute from mb to GB and still growing about 50GB right now. i want to know is there any way to stop. i have checked the system preference but didnot find any thing or service to stop. is there  any other way to stop this? any help will be appreciated
11:22 paulderscheid[m] Kill the mail server
11:23 I read a story about recursive auto-responding filling the disk in the 90s or 2000s. But that’s probably not it.
11:36 tcohen hola #koha o/
11:38 Joubu: it got back, but RO
11:39 I've made a manual fsck through VNC
11:39 and has just restarted
11:39 I can teach anyone how to restart any of the services
11:40 it is done through Portainer
11:43 we are back online
11:43 and jenkins running
11:46 cait tcohen++ thanks!
11:54 tcohen cait: I will trigger the exploded Master jobs again
11:55 has anyone bisected the failed tests?
11:56 cait tcohen: thank you, hope we will get non-exploded results
11:56 I couldn#t see the last results yet, because the server was down
11:56 so not sure which tests gave us trouble this time
11:57 tcohen: i think maybe it just didn't finish before the server went down? D11 is green for a change and it wasn't before I think
11:59 tcohen it's t/db_dependent/api/v1/transfer_limits.t
12:02 will be working on DB_IMAGE=mysql:8.0 ktd --es7 --plugin up -d
12:02 today
12:03 in case I can find that error
12:03 * tcohen switches DB version and OS every now and then
12:05 cait cool :)
12:06 tcohen: bug is here: https://bugs.koha-community.or[…]_bug.cgi?id=36277
12:06 huginn` 04Bug 36277: normal, P5 - low, ---, chris, NEW , t/db_dependent/api/v1/transfer_limits.t  is failing
12:07 tcohen (y)
12:13 cait: we might need to add some debugging code in master if we cannot reproduce locally
12:21 cait, are you familiar with the run_tests.pl script?
12:22 Joubu tcohen: it's caused by a slow response I'd say, it says "timeout"
12:26 fridolin joined #koha
12:43 cait tcohen: only as far as using it for the cypress tests
12:47 Joubu tcohen: bug 36177 has been pushed yesterday. It adds a new node module.
12:47 huginn` 04Bug https://bugs.koha-community.or[…]_bug.cgi?id=36177 critical, P5 - low, ---, jonathan.druart, RESOLVED FIXED, We need integration tests to cover CSRF checks
12:47 Joubu Can you confirm me that I need to rebuild the images manually?
12:48 they have been rebuilt yesterday it seems
12:49 lds joined #koha
12:53 Joubu tcohen: I am rebuilding them from gitlab
12:54 tcohen ok, thanks for the heads up
12:54 perl -Mt::lib::TestBuilder -e 'my $builder = t::lib::TestBuilder->new; foreach my $i (1..1000) { $builder->build_object({ class => 'Koha::Libraries' }); }'
12:54 I did that to trigger the slowness...
12:54 Joubu lol
12:54 tcohen because this is a loop inside a loop on libraries
12:55 I'm just gonna say it is not slow enough to make tests fail.
12:55 so I guess it is a problem with the node
12:56 Joubu yes I noticed that, but we are not expecting a lot of entries in the table, or there are leftover from selenium tests
12:56 ok
12:56 cait tcohen++ Joubu++
12:56 thanks for the help!
12:57 Joubu it failed on different nodes
12:57 Docker_9 and Docker_11 at least
12:57 tcohen yes, 1000 was a bit drastic heh
13:01 Dyrcona joined #koha
13:06 khall_ joined #koha
13:07 khall joined #koha
13:20 wizzyrea joined #koha
13:23 pastebot Someone at 127.0.0.1 pasted "tcohen" (34 lines) at https://paste.koha-community.org/39543
13:39 cait Process 380508 dead! sounds drastic
14:01 edveal joined #koha
14:15 magnuse tcohen: looks like i finally managed to build myself a .deb, by being in the root of my koha clone, checking out the 23.05.x branch and running this: sudo RELEASE=23.05 VERSION=23.05 EMAIL=magnus@libriotech.no ~/code/koha-dpkg-docker/build.sh
14:15 but then it's not actually using docker, is it?
14:21 tcohen magnuse: and you installed nodejs and stuff
14:21 ah mo
14:21 it is all in the base.tgz
14:21 sounds good to me
14:22 magnuse i did try a lot of different things, but in the end i guess i basically just ran build.sh
14:24 tcohen that's good, magnuse
14:24 magnuse and i'm not 100% sure why i suddenly got past the "aborting due to unexpected upstream changes", but as long as it works...
14:24 need to test the deb now, of course ;-)
14:24 tcohen the Docker itself is just packing a few things so the host OS doesn't need to have them installed
14:24 build.sh was patched by khall to take care of that
14:24 https://gitlab.com/koha-commun[…]type=heads#L86-88
14:25 what we've seen at some point, is permissions get messed up because the Docker runs as root
14:25 and then, commiting fails, etc
14:27 magnuse yeah, there were some ownership issues in kohaclone along the way
14:32 hm, there's a number of debs, akshuly. koha_23.05-1_all.deb + /debs/koha-{common,core,deps,f​ull,perldeps}_23.05-1_all.deb
14:32 tcohen magnuse I'd expect build.sh to succeed on the task
14:32 especially if run by root
14:32 magnuse which ones are actually needed? common and core are 47M, the others are 3-4K in size
14:37 tcohen all but full?
14:38 magnuse ok, i'll experiment in a virtualbox or something
14:38 thanks!
14:39 wajasu well, i was trying to run koha-testing-docker with rootless podman. its a no go. since it pulls in the yarn node_modules stuff in the container, when it build the css and js, it wants to write to the koha volume/dir in the container and has no right permission. so running as root makes it work.
14:39 paulderscheid[m] Hi general question: should I be aware of any koha-specific caveats when using triggers in the database?
14:40 Just because there are none by default. Thought there might be a reason for that.
14:40 Hope it is simply: no need.
14:42 cait I think we just don't use triggers
14:42 paulderscheid[m] Why do you even want to run it rootless wajasu?
14:43 Thanks cait. That's good.
14:43 cait maybe there was a problem with early mysql versions? at least I am nto aware of a discussion
14:46 tcohen we don't use triggers because each DB engine uses a different syntax for that... and some people think we should support PostgreSQL
14:46 if we picked to just support MySQL, we could use CHECK() constraints instead of doing some nasty things in the code
14:46 paulderscheid[m] That makes perfect sense.
14:46 tcohen does it?
14:46 :-D
14:47 I mean, I love Postgres, just don't think it is so much gain for the constraints it poses to us
14:47 cait as long as it#s not because we plan on supporting Oracle...
14:48 tcohen whatever we support, it needs to be worth the effort
14:48 paulderscheid[m] Me too, but I don't think it's realistic for the foreseeable future..
14:48 Yeah, basically what you said tcohen
14:50 Ah, btw with 'That makes perfect sense' I meant your explanation not supporting postgres.
14:50 tcohen I have a customer that would love to run Koha with SQL Server
14:50 which is a very mature DB engine with much more capabilities
14:50 paulderscheid[m] Why?
14:51 tcohen because they are government, and they bought all the M$ stack for all the infrastructure
14:51 paulderscheid[m] Support?
14:51 My condolences
14:51 tcohen I mean
14:52 ashimema LOL
14:53 tcohen we were lucky they accepted us to host Koha so they don't have an 'uncertified DB engine' on their infra
14:54 paulderscheid[m] Cringe
14:55 If I had a dollar for all yet to be discovered M$ CVE's, I could stop working
14:56 Or rather exploits, because they have yet to be discovered
14:57 But it's the same here in Germany. OS infra gets killed w/ fire every time a single roadblock pops up.
14:58 Joubu I would be rich already if there were bounties for patching Koha sec bugs...
14:58 or simply discovering :D
14:58 paulderscheid[m] Haha :D
14:59 khall magnuse I was able to build the packages. Here's the command I used based on what I do and what you passed to tcohen : git checkout v23.05.09 && sudo rm -rf /tmp/debs/koha* && rm -rf * && git reset --hard && docker run --volume=/home/kyle/repos/koha:/koha --volume=/tmp/debs:/debs --privileged --env VERSION="23.05.09~1" --env RELEASE="23.05" --env DEB_BUILD_OPTIONS="nocheck" koha/koha-dpkg:master
15:00 tcohen khall++
15:00 thanks for confirming
15:00 Joubu (maybe git clean -d -f better than rm -rf * && git reset --hard?)
15:01 tcohen git clean -f -x -d
15:01 ?
15:04 I'm tweaking the docs
15:04 input on that is welcome magnuse, khall
15:05 khall tcohen I didn't even know about those options. TIL :)
15:05 wajasu paulderscheid: I just develop with podman these days. It's convenient for me. I dont need to worry as much about pulling various projects in and work a bug.  Just want to protect my root on my dev box.
15:06 it works with rootful podman, so i can make an exception.
15:06 that 4Gb repo makes me smile though.
15:07 paulderscheid[m] Alright that makes sense, I have used podman for a while as an experiment w/ ktd but went back to docker.
15:08 wajasu i tried userns_mode=keep-id to get the rootless podman to run as my id, but it takes forever to chmod every file in the koha mounted volume/dir.
15:09 paulderscheid[m] Yeah, probably not the best experience.
15:09 I have really gotten into nix the past few weeks.
15:09 Want to try getting koha to run as a nix flake later this year.
15:11 wajasu paulderscheid: i saw a talk on some fosscon docker guy mentioning docker watch.  it basically copies/syncs you external files (i.e. git) into your container), watching them for changes.  I wonder if that would help speed things.
15:13 paulderscheid[m] If you have any success, update the podman section in the wiki please :D
15:15 wajasu https://youtu.be/u1q8AyNMxd4?t=1121  docker watch    hot reload, sync from host to container.
15:15 tcohen khall++
15:18 paulderscheid[m] Wow that's actually pretty awesome.
15:19 tcohen magnuse: new push on koha-dpkg-docker
15:19 [master bca6b30] Update README a couple years of pushes later :-D 1 file changed, 48 insertions(+), 69 deletions(-)
15:22 paulderscheid[m] Thanks for sharing wajasu
15:26 wajasu i may have time to try it out on my old box that has docker.
16:43 khall joined #koha
16:45 khall_ joined #koha
17:00 NikolayGospodinov[m] Do you happen to have information about a library with Koha that is taking out a Library Fund Movement Book?
17:39 reiveune bye
17:40 reiveune left #koha
17:52 JasonGreene[m] good day.   Trying to change the barcode on a book and tried to follow this   https://www.youtube.com/watch?v=y0QXWPMbBFc
17:52 yet in koha 23 I cand find the "edit" link when looking at an item.. any ideas?
17:52 never mind.. I found it :-)
17:55 well I found it yet when I change the "p - Barcode" field I don't see a "save' link only Add or save as temp ... is there a "save" link?
18:24 cait joined #koha
18:30 ashimema @later tell cait are you still struggling to apply bookings bugs.. I was really hoping to see them in master by now
18:30 huginn` ashimema: The operation succeeded.
18:36 davidnind Jason Greene: There are several ways to edit the items attached to a record. I normally go 1) Edit > Edit items from the record page (normal view) 2) In the table with the list of items, click the Actions button then select Edit 3) Title above the form should say 'Edit item #XXXX / Barcode XXXXXX 4) Make changes 5) Options at the bottom of the form are 'Save changes', 'Add a new item', 'Cancel'
18:50 Screenshot https://snipboard.io/YXIJPk.jpg
18:54 JasonGreene[m] <davidnind> "Jason Greene: There are several..." <- I got 1) Edit 2)Edit record and I see 1 through 9 buttons  under the top " Editing Anne of Green Gables c.4 Three Volumes In One (Record number 6876)
18:54 I'm lost
19:01 davidnind You are editing the record, not the items. When you are viewing a record, select Edit (it is a dropdown list) > Edit items. https://snipboard.io/xu5Uqf.jpg
19:05 Alternatively, in the table with the list of holdings, select the Edit button at the far right to bring up the form to edit that specific item https://snipboard.io/jWmDCq.jpg
19:09 cait joined #koha
19:19 lukeg joined #koha
19:27 davidnind I'm probably being too basic here: there are two parts to a catalog record (at a really basic level), and these are edited in two different places... (full message at <https://matrix.org/_matrix/med[…]JESoWWMzllAcBpWEV>)
19:40 JasonGreene[m] I understand... I think I found that I imported the books twice using the same csv... human problem.  So my thoughts are to remove ALL itmes and start the import over.   Is there a web page way to delete all items or is it only in mysql ?
19:50 davidnind You could use the Batch item deletion and Batch record deletion tools from the Cataloging home page. For items, you could get the details from either a report or use the Item search screen (Search > Item search at the very top of the staff interface home page).
19:52 Did you end up with a record for each item (that is, two records for Book A), or duplicated items for each record (a record for Book A, with two items exactly the same?)
19:56 JasonGreene[m] Not sure... I search on a book name and get several  books show up ... some are No physical items for this record or No items
19:58 Before I remove everything, can you search for a barcode
19:58 from the patron page
20:01 davidnind no, but you can use the catalog search and enter the barcode
20:05 you can also use the item search (Search > Item search > Barcode search (near the bottom of the form))
20:25 JasonGreene[m] thanks\
22:05 dcook .

← Previous day | Today | Next day → | Search | Index

koha1