April 2023 - Koha - lists.katipo.co.nz

Restore the default Marc Framework
by Victor Barroso Oliveira 04 Sep '24

04 Sep '24

Hello, how to restore the default Marc Framework to the original pattern? koha version 22.05.05 ubuntu 20 Thanks, Victor

4 5

Re: [Koha] How to copy patron permissions?
by BRANNON, CHRISTOPHER 22 Jan '24

22 Jan '24

Michael, I've had some jQuery in the Koha library for quite a while. You should take a look at https://wiki.koha-community.org/wiki/JQuery_Library#Add_clear_and_preset_pe… There are 3 versions of this for different versions of Koha, but this latest one includes a clear permissions button, a couple of preset permission buttons, and a copy permissions button. Please check it out. We also did a video tutorial on this enhancement in season one of The Terrific Every-Other-Thursday Training Videos. You can find that here: https://youtu.be/M6aQITCJY0U. ___________________________ Christopher Brannon IT Coordinator 702 E Front Ave Coeur d'Alene, ID 83814 (208)769-2315 Ext. 456 cbrannon(a)cdalibrary.org www.cdalibrary.org Keep tabs on us at: Date: Tue, 26 Apr 2022 10:39:58 +0200 From: Michael Kuhn <mik(a)adminkuhn.ch> To: Koha <koha(a)lists.katipo.co.nz> Subject: [Koha] How to copy patron permissions? Message-ID: <abc69231-a587-77d5-01d2-7f98e5b16174(a)adminkuhn.ch> Content-Type: text/plain; charset=UTF-8; format=flowed Hi Is it possible to copy the permissions of another patron when creating a new one? I always thought this would happen when copying/duplicating an existing patron. But when I actually tried it today the permissions were not there with the new patron and I had to set them manually. Best wishes: Michael Kuhn

4 3

Cannot import records: Failed to connect: Error connecting to localhost:61613
by Giuseppe Angilella 23 Jun '23

23 Jun '23

