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

change of domain name
by glernil evangelista 13 Jan '20

13 Jan '20

Good day! How can I change the domain name of a koha instance? I have a Koha 12.0 installed using debian repository.

4 3

Koha upgrade 3.18.11 --> 3.20.07
by Bortel, Gary 16 Oct '19

16 Oct '19

I am seeing two MySQL errors thrown when trying to update from 3.18.11 --> 3.20.07. Are these benign or something about which concern should be raised? The installation here is Ubuntu 14.04.3 with a multi-tenant package install of Koha. Mysql Ver 14.14 Distrib 5.5.46, for debian-linux-gnu (x86_64) using readline 6.3 . . . . Upgrade to 3.20.00.002 done (Bug 5010: Fix OPACBaseURL to include protocol) Upgrade to 3.20.01.000 done (Koha 3.20.1) Upgrade to 3.20.01.001 done (Bug 9942: Privacy is correctly set) Upgrade to 3.20.01.002 done (Bug 13993: Correct orderstatus for transferred orders) Upgrade to 3.20.02.000 done (Koha 3.20.2) Upgrade to 3.20.03.000 done (Koha 3.20.3) DBD::mysql::db do failed: Can't create table 'koha_library.#sql-4b9_42' (errno: 121) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 10584. Upgrade to 3.20.03.001 done (Bug 14205: Deleting an Item/Record does not remove link to course reserve) Upgrade to 3.20.03.002 done (Bug 14717: Prevent 0000-00-00 dates in patron data) DBD::mysql::db do failed: Duplicate entry '1-self_checkout' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 10614. Upgrade to 3.20.03.003 done (Bug 14298: AutoSelfCheckID user should only be able to access SCO ) Upgrade to 3.20.04.000 done (Koha 3.20.4) Upgrade to 3.20.04.001 done (Bug 14820: SMSSendUsername and SMSSendPassword are not listed in the system preferences) Upgrade to 3.20.05.000 done (Koha 3.20.4) Upgrade to 3.20.06.000 done (Koha 3.20.5) Upgrade to 3.20.06.001 done (Bug 14978: Make sure issues.itemnumber is a unique key) Upgrade to 3.20.07.000 done (3.20.7 release) gcb ______________________ Gary C. Bortel IT Services Manager, Library Development Program Office of the Secretary of State, Washington State Library 6880 Capitol Boulevard Southeast P.O. Box 42460 Olympia, WA 98501-2460 gary.bortel(a)sos.wa.gov<mailto:gbortel@secstate.wa.gov> voice: 360.570.5588 fax: 360.586.7575 Washington State Library: Empowering 21st Century Washington

9 22

Problem uploading patrons
by Elaine Bradtke 26 Aug '19

26 Aug '19

We're running 3.18.04. One (and only one) of my colleagues is unable to upload patron files. It's very curious, she has all the permissions, and I and another colleague have uploaded the same file without a problem. I have even logged into her account and uploaded the file successfully. But whenever she tries she gets a long string of error messages that boil down to Koha not parsing the header row. I've asked her to clear her browser (Firefox) history and cookies (there's an 8 hour time difference so I won't know if this works til tomorrow) Other than that I don't know why she can't do it and we can. Any ideas what might be causing the problem? -- Elaine Bradtke Data Wrangler 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 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)

9 14

Software error: Biblionumber
by Peter Feingundez 08 Jan '18

08 Jan '18

hi, i am a new koha-developer. I have a problem with my koha system, but i can´t understand it. I created one new MARC Framework changing some fields and one new item type for it. When i try to add one new record using this framework, i get this : Software error: No biblionumber tag for framework "MTS" at /usr/share/koha/lib/C4/Biblio.pm line 3135. What should i do? Thx. -- View this message in context: http://koha.1045719.n5.nabble.com/Software-error-Biblionumber-tp5747673.html Sent from the Koha-general mailing list archive at Nabble.com.

6 5

ERROR LOADING MODULE: Date::Manip::DM6
by Federico Leva (Nemo) 03 Dec '17

03 Dec '17

