- Koha - lists.katipo.co.nz

Upgrade: Ubuntu 16.04.6 LTS / Koha 17.11.18.000
by Alex Shepherd 28 Jan '20

28 Jan '20

Hi Guys, I’m needing to update my Koha server that hosts 8 separate instances of Koha and just looking for any advice or guidance to reduce disappointment… Its on a Digital Ocean Droplet, which I’ve taken a SnapShot of and will test the upgrade on a cloned test instance from the snapshot before doing it on production, so its low risk but I want to avoid unforeseen issues that may not show-up for a while. I’m aware of the notes here: https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Upgrade_Inst… but they are quite brief and I kinda expect more issues than “it just works”… Maybe it does - I don’t know yet. It is currently running: Ubuntu 16.04.6 LTS Koha 17.11.18.000 MariaDB 10.0.38-MariaDB-0ubuntu0.16.04.1 The only “special” things I’ve done to this server are: A) install the IndexData repos: http://ftp.indexdata.dk/ubuntu xenial InRelease http://ftp.indexdata.dk/ubuntu xenial Release to upgrade Yaz and Zebra as there were issue with my Koha instances handling some Asian languages (Thai I believe) that were improved with the later versions. B) Add the Startup scripts to each MySQL DB to reset the sequence numbers etc on boot. Questions in my mind: 1) Do I just alter the APT Koha repo to say 19.11 and run update/upgrade in one step or is there a need to step through each major version to get there? 1) Should I also upgrade Ubuntu to 18.04 LTS or just leave it on 16.04 LTS? This might affect the Yaz and Zebra versions as well. Any comments or advice? Regards Alex Shepherd p: +64-7-829 4441 m: +64-21-777764 e: kiwi64ajs(a)gmail.com

2 1

FW: Koha on Digital Ocean (Was: Re: Installation on so-called virtual server at external internet service provider IONOS)
by King, Fred 28 Jan '20

28 Jan '20