Hi, after upgrading a Debian (Ubuntu) installation to version 22.11.03.000 Rosalie , I fail to import any new Marc record into the database. My worker-output.log reports: Failed to connect: Error connecting to localhost:61613: Connection refused at /usr/share/perl5/Net/Stomp.pm line 27.; giving up at /usr/share/perl5/Net/Stomp.pm line 26. I believe this strange behavior can be traced back to Bug 26742: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26742 As suggested there, I did manually include the lines: <message_broker> <hostname>localhost</hostname> <port>61613</port> <username>guest</username> <password>guest</password> <vhost></vhost> </message_broker> (which weren't present, despite all previous upgrades) into my etc/koha-conf.xml file, and restarted everything. But the issue is still there. The About tab of my installation says that: Message broker: Using RabbitMQ Any help or hint? Many thanks! Best regards, Giuseppe.

3 2

Koha 21.11.09 released
by Arthur 11 May '23

11 May '23

The Koha community is pleased to announce the release of version 21.11.09. For full release notes, please visit https://koha-community.org/koha-version-21-11-09-released/ <https://koha-community.org/koha-21-11-09-released/> Thanks! 🚀

3 4

Background job / Staging MARC import stuck at 0%
by Michael Brown 09 May '23

09 May '23

Greetings: My name is Michael Brown and I am a professional cataloger and SirsiDynix System Admin at the Texas State Library & Archives in Austin (20+ years now). I have been using Koha on Arch Linux in my home library for about a year now. I am migrating my home server to AlmaLinux and I'm having a problem. I am running Koha 22.11.03.000 Rosalie on AlmaLinux 9.1. Staging a MARC file for import gets stuck at 0%. On screen, I am able to select the file for import (bib.mrc), review the profile options (but I don't change any defaults), and then click on "Stage for import" at the bottom. Next screen reads: The job has been enqueued! It will be processed as soon as possible. 0% View detail of the enqueued job After a few seconds, it changes to (and then hangs at): The job has been enqueued! It will be processed as soon as possible. 0% Not started View detail of the enqueued job Clicking on "View detail of the enqueued job" I see: Details of job #22 Job ID: 22 Status: New Progress: 0 / 0 Type: Staged MARC records for import Queued: 03/02/2023 05:42 Started: Ended: Report Detailed messages Return to the job list The corresponding entry in mariadb is: id 22 status new progress NULL size 0 borrowernumber 1 type stage_marc_for_import queue Name of the queue the job is sent to long_tasks data {"encoding":"UTF-8","comments":"","basket_id":null... context JSON-serialized context information for the job {"flags":1,"branch":"ALMA","interface":"intranet",... enqueued_on 2023-03-02 05:42:33 started_on NULL ended_on NULL (If you need to see the full entries for "data" and "context", please let me know.) tmp, koha_upload, and lock directories have been tweaked and fine tuned. I was getting early warnings about them not being set in koha-conf.xml so I created them (and set correct permissions) and I can see the uploaded file (for job 22 the name is 2287629673fb980ad4102f62ebeaa1b9_bib.mrc), so the actual upload function appears to be working. I am getting no apache errors and no other on-screen diagnostics. I have Koha 22.05.02.000 running on Arch Linux that imports this file just fine. Similarly, I have Koha latest running on a Debian VM that can import this file just fine, too. What am I missing? Details of my system: Koha version: 22.11.03.000 Rosalie OS version ('uname -a'): Linux alma 5.14.0-162.12.1.el9_1.x86_64 #1 SMP PREEMPT_DYNAMIC Mon Jan 23 14:51:52 EST 2023 x86_64 Perl interpreter: /usr/bin/perl Perl version: 5.032001 Perl @INC: /usr/share/koha/lib /usr/local/lib64/perl5/5.32 /usr/local/share/perl5/5.32 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 /var/lib/koha/plugins MySQL version: mysql Ver 15.1 Distrib 10.5.16-MariaDB, for Linux (x86_64) using EditLine wrapper Apache version: Server version: Apache/2.4.53 (AlmaLinux) Server built: Jul 20 2022 00:00:00 Memcached: Servers: 127.0.0.1:11211 | Namespace: KOHA | Status: running. | Config read from: koha-conf.xml Zebra version: Zebra 2.2.7 (C) 1994-2023, Index Data Zebra is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. SHA1 ID: ac40f289672405a299436d73c1532f9906774cc6 Using ICU Zebra status: Running Message broker: Using RabbitMQ Date and time: 03/01/2023 16:20 Time zone: Used: America/Chicago | Config: Undefined | Environment (TZ): Undefined Thanks, Michael

6 12

Last week to submit your Koha talk for the KohaCon: Perl and Koha conference in Helsinki 2023
by Perl Koha 04 May '23

04 May '23

