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

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

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 26 Aug '20

26 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

Unable to save
by Raphael Meyer 04 Jul '20

04 Jul '20

I was going to add bar codes at 6 am this morning but got this error instead. I had just upgraded to 20.05. Can't open /var/log/koha/library/opac-error.log (Permission denied) at /usr/share/perl5/Log/Log4perl/Appender/File.pm line 151. For help, please send mail to the webmaster ([no address given]<mailto:%5Bno%20address%20given%5D>), giving this error message and the time and date of the error. What can I do? Br Raphael Prince of Peace Abbey Oceanside CA Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10

5 7

Plack error in koha 19.11.06
by Alvaro Cornejo 01 Jul '20

01 Jul '20

Hi Since this morning we start to have this errors in plack: Error while loading /etc/koha/plack.psgi: Can't load application from file "/usr/share/koha/api/v1/app.pl": [JSON::Validator] GET http://swagger.io/v2/schema.json == Connect timeout at /usr/share/perl5/JSON/Validator.pm line 274. Compilation failed in require at (eval 397) line 1. Child process 6058 exited with status 115 Error while loading /etc/koha/plack.psgi: Can't load application from file "/usr/share/koha/api/v1/app.pl": [JSON::Validator] GET http://swagger.io/v2/schema.json == Connect timeout at /usr/share/perl5/JSON/Validator.pm line 274. Compilation failed in require at (eval 397) line 1. Child process 6063 exited with status 115 Error while loading /etc/koha/plack.psgi: Can't load application from file "/usr/share/koha/api/v1/app.pl": [JSON::Validator] GET http://swagger.io/v2/schema.json == Connect timeout at /usr/share/perl5/JSON/Validator.pm line 274. Compilation failed in require at (eval 397) line 1. Child process 6074 exited with status 115 Error while loading /etc/koha/plack.psgi: Can't load application from file "/usr/share/koha/api/v1/app.pl": [JSON::Validator] GET http://swagger.io/v2/schema.json == Connect timeout at /usr/share/perl5/JSON/Validator.pm line 274. Compilation failed in require at (eval 397) line 1. Child process 6077 exited with status 115 Error while loading /etc/koha/plack.psgi: Can't load application from file "/usr/share/koha/api/v1/app.pl": [JSON::Validator] GET http://swagger.io/v2/schema.json == Connect timeout at /usr/share/perl5/JSON/Validator.pm line 274. Compilation failed in require at (eval 397) line 1. Child process 6081 exited with status 115 Error while loading /etc/koha/plack.psgi: Can't load application from file "/usr/share/koha/api/v1/app.pl": [JSON::Validator] GET http://swagger.io/v2/schema.json == Connect timeout at /usr/share/perl5/JSON/Validator.pm line 274. Compilation failed in require at (eval 397) line 1. Child process 6084 exited with status 115 We tried to disable/enable stop/start plack and restarted apache2 but errors continue. We have temporarily disable plack so work can continue with koha What can be the cause? Regards, Alvaro |----------------------------------------------------------------------------------------| Stay safe / Cuídate/ Reste sécurisé *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. *q *Recycle always / Recicla siempre / Recyclez toujours P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire

2 2

access to the system
by Victor Barroso Oliveira 01 Jul '20

01 Jul '20

Good evening, After updating Ubuntu 20.04 and Koha 20.05.01 I don't get access to the system. I already reset apache and mysql and reboot, checked the installation configuration and was as I had done. What could be happening? Thank you, Victor

2 1