- Koha - lists.katipo.co.nz

Zebra Index not working
by Bruns, Anke 18 Jan '24

18 Jan '24

Hi, we are facing a similar problem to https://stackoverflow.com/questions/26925152/reindexing-zebra-because-there- are-no-results-found-in-opac-and-intranet-search. I tried rebuilding the Zebra index, also checked the directories' permissions according to https://koha.katipo.co.narkive.com/cc099Nwf/reindexing-zebra-because-there-a re-no-results-found-in-opac-and-intranet-search and tried to reset the Zebra Index, as proposed in https://koha-community.org/manual/16.11/html/apis02.html . None of this shows any effect. According to screen output, the 6 biblios (it's a very new testing instance) are exported and the index is rebuilt as expected. Yet, there are no search results at all. Curiously, the Koha instance where this problem occurs is one of six instances on one and the same server, all other five having fully functional Zebra indexes, and a rebuild on another instance on that server works without any problems. Does anybody have an idea what might be the reason for this? Cheers in advance, Anke -- Anke Bruns M.A. (LIS) Arbeitsgruppe "Anwendungs- und Informationssysteme" E-Mail: anke.bruns(a)gwdg.de ------------------------------------------------- Gesellschaft für wissenschaftliche Datenverarbeitung mbH Göttingen (GWDG) Burckhardtweg 4, 37077 Göttingen, URL: https://gwdg.de Support: Tel.: +49 551 39-30000, URL: https://gwdg.de/support Sekretariat: Tel.: +49 551 39-30001, E-Mail: gwdg(a)gwdg.de Geschäftsführer: Prof. Dr. Ramin Yahyapour Aufsichtsratsvorsitzender: Prof. Dr. Christian Griesinger Sitz der Gesellschaft: Göttingen Registergericht: Göttingen, Handelsregister-Nr. B 598 ------------------------------------------------- Zertifiziert nach ISO 9001 und ISO 27001 -------------------------------------------------

2 2

KOHA Upgraded - Configuration - HTML Customization
by Dr. Yesan S (DLIS) 17 Jan '24

17 Jan '24

Hello All, Recently we migrated Koha 21.05 to a new server and upgraded to Koha 23.05. We found that files in HTML customization are empty in the current installation. HMTL Source codes are not found. We want to modify them. Do we have to import the Koha configuration backup from the old server? Kindly advise. Is there any way to locate them in the current installation? thanks *Dr. Yesan Sellan, * *MLISc., PGDLAN, BCS., UGC-NET., PhD* *(Strategic | Learner | Achiever | Responsibility | Intellection)* Assistant Professor, PG and Research Department of Library and Information Science Bishop Heber College, Puthur PO, Trichy - 620017, INDIA Mobile: 91-9972348251 https://orcid.org/0000-0002-0501-5661 https://www.linkedin.com/in/dr-yesan-sellan-01230336/ -----------------------------------------------IMPORTANT------------------------------------------------------------------------- This message is intended only for the addressee. It may contain confidential information. Any unauthorized disclosure is strictly prohibited. If you have received this message in error, please notify us immediately so that we may correct our internal records. Please then delete the original message. Thank you

1 0

Call for news - Newsletter January 2024
by Koha Newsletter 16 Jan '24

16 Jan '24

Hi I'm collecting news for the January 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

3 3

Reminder: General IRC meeting 17 January 2024
by Fischer, Katrin 16 Jan '24

16 Jan '24

Hi all, just a quick reminder that we have scheduled a General IRC meeting for tomorrow: https://wiki.koha-community.org/wiki/General_IRC_meeting_17_January_2024 Time: https://www.timeanddate.com/worldclock/fixedtime.html?msg=Koha+General+IRC+M eeting <https://www.timeanddate.com/worldclock/fixedtime.html?msg=Koha+General+IRC+ Meeting&iso=20240117T1400> &iso=20240117T1400 Katrin

1 0

Argument "0, 00" isn't numeric in numeric gt (>) at /usr/share/koha/lib/C4/Overdues.pm line 292.
by Michael Kuhn 15 Jan '24

15 Jan '24

Hi Our library is working with Koha 22.05.17. Since some days the anacron job "cron.daily" sends us an e-mail with hundreds of lines like the following every day: Argument "0,00" isn't numeric in numeric gt (>) at /usr/share/koha/lib/C4/Overdues.pm line 292. I see in the circulation and fine rules the "Overdue fines cap (amount)" shows as "0,00" instead of "0.00" as usual. However, this can't be changed at this place. Changing lines in script "Overdues.pm" according to https://gomezcardozo.com/error-en-fines-koha/ didn't help. How can this output be prevented? 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 5

Re: [Koha] Koha Digest, Vol 219, Issue 7 - how to avoid high cpu uses due to web crawlers (vinod mishra)
by Amar Londhe 15 Jan '24

