- Koha - lists.katipo.co.nz

Batch check outs timing out after upgrade and migration
by Matthew Lindfield Seager 12 Sep '21

12 Sep '21

Hi All, I'm a Koha newbie so I hope this is the appropriate forum for this question, please let me know if not! I'm the ICT Manager in a small school in Phnom Penh that had a working Koha installation. One of our physical servers died and, rather than replace it to get back up to full redundancy, we decided to move our on-prem servers to an IaaS provider (Linode). In the process of restoring Koha onto the new server I discovered we were running Koha 20.05 on the old server and 21.05 on the new server. I then made the fateful mistake of proceeding with both changes at once (despite knowing better 😔). I upgraded the old server to 21.05 and then backed up and restored onto the new server (both Ubuntu 20.04 LTS). I also added TLS using Let's Encrypt at the same time. It all seemed to go smoothly but we're now experiencing slow performance when checking out and looking up patrons and we're getting gateway timeouts when we try to use Batch Check Out. Does anyone have any tips on how to troubleshoot this? So far I've: - checked specs (new server is a "dedicated" 4GB VM with specs equivalent to or better than the old server) - tried to find any configuration differences between the old server and the new server - looked through the wiki pages on performance <https://wiki.koha-community.org/wiki/Performance> and tuning <https://wiki.koha-community.org/wiki/Koha_Tuning_Guide> to see if there's anything we'd done on the old server but not on the new In the process I discovered that the old server was running on MariaDB 10.3.31 whereas I installed MySQL 8.0.26 on the new server. Could that be the source of all our issues or is that a red herring? To rule out MariaDB as the issue I've tried backing up the new server and restoring it on to an even newer server with MariaDB installed but so far I've not been successful in getting Koha running on MariaDB, despite successfully running the restore (after adjusting the SQL dump to change from MySQL's `utf8mb4_0900_ai_ci` collation to MariaDB's `utf8mb4_general_ci `). Has anyone got any nuggets of wisdom? I fear our next best option might be to create a new (MariaDB) server from the original back ups and manually re-enter the past 4 days worth of borrowing and returns 😔 Regards, Matt

2 1

Search/List RSS feeds (trigger? add call number?)
by Bales (US), Tasha R 12 Sep '21

12 Sep '21

