- Koha - lists.katipo.co.nz

Install fails: 19.11 on fresh Debian 9: table $SITE.zebraqueue doesn't exist
by Dwight Tuinstra 10 Mar '20

10 Mar '20

Hello all -- I'm volunteering some IT consulting at a small research library in Oaxaca, Mexico, that wishes to use koha. To start the project I'm trying to install a test instance of koha 19.11 on a fresh install of Debian 9, which the documentation suggests is one of the preferred platforms. I've carefully followed the wiki document "Koha on Debian" ( https://wiki.koha-community.org/wiki/Koha_on_Debian) performing all steps in the order indicated. So far I found one (known but unfixed) documentation bug and applied the workaround -- one needs to add a backports repository -- but this time I'm running up against something that isn't so easy. The problem manifests as the web UI seeming to hang after going through all the configuration screens and clicking on the button to create the database tables. After several minutes of no activity, the brower reports "Gateway Timeout" The gateway did not receive a timely response from the upstream server or application. There are two possible causes that I've been able to see so far: POSSIBILITY 1: There is an indexer problem that occurs even before the point where the web installer is run. The file /var/log/koha/opac (I'm calling my instance "opac") begins to fill up with error messages. The first few are: DBD::mysql::db do failed: Table 'koha_opac.systempreferences' doesn't exist [for Statement " SELECT * FROM systempreferences WHERE 1 = 0 "] at /usr/share/koha/lib/Koha/Database.pm line 114. DBD::mysql::st execute failed: Table 'koha_opac.systempreferences' doesn't exist [for Statement "SELECT `me`.`variable`, `me`.`value`, `me`.`options`, `me`.`explanation`, `me`.`type` FROM `systempreferences` `me` WHERE ( `me`.`variable` = ? )" with ParamValues: 0='casauthentication'] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1836. DBD::mysql::st execute failed: Table 'koha_opac.systempreferences' doesn't exist [for Statement "SELECT `me`.`variable`, `me`.`value`, `me`.`options`, `me`.`explanation`, `me`.`type` FROM `systempreferences` `me` WHERE ( `me`.`variable` = ? )" with ParamValues: 0='caslogout'] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1836. DBD::mysql::st execute failed: Table 'koha_opac.systempreferences' doesn't exist [for Statement "SELECT `me`.`variable`, `me`.`value`, `me`.`options`, `me`.`explanation`, `me`.`type` FROM `systempreferences` `me` WHERE ( `me`.`variable` = ? )" with ParamValues: 0='casserverurl'] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1836. DBD::mysql::db selectall_arrayref failed: Table 'koha_opac.marc_subfield_structure' doesn't exist [for Statement " SELECT * FROM marc_subfield_structure WHERE frameworkcode = ? AND kohafield > '' ORDER BY frameworkcode,tagfield,tagsubfield "] at /usr/share/koha/lib/C4/Biblio.pm line 1013. DBD::mysql::st execute failed: Table 'koha_opac.zebraqueue' doesn't exist [for Statement "SELECT COUNT(*) FROM zebraqueue WHERE done = 0;"] at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 324. DBD::mysql::st fetchrow_arrayref failed: fetch() without execute() [for Statement "SELECT COUNT(*) FROM zebraqueue WHERE done = 0;"] at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 325. After this, the log continues to grow with the last two lines constantly added over and over. Curiously, though, this seems to stop about the time that the web installer is run. POSSIBILITY 2: The creation of database tables takes so long that the browser or installer times out, or race conditions arise. I watched table creation in another window as the web installer was running. Table creation seemed to go slow (roughly a table every second) even though there was plenty of free memory, free disk space (with low disk activity), and the CPUs were over 95% idle. Table creation stopped at 162 tables, at almost the exact same moment that the browser gave the timeout message, so I'm not sure if that's all the tables or if there are supposed to be more. What's odd here is that the web installer writes a good number of messages to /var/log/koha/opac/intranet-error.log, each saying that one of these database tables do not exist: language_descriptions, language_subtag_registry, or systempreferences. However, all of these tables *do* exist in the database when one examines it later, which suggests a race condition. OTHER INFO: - Virtualization: VirtualBox 5.2.34_Ubuntu r133883, 2 i7 CPUs, pre-allocated fixed disk (32Gb), 2GB RAM - Debian version: 4.9.0-12-686-pae #1 SMP Debian 4.9.210-1 (2020-01-20) i686 - Koha version: 19.11 - Following: stable - Database: mariadb, on same host as koha - During WebUI installer: - All Perl dependencies installed and OK - All DB settings look reasonable, connection established, and database koha_opac exists and can be accessed Please help! I've spent hours upon hours doing the installation over and over, making sure everything is clean and updated, and all changes and actions are exactly as the documentation requests. I've kept configuration changes to the minimum required by the documentation in order to avoid complications. What do I need to do to get koha installed? --Dwight (Memo)

2 3

koha-US general meeting reminder: Wednesday, March 11th, 2020
by Jason Robb 10 Mar '20

10 Mar '20

Our next koha-US general meeting is *tomorrow*, Wednesday, March 11th. When: 8:30 AM PDT / 9:30 MDT / 10:30 CDT / 11:30 EDT (time converter <https://www.timeanddate.com/worldclock/fixedtime.html?msg=koha-US+March+gen…> ) Where: https://zoom.us/j/648572897 Agenda: https://docs.google.com/document/d/12u5AYt-HE6B7OCghtvXw4RQvj7bMyfB3aE8T5D2… This month we will discuss what's next with both Kohathon and the annual face-to-face conference, take a look at some of the special interest groups that are just getting started, and more! As always, there will be time to discuss Koha bugs, issues, and workflows so if you have a burning question or want to rally behind an issue, be sure to bring it! If you have specific topics for the agenda, please send them to secretary(a)koha-us.org Meetings are held via Zoom video conferencing. A microphone and webcam are recommended but not required. Zoom is available for Windows, Mac, and Linux on desktops, and Android and iOS on mobile devices. For help getting started, visit: https://support.zoom.us/hc/en-us/categories/200101697 These meetings are free and open to any and all. Jason Robb koha-US secretary secretary(a)koha-us.org

1 0

multiply zebra daemons problem on ubuntu 16.04
by Irakli Garibashvili 09 Mar '20

09 Mar '20

Dear All, We have encountered this problem when upgrading Ubuntu from version 14.04 to - 16.04 : We run multiply instances of koha on the ubuntu server. (Single Koha with several MySQL databases – koha, koha1, koha2, koha3) For each of the instances, we have to run separate koha-zebra-daemon. The daemon for the instance of koha1 is the following: --------------------------------------------------------------------------------------- USER=koha GROUP=koha DBNAME=koha1 NAME=koha-zebra-ctl.$DBNAME LOGDIR=/var/log/koha1 ERRLOG=$LOGDIR/koha-zebradaemon.err STDOUT=$LOGDIR/koha-zebradaemon.log OUTPUT=$LOGDIR/koha-zebradaemon-output.log KOHA_CONF=/etc/koha1/koha-conf.xml RUNDIR=/var/run/koha1/zebradb LOCKDIR=/var/lock/koha1/zebradb # you may need to change this depending on where zebrasrv is installed ZEBRASRV=/usr/bin/zebrasrv ZEBRAOPTIONS="-v none,fatal,warn" .................................................................................................... .............the same as for instance of koha, koha2, koha3........... --------------------------------------------------------------------------------------- When I activate the daemon, on Ubuntu 14.04 it passes without any problem, but on Ubuntu 16.04 I get the following error: --------------------------------------------------------------------------------------- $ sudo update-rc.d koha1-zebra-daemon defaults insserv: script koha1-zebra-daemon: service koha-zebra-daemon already provided! insserv: exiting now! update-rc.d: error: insserv rejected the script header --------------------------------------------------------------------------------------- Can anyone help me to solve the problem? Best regards Irakli Garibashvili Tbilisi, GEORGIA

2 1

-SQL report on total cost of books
by Yatheesh lis 09 Mar '20

09 Mar '20

Hi I would like to know total cost of books in my library Can anyone suggest -SQL query on following details 1) total number books & total cost. 2) total number of books with out cost Thank you

