Time Nick Message
22:05 dcook .
20:25 JasonGreene[m] thanks\
20:05 davidnind you can also use the item search (Search > Item search > Barcode search (near the bottom of the form))
20:01 davidnind no, but you can use the catalog search and enter the barcode
19:58 JasonGreene[m] from the patron page
19:58 JasonGreene[m] Before I remove everything, can you search for a barcode
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:52 davidnind 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: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: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: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/media/v3/download/matrix.org/tzGXanAJESoWWMzllAcBpWEV>)
19:05 davidnind 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: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
18:54 JasonGreene[m] I'm lost
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:50 davidnind Screenshot https://snipboard.io/YXIJPk.jpg
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:30 huginn` ashimema: The operation succeeded.
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
17:55 JasonGreene[m] 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?
17:52 JasonGreene[m] never mind.. I found it :-)
17:52 JasonGreene[m] yet in koha 23 I cand find the "edit" link when looking at an item.. any ideas?
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:39 reiveune bye
17:00 NikolayGospodinov[m] Do you happen to have information about a library with Koha that is taking out a Library Fund Movement Book?
15:26 wajasu i may have time to try it out on my old box that has docker.
15:22 paulderscheid[m] Thanks for sharing wajasu
15:19 tcohen [master bca6b30] Update README a couple years of pushes later :-D 1 file changed, 48 insertions(+), 69 deletions(-)
15:19 tcohen magnuse: new push on koha-dpkg-docker
15:18 paulderscheid[m] Wow that's actually pretty awesome.
15:15 tcohen khall++
15:15 wajasu https://youtu.be/u1q8AyNMxd4?t=1121 docker watch hot reload, sync from host to container.
15:13 paulderscheid[m] If you have any success, update the podman section in the wiki please :D
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:09 paulderscheid[m] Want to try getting koha to run as a nix flake later this year.
15:09 paulderscheid[m] I have really gotten into nix the past few weeks.
15:09 paulderscheid[m] Yeah, probably not the best experience.
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: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:06 wajasu that 4Gb repo makes me smile though.
15:06 wajasu it works with rootful podman, so i can make an exception.
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:05 khall tcohen I didn't even know about those options. TIL :)
15:04 tcohen input on that is welcome magnuse, khall
15:04 tcohen I'm tweaking the docs
15:01 tcohen ?
15:01 tcohen git clean -f -x -d
15:00 Joubu (maybe git clean -d -f better than rm -rf * && git reset --hard?)
15:00 tcohen thanks for confirming
15:00 tcohen khall++
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
14:58 paulderscheid[m] Haha :D
14:58 Joubu or simply discovering :D
14:58 Joubu I would be rich already if there were bounties for patching Koha sec bugs...
14:57 paulderscheid[m] But it's the same here in Germany. OS infra gets killed w/ fire every time a single roadblock pops up.
14:56 paulderscheid[m] Or rather exploits, because they have yet to be discovered
14:55 paulderscheid[m] If I had a dollar for all yet to be discovered M$ CVE's, I could stop working
14:54 paulderscheid[m] Cringe
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:52 ashimema LOL
14:51 tcohen I mean
14:51 paulderscheid[m] My condolences
14:51 paulderscheid[m] Support?
14:51 tcohen because they are government, and they bought all the M$ stack for all the infrastructure
14:50 paulderscheid[m] Why?
14:50 tcohen which is a very mature DB engine with much more capabilities
14:50 tcohen I have a customer that would love to run Koha with SQL Server
14:50 paulderscheid[m] Ah, btw with 'That makes perfect sense' I meant your explanation not supporting postgres.
14:48 paulderscheid[m] Yeah, basically what you said tcohen
14:48 paulderscheid[m] Me too, but I don't think it's realistic for the foreseeable future..
14:48 tcohen whatever we support, it needs to be worth the effort
14:47 cait as long as it#s not because we plan on supporting Oracle...
14:47 tcohen I mean, I love Postgres, just don't think it is so much gain for the constraints it poses to us
14:46 tcohen :-D
14:46 tcohen does it?
14:46 paulderscheid[m] That makes perfect sense.
14:46 tcohen if we picked to just support MySQL, we could use CHECK() constraints instead of doing some nasty things in the code
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:43 cait maybe there was a problem with early mysql versions? at least I am nto aware of a discussion
14:43 paulderscheid[m] Thanks cait. That's good.
14:42 paulderscheid[m] Why do you even want to run it rootless wajasu?
14:42 cait I think we just don't use triggers
14:40 paulderscheid[m] Hope it is simply: no need.
14:40 paulderscheid[m] Just because there are none by default. Thought there might be a reason for that.
14:39 paulderscheid[m] Hi general question: should I be aware of any koha-specific caveats when using triggers in the database?
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:38 magnuse thanks!
14:38 magnuse ok, i'll experiment in a virtualbox or something
14:37 tcohen all but full?
14:32 magnuse which ones are actually needed? common and core are 47M, the others are 3-4K in size
14:32 tcohen especially if run by root
14:32 tcohen magnuse I'd expect build.sh to succeed on the task
14:32 magnuse hm, there's a number of debs, akshuly. koha_23.05-1_all.deb + /debs/koha-{common,core,deps,full,perldeps}_23.05-1_all.deb
14:27 magnuse yeah, there were some ownership issues in kohaclone along the way
14:25 tcohen and then, commiting fails, etc
14:25 tcohen what we've seen at some point, is permissions get messed up because the Docker runs as root
14:24 tcohen https://gitlab.com/koha-community/koha-dpkg-docker/-/blob/master/build.sh?ref_type=heads#L86-88
14:24 tcohen build.sh was patched by khall to take care of that
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 magnuse need to test the deb now, of course ;-)
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 tcohen that's good, magnuse
14:22 magnuse i did try a lot of different things, but in the end i guess i basically just ran build.sh
14:21 tcohen sounds good to me
14:21 tcohen it is all in the base.tgz
14:21 tcohen ah mo
14:21 tcohen magnuse: and you installed nodejs and stuff
14:15 magnuse but then it's not actually using docker, is it?
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
13:39 cait Process 380508 dead! sounds drastic
13:23 pastebot Someone at 127.0.0.1 pasted "tcohen" (34 lines) at https://paste.koha-community.org/39543
12:57 tcohen yes, 1000 was a bit drastic heh
12:57 Joubu Docker_9 and Docker_11 at least
12:57 Joubu it failed on different nodes
12:56 cait thanks for the help!
12:56 cait tcohen++ Joubu++
12:56 Joubu ok
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:55 tcohen so I guess it is a problem with the node
12:55 tcohen I'm just gonna say it is not slow enough to make tests fail.
12:54 tcohen because this is a loop inside a loop on libraries
12:54 Joubu lol
12:54 tcohen I did that to trigger the slowness...
12:54 tcohen perl -Mt::lib::TestBuilder -e 'my $builder = t::lib::TestBuilder->new; foreach my $i (1..1000) { $builder->build_object({ class => 'Koha::Libraries' }); }'
12:54 tcohen ok, thanks for the heads up
12:53 Joubu tcohen: I am rebuilding them from gitlab
12:48 Joubu they have been rebuilt yesterday it seems
12:47 Joubu Can you confirm me that I need to rebuild the images manually?
12:47 huginn` 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36177 critical, P5 - low, ---, jonathan.druart, RESOLVED FIXED, We need integration tests to cover CSRF checks
12:47 Joubu tcohen: bug 36177 has been pushed yesterday. It adds a new node module.
12:43 cait tcohen: only as far as using it for the cypress tests
12:22 Joubu tcohen: it's caused by a slow response I'd say, it says "timeout"
12:21 tcohen cait, are you familiar with the run_tests.pl script?
12:13 tcohen cait: we might need to add some debugging code in master if we cannot reproduce locally
12:07 tcohen (y)
12:06 huginn` 04Bug 36277: normal, P5 - low, ---, chris, NEW , t/db_dependent/api/v1/transfer_limits.t is failing
12:06 cait tcohen: bug is here: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36277
12:05 cait cool :)
12:03 * tcohen switches DB version and OS every now and then
12:03 tcohen in case I can find that error
12:02 tcohen today
12:02 tcohen will be working on DB_IMAGE=mysql:8.0 ktd --es7 --plugin up -d
11:59 tcohen it's t/db_dependent/api/v1/transfer_limits.t
11:57 cait 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:56 cait so not sure which tests gave us trouble this time
11:56 cait I couldn#t see the last results yet, because the server was down
11:56 cait tcohen: thank you, hope we will get non-exploded results
11:55 tcohen has anyone bisected the failed tests?
11:54 tcohen cait: I will trigger the exploded Master jobs again
11:46 cait tcohen++ thanks!
11:43 tcohen and jenkins running
11:43 tcohen we are back online
11:40 tcohen it is done through Portainer
11:39 tcohen I can teach anyone how to restart any of the services
11:39 tcohen and has just restarted
11:39 tcohen I've made a manual fsck through VNC
11:38 tcohen Joubu: it got back, but RO
11:36 tcohen hola #koha o/
11:23 paulderscheid[m] I read a story about recursive auto-responding filling the disk in the 90s or 2000s. But that’s probably not it.
11:22 paulderscheid[m] Kill the mail server
11:13 Zahid[m] 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:08 Zahid[m] hi everyone
11:03 paulderscheid[m] o/
11:01 cait your breakfast is my lunch time :) bbiab!
11:01 paulderscheid[m] Crunch time
11:01 paulderscheid[m] Yeah, worked too long yesterday.
11:00 paulderscheid[m] Thanks for the resource davidnind-away :D __Go__od read
11:00 cait bit late :D
10:57 paulderscheid[m] morning #koha
10:38 magnuse davidnind: cool project!
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/
08:34 magnuse fridolin++ cait++
08:24 cait fridolin++
08:21 cait thanks :) you are the best!
08:19 fridolin And pushed for 23.11.04
08:17 fridolin Yep seen it :D
08:17 huginn` 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36232 blocker, P5 - low, ---, mhby87, Pushed to master , Error fixing OAI-PMH:AutoUpdateSetsEmbedItemData syspref name on the DB
08:17 fridolin Bug 36232
08:12 cait 36232 - I know you are workign through all of them just don't want that to be lost (feeling responsible)
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:10 fridolin great
08:09 cait I'll do a follow-up in a bit
08:09 cait fridolin: i think you are right, Nick caught the second, but not the first occurrence
08:07 huginn` 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36215 normal, P5 - low, ---, martin.renvoize, Pushed to master , Bookings calendar only shows bookings within RESTdefaultPageSize
08:07 fridolin Bug 36215 needs a review, unless I'm wrong
08:07 fridolin great
08:06 Joubu the server is back, but I don't know how to restart the web server
08:05 Joubu it's solved
08:05 cait let's hope they resolve it soon
08:04 cait tcohen left me a note that he has raised an issue with the hoster (wiki, jenkins)
08:04 cait good morning all
08:03 Joubu yes fridolin, jenkins, wiki, everything that is hosted on the portainer server
08:00 fridolin I get PR_CONNECT_RESET_ERROR
08:00 fridolin https://jenkins.koha-community.org/ problem ?
08:00 fridolin hellow
07:40 magnuse \o/
07:30 Joubu things still down even with the server up again, we need tcohen back
07:27 reiveune hello
02:19 huginn` tcohen: The operation succeeded.
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