- Koha - lists.katipo.co.nz

Patron not searchable after initial login with LDAP
by Andreas Tomiak 15 Apr '24

15 Apr '24

Hello, a new user has successfully created a new patron record. If we try to search him, the administrative interface returns empty pages. We don´t find any hint in the log files. A database error? The user was created automatically after his first login with LDAP data. Any hints to fix this? We are using the actual Koha version, restart of koha-common or MariaDB and a full system restart does not change the weird behaviour. Thanks Andreas Tomiak -- Dr. Andreas Tomiak Bibliotheksleiter ORCID https://orcid.org/0000-0002-3952-5416 SCOPUS Author ID 16450079500 ResearcherID M-5165-2015 SSR DEA900130625 GND 1132720850 VIAF ID 166149616483803750669 http://viaf.org/viaf/166149616483803750669 Call sign DH7ADR Tel.: +49 30 8062 42593, +49 160 9360 2804, Fax: +49 30 8062 42953 ________________________________________________________________________________________________ Helmholtz-Zentrum Berlin für Materialien und Energie GmbH Mitglied der Hermann von Helmholtz-Gemeinschaft Deutscher Forschungszentren e.V. Aufsichtsrat: Vorsitzender Dr. Volkmar Dietz, stv. Vorsitzende Dr. Jutta Koch-Unterseher Geschäftsführung: Prof. Dr. Bernd Rech, Thomas Frederking Sitz Berlin, AG Charlottenburg, 89 HRB 5583 Postadresse: Hahn-Meitner-Platz 1 14109 Berlin Deutschland Ringgold ID (RIN) 28340 ISNI http:/isni.org/isni/0000000110903682 ROR https://ror.org/02aj13c28 GRID https://grid.ac/institutes/grid.424048.e

2 1

Mattermost - the new place to be for all things Koha
by Auld, Andrew 15 Apr '24

15 Apr '24

*Mattermost - the new place to be for all things Koha* chat.koha-community.org Many of us have been discussing for ages how we would like to improve communication across the Koha Community and these discussions really came to a head at Hackfest last week in Marseille. We all decided that we needed a new tool that is as inclusive as possible, open source, modern, easy to use and familiar. The tool selected is Mattermost and you can start to use it straight away to ask questions, discuss bugs, raise issues or find out news about the Koha project. It will take a few weeks to settle into, and to implement all of the connections, integrations and bots that will make it as near perfect as a tool can be, but if you are happy to just dive in, then go over to chat.koha-community.org and log in. There is currently a bridge to IRC so that anything posted in IRC appears in a channel in Mattermost and anything posted in that channel (in Mattermost) appears in IRC. There are no plans to leave IRC completely - it will take time for everyone to get used to Mattermost and for the community to make sure it isn’t cutting out any voices if it does decide to stop using IRC. The current Mailing lists are also unaffected by this change. PTFS Europe is hosting the Koha Community Mattermost server and there are a number of admin users across the community. -- Andrew Auld Commercial Director PTFS Europe [image: Phone icon] M: +44 7811 370104 | T: +44 1483 378728 ext. 1010 [image: Email icon] andrew.auld(a)ptfs-europe.com [image: Link icon] www.ptfs-europe.com Sign up for our Newsletter. <http://eepurl.com/dPjjkn> <http://www.linkedin.com/company/ptfs-europe-limited> <http://youtube.com/@PTFSEurope> [image: Click to open PTFS Europe webpage] <https://www.ptfs-europe.com>

1 0

Content of tags <request> and <baseURL> in OAI-PMH
by Michael Kuhn 14 Apr '24

14 Apr '24

