- Koha - lists.katipo.co.nz

Re: [Koha] Unable to run the indexing after installing elastic search
by Katrin Fischer 04 Aug '24

04 Aug '24

Hi, it looks like Elasticsearch might not be running or not be correctly installed/configured for your Koha installation. Unfortunately I don't know how to best debug this. Maybe others might be able to weigh in here. Katrin On 30.07.24 07:59, Nirmit Krishnatray wrote: > > Hi Katrin, > > Please find the error below: > > [NoNodes] ** No nodes are available: [http://localhost:9200] called > from sub Search::Elasticsearch::Role::Client::Direct::_ANON_ at > /usr/share/koha/lib/Koha/SearchEngine/Elasticsearch/Indexer.pm line > 437.Something went wrong rebuilding indexes for library > > *Best Regards* > > *Nirmit Krishnatray * > > *From:*Katrin Fischer [mailto:katrin.fischer.83@web.de] > *Sent:* 30 July 2024 00:15 > *To:* Nirmit Krishnatray <nirmit(a)edutech.com>; koha(a)lists.katipo.co.nz > *Subject:* Re: [Koha] Unable to run the indexing after installing > elastic search > > Hi, > > attachments don't work on the mailing list. If you can, the easiest > will be to copy the error message into the email directly. > > Katrin > > On 29.07.24 12:03, Nirmit Krishnatray wrote: > > Hello Katrin > > Hope you’re well. As discussed in the previous mail. Please find > error snip attached, that I’m getting while indexing elasticsearch. > > Best Regards > > Nirmit K > > *From:*Katrin Fischer [mailto:katrin.fischer.83@web.de > <mailto:katrin.fischer.83@web.de>] > *Sent:* Sunday, July 28, 2024 9:16 PM > *To:* Nirmit Krishnatray <nirmit(a)edutech.com> > <mailto:nirmit@edutech.com>; koha(a)lists.katipo.co.nz > *Subject:* Re: [Koha] Unable to run the indexing after installing > elastic search > > Hi, > > I haven't done it from scratch myself yet, but the wiki should > hopefully be helpful: > > https://wiki.koha-community.org/wiki/Koha_on_Debian#Elasticsearch > > Please also check that you install the right Elasticsearch version > that will work with your Koha version: > > https://wiki.koha-community.org/wiki/System_requirements_and_recommendations > > Hope this helps, > > Katrin > > On 28.07.24 16:05, Nirmit Krishnatray wrote: > > Hi Katrin, > > Would you be able to please provide the steps to configure > elastic search in koha 23.11. Meanwhile i'll share the error > message i'm getting. > > Best Regards > > signatureImage > > Nirmit Krishnatray | Manager - Professional Services > > DBS Business Center, World Trade Tower, Barakhamba > Lane,Connaught Place, > > New Delhi – 110001 > M: +91 9003078515 <tel:+919003078515> | E: nirmit(a)edutech.com > <mailto:nirmit@edutech.com> > Edutech India <http://www.edutechindia.com/> | LinkedIn > <https://www.linkedin.com/company/edutech-india> | _X_ | > Facebook <https://www.facebook.com/EdutechIN> | Youtube > <https://www.youtube.com/channel/UCaEFU0Cf-eAM9NeeGA8t9gg> > > ------------------------------------------------------------------------ > > *From:*Katrin Fischer <katrin.fischer.83(a)web.de> > <mailto:katrin.fischer.83@web.de> > *Sent:* Sunday, July 28, 2024 7:31:20 PM > *To:* Nirmit Krishnatray <nirmit(a)edutech.com> > <mailto:nirmit@edutech.com>; koha(a)lists.katipo.co.nz > <mailto:koha@lists.katipo.co.nz><koha(a)lists.katipo.co.nz> > <mailto:koha@lists.katipo.co.nz> > *Subject:* Re: [Koha] Unable to run the indexing after > installing elastic search > > Hi, > > can you please also supply the error message? > > Katrin > > On 28.07.24 15:54, Nirmit Krishnatray wrote: > > Hi Katrin, > > Im using this command > > *sudo koha-elasticsearch --rebuild -d library* > > Best Regards > > signatureImage > > Nirmit Krishnatray | Manager - Professional Services > > DBS Business Center, World Trade Tower, Barakhamba > Lane,Connaught Place, > > New Delhi – 110001 > M: +91 9003078515 <tel:+919003078515> | E: > nirmit(a)edutech.com <mailto:nirmit@edutech.com> > Edutech India <http://www.edutechindia.com/> | LinkedIn > <https://www.linkedin.com/company/edutech-india> | _X_ | > Facebook <https://www.facebook.com/EdutechIN> | Youtube > <https://www.youtube.com/channel/UCaEFU0Cf-eAM9NeeGA8t9gg> > > ------------------------------------------------------------------------ > > *From:*Koha <koha-bounces(a)lists.katipo.co.nz> > <mailto:koha-bounces@lists.katipo.co.nz>on behalf of > Katrin Fischer <katrin.fischer.83(a)web.de> > <mailto:katrin.fischer.83@web.de> > *Sent:* Sunday, July 28, 2024 6:36:37 PM > *To:* koha(a)lists.katipo.co.nz > <mailto:koha@lists.katipo.co.nz><koha(a)lists.katipo.co.nz> > <mailto:koha@lists.katipo.co.nz> > *Subject:* Re: [Koha] Unable to run the indexing after > installing elastic search > > Hi, > > what command are you running in order to index and what is > the error > message you see? > > Katrin > > On 28.07.24 14:39, Nirmit Krishnatray wrote: > > Hello all, > > > > I have recently installed elastic search but it gvies an > error while indexing. What could be the issue? > > > > > > Best Regards > > > > Nirmit Krishnatray > > _______________________________________________ > > > > Koha mailing list http://koha-community.org > <http://koha-community.org> > > Koha(a)lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> > > Unsubscribe: > https://lists.katipo.co.nz/mailman/listinfo/koha > <https://lists.katipo.co.nz/mailman/listinfo/koha> > _______________________________________________ > > Koha mailing list http://koha-community.org > <http://koha-community.org> > Koha(a)lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> > Unsubscribe: > https://lists.katipo.co.nz/mailman/listinfo/koha > <https://lists.katipo.co.nz/mailman/listinfo/koha> >

