March 2019 - 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

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

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

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

Invitation for Libraries using Koha to participate in the 2018 Library Automation Perceptions survey
by Marshall Breeding 18 Nov '19

18 Nov '19

To all libraries using Koha: I'm collecting data for the 2018 International Library Automation Perceptions survey. This survey, now in its twelfth annual iteration, provides an opportunity for libraries to register their perceptions of the strategic automation products they use, organizations that provide these products, and the quality of support delivered. The survey also probes at considerations for migrating to new systems and the level of interest in open source products. As open source software supported both by the general community and by a variety of different service organizations, some special considerations apply to Koha. In the libraries.org directory, Koha is represented by a combination of the name Koha and the primary support organization involved. (For example Koha - Catalyst IT, Koha -- ByWater Solutions). Libraries relying entirely on community support or internal resources are represented as Koha - Independent. If there are any special support arrangements not covered by these conventions, just mention that in the comments area of the survey. In this way the survey will be able to reflect both the functionality of the Koha software and the quality of support provided. This model of representing libraries using Koha isn't ideal, but is a pragmatic approach that aggregates all users of Koha while also segregating the different support scenarios. Participation in this survey will help amplify the visibility of Koha among those interested in library automation. While the numeric rating scales support the statistical results of the study, it's the comments offered that provide the most insight into the current state of library automation satisfaction. Comments will be published in the survey results, redacted to conceal text that might identify the individual or organization responding. The raw data for the survey will not be shared, but reports are available that provide a variety of ways to view results. Please help your fellow librarians who might be in the process of evaluating library automation options by responding to the survey. Any information regarding vendor performance and product quality can be helpful when making strategic decisions regarding automation alternatives. A large number of responses strengthen the impact of the survey and the subsequent report. If you have responded in previous years, please respond again this year to help identify any trends regarding improvement or worsening of the products or support services. For more information about the survey, for instructions on how to participate, and to see results of previous year's survey reports, see: http://librarytechnology.org/web/breeding/AutomationSurvey/ I hope that all libraries using Koha will respond. Feel free to forward this request to any other library-related list. You can view the report summarizing the results of last year's survey, including data from all previous editions, here: https://librarytechnology.org/perceptions/2017/ Please let me know if there are any questions regarding the survey. Marshall Breeding Editor, Library Technology Guides www.librarytechnology.org Marshall.breeding(a)librarytechnology.org twitter.com/mbreeding

1 1

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

Library Summary / Stats - Report Page - Help
by SATISH 01 Oct '19

01 Oct '19

Dear All, I have a suggestion or expectation in koha regarding library summary. a default page dedicated to "library summary" which is in-built in koha (may be inside reports) and gives: 1. No.of Non Repetitive Titles (which means records) : 0000 2. No. of books (items): 0000 3. No. of books issued / checked out (as on date): 0000 4. No. of Active Patrons Cards: 0000 5. No. of De-activated/ Expired Patrons Cards: 0000 6. Total Expenditure on Books: 0000 (in respective currencies) "Example: http://eprints.iisc.ernet.in/ | Number of publications in the repository: 44108" Instead of running separate sql queries which are commonly needed, repetitive in requirements as a "*ready reference*", could be displayed in a single summary page or "about library", and this should not be created manually, and could be generated from the script itself. This also helps during library inspection committee visits, auditing takes place, whenever reporting is required for the stake holders, etc.. If this facility is already available, kindly let me know, how to achieve this. Otherwise, kindly consider this as a suggestion. With thanks Satish MV Librarain Govt. Engineering College, Hassan. Karnataka. www.gechassan.ac.in --

3 7

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

Restoring OPAC - Help
by SATISH 02 Jun '19

02 Jun '19

Hi, With Koha 16.11.11 / Package Installation/ Ubuntu 14.04 Desktop with MySQL - mysql Ver 14.14 Distrib 5.5.57 Took mysqldump and moved koha database from server A to server B Did db-schema upgrade, rebuild zebra index But, I am not able to find OPAC pages server B. (Home › Administration › System preferences > Local Use) Is there any specific files to be restored?? Your answers would help me in restoring OPAC. Thank You Satish MV Librarian Govt. Engineering College, Hassan. Karnataka. --

3 6

Re: [Koha] Message for Birthday wishes though Koha
by vinod mishra 01 Jun '19

01 Jun '19

Dear All, Thanks, I have filed a bug at https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22086 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* On Thu, Jan 10, 2019 at 8:44 AM MAMCET Library <mamcet.library10(a)gmail.com> wrote: > Nice idea sir your welcome.. > > On Wed, Jan 9, 2019 at 4:15 PM vinod mishra <mishravk79(a)gmail.com> wrote: > >> Dear All, >> We are sending a lot of alert messages through Koha like book renewal, >> hold, overdue, etc. So how can we make this possible to send birthday >> wishes from Koha? >> >> The system should match the Koha server date with patron birthday record >> and sent a wish as per library defined format like other email alerts? >> >> >> 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* >> _______________________________________________ >> Koha mailing list http://koha-community.org >> Koha(a)lists.katipo.co.nz >> https://lists.katipo.co.nz/mailman/listinfo/koha >> > > > -- > Thanking you.. > > Librarian, > MAMCET <http://mamcet.com/> > Trichy-Chennai Trunk Road, > Siruganur, Tiruchirappalli-621 105. > >

2 1