Hello! I'm trying Koha on a small fedora 23 virtual machine for testing (500 MB RAM, 1 core) and I often get this error in the web interface: ---- Software error: ERROR LOADING MODULE: Date::Manip::DM6 at /usr/share/perl5/vendor_perl/Date/Manip.pm line 34. Compilation failed in require at /usr/share/perl5/vendor_perl/C4/Overdues.pm line 25. BEGIN failed--compilation aborted at /usr/share/perl5/vendor_perl/C4/Overdues.pm line 25. Compilation failed in require at /usr/share/perl5/vendor_perl/C4/Members.pm line 29. BEGIN failed--compilation aborted at /usr/share/perl5/vendor_perl/C4/Members.pm line 29. Compilation failed in require at /usr/share/perl5/vendor_perl/C4/Search.pm line 28. BEGIN failed--compilation aborted at /usr/share/perl5/vendor_perl/C4/Search.pm line 28. Compilation failed in require at /usr/share/perl5/vendor_perl/C4/AuthoritiesMarc.pm line 24. BEGIN failed--compilation aborted at /usr/share/perl5/vendor_perl/C4/AuthoritiesMarc.pm line 24. Compilation failed in require at /usr/share/koha/intranet/cgi-bin/tools/manage-marc-import.pl line 32. BEGIN failed--compilation aborted at /usr/share/koha/intranet/cgi-bin/tools/manage-marc-import.pl line 32. ---- The error is always identical and goes away with a refresh. When it happens I see I have less than 10 MB free memory so it really just seems a resource issue. I'll give Koha more memory :) but let me know if I missed something obvious. Federico (BEIC)

2 2

SIP2 Server not start!
by Luigi Ipsa 05 Jul '17

05 Jul '17

Hi, I followed the guide on https://sites.google.com/a/liblime.com/koha-manual/Home/Table-of-Contents/A… https://sites.google.com/a/liblime.com/koha-manual/Home/Table-of-Contents/A… to configure the SIP2 server, but when i start it do not have any warning if it is correctly initialized or not. Files sip_log.out and sip_log.err are empty, try "ps-ef | grep SIP" but there are no processes, by connecting telnet gives me refused connection. There are other logs to be checked? -- View this message in context: http://www.nabble.com/SIP2-Server-not-start%21-tp21852177p21852177.html Sent from the Koha - Discuss mailing list archive at Nabble.com.

5 7

Publisher Authority Type
by Krishna K 13 Apr '17

13 Apr '17

Hi, At the school library where we are setting up Koha, as part of migrating data, we plan to set up a new authority type for Publisher. We would like to import publisher data from an excel into the publisher authority type, then import the biblio with references to these publishers. I am unable to find detail instructions for the same. Could any of you help me with this please ? Also, which are the MARC tags we should use for illustrator, translated by and for editor fields ? Thanks for the support of this forum. -- Regards, Krishna

3 3

No patron search results in Koha 16.05.09
by Michael Kuhn 12 Apr '17

12 Apr '17

Hi Today I updated a Koha installation from 3.20.03 to 16.05.09 (oldstable) via "apt-get install koha-common". * OS: Debian GNU/Linux 8 (Linux 3.16.0-4-amd64 #1 SMP) * Perl-Version: 5.020002 * Apache-Version: 2.4.10 (Debian) * Zebra-Version: 2.0.59 * Plack is not in use After the update the patron search via Koha menu "Patrons" is no more working. After searching for a patron just the header line with "Card / Name / Date of birth etc" appears but no actual results. Using the Koha menu "Circulation" patron search is working, e. g. in "Check out" where it is possible to enter patron card number or partial name. And of course all these patrons can be found in the database using SQL. Could this be a bug? 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

6 11

Error decoding record
by Alfredo Sanjuán 11 Apr '17

11 Apr '17

I have a big biblio record (more than 9999 bytes, a lot of items attached) that zebra refuses to index. I got this error when searching: Use of uninitialized value $self in pattern match (m//) at /usr/share/perl5/MARC/File/XML.pm line 441. ERROR DECODING RECORD - Empty String at /usr/share/perl5/MARC/File/XML.pm line 448. : at /usr/share/koha/lib/C4/Search.pm line 1920. and the biblio record doesn't show on the results. I rebuild the index with: rebuild_zebra.pl -b -x -r -v Is this a known problem? I'm running Koha 16.11.03.000. -- Alfredo Sanjuán - IBD Internet Tel: 943376085

2 4