September 2021 - Koha - lists.katipo.co.nz

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

19 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

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 10 Jun '22

10 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

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

404.pl
by Keith Sorbo 23 Nov '21

23 Nov '21

While watching the top command on my ubuntu server, I notice that while retrieving search items in the OPAC I get a lot of 404.pl instances. These seem to be a drag on the performance of the server. (We are a small school with a small VPS server). I assume that these are caused by Koha searching for missing covers. Is there any way to mitigate the effect of these searches? Is there a timeout setting or even disable these searches? Thanks.

3 3

June 3 CatSIG, cataloging-tastic!
by Hernandez, Heather H 03 Nov '21

03 Nov '21

Hi, all! The next Koha-US Cataloging Special Interest Group ("Cat SIG") meeting is tomorrow, June 3, 2021, at 8 PT, 9 MT, 10 CT, 11 ET, and you don't have to be a member of Koha-US to join us! You don't even need to self-identify as a cataloger! Join us for our usual roundtable of questions, solutions and resource brainstorming, tips, tricks, suggestions, bug & development awareness, and the usual laughter, fun, and fellowship to discuss anything cataloging, authority, or metadata related in Koha. Actual catalogers do attend, as well as the cataloging curious and those who have had cataloging thrust upon them! Information on joining us is always on the Koha-US calendar: https://koha-us.org/event/cataloging-special-interest-group-2/?instance_id=… And feel free to send me any questions or topics for discussion ahead of time! See you there! --h2 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Ms. Heather Hernandez (she, her, hers) Technical Services Librarian San Francisco Maritime National Historical Park Research Center 2 Marina Blvd., Bldg. E, 3rd floor, San Francisco, CA 94123-1284 415-561-7032, heather_hernandez(a)nps.gov<https://webmail.lmi.net/src/compose.php?send_to=heather_hernandez%40nps.gov> Library catalog: http://keys.bywatersolutions.com/

1 4

Roles for 22.05 open
by Jonathan Druart 20 Oct '21

20 Oct '21

Hello everybody, The roles for the 22.05 release cycle are now opened. The vote will take place during one of the dev meetings in October. https://wiki.koha-community.org/wiki/Roles_for_22.05 The description of the roles can be found at this wiki page https://wiki.koha-community.org/wiki/Project_roles Regards, Jonathan

2 2

Re: [Koha] Renewal notice email
by Shafrizan Affendi 02 Oct '21

02 Oct '21

I do have access to the server. Can you tell me which *.pl that i need to set in cron.hourly? i tried process_message_queue.pl in cron.hourly but not successful. On Tue, 28 Sep 2021, 12:25 am Coehoorn, Joel, <jcoehoorn(a)york.edu> wrote: > This is possible, but it's managed via the linux cron tables rather than > via the Koha user interface. You'll need someone who can ssh into the > server and is comfortable using a linux cli prompt to edit files. > > Joel Coehoorn > Director of Information Technology > York College of Nebraska > > > On Mon, Sep 27, 2021 at 8:28 AM Shafrizan Affendi <shaffendi(a)gmail.com> > wrote: > >> Hi there. Im using Koha ver 21.05. >> >> I would like to ask how can I generate renewal notice (email) and send >> message que in every hour? >> >> If im not mistaken, default koha will send the email in the midnight. >> >> For example, i renew 1 book at 10 am. and will get the email notice at >> midnight. I want to make koha send the notice email right after i renew >> the >> book so that i can receive the email at 11.01 am. >> >> Can anyone help me? Thanks in advance >> _______________________________________________ >> >> Koha mailing list http://koha-community.org >> Koha(a)lists.katipo.co.nz >> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha >> >

2 2

Framework Reports
by Charles Kelley 02 Oct '21

02 Oct '21

Hi, all! I frequently use the following SQL report, which I think I got from the Koha wiki. SELECT bib.biblionumber AS 'Bib. Record Number', bib.author AS 'Author', bib.title AS 'Title' FROM biblio bib WHERE bib.frameworkcode = <<Choose MARC framework (bibliographic) framework>> This serves us well, but as you might guess, one must know the framework code in order for the report to function correctly. Moreover, pressing "Run the report" without entering a framework leads to an out-of-memory error. (An empty submission would be equivalent to the default framework, but this seems not to be the case.) Is there a way to modify it so that one can select from a list, e.g., SELECT bib.biblionumber AS 'Bib. Record Number', bib.author AS 'Author', bib.title AS 'Title' FROM biblio bib WHERE bib.frameworkcode = <<Choose MARC framework (bibliographic) framework|FRAMEWORK_CODE>> I have looked for the name of an equivalent to my FRAMEWORK_CODE list in the Koha wiki but alas, for I have not found it. So, I duplicated the description in an ad-hoc authorized list, my FRAMEWORK_CODE above, but that means updating the new ad-hoc list every time we add or rid a framework. If there isn't already access to such a list, I'll submit a feature request. Many thanks. -- 気を付けて。 /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 1

New Koha minor versions released - security fixes included, UPGRADE!
by Jonathan Druart 02 Oct '21

02 Oct '21

Hello everybody, I am announcing, on behalf of the whole Koha release team, synchronised releases for the four release versions we are currently supporting. The release notes are available below: 21.05.04 - https://koha-community.org/koha-21-05-04-released-%e2%9a%a0-security-releas… 20.11.10 - https://koha-community.org/koha-20-11-10-released-%e2%9a%a0-security-releas… 20.05.16 - https://koha-community.org/koha-20-05-16-released-%e2%9a%a0-security-releas… 19.11.22 - https://koha-community.org/koha-19-11-22-released-%e2%9a%a0-security-releas… As they contain security bug fixes we suggest you upgrade all the Koha instances you are in charge of as soon as possible. Let us know if you have any questions. Regards, Jonathan

4 3