1 0

koha-US August 2024 Events & Meetings
by Kristi Krueger 02 Aug '24

02 Aug '24

Hello! koha-US online meetings and events are free and open to all. *Please note that the August meetings schedule is a little different from other months to accommodate the koha-US Annual Conference from August 13-16. * See our calendar for a full list: http://koha-us.org/calendar/. For Google Calendar users, add our events calendar to your list for easy access to meeting times and links: https://calendar.google.com/calendar/u/1?cid=a29oYS11cy5vcmdfZG1xb2pkczE5Zn… *Meetings * General Meeting - Wednesday, August 14 @ 8:45a PT / 11:45a ET / 15:45 UTC Board Meeting - Wednesday, August 7 @ 8:30a PT / 11:30a ET / 15:30 UTC *Special Interest Groups* Cataloging - Thursday, August 1 @ 8:00a PT / 11:00a ET / 15:00 UTC System Administration - No meeting in August. Next meeting: September 10. Circulation - Thursday, August 8 @ 8:00a PT / 11:00a ET / 15:00 UTC Acquisitions - Tuesday, August 20 @ 9:00a PT / 12:00p ET / 16:00 UTC Web Development - No meeting in August. Next meeting: September 19. Consortia - Thursday, August 22 @ 9:00a PT / 12:00p ET / 16:00 UTC Visit http://koha-us.org/special-interest-groups/ to learn more and sign up for topic-specific mailing lists. Most meetings and events are recorded and made available at https://www.youtube.com/kohaus Kristi Krueger koha-US Secretary secretary(a)koha-US.org

1 1

Re: [Koha] Out of memory when Koha starts due to opac-search.pl and 500.pl
by David Cook 02 Aug '24

02 Aug '24