*TL;DR :* 1. There's only one week left before our call for talks closes on April 30th. Don't hesitate to submit your draft ideas or works in progress here: ➡️ CALL FOR TALKS SUBMISSION PAGE: perlkohacon.fi/cft <https://perlkohacon.fi/Call-For-Talks-Perl-Koha-Helsinki-August-2023.html> 2. The Perl and Koha Conference in Helsinki will happen from 📅 *August 14th to 18th, 2023* More hints on this soon! 3. Track our social channels (we prefer Telegram): - *t*.me/PerlKohaCon <http://t.me/PerlKohaCon> - *Facebook*.com/PerlKohaCon <http://facebook.com/PerlKohaCon> - *Twitter*.com/PerlKohaCon <http://twitter.com/PerlKohaCon> - *Instagram*.com/PerlKohaCon <http://instagram.com/PerlKohaCon> - *LinkedIn*.com/showcase/PerlKohaCon <http://linkedin.com/showcase/PerlKohaCon> - (Mastodon) *Fosstodon*.org/@perlkohacon <http://fosstodon.org/@perlkohacon> ... and share the link to this message you are reading among your friendly bubble. 🤗 We need more interesting talks, we need more attendees, and you. *LONG VERSION, with some fun and suspense:* We're inspired to bring you the "Perl and Koha Conference in Helsinki" (also known as KohaCon with YAPC::Europe/PerlCon) taking place from 📅 August 14th to 18th, 2023. The conference will feature three days of talk streams (August 14th to 16th) and two additional days of workshops and special meetings (August 17th to 18th). Among all the usual things you know about KohaCon, this time, we have a unique event that gives an opportunity for the Koha and Perl communities to unite, exchange insights, and forge (unwind together!) new connections. As a valued member of the Koha community of all of you, we need your expertise! 🌟 We also need your help to present Koha to the Perl community in the best possible way, as Koha could become the flagship product for the Perl community. To make that happen, we need to unite, present ourselves, and share all the ideas we can come up with! (By the way, you can propose ideas through our channels or by reaching out directly to the main organizer, Andrii, at nugged(a)gmail.com) There's only one week left before our call for talks closes on April 30th. Don't hesitate to submit your draft ideas or works in progress here: ➡️ CALL FOR TALKS SUBMISSION PAGE: perlkohacon.fi/cft <https://perlkohacon.fi/Call-For-Talks-Perl-Koha-Helsinki-August-2023.html> After you make a placeholder for a talk (i.e. send the form), we will know this, and confirm with you later, and this will help us to select the best talks, make the conference most interesting and useful, and plan our schedule. Afterward, you can progress with your talk development further, this means no need to have the talk ready in one week, so no panic. No-panic more: if you want, you can talk to our dedicated team, who is ready to help you refine your talk and provide guidance if needed. Reach out to us at perlkohacon(a)gmail.com 💌. If you have experience in Koha or around, but no experience in stage-action: we value first more, so we'll try to cover your back! Mind that talk is only one part of the reason and only ignition point to share your experience: you might find mates and interested people after your presentation, so that might be just the beginning of something greater! We will talk all about expansion, improvement, and experience exchange, and these are engaging topics for your talk (but keep your experience in priority of anything below): Best practices, tips, hacks, and challenges in using Koha in the library Koha software development, including integrations with other systems The future of BIBFRAME, MARC, and Linked Open Data in Koha Features needed for Koha to become more capable, which the Perl community can contribute to, such as ILL, ERM, and others Upcoming or requested Koha feature developments: proposals, progress, and collaboration opportunities As this will be an event with many IT professionals and developers from the Perl community, we will also cover geekier and dev-related topics. However, we will have one separate stream fully dedicated to libraries (usage, pro-tips, and KohaCon-related topics). You will meet library and Koha experts from 🇫🇮Finland, a country that has already switched hundreds of libraries to Koha, as well as experts from ByWater Solutions, BibLibre, PTFS Europe, Koha-and-library IT-topic activists from France, Germany, Sweden, and more. Even from Ukraine (consider there will be something special about this). This conference is an excellent opportunity to make meaningful connections with the Perl community and explore how these relationships can benefit the Koha community! 🤝 Don't forget, August is an ideal time for a summer vacation in Helsinki with your family. ☀️ Extend your stay over the weekends to experience the city's culture and attractions while attending the conference. We will have a partners program and more coordinated activities (might be even sponsored, but we need more participants and attendees to make that happen!). Stay connected by following us on social media, there, we will publish more and announce things that we will have these weeks soon before the conference (yes, something gifty or nifty is planned). We'll target as main social channel Telegram one: - t.me/PerlKohaCon and encourage you to use this geeky, fast, and comfortable groups, channels, and messaging platform. But feel free to join us on any of these platforms for news and updates: - Facebook.com/PerlKohaCon <http://facebook.com/PerlKohaCon> - Twitter.com/PerlKohaCon <http://twitter.com/PerlKohaCon> - Instagram.com/PerlKohaCon <http://instagram.com/PerlKohaCon> - LinkedIn.com/showcase/PerlKohaCon <http://linkedin.com/showcase/PerlKohaCon> - (Mastodon) Fosstodon.org/@perlkohacon <http://fosstodon.org/@perlkohacon> Feel free to use the platform where you have the most connections to share and spread the word! *🙏 "Kiitos" - this means "Thank you" in Finnish.* Btw, and sounds as it reads, no fine prints! Please share this message with colleagues and friends who might be interested in presenting at the conference or attending. Together, let's make this event a significant and enriching experience for both the Koha and Perl communities! 🚀 ... and we look forward to seeing you in Helsinki! Warm regards, The Perl and Koha Conference Organizing Team === Andrii and the National Library of Finland Koha team!

2 2

Where is the Spine Label/Barcode Label Creator in 22.11
by Evan Stewart 02 May '23

