January 2022 - Koha - lists.katipo.co.nz

Sorry, your Google login failed
by tony.h 18 Jan '23

18 Jan '23

Greetings, I'm having trouble getting the Google login to work since upgrading/rebuilding Koha (we rebuilt the VPS and followed the install guide: https://wiki.koha-community.org/wiki/Debian) *The problem:* 1) I can log in through my local account, no problem. 2) I then try to login through my Google account 3) After pressing allow from the accounts.google.com site, a message is displayed: /Sorry, your Google login failed. .../ The full message is below. "Log in to your account Google login Sorry, your Google login failed. The email address you are trying to use is not associated with a borrower at this library. Please note that the Google login will only work if you are using the e-mail address registered with this library. If you want to, you can try to log in using a different account Log in with Google If you do not have a Google account, but do have a local account, you can still log in:" There are no errors in the Apache log files. *Configuration* Since we had troubles, I'm following the testing guide to configure the OAuth login: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10988#c68 I removed the Google OAuth entries: DELETE FROM systempreferences WHERE variable LIKE 'GoogleO%'; I then ran the upgrade schema tool, as I did when I imported the db: sudo koha-upgrade-schema keiin_lib I added values back in admin panel (Home › Administration › System preferences > Google OpenID Connect I confirmed the 4 values are displayed in the MySQL DB: SELECT * FROM systempreferences WHERE variable LIKE 'GoogleO%'; Any thoughts? Tony -- View this message in context: http://koha.1045719.n5.nabble.com/Sorry-your-Google-login-failed-tp5895227.… Sent from the Koha-general mailing list archive at Nabble.com.

5 5

Request for Libraries using Koha to participate in the 2021 Library Automation Perceptions survey
by Marshall Breeding 03 Nov '22

03 Nov '22

To all libraries using Koha: I'm collecting data for the 2021 edition of the International Library Automation Perceptions survey. This survey, conducted annually since 2007, provides an opportunity for libraries to register their perceptions of the strategic automation products they use, organizations that provide these products, and the quality of support delivered. The survey also probes at considerations for migrating to new systems and the level of interest in open source products. As open source software supported both by the general community and by a variety of different service organizations, some special considerations apply to Koha. In the libraries.org directory, Koha is represented by a combination of the name Koha and the primary support organization involved. (For example Koha - Catalyst IT, Koha -- ByWater Solutions). Libraries relying entirely on community support or internal resources are represented as Koha - Independent. If there are any special support arrangements not covered by these conventions, just mention that in the comments area of the survey. In this way the survey will be able to reflect both the functionality of the Koha software and the quality of support provided. This model of representing libraries using Koha isn't perfect, but is a pragmatic approach that aggregates all users of Koha while also segregating the different support scenarios. Participation in this survey will help amplify the visibility of Koha among those interested in library automation. While the numeric rating scales support the statistical results of the study, it's the comments offered that provide the most insight into the current state of library automation satisfaction. Comments will be published in the survey results, redacted to conceal text that might identify the individual or organization responding. The raw data for the survey will not be shared, but reports are available that provide a variety of ways to view results. Please help your fellow librarians who might be in the process of evaluating library automation options by responding to the survey. Any information regarding vendor performance and product quality can be helpful when making strategic decisions regarding automation alternatives. A large number of responses strengthen the impact of the survey and the subsequent report. If you have responded in previous years, please respond again this year to help identify any trends regarding improvement or worsening of the products or support services. For more information about the survey, for instructions on how to participate, and to see results of previous year's survey reports, see: https://librarytechnology.org/perceptions/2021/invite/ I hope that all libraries using Koha will respond. Feel free to forward this request to any other library-related list. You can view the report summarizing the results of last year's survey, including data from all previous editions, here: https://librarytechnology.org/perceptions/2020/ Please let me know if there are any questions regarding the survey. Marshall Breeding Editor, Library Technology Guides www.librarytechnology.org Marshall.breeding(a)librarytechnology.org twitter.com/mbreeding

1 1

Error
by Himanshu Aggarwal 20 Jun '22

20 Jun '22

While doing batch record modification I am getting following error Cannot enqueue this job. (The error was: Job has not been enqueued. See the Koha logfile for more information). Kindly help -- Assistant Librarian, Confucius Institute Scholar 13-14, R.D. National College, Bandra (W.)

4 7

Koha on Debian 10
by Clogher Historical Society 09 Jun '22

09 Jun '22

Hi, Thanks for the replies, it seems that I need to be running Debian 9 ( Stretch) not version 10 (Buster) but there is someone called: mtj on IRC who is working on Debian 10. There doesn't seem to be a downgrade option in Debian so reinstalling the whole operating system is pretty awkward. I hope (MTJ) includes Debian 10 support soon. Best Regards, Aindriú

5 7

Fwd: update error
by Katrin Fischer 29 Mar '22

29 Mar '22