15 Jan '24

Hello, I've observed a concerning issue with our Koha server, where multiple bots are causing downtime and significantly increasing CPU usage. Some of the problematic bots include: * PetalBot;+https://webmaster.petalsearch.com/site/petalbot * MJ12bot/v1.4.8; http://mj12bot.com/ * SemrushBot/7~bl; +http://www.semrush.com/bot.html Despite attempting to address this by adding a robots.txt file, it hasn't proven effective in preventing these bots from causing disruptions. Additionally, the dynamic nature of IP addresses makes it challenging to block them individually. Furthermore, I've noticed that the Apache2 server is generating internal requests, and I'm uncertain about the cause and purpose of these requests. ` ::1 - - [15/Jan/2024:12:40:41 +0530] "OPTIONS * HTTP/1.0" 200 126 "-" "Apache/2.4.41 (Ubuntu) OpenSSL/1.1.1f (internal dummy connection)" ` I need your expertise to fix the bot issues impacting server performance, high CPU usage, and prevent unauthorized internal requests. Thanks and Regards, Amar Londhe Full-Stack Developer On 11/01/24 4:30 am, koha-request(a)lists.katipo.co.nz wrote: > Send Koha mailing list submissions to > koha(a)lists.katipo.co.nz > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.katipo.co.nz/mailman/listinfo/koha > or, via email, send a message with subject or body 'help' to > koha-request(a)lists.katipo.co.nz > > You can reach the person managing the list at > koha-owner(a)lists.katipo.co.nz > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Koha digest..." > > > Today's Topics: > > 1. how to avoid high cpu uses due to web crawlers (vinod mishra) > 2. Re: how to avoid high cpu uses due to web crawlers > (Nirmit Krishnatray) > 3. Re: how to avoid high cpu uses due to web crawlers (vinod mishra) > 4. Re: how to avoid high cpu uses due to web crawlers > (Wagner, Alexander) > 5. koha-US Board Meeting Minutes for January 10, 2024 > (Kristi Krueger) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 10 Jan 2024 12:51:38 +0530 > From: vinod mishra<mishravk79(a)gmail.com> > To: Koha<Koha(a)lists.katipo.co.nz> > Subject: [Koha] how to avoid high cpu uses due to web crawlers > Message-ID: > <CAGLUwiRDAsH66xeQoznjHXxEiGiiGvdTv8P7w5uihM3H93mU2g(a)mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > > Hello > > I found that an IP 47.76.35.19 is hitting my opac continuously, due to > which CPU use is very high, and it makes the entire Koha opac and staff > client very slow. > > I tried following the links but could not resolve the issue. > > https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4042#c3 > https://wiki.koha-community.org/wiki/Koha_Tuning_Guide > > I am also not able to locate the file .htaccess in mu ubuntu 18.04 with > koha 20.04 > Can anyone how to resolve this? > > With Regards, > > Vinod Kumar Mishra, > (Ph.D, MLISC, MA, B.Sc, DCA) > Assistant Librarian, > Biju Patnaik Central Library (BPCL), > NIT Rourkela, > Sundergadh-769008, > Odisha, > India. > Mob:91+9439420860 > URL:https://vinod.itshelp.co.in/ <http://vinod.itshelp.co.in/> > ORCID ID:https://orcid.org/0000-0003-4666-7874 > <http://orcid.org/0000-0003-4666-7874> > Scopus ID: 57223138343 > > *"Spiritual relationship is far more precious than physical. Physical > relationship divorced from spiritual is body without soul" -- Mahatma > Gandhi* > > > ------------------------------ > > Message: 2 > Date: Wed, 10 Jan 2024 07:46:17 +0000 > From: Nirmit Krishnatray<nirmit(a)edutech.com> > To: vinod mishra<mishravk79(a)gmail.com>, Koha > <Koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] how to avoid high cpu uses due to web crawlers > Message-ID:<27ebb0c12a164436a0b59c8be7e46401(a)edutech.com> > Content-Type: text/plain; charset="utf-8" > > Hi sir, > > Try to block the ip that is hitting on your server. > > Best Regards > Nirmit Krishnatray | Associate Manager - Professional Services > DBS Business Center, World Trade Tower, Barakhamba Lane,Connaught Place, > New Delhi – 110001 > M: +91 9003078515 | E:nirmit@edutech.com > Edutech India | LinkedIn | Twitter | Facebook | Youtube > > > -----Original Message----- > From: Koha [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of vinod mishra > Sent: 10 January 2024 12:52 > To: Koha<Koha(a)lists.katipo.co.nz> > Subject: [Koha] how to avoid high cpu uses due to web crawlers > > Hello > > I found that an IP 47.76.35.19 is hitting my opac continuously, due to which CPU use is very high, and it makes the entire Koha opac and staff client very slow. > > I tried following the links but could not resolve the issue. > > https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4042#c3 > https://wiki.koha-community.org/wiki/Koha_Tuning_Guide > > I am also not able to locate the file .htaccess in mu ubuntu 18.04 with koha 20.04 Can anyone how to resolve this? > > With Regards, > > Vinod Kumar Mishra, > (Ph.D, MLISC, MA, B.Sc, DCA) > Assistant Librarian, > Biju Patnaik Central Library (BPCL), > NIT Rourkela, > Sundergadh-769008, > Odisha, > India. > Mob:91+9439420860 > URL:https://vinod.itshelp.co.in/ <http://vinod.itshelp.co.in/> ORCID ID:https://orcid.org/0000-0003-4666-7874 > <http://orcid.org/0000-0003-4666-7874> > Scopus ID: 57223138343 > > *"Spiritual relationship is far more precious than physical. Physical relationship divorced from spiritual is body without soul" -- Mahatma > Gandhi* > _______________________________________________ > > Koha mailing listhttp://koha-community.org Koha(a)lists.katipo.co.nz > Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha > > ------------------------------ > > Message: 3 > Date: Wed, 10 Jan 2024 13:23:31 +0530 > From: vinod mishra<mishravk79(a)gmail.com> > To: Nirmit Krishnatray<nirmit(a)edutech.com> > Cc: Koha<Koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] how to avoid high cpu uses due to web crawlers > Message-ID: > <CAGLUwiTpOGzFrz84VAX5BZvSa7ejZ+riVFmtDEVuy1c-QTGU0A(a)mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > > Thanks that is the ultimate solution, looking for any other effective > solution too if faced in future. Creating robots.txt file seems easy but > finding which crawler is hitting is difficult with IP > > On Wed, 10 Jan, 2024, 13:16 Nirmit Krishnatray,<nirmit(a)edutech.com> wrote: > >> Hi sir, >> >> Try to block the ip that is hitting on your server. >> >> Best Regards >> Nirmit Krishnatray | Associate Manager - Professional Services >> DBS Business Center, World Trade Tower, Barakhamba Lane,Connaught Place, >> New Delhi – 110001 >> M: +91 9003078515 | E:nirmit@edutech.com >> Edutech India | LinkedIn | Twitter | Facebook | Youtube >> >> >> -----Original Message----- >> From: Koha [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of vinod >> mishra >> Sent: 10 January 2024 12:52 >> To: Koha<Koha(a)lists.katipo.co.nz> >> Subject: [Koha] how to avoid high cpu uses due to web crawlers >> >> Hello >> >> I found that an IP 47.76.35.19 is hitting my opac continuously, due to >> which CPU use is very high, and it makes the entire Koha opac and staff >> client very slow. >> >> I tried following the links but could not resolve the issue. >> >> https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4042#c3 >> https://wiki.koha-community.org/wiki/Koha_Tuning_Guide >> >> I am also not able to locate the file .htaccess in mu ubuntu 18.04 with >> koha 20.04 Can anyone how to resolve this? >> >> With Regards, >> >> Vinod Kumar Mishra, >> (Ph.D, MLISC, MA, B.Sc, DCA) >> Assistant Librarian, >> Biju Patnaik Central Library (BPCL), >> NIT Rourkela, >> Sundergadh-769008, >> Odisha, >> India. >> Mob:91+9439420860 >> URL:https://vinod.itshelp.co.in/ <http://vinod.itshelp.co.in/> ORCID ID: >> https://orcid.org/0000-0003-4666-7874 >> <http://orcid.org/0000-0003-4666-7874> >> Scopus ID: 57223138343 >> >> *"Spiritual relationship is far more precious than physical. Physical >> relationship divorced from spiritual is body without soul" -- Mahatma >> Gandhi* >> _______________________________________________ >> >> Koha mailing listhttp://koha-community.org Koha(a)lists.katipo.co.nz >> Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha >> > > ------------------------------ > > Message: 4 > Date: Wed, 10 Jan 2024 10:19:55 +0100 (CET) > From: "Wagner, Alexander"<alexander.wagner(a)desy.de> > To: vinod mishra<mishravk79(a)gmail.com> > Cc: Koha<Koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] how to avoid high cpu uses due to web crawlers > Message-ID:<2002597982.8686470.1704878395276.JavaMail.zimbra(a)desy.de> > Content-Type: text/plain; charset=utf-8 > > Hi! > >> I found that an IP 47.76.35.19 is hitting my opac continuously, due to >> which CPU use is very high, and it makes the entire Koha opac and staff >> client very slow. > This does not look like a legit crawler. So most likely you can't tackle this guy with a robots.txt as most likely it will not respect it anyway. > >> I am also not able to locate the file .htaccess in mu ubuntu 18.04 with >> koha 20.04 >> Can anyone how to resolve this? > `.htaccess` files do not exist by default, you'd have to create it in the appropriate place with proper permissions and ownerships using your favourite text-editor. They are basically folder based firewall rules read by your webserver. IOW you could either use those or have a rule in your apache configs. > > I am no expert in either but on one of our current (non-koha)-systems we use something like > > ``` > > # Turn badips away > RewriteMap hosts-deny "txt:/opt/invenio/var/tmp/hosts-deny.txt" > RewriteCond "${hosts-deny:%{REMOTE_ADDR}|NOT-FOUND}" "!=NOT-FOUND" [OR] > RewriteCond "${hosts-deny:%{HTTP:X-Forwarded-For}|NOT-FOUND}" "!=NOT-FOUND" > RewriteRule .* - [R=429,L] > > ``` > > in the apache configs. This refers to a txt-file in this case in some funny path `/opt/invenio/var/tmp/` called `hosts-deny.txt` that lists the ip-addresses that should be dropped. You could in principle create such a file in some place your apache can see it. This makes it a bit easier to handle unwanted "crawlers" as you just add the offending ips there. > > HTH. >