Hi In our library we are using Koha 21.11.10 We are trying to use OAI-PMH but when calling https://bibliothek.iunworld.com/cgi-bin/koha/oai.pl?verb=Identify the output is as follows: <?xml version="1.0" encoding="UTF-8"?> <?xml-stylesheet type='text/xsl' href='/opac-tmpl/xslt/OAI.xslt'?> <OAI-PMH xsi:schemaLocation='http://www.openarchives.org/OAI/2.0/ http://www.openarchives.org/OAI/2.0/OAI-PMH.xsd' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns='http://www.openarchives.org/OAI/2.0/'> <responseDate>2024-04-03T16:39:53Z</responseDate> <request verb='Identify'>https://bibliothek.iunworld.com/opac/oai.pl</request> <Identify> <repositoryName>IUN World</repositoryName> <baseURL>https://bibliothek.iunworld.com/opac/oai.pl</baseURL> <protocolVersion>2.0</protocolVersion> <adminEmail>root@localhost</adminEmail> <earliestDatestamp>2020-01-21T13:25:14Z</earliestDatestamp> <deletedRecord>persistent</deletedRecord> <granularity>YYYY-MM-DDThh:mm:ssZ</granularity> <compression>gzip</compression> </Identify> </OAI-PMH> As you see in both the tags <request> and <baseURL> there is an incorrect URL ( https://bibliothek.iunworld.com/opac/oai.pl ) which only leads to a 404 error page. The correct URL would be https://bibliothek.iunworld.com/cgi-bin/koha/oai.pl I have changed the following line in file "/usr/share/koha/lib/Koha/OAI/Server/Identify.pm" to get the correct URL at least in tag <baseURL>: #baseURL => $baseURL, baseURL => 'https://bibliothek.iunworld.com/cgi-bin/koha/oai.pl', But I couldn't find out how to get the correct URL also in tag <request>. In fact I doubt what I'm doing is the correct way but I couldn't find any information in the manual on how to configure OAI-PMH except via the system preferences. Why is Koha showing the incorrect URL https://bibliothek.iunworld.com/opac/oai.pl at all and how can I change this? 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 2

Call for news - Newsletter April 2024
by Koha Newsletter 13 Apr '24

13 Apr '24

Hi I'm collecting news for the April 2024 Koha Community Newsletter. Please send anything noteworthy to: kohanews (at) gmail (dot) com News criteria: * News items can be of any length. * Images are fine. * Anything and everything Koha. * Submit by the 26th of the month. Text format criteria: * Just structured plain text, or * HTML text to include tables or similar For events: * Consider adding your event to the Koha Community calendar at https://koha-community.org/calendar/ Thank you! Michael Kuhn Editor, Koha Community Newsletter

1 0

Error 500 when searching in Koha 23.11.0
by Michael Kuhn 13 Apr '24

13 Apr '24