(Reposted after it got stuck in moderation--too many recipients.) -----Original Message----- From: King, Fred Sent: Monday, January 27, 2020 12:48 PM To: 'Chris Brown' <chris(a)stayawake.co.uk>; Heinz-Jürgen Oertel <hj.oertel(a)t-online.de> Cc: koha <koha(a)lists.katipo.co.nz>; koha-us(a)koha-us.org Subject: Koha on Digital Ocean (Was: Re: [Koha] Installation on so-called virtual server at external internet service provider IONOS) Hello Chris, Heinz-Jürgen, and everybody, I'm glad to hear that someone else is using Digital Ocean! We're currently running the MedStar Authors Catalog Koha instance at Digital Ocean, and since I bought our in-house Koha instance server refurbished seven years ago and I'm getting kind of nervous, I'm trying to move that to Digital Ocean as well. I'm planning to start on the $5 USD per month configuration ($6 USD with weekly backup), though we may splurge for the $10/$12 configuration if we need to. Yes, we're a very small library--circulation is maybe in the high two figures per month and is mostly the Advanced Cardiac Life Support exam review book. Getting another in-house server isn't an option. My next step is a Technical Review Meeting with our IT department where I need to convince the Demand Management Team that Koha/Digital Ocean will not present a security threat to the rest of our network and the Protected Health Information contained therein. Our systems were attacked a couple of years ago and we were shut down for a couple of weeks (my desk has never been so tidy), so their concerns are understandable. The form they asked me to fill out was the same one that any software vendor chosen by the hospital needs to use, though in my case a lot of the answers were "not applicable." Which brings me to a few questions, some general and some Koha or maybe Digital Ocean specific: One of the things I think they'll ask me about is data encryption. The form I filled out asked the highest level--TLS 1.3, 1.2, 1.1, SSL 3.0 or less. Any ideas? Yes, it's a basic question that I should know, but there are large gaps in my knowledge as I'm mostly self-taught. They're also going to ask about antivirus protection. I have never heard of a Koha instance running on Debian/Ubuntu being affected by a virus or anything similar, and if it had happened I think I would have heard of it since I've been involved with Koha since version 2.something-or-other. Does anybody know something different? I'd also like to hear from other users of Digital Ocean, or from people whose Koha systems have had to undergo a review of this type. Any advice? I know enough about Koha, Ubuntu, and Digital Ocean to be able to set up, migrate, and run our small Koha system, enough to install it on a Raspberry Pi (http://avengingchicken.online/misc/installing_koha_on_raspberry-pi-4.pdf) take part in a panel discussion (http://koha-us.org/learn/conferences/kohacon2019/, see "Unsupported? You're not on your own!"), but this part is something new to me. Thank you, Fred King, AHIP Medical Librarian, MedStar Washington Hospital Center fred.king(a)medstar.net 202-877-6670 ORCID 0000-0001-5266-0279 MedStar Authors Catalog: http://medstarauthors.org Mars is the only known planet in the universe inhabited solely by robots. --Brandon Spektor, LiveScience -----Original Message----- From: Koha <koha-bounces(a)lists.katipo.co.nz> On Behalf Of Chris Brown Sent: Sunday, January 26, 2020 9:55 AM To: Heinz-Jürgen Oertel <hj.oertel(a)t-online.de> Cc: koha <koha(a)lists.katipo.co.nz> Subject: [EXTERNAL] Re: [Koha] Installation on so-called virtual server at external internet service provider IONOS ** ATTENTION: This email originated from outside the MedStar network. ** DO NOT CLICK links or attachments unless you recognize the sender and know the content is safe. Hi Heinz-Jürgen, I don't have any experience of IONOS but I successfully host Koha on a virtual private server from Digital Ocean. For a long time we were running on a small configuration costing 20 USD per month though we have now upgraded as we're supporting 5 libraries (and a web site). I have had a smooth ride (though I do have prior experience of administering Linux servers). Digital Ocean will give you a VPS with Debian pre-installed which makes it easy to get started. If you're hosting in-house, some things to think about: 1. Does your ISP offer a static IP address? 2. You will need to set up a tunnel (or do I mean a bridge?) through your broadband router to your Koha server 3. You will need a way to do backups -- preferably off-site Good luck! Best Regards Chris Brown On Sun, Jan 26, 2020 at 12:53 PM Heinz-Jürgen Oertel <hj.oertel(a)t-online.de> wrote: > Hello, > just a short introduction, joined the list today. > I'm on the way to replace the currently used Allegro-B for our small, > about > 3000 books, library. The main reason is to have an OPAC to tell the > world what we have collected so far in our specialized library. > > We have two options > - installing koha on a separate pc (debian) on our premises, but so > far I don't know how can open the OPAC to the customers > > - installing koha on an external virtual server with root access My > question, is there someone here having it done at IONOS, the former > German company 1&1. > > Or to you have better recommendations. > By the way, money is a very small resource in our association, German > Verein e.V. > > Greetings > Heinz > > > > _______________________________________________ > Koha mailing list > https://urldefense.proofpoint.com/v2/url?u=http-3A__koha-2Dcommunity.o > rg&d=DwIGaQ&c=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVxj8-bJ04M&r=vKh6XwOmjy > C51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI&m=d1e9HNijxpF-CFm6aDGu2L4sA9uNUSWxNY > OhmVfKlfY&s=PFaZDDXbAVaeRYYYQEEUYB394Eoew_4m7DdURTjQriU&e= > Koha(a)lists.katipo.co.nz > https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.katipo.co.n > z_mailman_listinfo_koha&d=DwIGaQ&c=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVx > j8-bJ04M&r=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI&m=d1e9HNijxpF-C > Fm6aDGu2L4sA9uNUSWxNYOhmVfKlfY&s=2YTTiymU3KGcGMBjQQzVdlLnADG5enBMFZZdo > gdgCtQ&e= > _______________________________________________ Koha mailing list https://urldefense.proofpoint.com/v2/url?u=http-3A__koha-2Dcommunity.org&d=… Koha(a)lists.katipo.co.nz https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.katipo.co.nz_mai… ---------------------------------------------------------------------- MedStar Health is a not-for-profit, integrated healthcare delivery system, the largest in Maryland and the Washington, D.C., region. Nationally recognized for clinical quality in heart, orthopaedics, cancer and GI. IMPORTANT: This e-mail (including any attachments) may contain information that is private, confidential, or protected by attorney-client or other privilege. If you received this e-mail in error, please delete it from your system without copying it and notify sender by reply e-mail, so that our records can be corrected... Thank you. Help conserve valuable resources - only print this email if necessary.