02 May '23

Hello, I cannot find the barcode/spine label creator in Koha 22.11. It was in the Tools menu before I upgraded to 22. I want to print a label showing the barcode number for my books. Has this tool moved to another area? Does it still exist on 22.11? Thank you for the assistance. -Evan Stewart Hope International School Moshi, Tanzania

2 2

Koha Community Newsletter: April 2023
by Koha Newsletter 30 Apr '23

30 Apr '23

The Koha Community Newsletter for April 2023 is here: https://koha-community.org/koha-community-newsletter-april-2023/ Many thanks to everyone who submitted articles and news to this newsletter! Please feel free to email me with any corrections or suggestions. -- Michael Kuhn Editor, Koha Community Newsletter

1 0

Error 500 with dpkg returned an error code (1)
by library＠ssst.edu.ba 29 Apr '23

29 Apr '23

Hello all, I keep coming up against error 500 when trying to add a record (no matter which framework I try to use or whether it's via a Z39.50 server or manual entry) as well as when going to the About Koha page in the staff interface. When I opened the terminal, there were 2 updates to be applied so I ran the update but it does not work. Here is the entire output: 2 updates can be applied immediately. To see these additional updates run: apt list --upgradable Enable ESM Apps to receive additional future security updates. See https://ubuntu.com/esm or run: sudo pro status Last login: Mon Apr 10 11:34:09 2023 from 10.1.3.133 root@koha:~# apt list --upgradable Listing... Done distro-info-data/jammy-updates 0.52ubuntu0.3 all [upgradable from: 0.52ubuntu0.2] grub-efi-amd64-bin/jammy-updates 2.06-2ubuntu14.1 amd64 [upgradable from: 2.06-2ubuntu10] grub-efi-amd64-signed/jammy-updates 1.187.3~22.04.1+2.06-2ubuntu14.1 amd64 [upgradable from: 1.182~22.04.1+2.06-2ubuntu10] grub-efi-amd64/jammy-updates 2.06-2ubuntu14.1 amd64 [upgradable from: 2.06-2ubuntu10] shim-signed/jammy-updates 1.51.3+15.7-0ubuntu1 amd64 [upgradable from: 1.51+15.4-0ubuntu9] root@koha:~# apt-get update Hit:1 http://ba.archive.ubuntu.com/ubuntu jammy InRelease Hit:2 http://ba.archive.ubuntu.com/ubuntu jammy-updates InRelease Hit:3 http://ba.archive.ubuntu.com/ubuntu jammy-backports InRelease Hit:4 http://ba.archive.ubuntu.com/ubuntu jammy-security InRelease Hit:5 http://debian.koha-community.org/koha stable InRelease Reading package lists... Done W: http://debian.koha-community.org/koha/dists/stable/InRelease: Key is stored in legacy trusted.gpg keyring (/etc/apt/trusted.gpg), see the DEPRECATION section in apt-key(8) for details. root@koha:~# apt-get upgrade Reading package lists... Done Building dependency tree... Done Reading state information... Done Calculating upgrade... Done The following packages will be upgraded: distro-info-data grub-efi-amd64 grub-efi-amd64-bin grub-efi-amd64-signed shim-signed 5 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 1 not fully installed or removed. Need to get 3,699 kB of archives. After this operation, 5,861 kB of additional disk space will be used. Do you want to continue? [Y/n] Y Get:1 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 distro-info-data all 0.52ubuntu0.3 [5,258 B] Get:2 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 grub-efi-amd64 amd64 2.06-2ubuntu14.1 [47.1 kB] Get:3 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 grub-efi-amd64-signed amd64 1.187.3~22.04.1+2.06-2ubuntu14.1 [1,388 kB] Get:4 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 grub-efi-amd64-bin amd64 2.06-2ubuntu14.1 [1,591 kB] Get:5 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 shim-signed amd64 1.51.3+15.7-0ubuntu1 [667 kB] Fetched 3,699 kB in 0s (13.8 MB/s) Preconfiguring packages ... (Reading database ... 152607 files and directories currently installed.) Preparing to unpack .../distro-info-data_0.52ubuntu0.3_all.deb ... Unpacking distro-info-data (0.52ubuntu0.3) over (0.52ubuntu0.2) ... Preparing to unpack .../grub-efi-amd64_2.06-2ubuntu14.1_amd64.deb ... Unpacking grub-efi-amd64 (2.06-2ubuntu14.1) over (2.06-2ubuntu10) ... Preparing to unpack .../grub-efi-amd64-signed_1.187.3~22.04.1+2.06-2ubuntu14.1_amd64.deb ... Unpacking grub-efi-amd64-signed (1.187.3~22.04.1+2.06-2ubuntu14.1) over (1.182~22.04.1+2.06-2ubuntu10) ... Preparing to unpack .../grub-efi-amd64-bin_2.06-2ubuntu14.1_amd64.deb ... Unpacking grub-efi-amd64-bin (2.06-2ubuntu14.1) over (2.06-2ubuntu10) ... Preparing to unpack .../shim-signed_1.51.3+15.7-0ubuntu1_amd64.deb ... Unpacking shim-signed (1.51.3+15.7-0ubuntu1) over (1.51+15.4-0ubuntu9) ... Setting up koha-common (22.11.03-1) ... Upgrading database schema for library DBD::mysql::st execute failed: Table 'koha_library.systempreferences' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152. DBD::mysql::st execute failed: Table 'koha_library.systempreferences' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152. Use of uninitialized value in numeric lt (<) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 78. DBD::mysql::db do failed: Table 'koha_library.bookshelf' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152. DBD::mysql::db do failed: Table 'koha_library.shelfcontents' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152. DBD::mysql::db do failed: Table 'koha_library.virtualshelfcontents' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152. DBD::mysql::db do failed: Table 'koha_library.virtualshelfcontents' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152. Undefined subroutine &main::DropAllForeignKeys called at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 86. dpkg: error processing package koha-common (--configure): installed koha-common package post-installation script subprocess returned error exit status 255 Setting up distro-info-data (0.52ubuntu0.3) ... Setting up grub-efi-amd64-bin (2.06-2ubuntu14.1) ... Setting up grub-efi-amd64 (2.06-2ubuntu14.1) ... Installing grub to /boot/efi. Installing for x86_64-efi platform. Installation finished. No error reported. Sourcing file `/etc/default/grub' Sourcing file `/etc/default/grub.d/init-select.cfg' Generating grub configuration file ... Found linux image: /boot/vmlinuz-5.15.0-69-generic Found initrd image: /boot/initrd.img-5.15.0-69-generic Found linux image: /boot/vmlinuz-5.15.0-60-generic Found initrd image: /boot/initrd.img-5.15.0-60-generic Warning: os-prober will not be executed to detect other bootable partitions. Systems on them will not be added to the GRUB boot configuration. Check GRUB_DISABLE_OS_PROBER documentation entry. Adding boot menu entry for UEFI Firmware Settings ... done Setting up grub-efi-amd64-signed (1.187.3~22.04.1+2.06-2ubuntu14.1) ... Installing grub to /boot/efi. Installing for x86_64-efi platform. Installation finished. No error reported. Setting up shim-signed (1.51.3+15.7-0ubuntu1) ... update-alternatives: using /usr/lib/shim/shimx64.efi.signed.latest to provide /usr/lib/shim/shimx64.efi.signed (shimx64.efi.signed) in auto mode Installing grub to /boot/efi. Installing for x86_64-efi platform. Installation finished. No error reported. Errors were encountered while processing: koha-common needrestart is being skipped since dpkg has failed E: Sub-process /usr/bin/dpkg returned an error code (1) Can anybody advise me on what I should do? Best regards Aida Đikić Librarian

5 12

Koha and IPV6
by Michael Kuhn 28 Apr '23

28 Apr '23

Hi Our library can access the the future virtual machine running Koha only via IPV6. I coulnd't find the terms IPV4 or IPV6 neither in https://wiki.koha-community.org/wiki/System_requirements_and_recommendations nor in the current Koha manual. Thus my question (since until now I have implemented only Koha-installations with IPV4): Is Koha able to run just with IPV6 addresses, also when using Let's Encrypt? Are there maybe some caveats? Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik(a)adminkuhn.ch · W www.adminkuhn.ch

3 3