Hi Mike, It certainly sounds like a crawler/bot getting stuck in a loop. In your log there, I see the client IP address 190.92.203.86, which belongs to Huawei Cloud Singapore. I've seen a lot of bots/crawlers from Huawei Cloud Singapore hitting Australian Koha sites over the last 6 months or so. That 'AH02811: script not found or unable to stat: /usr/lib/cgi-bin/koha' error is interesting. If you look at /etc/apache2/conf-enabled/serve-cgi-bin.conf, you'll see that at a global level /cgi-bin/ is aliased to /usr/lib/cgi-bin. So if the crawler sent any HTTP requests using your IP address and not the hostname, they'd be caught by that directive instead of your name-based virtual host. Could be some other explanations for why the virtual host wasn't used, but overall that would explain that message. Anyway, it's not necessarily a Koha-specific issue. If you're not already using it, I'd suggest you look at installing and setting up something like fail2ban. That said, I have noticed the bots out of Huawei Cloud Singapore tend to cycle through a lot of different IP addresses, which does make things tricky. Sometimes, it'll just use one IP address that is easy to detect and block, but sometimes it might just do 1-2 hits per IP address (from a variety of different IP ranges). Let me know if you'd like to chat more about it. David Cook Senior Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 0899 Online: 02 8005 0595 -----Original Message----- Date: Sat, 13 Jul 2024 21:10:36 +1000 From: Mike Lake <mikel(a)speleonics.com.au> To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Out of memory when Koha starts due to opac-search.pl and 500.pl Message-ID: <f034d85a454901421773c0f4df4a045f(a)speleonics.com.au> Content-Type: text/plain; charset=UTF-8; format=flowed Hi Katrin suggested: > it might be that you are hit by a bad crawler/bot Thanks Katrin. That *may* have been the cause. The system is working OK at present. I did a complete shutdown and reboot. I did notice in the opac-error.log, which is now over 10 MB, a recurring query (see below) that was being made every 30 seconds. Exact same query, clearly automated. That seems to have ended now. cgi-bin/koha/opac-search.pl?q=ccl%3Dau%3A%22James%2C%20Julia%20M.%22%20and%20itype%3ABK%20and%20su-to%3ACaves%20and%20ccode%3AArX%20and%20ccode%3AArX%20and%20holdingbranch%3AASFLIB%20and%20au%3AMartin%2C%20D.J.%20and%20au%3AWelch%2C%20Bruce%20R.%20and%20location%3AARC&sort_by=relevance_dsc&limit=available I was also getting these errors which were filling up the logs: [Fri Jul 12 21:24:30.948916 2024] [cgi:error] [pid 17819] [client 190.92.203.86:51260] AH02811: script not found or unable to stat: /usr/lib/cgi-bin/koha There is no such perl script $ dpkg -L koha-common | grep '/usr/lib/cgi-bin/' so I just created one to return "hello". Now our Koha instance is back up again and our VM is coping with the load. https://opac.caves.org.au Thanks for the reply. I'll make another separate post on another current opac-error.log error line, if it still persists, after I upgrade from 23.11.05 Mike ASF Sys Admin On 2024-07-13 7:34 pm, Katrin Fischer wrote: > Hi Mike, > > it might be that you are hit by a bad crawler/bot and need to block > access for them in your firewall. There are some that ignore the > robots.txt and they can bring down a Koha server. > > I you look at the Apache access logs you might see that all those > requests come from the same IP address. > > Hope this helps, > > Katrin > > On 10.07.24 13:02, Mike Lake wrote: >> Hi all >> >> I'm having serious problems with my Koha instance. It serves the OPAC >> for the Australian Speleological Federation. We are currently on Koha >> 23.11 on a Debian 10.13. The system has been running fine for ages. >> >> I was getting errors from the OOM killer: >> >> oom_reaper: reaped process 1554 (opac-search.pl), now anon-rss:0kB, >> file-rss:0kB, shmem-rss:0kB >> opac-search.pl invoked oom-killer: >> gfp_mask=0x6200ca(GFP_HIGHUSER_MOVABLE), nodemask=(null), order=0, >> oom_score_adj=0 >> opac-search.pl cpuset=/ mems_allowed=0 >> >> So I shutdown Koha (took a while as I was out of memory) >> systemctl stop koha-common.service >> >> Rebooted the machine and when i bought Koha up: >> systemctl start koha-common.service >> Now I'm still getting 96 processes & errors taking all CPU and memory: >> >> 3620 R /usr/bin/perl >> /usr/share/koha/opac/cgi-bin/opac/opac-imageviewer.pl >> 3622 R /usr/bin/perl /usr/share/koha/opac/cgi-bin/opac/errors/500.pl >> 3624 R /usr/bin/perl /usr/share/koha/opac/cgi-bin/opac/errors/500.pl >> 3625 D /usr/bin/perl >> /usr/share/koha/opac/cgi-bin/opac/opac-search.pl >> 3627 R /usr/bin/perl /usr/share/koha/opac/cgi-bin/opac/errors/500.pl >> 3629 D /usr/bin/perl >> /usr/share/koha/opac/cgi-bin/opac/opac-search.pl >> 3630 R /usr/bin/perl /usr/share/koha/opac/cgi-bin/opac/errors/500.pl >> 3633 D /usr/bin/perl /usr/share/koha/opac/cgi-bin/opac/errors/500.pl >> >> Actually its 96 x opac-search.pl + 57 x 500.pl >> >> A reboot does not help. Every time I start Koha those processes appear >> and take all cores and memory. >> >> I do see that the MariaDB is down. "Failed to start MariaDB 10.3.39 >> database server." >> Attempts to start it: systemctl start mariadb.service >> give that error probably because I'm out of memory does to the 100 >> perl processes running. >> >> A "systemctl stop koha-common.service" does not stop or end those >> opac-search.pl or 500.pl processes. >> >> The /var/log/koha/opac/opac-error.log says: >> >> [cgi:error] [pid 6911] [client 124.243.148.74:47310] End of script >> output before headers: 500.pl >> [cgi:error] [pid 6959] [client 190.92.216.104:41580] End of script >> output before headers: opac-search.pl >> >> Something is borked :-( Help most welcome. >> > _______________________________________________ > > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha -- Mike ------------------------------ Subject: Digest Footer _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha ------------------------------ End of Koha Digest, Vol 225, Issue 8 ************************************

