February 2020 - 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

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

Location of tag 245$c in koha database
by vinod mishra 30 Jul '21

30 Jul '21

Dear All, May i know the location of marc tag 245$c im koha database/table, i wish to get the report of the same. With Regards, Vinod Kumar Mishra, Assistant Librarian, Biju Patnaik Central Library (BPCL), NIT Rourkela, Sundergadh-769008, Odisha, India. Mob:91+9439420860 Website: http://mishravk.com/ ORCID ID: http://orcid.org/0000-0003-4666-7874 *"Spiritual relationship is far more precious than physical. Physical relationship divorced from spiritual is body without soul" -- Mahatma Gandhi*

3 4

Request to list in paid support provider from India
by JITHIN N 24 Jul '21

24 Jul '21

Dear Koha Community https://www.texicon.in/ is an Indian based software service and support the company, offering service in Koha software since 2018. So far we automated 100 plus libraries across the country with Koha Library management software and we also launched a public Z39.50 server on last National Reading Day with a collection of 1 lakh plus regional language (Malayalam) books bibliographic data to support the library network of Kerala State. We kindly request you consider listing our company details in paid support provider of Koha Community web site. Company Name: * TEXICON SOFTWARE SOLUTIONS * Contact Person: Jithin N Contact email: : info(a)texicon.in , jithin984731(a)gmail.com Website: https://www.texicon.in/ Telephone: +919847314010 With regards *Texicon* Software Solution Padikkal Malappuram District. Kerala 676317 India

2 2

Check-in Receipt
by Mubassir Ahsan 15 Feb '21

15 Feb '21

Is there any way to print check-in receipt in koha. *Best wishes.--------------------Md. Mubassir Ahsan* *Library In-Charge* Southeast University Phone: +8801916303060 Email: mahsandu(a)gmail.com Facebook: mmahsan <http://facebook.com/mmahsan> Skype: mahsandu Twitter: mahsandu

4 4

moving database from 17.5 to 19.11 error
by Alvaro Cornejo 27 Aug '20

27 Aug '20

Hi I´m tryin to do the DB move from 17.5 to 19.11. I take following steps: - backup 17.5 with koha-backup and I get two files a sql.gz and a tar.gz - scp both files to new server - run koha-remove biblioteca - run koha-restore sql tar files and I start having a lot of errors like: ERROR: File exists: /var/lib/koha/biblioteca/biblios/key/ and at the end I have: ERROR 1396 (HY000) at line 1: Operation DROP USER failed for 'koha_biblioteca'@'%' ERROR 1819 (HY000) at line 1: Your password does not satisfy the current policy requirements DBI connect('database=koha_biblioteca;host=localhost;port=3306','koha_biblioteca',...) failed: Access denied for user 'koha_biblioteca'@'localhost' (using password: YES) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517. DBI connect('database=koha_biblioteca;host=localhost;port=3306','koha_biblioteca',...) failed: Access denied for user 'koha_biblioteca'@'localhost' (using password: YES) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517. DBI connect('database=koha_biblioteca;host=localhost;port=3306','koha_biblioteca',...) failed: Access denied for user 'koha_biblioteca'@'localhost' (using password: YES) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517. DBI connect('database=koha_biblioteca;host=localhost;port=3306','koha_biblioteca',...) failed: Access denied for user 'koha_biblioteca'@'localhost' (using password: YES) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517. DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: Access denied for user 'koha_biblioteca'@'localhost' (using password: YES) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1520. at /usr/share/koha/lib/Koha/Database.pm line 107 Something went wrong rebuilding biblio indexes for biblioteca DBI connect('database=koha_biblioteca;host=localhost;port=3306','koha_biblioteca',...) failed: Access denied for user 'koha_biblioteca'@'localhost' (using password: YES) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517. DBI connect('database=koha_biblioteca;host=localhost;port=3306','koha_biblioteca',...) failed: Access denied for user 'koha_biblioteca'@'localhost' (using password: YES) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517. DBI connect('database=koha_biblioteca;host=localhost;port=3306','koha_biblioteca',...) failed: Access denied for user 'koha_biblioteca'@'localhost' (using password: YES) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517. DBI connect('database=koha_biblioteca;host=localhost;port=3306','koha_biblioteca',...) failed: Access denied for user 'koha_biblioteca'@'localhost' (using password: YES) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517. DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: Access denied for user 'koha_biblioteca'@'localhost' (using password: YES) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1520. at /usr/share/koha/lib/Koha/Database.pm line 107 Something went wrong rebuilding authority indexes for biblioteca [....] Restarting apache2 (via systemctl): apache2.serviceJob for apache2.service failed because the control process exited with error code. See "systemctl status apache2.service" and "journalctl -xe" for details. failed! I double checked that mysqroot pass is the same on both systems. How do I check "user koha_biblioteca" password to be the same on both systems? |-----------------------------------------------------------------------------------------------------------------| Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier celular y Nextel en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS y GPRS online Visitenos en www.perusms.com

5 7

Remove Not For Loan / Available distinctions
by Elaine Bradtke 27 Aug '20

27 Aug '20

We've been running Koha for a while, but have a new person in charge and they (correctly) pointed out that displaying Available / Not Available status for a collection that's 99% reference only is useless and possibly confusing. Is there an easy way to switch this display off? A quick look round the preferences didn't show anything. We're trying to avoid custom configurations because we've got very minimal, volunteer support. Right now, just about everything shows up as 'not available' even though it's sitting right there on the shelf. Thanks! Elaine Bradtke VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999

2 3

Problems with Virtual Hosts?
by dimabin 29 Feb '20

