March 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

Elasticsearch again
by Tom Hanstra 02 Apr '20

02 Apr '20

Earlier testing of Koha 19.11.03 with Elasticsearch 7 and 6 both gave errors. There was some suspicion that perhaps Elasticsearch had to be rolled back to V5. So, I did that today, as well as upgrading Koha to 19.11.04. And I am getting a new error. Basically, now, it looks like there might be a configuration error somewhere? Here is my current error when trying to index: PERL5LIB=/usr/share/koha/lib:/usr/local/lib:/usr/local/share/perl5 ./bin/search_tools/rebuild_elasticsearch.pl -d -v -p 4 [7019] Checking state of biblios index [7019] Dropping and recreating biblios index [Request] ** [http://localhost:9200]-[400] [illegal_argument_exception] Custom Analyzer [analyzer_phrase] failed to find filter under name [icu_folding], called from sub Search::Elasticsearch::Role::Client::Direct::__ANON__ at /usr/share/koha/lib/Koha/SearchEngine/Elasticsearch/Indexer.pm line 349. With vars: {'body' => {'status' => 400,'error' => {'root_cause' => [{'reason' => 'Custom Analyzer [analyzer_phrase] failed to find filter under name [icu_folding]','type' => 'illegal_argument_exception'}],'reason' => 'Custom Analyzer [analyzer_phrase] failed to find filter under name [icu_folding]','type' => 'illegal_argument_exception'}},'request' => {'serialize' => 'std','path' => '/koha_london_test_20_biblios','ignore' => [],'mime_type' => 'application/json','body' => {'settings' => {'index' => {'analysis' => {'normalizer' => {'nfkc_cf_normalizer' => {'type' => 'custom','char_filter' => 'icu_normalizer'},'icu_folding_normalizer' => {'filter' => ['icu_folding'],'type' => 'custom'}},'char_filter' => {'punctuation' => {'pattern' => '([\\x00-\\x1F,\\x21-\\x2F,\\x3A-\\x40,\\x5B-\\x60,\\x7B-\\x89,\\x8B,\\x8D,\\x8F,\\x90-\\x99,\\x9B,\\x9D,\\xA0-\\xBF,\\xD7,\\xF7])','type' => 'pattern_replace','replacement' => ''}},'analyzer' => {'analyzer_stdno' => {'filter' => ['icu_folding'],'char_filter' => ['punctuation'],'tokenizer' => 'whitespace'},'analyzer_phrase' => {'filter' => ['icu_folding'],'char_filter' => ['punctuation'],'tokenizer' => 'keyword'},'analyzer_standard' => {'filter' => ['icu_folding'],'tokenizer' => 'icu_tokenizer'}}}},'index.mapping.total_fields.limit' => '10000'}},'qs' => {},'method' => 'PUT'},'status_code' => 400} FWIW, Koha knows what the indices should be but also seems to know that they do not yet exist: Nodes: localhost:9200 | Status: running | Indices: koha_london_test_20_biblios (count: -1), koha_london_test_20_authorities (count: -1) Anyone seen this type of error or have ideas on what might be going on with this particular issue? Thanks, Tom -- *Tom Hanstra* *Sr. Systems Administrator* hanstra(a)nd.edu

2 2

Courser reserves on OPAC
by Carlos Lopez 31 Mar '20

31 Mar '20

Hi folks Has anyone had any luck modifying columns on the OPAC Course Reserves display? (suppressing some columns, reordering others) If so, what was involved? (modifying the template? adding some JS? something else?) With kind regards from the Dalton McCaughey Library Team Carlos Lopez Dalton McCaughey Library | 29 College Crescent, Parkville, VICTORIA 3052 Ph: 03 9340 8888 ext.1 | library(a)dml.vic.edu.au<mailto:library@dml.vic.edu.au> | library.dmlibrary.org.au

2 3

Koha release 19.11.04
by Joy Nelson 30 Mar '20

30 Mar '20

Greetings! The Koha community is proud to announce the release of Koha 19.11.04. It includes 1 new feature, 6 enhancements, 44 bug fixes. The new feature allows libraries to easily modify due dates for checkouts. This was pushed to accommodate libraries needs during Covid-19. This does contain some untranslated strings. Apologies for any inconvenience this may cause. Details can be seen here: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24846 The full release notes are available at https://koha-community.org/koha-19-11-04-release/ Debian packages will be updated within a few days -- Joy Nelson President, Koha Division ByWater Solutions <http://bywatersolutions.com> Support and Consulting for Open Source Software Phone/Fax (888)900-8944 What is Koha? <http://bywatersolutions.com/what-is-koha/>

1 1