Good morning, I'm writing with a couple questions about out-of-the-box RSS feeds for searches. I'm interested in how to modify them (I really need one or more of our call numbers/classification numbers to be included), and how they are triggered. I see two types of feeds, below. "Subscribe to this search" * The manual says this feed "will allow you to see when a new item is added to the catalog". * How is a "new item" defined? I've taken a look at opac-opensearch.tt and opac-search.pl, in order to under how date limiting is coming in to play, specifically (which dates, what comparison, what fields, etc.). I do see reference to an 005 date "hack" for Atom, but it seems like only the RSS portions of the code are relevant. I'd like to determine if I can only ever expect newly added records to be returned, or would/could updated records also be returned? "Subscribe to this list" * I don't see information about this feed in the manual. * Since this is a search about already-cataloged, known items, it wouldn't make sense for the RSS to retrieve only newly cataloged records. Therefore, what should trigger a subscriber to receive an update about their list if an item has been updated? Is it the bib 005, or something else? I've tried editing a few records in a list I am subscribed to, expecting to get a new email, but I didn't receive a message. Although this last part may sound confusing, I'm leaving as is, as it may help explain context-I've added the feeds to my Microsoft Outlook, where each matching item shows up as a discrete "email" message in my RSS Feeds folder. Maybe the problem here is my understanding of RSS. My feeds appear to be refreshed every time I check my mail, but I'm only receiving RSS for newly added records. I didn't receive a new feed today of records in my "list" that I edited yesterday. Finally, I find that the RSS output is not usable for my patrons. We really need call number to be included in the RSS. It looks like we could modify the template line below to swap out isbn with another identifier, but I'm not sure how to know what term to swap in after "SEARCH_RESULT.": <dc:identifier>ISBN:[% SEARCH_RESULT.isbn | html %]</dc:identifier> I've tried "report-number", "callnum", "lcn", and "local-classification", which all failed to produce results. Please advise if there are any known examples about customizing the RSS templates for the basic searches above (I didn't see anything promising in the Wiki, when I searched for "RSS" or "opensearch.tt"). Thanks so much for your time, Tasha Bales Enterprise Services http://isesi.web.boeing.com/

2 3

VuFind Summit 2021
by mohan pradhan 10 Sep '21

10 Sep '21

Central Department of Library and Information Science, TU in partnership with Villanova University’s Falvey Memorial Library, the VuFind Summit 2021 is going to be organized on November 15-17, 2021. Welcome you all for presenting your paper and participation. For details click the link: VuFind Summit 2021 <https://vufind.org/wiki/community:conferences:summit_2021:cfp#call_for_pape…> Prof. Mohan Raj Pradhan, Ph. D. Secretary VuFind Software

1 0

Security releases for all stable branches - UPGRADE!
by Jonathan Druart 09 Sep '21

09 Sep '21

Hello everybody, Don't ignore this email! Last week a critical security bug was reported on our bug tracker. We fixed it and built debian packages for the four stable releases we currently support. The security flaw can cause a privilege escalation from OPAC users. It can be highly damaging, especially if your staff interface is accessible via login from everywhere without further security measures like IP restrictions in place. How to fix the problem? If you are using a debian-based system you should upgrade using the debian packages: % apt update % apt install koha-common If you are using an older version of Koha (<19.11) you should either upgrade to a newer version, or apply those two patches (they should apply on older versions as well): https://paste.debian.net/hidden/885fb5ec/ https://paste.debian.net/hidden/1184f523/ https://paste.debian.net/plainh/ae9f9f25 You can apply them using the following command: % wget "https://paste.debian.net/plainh/885fb5ec" -O 28929_1.patch % wget "https://paste.debian.net/plainh/1184f523" -O 28929_2.patch % wget "https://paste.debian.net/plainh/ae9f9f25" -O 28947.patch % patch -p1 -d /usr/share/koha/intranet/cgi-bin/ < /kohadevbox/koha/28929_1.patch % patch -p1 -d /usr/share/koha/opac/cgi-bin/ < /kohadevbox/koha/28929_2.patch % patch -d /usr/share/koha/opac/cgi-bin/opac/ < /kohadevbox/koha/28947.patch The two bugs are 28929 and 28947. As they contain information about how to recreate the vulnerability they will stay hidden two more days to let you upgrade your systems. Let us know if you have any questions! Regards, Jonathan

3 4

install koha
by stefan 09 Sep '21

09 Sep '21

Hi, I'm from Romania, I'm a librarian and I want to install koha on the library computer. I tried using the instructions at https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Install_Ubun… but without success. On the computer i have ubuntu 20.04.3. I want to install koha and then get in the system all the books in the library and all the students that come to the library. I want to get koha up and running individually on this local computer. I don't have a system admin at the school. The computer is connected to the internet. Can somebody explain to me how i configure /etc/koha/koha-sites.conf? Also, what is the difference between web install and IP install. What would be best form me? I don't know about domain names and INTRAPORT AND OPACPORT...

3 2

500 error when choosing patron for purchase suggestion
by Jesse Stallings 09 Sep '21

09 Sep '21

Running 21.05.02 on Debian stretch 9.13. When selecting "set to patron" or "select manager" while entering a purchase suggestion from the staff console, a 500 error rather than a patron search box appears in the popup. This issue seems related to bug 26738 <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26738>, where suggestion managers and patrons were unable to be saved, but I'm unable to get even that far. I'm not sure how to troubleshoot this—has anyone else run into this issue? Created bug report 28946 <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28946> last week, but hasn't received any attention. Thanks!

1 0

Elasticsearch error stops bulkmarcimport
by Bales (US), Tasha R 07 Sep '21

07 Sep '21

I've occasionally seen this error when loading MARC record on the command line using bulkmarcimport.pl: Bad response received when submitting request to Elasticsearch. When it occurs, the bulkmarcimport ceases, interrupting the load. I've found nothing else in any other logs on the Koha server that help explain the error. I'm not sure what Elasticsearch has to do with my bulkmarcimport, unless it is Elasticsearch trying to index records on-the-fly after they are loaded? Is there an easy way to prevent this error from happening? Perhaps I should stop the Elasticsearch process while doing a bulkmarcimport? My Elasticsearch servers are external to the Koha environment, and I don't see any obvious indexing processes running on my local machine, so I'm not sure how best to intervene to prevent the above issue. I'm currently working my way through loading 1.3 million records, and I've had several redo's already as a result of loads being interrupted partway through (running bulkmarcimport via a cronjob helped *a lot*, but now I've had two ES errors/interruptions in the last day, which has put me a day behind). I am currently working with batches of 200K records or less. Thanks for any tips you may have! In the meantime, I will modify my latest MARC file to try to remove records already loaded and then resubmit the job (in order to save additional hours spent reloading 98K records). Tasha Bales Enterprise Services http://isesi.web.boeing.com/

1 0

Out Of Office until 21 September 2021
by sheralynb 04 Sep '21

04 Sep '21

Thank you for contacting me. I will be out of the office until 21 September 2021 and not checking email. In the event of an emergency, please contact kimc(a)latahlibrary.org. Sheralyn Bassett She/Her/Hers Manager of Technical Services Latah County Library District 110 S. Jefferson, Moscow ID 83843 208-882-3925 ext 120

1 0

report to show the listing of titles entered by each Librarian
by Victor Barroso Oliveira 03 Sep '21

03 Sep '21

Good morning, This report allows you to view the number of items entered for each Librarian. SELECT concat(p.firstname, ' ', p.surname) AS Operador, concat(a.action, ' ', a.info) AS Ação, count(a.timestamp) AS Quantidade FROM action_logs a LEFT JOIN borrowers p ON (a.user=p.borrowernumber) WHERE a.module='CATALOGUING' AND a.timestamp BETWEEN <<Data Inicial (dd.mm.yyy)|date>> AND <<Data Final (dd.mm.yyy)|date>> AND a.info IN ('item','biblio') GROUP BY p.borrowernumber, concat(a.action, ' ', a.info) How can I change this report to show the listing of titles entered by each Librarian?

1 0

List of all cataloged items and the users who inserted the item.
by Victor Barroso Oliveira 02 Sep '21

02 Sep '21

Good afternoon, What would be the sql code to generate a report with a list of all cataloged items and the users who inserted the item.

1 0