1 0

Department Name in Item Information
by Rupinder Singh 13 Jan '24

13 Jan '24

Hi, We have been using Koha at our university for the last year. We get allocated a consolidated budget at the beginning of the financial year. And we'd like to spend that budget as per the purchase requests sent by different departments of the university. However we haven't used the acquisition module yet and are not planning to do so. But of all the books we catalog in koha, I also want to save information about the department that requested that book. So that it can be exported via catalog report, so I can see how much of the budget we have spent on each department. And each book item shall have this information for the requesting department in the Items section. Please suggest what the best approach to achieve this could be. Is there any existing field to specify that, or is there any existing field I can make use of to put this information? I have also found certain subfields in 952 item information that are not in use. Can I map a new authorized value to this newly created field? Please, guys, Guide me. Rupinder Singh

2 1

koha-US Board Meeting Minutes for January 10, 2024
by Kristi Krueger 10 Jan '24

10 Jan '24

Hello, Here's a link to the minutes from the koha-US board meeting on Wednesday, January 10, 2024-- https://docs.google.com/document/d/1k-SG3wlk0bA7BD708ZW_Fjmin7CoX1y7tBD3fF3… 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, February 7 @ 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 agenda, please send them to secretary(a)koha-us.org. Kristi Krueger koha-US Secretary secretary(a)koha-us.org

