- Koha - lists.katipo.co.nz

LDAP changes from 19.xx to 21.05 ?
by Hector Gonzalez Jaime 12 Oct '21

12 Oct '21

Hello, we recently tried to update our development server to 21.05, and it mostly works, but it does not like our LDAP setup, which is unchanged. plack-error.log is filled with errors from this one: Error while loading /etc/koha/plack.psgi: No ldapserver "hostname" defined in KOHA_CONF: /etc/koha/sites/clavius/koha-conf.xml at /usr/share/koha/lib/C4/Auth_with_ldap.pm line 58, <DATA> line 755. Now, we did not touch our LDAP configuration, which was correct and working with 19.11. Can somebody help find out what changed? Our ldap configuration is like this now: <ldapserver id="ldapserver" listenref="ldapserver"> <hostname>ip.address.for.server</hostname> <base>ou=users,dc=domain,dc=example,dc=org</base> <replicate>1</replicate> <update>1</update>  <auth_by_bind>1</auth_by_bind> <principal_name>uid=%s,ou=users,dc=domain,dc=example,dc=org</principal_name> <mapping>  <firstname is="givenname" ></firstname> <surname is="sn" ></surname> <address is="postaladdress" ></address> <city is="l" >Tijuana, BCN</city> <zipcode is="" ></zipcode> <branchcode is="" >TJNA</branchcode> <userid is="uid" ></userid> <password is="" ></password> <email is="mail" ></email> <phone is="" ></phone> <categorycode is="" >STUDENT</categorycode> <privacy is="" >1</privacy> </mapping> </ldapserver> Thanks. -- Hector Gonzalez cacho(a)genac.org

2 2

koha-US General Meeting reminder: Wednesday, October 13th
by Jason Robb 12 Oct '21

12 Oct '21