2 1

INSTANCE CREATED NOT AVAILABLE IN APACHE RELATED FOLDERS
by Josh Getanda 27 Jan '20

27 Jan '20

Hi, I have experienced some three major issues in an attempt to install KOHA 19.11 in Ubuntu 16.04 Server. 1. After successfully creating an instance called "library", on checking the available instances created using "koha-list", the result returns a null value (i.e. no instance is visible). 2. Consequently, due to the above, the apache-related files required to be edited and access from the browser are not available. For instance, the ~/library.conf file is missing data. That is, editing the /etc/apache2/sites-enabled/library.conf, the file is blank with no information in it. 3. Also, I believe still related to the missing instance, trying to use the "a2ensite" command to enable the site returns an error message stating, "The instance library does not exist." So how can enable this instance, whereas checking the data in Mariadb, the koha-library database exists? Thanks in advance. Regards.

2 3

hackfest 2020 in Marseille, registrations are open !
by Paul Poulain 27 Jan '20

27 Jan '20

Hello everyone, almost everything is in the title : you can register for the hackfest by sending me an email. As announced previously, it will take place in BibLibre office, Marseille, France, March 23-27 Some explanations for those who need them: * the hackfest is NOT a developer week. it's a week for anyone willing to contribute to Koha, whatever the kind of contribution (testing, documenting, ...) * the hackfest is free of charge (but you'll have to deal with your traveling costs, of course) * you can come for 5 days, or less. Don't come for 1 day, it's useless. coming for 2 days is very frustrating. Coming for 3 to 5 days is perfect ! * 40-45 ppl fit in our office. If we're more than this, we'll have to book an additional room [thanks to the company just next door] So register as soon as possible * there's no schedule, everyone comes with it's own ideas/goals/expectations * that's not a training session * if you need an official invitation, just ask by email Hoping to see you next month !!! -- Paul Poulain, Associé-gérant / co-owner BibLibre, Services en logiciels libres pour les bibliothèques BibLibre, Open Source software and services for libraries

1 0

Russian Language characters in public catalog
by Eric Phetteplace 27 Jan '20

27 Jan '20

Hi all, This is perhaps more of a general web design problem than a Koha-specific one but I'm wondering if others have had trouble with accented Russian characters displaying properly and what their solution was. Here's a search of all our Russian language records <https://library.cca.edu/cgi-bin/koha/opac-search.pl?advsearch=1&idx=kw&op=a…>; there's an accent that's a large, sweeping arch over multiple letters (sorry, after some research I still don't know its name) which renders as blank unicode boxes by fonts that do not support it, e.g. "M. Sarʹi︠a︡n" as opposed to how it should look <https://www.google.com/search?&q=M.+Sar%CA%B9i%EF%B8%A0a%EF%B8%A1n>. The Arial font is so far the only one I've found that renders the accent properly, though I assume there are others. Koha theme's NotoSans doesn't and neither do any of our institutional brand fonts. Is there anywhere in the public catalog display where the record language is shown? Preferably as a class or other CSS hook, if I could just do `#catalogue_detail_biblio.russian { font-family: arial }` that'd be the perfect solution. I've been considering how to handle this but nothing other than simply switching the whole catalog's font to Arial seems great. I can add some JavaScript to change the font on just select pages, but I'd have to tell when affected records are appearing and also apply it to search results. I could edit all the records to romanize them but would be laborious since I don't think there's a way to do a bulk edit that catches every instance of the accent. Plus, newly imported records will have the same problem and I'll have to keep revisiting them. Best, ERIC PHETTEPLACE Systems Librarian (he/him) ephetteplace(a)cca.edu | o 510.594.3660 5212 Broadway | Oakland, CA | 94618 :(){ :|: & };:

4 5

Installation on so-called virtual server at external internet service provider IONOS
by Heinz-Jürgen Oertel 26 Jan '20