29 Feb '20

I tried to install Koha following this manual: https://wiki.koha-community.org/wiki/Koha_on_Debian My system: Debian (at digitalocean) In what follows, XXX is my domain at ".org". libersu is my instance. Contents of /etc/koha/koha-sites.conf: DOMAIN=".XXX.org" INTRAPORT="80" INTRAPREFIX="" INTRASUFFIX="-intra" OPACPORT="80" OPACPREFIX="" OPACSUFFIX="" Folder /etc/koha/sites/ contains an empty folder libersu. Directory /etc/apache2/sites-available contains only 2 files: 000-default.conf default-ssl.conf URLs: http://libersu.XXX.org/ http://libersu-intra.XXX.org/ When I open these URLs in browser, it opens just Apache2 Debian Default Page, not Koha. Please help me with this. -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html

3 2

Software Error Message Showing in Koha 19.11
by Shibin S B 29 Feb '20

29 Feb '20

Dear LIS Professionals, Is there any problem with koha 19.11 for issuing reserved books? While I am trying to do so, koha is showing software error. Do anyone have any idea or suggestion regarding this? Regards Shibin S B

4 3

Re: [Koha] Koha Digest, Vol 172, Issue 24
by Bustillos, Corina 27 Feb '20

27 Feb '20

unsubscribe Corina Bustillos | Unit Assistant Director Delia Montes-Gallo Library of the Health Sciences 4800 Alberta Ave. | El Paso | Texas | 79905 O 915.215.4313 | F 915.545.6656 http://elpaso.ttuhsc.edu/libraries/ ________________________________ From: Koha <koha-bounces(a)lists.katipo.co.nz> on behalf of koha-request(a)lists.katipo.co.nz <koha-request(a)lists.katipo.co.nz> Sent: Wednesday, February 26, 2020 4:00:02 PM To: koha(a)lists.katipo.co.nz Subject: Koha Digest, Vol 172, Issue 24 WARNING: The sender of this email could not be validated and may not match the person in the "From" field. CAUTION: This email originated from outside of TTUHSC. Do not click links or open attachments unless you recognize the sender and know the content is safe. Send Koha mailing list submissions to koha(a)lists.katipo.co.nz To subscribe or unsubscribe via the World Wide Web, visit https://urldefense.com/v3/__https://lists.katipo.co.nz/mailman/listinfo/koh… 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. Re: [Koha-devel] Update to Koha 19.11.03 Release (Mason James) ---------------------------------------------------------------------- Message: 1 Date: Wed, 26 Feb 2020 23:59:14 +1300 From: Mason James <mtj(a)kohaaloha.com> To: Koha Devel <koha-devel(a)lists.koha-community.org>, Koha <Koha(a)lists.katipo.co.nz>, All Staff <staff(a)bywatersolutions.com> Subject: Re: [Koha] [Koha-devel] Update to Koha 19.11.03 Release Message-ID: <d345d584-5097-7da6-aafd-154a7bebab9a(a)kohaaloha.com> Content-Type: text/plain; charset=utf-8 hi Folks, the latest packages are available cheers, Mason On 26/02/20 6:03 am, Joy Nelson wrote: > Hello all! A quick update on the recent maintenance releases. > > All maintenance releases (18.11.14, 19.05.08, 19.11.03) contain a security update related to XSLT. > > https://urldefense.com/v3/__https://bugs.koha-community.org/bugzilla3/show_… > "This patchset refines the XSLT processing configuration such that we are more secure by disallowing the processing of external stylesheets by default and adding a configuration option to re-enable the functionality." > > > Cheers > -joy > > > On Mon, Feb 24, 2020 at 4:31 PM Joy Nelson <joy(a)bywatersolutions.com <mailto:joy@bywatersolutions.com>> wrote: > > Greetings! > > The Koha community is proud to announce the release of Koha 19.11.03. > > This is a maintenance release containing 7 enhancements and 78 bugfixes > > The full release notes are available at > https://urldefense.com/v3/__https://koha-community.org/koha-19-11-03-releas… > > Debian packages will be updated within a few days > > > Joy Nelson > President, Koha Division > > ByWater Solutions <https://urldefense.com/v3/__http://bywatersolutions.com__;!!PZU9J6Y!PFQ2n75… > > Support and Consulting for Open Source Software > Phone/Fax (888)900-8944 > What is Koha? <https://urldefense.com/v3/__http://bywatersolutions.com/what-is-koha/__;!!P… > > > > > > -- > Joy Nelson > President, Koha Division > > ByWater Solutions <https://urldefense.com/v3/__http://bywatersolutions.com__;!!PZU9J6Y!PFQ2n75… > > Support and Consulting for Open Source Software > Phone/Fax (888)900-8944 > What is Koha? <https://urldefense.com/v3/__http://bywatersolutions.com/what-is-koha/__;!!P… > > > > > _______________________________________________ > Koha-devel mailing list > Koha-devel(a)lists.koha-community.org > https://urldefense.com/v3/__https://lists.koha-community.org/cgi-bin/mailma… > website : https://urldefense.com/v3/__http://www.koha-community.org/__;!!PZU9J6Y!PFQ2… > git : https://urldefense.com/v3/__http://git.koha-community.org/__;!!PZU9J6Y!PFQ2… > bugs : https://urldefense.com/v3/__http://bugs.koha-community.org/__;!!PZU9J6Y!PFQ… ------------------------------ Subject: Digest Footer _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz https://urldefense.com/v3/__https://lists.katipo.co.nz/mailman/listinfo/koh… ------------------------------ End of Koha Digest, Vol 172, Issue 24 *************************************

1 0