2 1

How to add authorized value to a report output
by Joelle Hannert 06 Mar '20

06 Mar '20

I'm trying to get a report to include an output of a custom borrower attribute, but having trouble coming up with the correct way to ask for this in the SQL code. I feel like the answer is somewhere on this schema page: http://schema.koha-community.org/18_11/tables/borrower_attributes.html but nothing I'm trying is working. The authorized value for our local attribute is "BANNERHOLD." I tried the following: - borrower_attributes.bannerhold - borrower_attribute_types.bannerhold - code.bannerhold I don't really understand how the relationships work, so it's just trial and error for me. Any advice would be much appreciated! Joelle -- Joelle Hannert Library Technical Services Coordinator Northwestern Michigan College (231) 995-1684 Work days: M, W, Th, F

3 4

Rancor/advanced bib editor at next Cataloging SIG meeting
by Hernandez, Heather H 05 Mar '20

05 Mar '20

Hi! The next meeting of the Koha-US Cataloging SIG is Thursday, March 5, 2020, 8am – 9am PT (9 MT/10 CT/11 ET), https://zoom.us/j/861480992 (Open to all!) Topic: Advanced Bibliographic Editor/Rancor Round Table! Join us for a live Rancor walk-through in a real, live Koha catalog!!! Experimenting!! Q&A!! Sharing!! Send me ideas for what you'd like to see in Rancor--we'll try it!! Spoiler: There will be multiple browsers in use at once!! (What?!?) Tune in to see if I'm wearing (and clutching??) my pearls!! Join us and join in--unmute and chime in! Share your tips and tricks! Ask questions! The meeting will be recorded and available on the Koha-US YouTube channel for those who want to re-watch or can't make it to the live round table with the chat saved and appended to the description. (Koha and chill!) See you then! --h2 ~~~~~~~~~~~~~~ Ms. Heather Hernandez (she, her, hers) Technical Services Librarian San Francisco Maritime National Historical Park Research Center 2 Marina Blvd., Bldg. E, 3rd floor, San Francisco, CA 94123-1284 415-561-7032, heather_hernandez(a)nps.gov<mailto:heather_hernandez@nps.gov> Library catalog: http://keys.bywatersolutions.com/