The next koha-US general meeting is *tomorrow, *Wednesday, October 13th, 2021. When: 8:30a PT / 11:30a ET / 16:30 UTC (time converter <https://www.timeanddate.com/worldclock/fixedtime.html?msg=koha-US+October+g…> ) Where: https://us02web.zoom.us/j/648572897?pwd=TUpsRE1TYlFPWWxTWFl4TVovSTJ3Zz09 Agenda: https://docs.google.com/document/d/11nlpg5NQQD5MtOTEu-nsBJo6JqJVKNROzg3th0O… This month we'll be recapping the conference. Please join us if you have feedback or input, and remember to stick around after this meeting if you're interested in helping out with next year's conference(s). 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. Jason Robb koha-US secretary secretary(a)koha-us.org

1 0

Reports timing out, prevents access to web interfaces
by Bales (US), Tasha R 12 Oct '21

12 Oct '21

Good afternoon, I'm experiencing an issue where if I'm working in the staff interface and kick off a long-running Report, I'm unable to navigate to or use Koha in any other browser tab, or in any other browser, either in the staff or public interface. I've confirmed that this affects other users working on their own machines too; in other words, my report interrupts their access. I doubt that this is intended behavior. I'm going to try to do some query-tuning (any suggestions for tools to use to optimize/identify inefficient queries?). Any other ideas to troubleshoot this issue? I found an old list post that suggested the Koha Tuning Guide<https://wiki.koha-community.org/wiki/Koha_Tuning_Guide> on the Koha Wiki, but it isn't entirely clear to me if it is comprehensive, or if all parts are relevant to our issue. I'm hesitant to blindly start changing values. Before we pursue the tuning, are there any other suggestions? Is this really a problem that is expected to happen? I should add that long queries that need to be run on a routine basis, we'd run via cronjob. However, I'm worried that staff who work solely on the web might inadvertently run a big one-off report (or do a huge record load, also a problem), and bring down the whole system. FWIW, we have two processors: Intel(R) Xeon(R) Silver 4110 CPU @ 2.10GHz. We have about 1.3 million records and the same number of items. We're using MySQL 5.7, and Koha 20.11.06. Regarding RAM, this is the output of the "free" command, if relevant: total used free shared buff/cache available Mem: 65308616 2038820 41354324 107800 21915472 62437176 Swap: 8257532 780 8256752 Tasha Bales Enterprise Services http://isesi.web.boeing.com/

3 5

Bywater solutions Support Plugin gives 500 error
by Dhyaneshwar Shukla. 11 Oct '21

11 Oct '21

After successful installation and configuration of ByWater Solutions Support Plugin , when i try to run the plugin it gives an error 500. Please help.

1 0

ElasticSearch faceted search
by Thomas Klausner 11 Oct '21

11 Oct '21

Hi! I'm trying to add a new facet, but it seems that the field names available for faceted search are hardcoded in the source code in Koha::SearchEngine::Elasticsearch->get_facetable_fields It also seems that any changes I make via the UI in admin/searchengine/elasticsearch/mappings.pl are not saved to the DB. Is this UI not meant for updated? Here: https://koha-community.org/manual/21.05/en/html/searching.html#elasticsearc… some yaml files are mentioned. Do I need to edit those files and the UI is just a red herring? Greetings, domm -- #!/usr/bin/perl https://domm.plix.at for(ref bless{},just'another'perl'hacker){s-:+-$"-g&&print$_.$/}

1 0

[KOHA] Software Error :
by Neeraj Sharma 08 Oct '21

08 Oct '21

Greetings of the day!!! I am experiencing the following error after successfully web installation. If there is any solution of it please let me know. Software error: DBIx::Class::Storage::DBI::_dbh_execute(): Table 'koha_library.discharges' doesn't exist at /usr/share/koha/lib/Koha/Patron/Discharge.pm line 32 For help, please send mail to the webmaster ([no address given]), giving this error message and the time and date of the error. Hoping to hear from you soon. Thanks & Regards -Neeraj Sharma

2 1

Regarding KOHA Web Installer Issue.
by Neeraj Sharma 08 Oct '21

08 Oct '21

Greetings of the day !!! I'm experiencing the following issue during KOHA Web Installation. The following error occurred while importing the database structure: [Thu Oct 7 15:45:42 2021] install.pl: DBD::mysql::st execute failed: Column 'frombranch' cannot be used in a check constraint 'transport_cost_chk_1': needed in a foreign key constraint 'transport_cost_ibfk_1' referential action. at /usr/share/perl5/DBIx/RunSQL.pm line 279, <$args{...}> line 1. Please contact your system administrator It is requested to provide the solution for the mentioned issue. -- Thanks & Regards Neeraj Sharma

2 1

Re: [Koha] Framework Reports
by Charles Kelley 07 Oct '21

07 Oct '21

Hi, all! In our latest exchange, on 3 Oct. 2021 at 08:01 [JST], I received this through the Koha Discussion Group: for the existing runtime parameters you can refer to the manual: > > > https://koha-community.org/manual//21.05/en/html/reports.html#report-from-s… > > The one for frameworks is <<Framework list|biblio_framework>> > Thank you for the advisement. My report works properly now excepting for one problem: While I now get a proper list, when I press the Download button, I get only the header. The actual downloaded report is empty excepting for the header. Worse, the downloaded report is empty only when the selected framework is the default. The reports for the other frameworks, e.g., BK (for textual materials), do indeed download the biblionumber, author, and title. Here's the SQL instruction in its entirety: SELECT biblio.biblionumber AS 'Bib. Record No.', biblio.author AS 'Author', > biblio.title AS 'Title' > FROM biblio > WHERE biblio.frameworkcode = <<Which framework?|biblio_framework>> > ORDER BY biblio.biblionumber ASC > This happens to all three download file options: CSV, TAB, and ODS. Any advice on fixing this? Is this a bug? I didn't see such a bug on Bugzilla, so I submitted one, by the way. -- 気を付けて。 /ki wo tukete/ = Take care. -- Charles. Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338 Charles Kelley Tsukimino 1-Chome 5-2 Tsukimino Gaadenia #210 Yamato-shi, Kanagawa-ken 〒242-0002 JAPAN +1-301-741-7122 [US cell] +81-80-4356-2178 [JPN cell] mnogojazyk(a)aol.com [h] cmkelleymls(a)gmail.com [p] linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> Meeting Your Information Needs. Virtually.

2 4

stack number cannot be stored in Koha 21.05
by Michael Kuhn 06 Oct '21

06 Oct '21

Hi In our library we use Koha 21.05.02 on Debian GNU/Linux 11. As we found out it not possible to store the content of field 952$j (stack / shelving control number) in the Koha database. I have also tested this on my demo installation with Koha 21.05.00 and on another demo installation with Koha 21.05.04 - everywhere the same. Can anyone please confirm this? If yes, I will open a bug report. 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 4

koha-US October 2021 Events & Meetings
by Jason Robb 05 Oct '21

05 Oct '21

*Meetings* Board Meeting - Wednesday, October 6th @ 8:30a PT / 11:30a ET / 15:30 UTC - Meeting Link - https://us02web.zoom.us/j/293750042?pwd=SGQzS2pmU3prNFhYRHNaeTFhOHN4QT09 - Agenda - https://docs.google.com/document/d/1iILfKHuxG6-yGvhliMUUXYloFyRRt8UcwDZqr0e… General Meeting - Wednesday, October 13th @ 8:30a PT / 11:30a ET / 15:30 UTC *The conference committee will meet directly following this meeting - stick around if you'd like to help out with next year's conference(s).* *Special Interest Groups* Cataloging - Thursday, October 7th @ 8:00a PT / 11:00a ET / 15:00 UTC System Administration - Tuesday, October 12th @ 8:00a PT / 11:00p ET / 15:00 UTC Acquisitions - Tuesday, October 19th @ 9:00a PT / 12:00p ET / 16:00 UTC Web Development - Thursday, October 21st @ 10:00a PT / 1:00p ET / 17:00 UTC Books & Crafts - Wednesday, October 27th @ 5:00p PT / 8:00p ET / 00:00 UTC Visit http://koha-us.org/special-interest-groups/ to learn more and sign up for topic-specific mailing lists. koha-US online meetings and events are free and open to all. See our calendar for a full list: http://koha-us.org/calendar/. For Google Calendar users, add our events calendar for easy access to meeting times and links: https://calendar.google.com/calendar/u/1?cid=a29oYS11cy5vcmdfZG1xb2pkczE5Zn… Most meetings and events are recorded and made available at https://www.youtube.com/kohaus Jason Robb koha-US Secretary secretary(a)koha-us.org

1 0