26 Jan '20

Hello, just a short introduction, joined the list today. I'm on the way to replace the currently used Allegro-B for our small, about 3000 books, library. The main reason is to have an OPAC to tell the world what we have collected so far in our specialized library. We have two options - installing koha on a separate pc (debian) on our premises, but so far I don't know how can open the OPAC to the customers - installing koha on an external virtual server with root access My question, is there someone here having it done at IONOS, the former German company 1&1. Or to you have better recommendations. By the way, money is a very small resource in our association, German Verein e.V. Greetings Heinz

3 4

Enquiry
by Himanshu Aggarwal 26 Jan '20

26 Jan '20

*s their any particular sequence when you fill Excel to import into Koha* -- Assistant Librarian, Confucius Institute Scholar 13-14, R.D. National College, Bandra (W.)

2 1

problem Loading of checkout books for circulation
by Nur Ahammad 26 Jan '20

26 Jan '20

Hi all, When I do the circulation of books, my koha showing " Loading ... You may continue scanning" but showing the circulation books. Please see the following link https://drive.google.com/file/d/0B7hpDgEcnVrVUWw4LThtR0s4QXdzN1ZqUTNqVklpd3… -- Nur Ahammad Senior Assistant Librarian +8801816188851 Daffodil International University *Read to Know. Read to Learn. Read to Lead*

3 2

upgrade from 17.05 to oldstable dependency error.
by Alvaro Cornejo 25 Jan '20

25 Jan '20

Hi I{m trying to upgrade a koha installation from 17.05 to oldstable (tried stable also) but apt-get upgrade said package will be kept back. OS is Ubunutu xenial (16.4) I check dependency and I get this: acornejo@CelacpVps:~$ sudo apt-get --with-new-pkgs upgrade koha-common Reading package lists... Done Building dependency tree Reading state information... Done Calculating upgrade... Done Some packages could not be installed. This may mean that you have requested an impossible situation or if you are using the unstable distribution that some required packages have not yet been created or been moved out of Incoming. The following information may help to resolve the situation: The following packages have unmet dependencies: koha-common : Depends: libhttp-oai-perl (< 4.0) but 4.03-1 is to be installed or libhttp-oai-3.27-perl but it is not going to be installed E: Broken packages acornejo@CelacpVps:~$ This is the referred library installed version. acornejo@CelacpVps:~$ apt list --installed |grep libhttp libhttp-oai-perl/xenial,xenial,now 4.03-1 all [installed,automatic] acornejo@CelacpVps:~$ Will it be safe to remove that lib and manually install an older version? Regards Alvaro |-----------------------------------------------------------------------------------------------------------------| 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

1 0

Printing overdue letters
by Mark Alexander 24 Jan '20

24 Jan '20

My librarian has asked me to make Koha do something that doesn't sound easy to me. She'd like to be able to generate letters to each patron having overdues more than N days (where N is a variable). The letter would be then be printed, stuffed into an envelope, and mailed with the postal service. I know that sounds old-fashioned, but she seems to really want to do this instead of using Koha's ability to email notices and messages. I can understand this, knowing that in this part of rural New England, many of our patrons are elderly and either don't have email, or have it but don't want to give us their email addresses. I am not sure I can do this in a simple SQL report, which generates a table, not a form letter. So my next idea was to write a report that outputs the needed information (patron name, address, list of overdue books and their replacement price). Then I'd export the results of the report to a CSV file. Then I'd do a mail merge in Libre Office Writer (or Word, which the librarian uses) using the data in the CSV file. The generated letter might look like this: To: PATRON_ADDRESS Dear PATRON_NAME, You have the following overdue books: BOOK1_TITLE, BOOK1_PRICE BOOK2_TITLE, BOOK1_PRICE ... Thanks, Your library I think this might work, except that I can't figure out how to get a patron's list of overdue books into the generated letter. The SQL would need to produce a CSV file with a single row for each patron, containing the patron name, address, and an arbitrarily long list of overdue books. I am not sure that is possible, but then, my SQL skills are not so great. Any help with this would be appreciated greatly.

4 5