1 0

how to avoid high cpu uses due to web crawlers
by vinod mishra 10 Jan '24

10 Jan '24

Hello I found that an IP 47.76.35.19 is hitting my opac continuously, due to which CPU use is very high, and it makes the entire Koha opac and staff client very slow. I tried following the links but could not resolve the issue. https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4042#c3 https://wiki.koha-community.org/wiki/Koha_Tuning_Guide I am also not able to locate the file .htaccess in mu ubuntu 18.04 with koha 20.04 Can anyone how to resolve this? With Regards, Vinod Kumar Mishra, (Ph.D, MLISC, MA, B.Sc, DCA) Assistant Librarian, Biju Patnaik Central Library (BPCL), NIT Rourkela, Sundergadh-769008, Odisha, India. Mob:91+9439420860 URL: https://vinod.itshelp.co.in/ <http://vinod.itshelp.co.in/> ORCID ID: https://orcid.org/0000-0003-4666-7874 <http://orcid.org/0000-0003-4666-7874> Scopus ID: 57223138343 *"Spiritual relationship is far more precious than physical. Physical relationship divorced from spiritual is body without soul" -- Mahatma Gandhi*

3 3

koha-US Board Meeting Reminder for Wednesday, January 10, 2024
by Kristi Krueger 08 Jan '24

08 Jan '24

Hello! The next koha-US Board Meeting is Wednesday, January 10, 2024. When: 8:30a PT / 11:30a ET (time converter <https://www.timeanddate.com/worldclock/fixedtime.html?msg=koha-US+Board+Mee…> ) Where: https://us02web.zoom.us/j/293750042?pwd=SGQzS2pmU3prNFhYRHNaeTFhOHN4QT09 Agenda: https://docs.google.com/document/d/1-Sy6ORSGNnYk6MNov_IhIK0U3THyPFRJaoOoY75… If you have additional topics for the agenda, please send them to secretary(a)koha-us.org. Meetings are held via Zoom video conferencing. A microphone and webcam are recommended but not required. Zoom is available for Windows, Mac, and Linux on desktops, and Android and iOS on mobile devices. For help getting started, visit: https://support.zoom.us/hc/en-us/categories/200101697 These meetings are always free and open to any and all. Kristi Krueger koha-US Secretary secretary(a)koha-US.org

1 0