Hi Ana, please always keep conversation on the mailing list, so others can help you too. It looks like REGEXP_REPLACE might be a feature only available in newer MySQL versions. It doesn't seem to appear in the 5.7 manual, but only in the 8.0 manual, but I am having trouble finding the version it was introduced in. What OS are you using and is updating the DBMS or switching to MariaDB an option? Katrin -------- Forwarded Message -------- Subject: RE: update error Date: Tue, 4 Jan 2022 12:10:58 +0000 From: anabela semedo <anabela556(a)hotmail.com> To: Katrin Fischer <katrin.fischer.83(a)web.de> Hi Katrin, thanks for your time. I use the mysql, version 5.7.38 I still couldn't solve it. do I have to uninstall everything? Upgrade to 21.05.00.016 [14:16:28]: Bug 24387 - Rename opac_news with additional_contents ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: FUNCTION koha.biblioteca.REGEXP_REPLACE does not exist at /usr/share/koha/lib/C4/Installer.pm line 738 Thanks again, Ana Bela *De:*Katrin Fischer [mailto:katrin.fischer.83@web.de] *Enviada:* sábado, 1 de janeiro de 2022 10:53 *Para:* anabela semedo <anabela556(a)hotmail.com>; Koha <koha(a)lists.katipo.co.nz> *Assunto:* Re: update error Hi Ana, better to copy the error into the email as attachments will be removed on the mailing list: Upgrade to 21.05.00.016 [14:16:28]: Bug 24387 - Rename opac_news with additional_contents ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: FUNCTION koha.biblioteca.REGEXP_REPLACE does not exist at /usr/share/koha/lib/C4/Installer.pm line 738 Are you using MySQL or MariaDB and which is the version? Katrin On 30.12.21 17:36, anabela semedo wrote: hello ever one i have a problem here, trying to update koha to the latest version and i have this error here that i am not able to resolve. can anybody help me? thankyou. Ana Bela Semedo

3 2

New BibLibre's sandbox server
by Jonathan Druart 15 Feb '22

15 Feb '22

Hi all, I think I haven't announced it here yet. BibLibre offered the community a new server for the sandboxes. It's a replacement to the old BibLibre one. Note that PTFS-E and Bywater's are still around :) The only difference is that this one is using elastic search as the search engine by default. https://sandboxes.biblibre.eu/ More info about sandboxes can be found on the wiki: https://wiki.koha-community.org/wiki/Sandboxes Issues or enhancement requests can be done at https://gitlab.com/koha-community/koha-sandboxes-docker Regards, Jonathan

1 1

Incomplete LEADER when creating new child records
by Michael Kuhn 03 Feb '22

03 Feb '22

Hi Our library is working with Debian 11 and Koha 21.05.02. When displaying a bibliographic record in the normal view of the staff client, the clicking "New > New child record" the LEADER will just contain the following: "␣␣␣␣␣␣␣␣␣a␣␣␣␣␣␣␣␣␣␣␣␣␣␣" (I have replaced the space character by ␣ to make it visible). It stays the same when we click into the field. So when we fill the rest of the required fields and save the record we will end up with a record that is not properly linked to the parent record. This is irritating since when just creating a "normal" (non-child) new record, the LEADER is automatically filled with the correct content when clicking the field resp. trying to save the record. This happens through plugin "marc21_leader.pl". However, when creating A new child record if we click the tag editor symbol at the far right, the popup "000- Leader" opens and we can click "OK" which will eventually result in the following LEADER content: "␣␣␣␣␣aaa␣a22␣␣␣␣␣␣␣␣4500". This seems somehow cumbersome since we don't want to change anything there. It would be desirable if this content would just appear when clicking the field resp. trying to save the record as it does when just creating a "normal" (non-child) record. Is there a way to achieve 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

2 2

Import ignored records
by Toni Afandi 31 Jan '22

31 Jan '22

Hello everyone, Could we import ignored records from staged MARC records? There is a situation that I've changed my mind about some records that have been ignored. Thanks in advance. Regards, *Toni Afandi* *Librarian* *STT SAAT* *(Southeast Asia Bible Seminary)* Jl. Bukit Hermon No 1, Tidar Atas Malang, Jawa Timur 65151 Indonesia www.seabs.ac.id

2 1

Un-archiving acquisitions suggestions
by Drucker, Jon 31 Jan '22

31 Jan '22

Is it possible to un-archive an acquisitions suggestion? We're on 21.05. Thanks, Jon -- Jon Drucker Assistant Professor, Landman Library Collections and Technical Services Librarian Arcadia University | druckerj(a)arcadia.edu My calendar: https://calendar.google.com/calendar/u/0?cid=ZHJ1Y2tlcmpAYXJjYWRpYS5lZHU

2 1

Koha Staff Login Issue Please help me.
by MASTeR Library 31 Jan '22

31 Jan '22

I am encountered with error " Autolocation is switched on and you are logging in with an IP address that doesn't match your library". If any body knows the trouble shoot please help me. Enclosed Errr: https://i.ibb.co/YyDBnrB/koha-loing.png 1. Login into your staff client using a superlibrarian account. 2. Go to Home -> Koha Administration -> Global system preferences 3. Search for the system preference "AutoLocation" and set it to "Yes/No" (I changed this option.) 4. Save the change and logout and then login back in. face the problem anymore. Please hope this helps. -- Thanking you.. Librarian, MAMCET <http://mamcet.com/> Trichy-Chennai Trunk Road, Siruganur, Tiruchirappalli-621 105.

2 1