1 1

Issue list of statuses
by Mohamad F Barham 04 Mar '20

04 Mar '20

Dears, In serials module, the list of issue statuses is hardcoded, is there a way to add new statuses or to use it as authorized value. I need statuses like withdrawn as its not existing in the list, Koha version: 19.11.03.000 Linux libkoha 4.9.0-9-amd64 #1 SMP Debian 4.9.168-1+deb9u3 (2019-06-16) x86_64 attached current statuses. Regards [cid:image002.png@01D327F4.25E9A910] Mohamad Barham System Engineer | Information Technology Department Birzeit University P.O.Box. 14, Birzeit, Palestine Tel: + 970 22982012 | Mob: +970 597 861929 | Ext: 5616 mbarham(a)birzeit.edu | www.birzeit.edu<http://www.birzeit.edu/> ~~~~~~~~~~~~~~~~~~~~~~~~~~ The information contained in this communication is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. It may contain confidential or legally privileged information. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by responding to this email and then delete it from your system. The University is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. ~~~~~~~~~~~~~~~~~~~~~~~~~~

2 1

Restrictions on 9XX Fields
by Charles Kelley 03 Mar '20

03 Mar '20

Hi, all! I'd like to thank everyone for the help I have received in the past. My library would like to begin tracking changes we make to the catalog records. I already know Koha does keep track of changes, for when I click on "Modification Logs", I see a rich history. What I had in mind was something that we did in another library job of mine: rededicated a 9XX field to log a brief synopsis of the changes we made. Mostly just the cataloger's name or initials, timestamp, and a few words, e.g., 949 \\ $a Kelley, Charles. $b 2020-02-28 $c Added subject field. $c Romanized Cyrillic title. 949 \\ $a Sloshkin, Victoria. $b 2020-02-29 $c Added editor [700]. $c Added series title. 949 \\ $a Watanabe, Junko. $b 2020-02-30 $c Fixed title indicators. 949 \\ $a Watanabe, Junko. $b 2020-02-31 $c OK. Nothing more involved or detailed than the illustrations. If we really need the detail, we'll look at the modification logs. I know the 9XX fields are locally defined, but as far as I can determine, Koha uses the 942, 952, and 999 fields and they are to be avoided. Are there other 9XX fields that we ought to avoid? I have added to the avoidance list the CANMARC fields and the other fields in the Koha default framework. I understand I'll have to add the brief change log field (949 in my examples)and its subfields to the frameworks. Many thanks for your help. -- -- Charles. Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338 Charles Kelley 5-2 Tsukimino 1-Chome #210 Yamato-shi, Kanagawa-ken 〒242-0002 JAPAN +1-301-741-7122 [US cell] +81-80-4714-5490 [JPN cell] mnogojazyk(a)aol.com [h] cmkelleymls(a)gmail.com [p] linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> Meeting Your Information Needs. Virtually.