3 2

The Terrific Every-Other-Thursday Training Videos | 423
by BRANNON, CHRISTOPHER 01 Aug '24

01 Aug '24

Koha can't protect you from the perils of the daily grind at your library, but it can at least protect you from deleting a patron account by accident. If you have accounts that you want to prevent others from mistakenly deleting crucial accounts that you depend on for your Koha workflows, be sure to check out this episode. As an added bonus, George will show how to prevent unauthorized staff from changing the setting. He'll even whack them on the hand with a ruler (for an extra fee). https://youtu.be/M23YmpMQ6bI Sincerely, Christopher Brannon koha-US Admin

1 0

REMINDER: General IRC meeting 1 August 2024
by Paul Derscheid 01 Aug '24

01 Aug '24

Hi all, We have a General Jitsi meeting scheduled for now: https://wiki.koha-community.org/wiki/General_IRC_meeting_1_August_2024 Time converter: https://www.timeanddate.com/worldclock/fixedtime.html?msg=Koha+General+IRC+… Sorry, forgot to send this yesterday, the meeting is already in progress. See you there! Paul

1 0

barcodes and price
by Kazım ŞENTÜRK 01 Aug '24

01 Aug '24

Hello, The barcodes below (952$p) field of 952$g - Cost, normal purchase price are not recorded: 302594 305835 314329 I have an Excel file that includes barcode numbers and their price fields like below: 952$p - 952$g 302594 - 16.45 305835 - 10.80 314329 - 9.60 Could we match the barcode numbers registered in KOHA with the barcode numbers in our Excel file to import the price value into 952$g? Best regards Kazım ŞENTÜRK Kütüphane Müdür V. Bursa Uludağ Üniversitesi Kütüphane ve Dokümantasyon Daire Başkanlığı Prof. Dr. Fuat Sezgin Merkez Kütüphanesi Görükle Yerleşkesi Nilüfer / Bursa

2 1

(no subject)
by Ramakant 01 Aug '24

01 Aug '24

⁣Get TypeApp for Android

1 0

Reminder: upcoming general meeting 1 August 2024
by David Nind 01 Aug '24

01 Aug '24

Just a reminder that the General Koha Community meeting is on "today" - 1 August 2024, 13:00 UTC. This meeting is now held quarterly, and is for discussing topics about the Koha Community (generally wider community topics, and not things covered at development or documentation meetings). See the agenda for details (and the video conference link), and feel free to add anything else: https://wiki.koha-community.org/wiki/General_IRC_meeting_1_August_2024 David Nind | david(a)davidnind.com New Zealand

1 0

Koha Community Newsletter: July 2024
by Koha Newsletter 31 Jul '24

31 Jul '24

The Koha Community Newsletter for July 2024 is here: https://koha-community.org/koha-community-newsletter-july-2024/ Many thanks to everyone who submitted articles and news to this newsletter! Please feel free to email me (kohanews(a)gmail.com) with any corrections or suggestions. -- Michael Kuhn Editor, Koha Community Newsletter

1 0

Koha July release with security fixes
by Fridolin SOMERS 30 Jul '24

30 Jul '24

Hello everyone 🤗 The Koha community is proud to announce the July releases: - 24.05.02 - 23.11.07 - 23.05.13 - 22.11.19 It is a bugfix/maintenance release including some security fixes. It is highly recommended to upgrade 🚀 The full release notes will soon be available here: - https://koha-community.org/koha-24-05-02-released - https://koha-community.org/koha-23-11-07-released - https://koha-community.org/koha-23-05-13-released - https://koha-community.org/koha-22-11-19-released Debian packages are already available 📦 Tarballs will be available soon. Best regards 🤓 -- Fridolin SOMERS <fridolin.somers(a)biblibre.com> Software and system maintainer 🦄 BibLibre, France

1 0