Hi I have updated our database from koha 21.11.10 to the current Koha 23.11.04. When searching the catalogue I get a result list, but when clicking a single hit I get an error 500. In file "plack-error.log" I have found the following line which could be the reason: DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: Unknown column 'issue.renewals_count' in 'field list' at /usr/share/koha/lib/Koha/Objects.pm line 317 In fact there is no table "issue" in Koha 23.11, the correct name of this table is "issues" (see https://schema.koha-community.org/23_11/tables/issues.html) I have searched in Bugzilla but couldn't find a respective bug. But I found the sequence "issue.renewals_count" in https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=137152 so there may be some relation to https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30275 Does anyone know how I can solve this problem with the 500 error? Best wishes: Michael Kuhn -- 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

1 1

Update to Koha 23.11.04 fails
by Michael Kuhn 12 Apr '24

12 Apr '24

Hi Today I tried to update a Koha 21.11.10 database to Koha 23.11.04 but the update process failed at the following point: Upgrade to 23.06.00.068 [22:55:59]: Bug 23798 - Convert OpacMaintenanceNotice system preference to additional contents ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db selectrow_array failed: Unknown column 'id' in 'field list' at /usr/share/koha/lib/C4/Installer.pm line 741 I couldn't find anything regarding this error in Bugzilla, but maybe it is related to https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23798#c12 which shows a similar error regarding an "Unknown column 'title'". How should I proceed? 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

2 2

The Terrific Every-Other-Thursday Training Video | 415
by BRANNON, CHRISTOPHER 11 Apr '24

11 Apr '24

It's spring, and time for spring cleaning! Let's start with clean prints from reports. Sometimes when you print reports from Koha, you get extra little tidbits like menus or wonky margins. Wouldn't it be nice to just tell the report to print, and get exactly that? Christopher will go over a printing technique he shared as part of an episode in season 2, and apply it to reports, and report templates. George will be mostly bored through the whole process, but in the end concede that Christopher has once again done a good thing for the Koha universe. And everyone will ooh and ah. https://youtu.be/fUrd_dZlHMU Sincerely, Christopher Brannon koha-US Admin

1 0

Not possible to create Koha instance with Let's Encrypt
by Michael Kuhn 11 Apr '24

11 Apr '24

Hi I was just installing the most recent Koha 23.11.04-4. But when trying to create my Koha instance with Let's Encrypt I executed the following command: sudo koha-create --create-db mdc --letsencrypt But instead of obtaining a certificate the output ends with the following: (for full output see below): sed: -e Ausdruck #5, Zeichen 53: Unbekannte Option für »s« (in English maybe: sed: -e Expression #5, character 53: Unknown option for »s«) How can I circumvent this problem? Is this maybe the error that Tomas Cohen Arazi mentioned in his mail to the mailinglist on 16:06? 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 koha@mdckoha1:~$ sudo koha-create --create-db mdc --letsencrypt The letsencrypt package is not installed. Do it now? [y/N] y Paketlisten werden gelesen… Fertig Abhängigkeitsbaum wird aufgebaut… Fertig Statusinformationen werden eingelesen… Fertig Hinweis: »certbot« wird an Stelle von »letsencrypt« gewählt. Die folgenden zusätzlichen Pakete werden installiert: python3-acme python3-certbot python3-configargparse python3-distro python3-icu python3-josepy python3-openssl python3-parsedatetime python3-rfc3339 Vorgeschlagene Pakete: python-certbot-doc python3-certbot-apache python3-certbot-nginx python-acme-doc python-openssl-doc python3-openssl-dbg Die folgenden NEUEN Pakete werden installiert: certbot python3-acme python3-certbot python3-configargparse python3-distro python3-icu python3-josepy python3-openssl python3-parsedatetime python3-rfc3339 0 aktualisiert, 10 neu installiert, 0 zu entfernen und 0 nicht aktualisiert. Es müssen 1.013 kB an Archiven heruntergeladen werden. Nach dieser Operation werden 4.739 kB Plattenplatz zusätzlich benutzt. Holen:1 http://deb.debian.org/debian bookworm/main amd64 python3-openssl all 23.0.0-1 [50,8 kB] Holen:2 http://deb.debian.org/debian bookworm/main amd64 python3-josepy all 1.13.0-1 [23,1 kB] Holen:3 http://deb.debian.org/debian bookworm/main amd64 python3-rfc3339 all 1.1-4 [7.088 B] Holen:4 http://deb.debian.org/debian bookworm/main amd64 python3-acme all 2.1.0-1 [32,0 kB] Holen:5 http://deb.debian.org/debian bookworm/main amd64 python3-configargparse all 1.5.3-1 [26,1 kB] Holen:6 http://deb.debian.org/debian bookworm/main amd64 python3-distro all 1.8.0-1 [20,5 kB] Holen:7 http://deb.debian.org/debian bookworm/main amd64 python3-parsedatetime all 2.6-3 [41,2 kB] Holen:8 http://deb.debian.org/debian bookworm/main amd64 python3-certbot all 2.1.0-4 [209 kB] Holen:9 http://deb.debian.org/debian bookworm/main amd64 certbot all 2.1.0-4 [122 kB] Holen:10 http://deb.debian.org/debian bookworm/main amd64 python3-icu amd64 2.10.2-1+b3 [482 kB] Es wurden 1.013 kB in 0 s geholt (20,1 MB/s). Vorkonfiguration der Pakete ... Vormals nicht ausgewähltes Paket python3-openssl wird gewählt. (Lese Datenbank ... 101801 Dateien und Verzeichnisse sind derzeit installiert.) Vorbereitung zum Entpacken von .../0-python3-openssl_23.0.0-1_all.deb ... Entpacken von python3-openssl (23.0.0-1) ... Vormals nicht ausgewähltes Paket python3-josepy wird gewählt. Vorbereitung zum Entpacken von .../1-python3-josepy_1.13.0-1_all.deb ... Entpacken von python3-josepy (1.13.0-1) ... Vormals nicht ausgewähltes Paket python3-rfc3339 wird gewählt. Vorbereitung zum Entpacken von .../2-python3-rfc3339_1.1-4_all.deb ... Entpacken von python3-rfc3339 (1.1-4) ... Vormals nicht ausgewähltes Paket python3-acme wird gewählt. Vorbereitung zum Entpacken von .../3-python3-acme_2.1.0-1_all.deb ... Entpacken von python3-acme (2.1.0-1) ... Vormals nicht ausgewähltes Paket python3-configargparse wird gewählt. Vorbereitung zum Entpacken von .../4-python3-configargparse_1.5.3-1_all.deb ... Entpacken von python3-configargparse (1.5.3-1) ... Vormals nicht ausgewähltes Paket python3-distro wird gewählt. Vorbereitung zum Entpacken von .../5-python3-distro_1.8.0-1_all.deb ... Entpacken von python3-distro (1.8.0-1) ... Vormals nicht ausgewähltes Paket python3-parsedatetime wird gewählt. Vorbereitung zum Entpacken von .../6-python3-parsedatetime_2.6-3_all.deb ... Entpacken von python3-parsedatetime (2.6-3) ... Vormals nicht ausgewähltes Paket python3-certbot wird gewählt. Vorbereitung zum Entpacken von .../7-python3-certbot_2.1.0-4_all.deb ... Entpacken von python3-certbot (2.1.0-4) ... Vormals nicht ausgewähltes Paket certbot wird gewählt. Vorbereitung zum Entpacken von .../8-certbot_2.1.0-4_all.deb ... Entpacken von certbot (2.1.0-4) ... Vormals nicht ausgewähltes Paket python3-icu wird gewählt. Vorbereitung zum Entpacken von .../9-python3-icu_2.10.2-1+b3_amd64.deb ... Entpacken von python3-icu (2.10.2-1+b3) ... python3-configargparse (1.5.3-1) wird eingerichtet ... python3-parsedatetime (2.6-3) wird eingerichtet ... python3-distro (1.8.0-1) wird eingerichtet ... python3-icu (2.10.2-1+b3) wird eingerichtet ... python3-openssl (23.0.0-1) wird eingerichtet ... python3-josepy (1.13.0-1) wird eingerichtet ... python3-rfc3339 (1.1-4) wird eingerichtet ... python3-acme (2.1.0-1) wird eingerichtet ... python3-certbot (2.1.0-4) wird eingerichtet ... certbot (2.1.0-4) wird eingerichtet ... Created symlink /etc/systemd/system/timers.target.wants/certbot.timer → /lib/systemd/system/certbot.timer. Trigger für man-db (2.11.2-2) werden verarbeitet ... Prüfe Prozesse... Prüfe Linux-Kernel... Der laufende Kernel ist aktuell. Es müssen keine Dienste neugestartet werden. Es müssen keine Container neu gestartet werden. Es gibt keine Nutzer-Sitzungen mit veralteten Prozessen. No VM guests are running outdated hypervisor (qemu) binaries on this host. sed: -e Ausdruck #5, Zeichen 53: Unbekannte Option für »s«

1 1

IMPORTANT: Koha hotfix
by Tomas Cohen Arazi 11 Apr '24

11 Apr '24

Hi everyone, we just identified an error on last week's releases and are publishing a quick update. Packages are generally available with the patched versions and should be applied. Source tarballs are a bit delayed but will be published as well. Thanks to all involved -- Tomás Cohen Arazi Theke Solutions (https://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F

1 0

koha-US Board Meeting Minutes for April 10, 2024
by Kristi Krueger 10 Apr '24

10 Apr '24

Hello, Here's a link to the minutes from the koha-US board meeting on Wednesday, April 10, 2024- https://docs.google.com/document/d/1nju6OWnbxCkUDE9-KbWCJvtGAhIH4eT8qiad8B8… koha-US meetings are open to all! Board meetings are held on the second Wednesday of each month at 8:30 PT / 9:30 MT / 10:30 CT / 11:30 ET. The next koha-US General Meeting will be on Wednesday, May 1 @ 8:30 PT / 9:30 MT / 10:30 CT / 11:30 ET (time converter <https://www.timeanddate.com/worldclock/fixedtime.html?msg=koha-US+February+…> ). If you have additional topics for the General Meeting agenda, please send them to secretary(a)koha-us.org. Kristi Krueger koha-US Secretary secretary(a)koha-us.org

1 0