3 2

Re: [Koha] Restrictions on 9XX Fields
by Charles Kelley 03 Mar '20

03 Mar '20

Hi, Caroline This is good to hear. Thanks for the confirmation, and the suggestion of the additional MARC tag fields. They may be a better solution. In our latest exchange, on 2 Mch. 2020, at 11:21, Caroline Cyr-La-Rose wrote: > As far as I know, Koha only uses those three MARC fields (942, 952 and 999). > > Also, have you looked at the following system preferences MarcFieldForCreatorId, MarcFieldForCreatorName, MarcFieldForModifierId and MarcFieldForModifierName? You can enter your local 9XX fields in there. Quoting my question of 2 Mch. 2020, 12:29, to wit: > My library would like to begin tracking changes we make to the catalog records. I already know Koha does keep track of changes, for when I click on "Modification Logs", I see a rich history. > > What I had in mind was something that we did in another library job of mine: rededicated a 9XX field to log a brief synopsis of the changes we made. Mostly just the cataloger's name or initials, timestamp, and a few words, e.g., > 949 \\ $a Kelley, Charles. $b 2020-02-28 $c Added subject field. $c Romanized Cyrillic title. > 949 \\ $a Sloshkin, Victoria. $b 2020-02-29 $c Added editor [700]. $c Added series title. > 949 \\ $a Watanabe, Junko. $b 2020-02-30 $c Fixed title indicators. > 949 \\ $a Watanabe, Junko. $b 2020-02-31 $c OK. -- Caroline Cyr La Rose, M.S.I. Bibliothécaire | Responsable de produit Tél. : 1-833-465-4276, poste 221 Caroline.Cyr-La-Rose(a)inLibro.com <mailto:caroline.cyr-la-rose@inLibro.com> INLiBRO | Spécialistes en technologies documentaires | www.inLibro.com < http://www.inLibro.com> -- -- Charles. Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338 Charles Kelley 5-2 Tsukimino 1-Chome #210 Yamato-shi, Kanagawa-ken 〒242-0002 JAPAN +1-301-741-7122 [US cell] +81-80-4714-5490 [JPN cell] mnogojazyk(a)aol.com [h] cmkelleymls(a)gmail.com [p] linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> Meeting Your Information Needs. Virtually.

1 0

koha-US March 2020 Meetings & Events
by Jason Robb 02 Mar '20

02 Mar '20

koha-US online meetings and events are free and open to all. See our calendar for a full list: http://koha-us.org/calendar/ *Meetings* Board Meeting - Wednesday, March 4th @ 8:30-9:30 PT (9:30 MT / 10:30 CT / 11:30 ET) - Meeting Link - https://zoom.us/j/293750042 - Agenda - https://docs.google.com/document/d/12TKC2nKuasTRC-xFvbYuqgY2arBu90xXOnVMD3V… General Meeting - Wednesday, March 11th @ 8:30-9:30 PT (9:30 MT / 10:30 CT / 11:30 ET) *Learning Opportunities* Basic SQL for Koha Users - Tuesday, March 24th @ 8:30-9:30 PT (9:30 MT / 10:30 CT / 11:30 ET) *Special Interest Groups* Cataloging - Thursday, March 5th @ 8-9 PT (9 MT / 10 CT / 11 ET) System Administration - Tuesday, March 10th @ 9-10 PT (10 MT / 11 CT / Noon ET) Acquisitions - Tuesday, March 17th @ 9-10 PT (10 MT / 11 CT / Noon ET) See what other SIGs are in the works and join groups on topics important to you: http://koha-us.org/special-interest-groups/ For example, do you wish certain Koha functionality was more streamlined? Do you have strong opinions about how Koha looks and feels? Consider joining the *Web Development SIG <https://groups.google.com/a/koha-us.org/forum/#!forum/webdev>* to chat about Koha user experience and interface design, customization, and more. Jason Robb koha-US secretary secretary(a)koha-us.org

1 0