- Koha - lists.katipo.co.nz

***UNCHECKED*** GDPR IRC meeting proposal
by Josef Moravec 15 Feb '18

15 Feb '18

Hello all, it would be nice to have some meeting about the GDPR and data privacy in Koha. With GDPR going to take effect in May, there is not too much of time to adapt our systems and proccesses. The subject of meeting should be disscusion about things documented on Koha wiki [1] and to share our experiences with GDPR implementation. There is also omnibus bug report found at [2] We just need to set up a date and time of the meeting, here is the poll: https://framadate.org/ymtnis54CARuR4am Cheers Josef Sources: [1] https://wiki.koha-community.org/wiki/Improve_data_protection_and_patron_pri… [2] https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18081

1 0

Call for News: February 2018 Newsletter
by kohanews 14 Feb '18

14 Feb '18

I'm collecting news for the February newsletter. Send anything noteworthy to: k o h a news AT gmail dot com News criteria: --------------------------- ** For events **: - Please include dates for past events. If I can't find dates I may not add it. - Announcements for future events with dates T.B.A. are fine ...Eg., Kohacon - For past events , **** one month back is the cut-off ****. * News items can be of any length. * Images are fine * Anything and everything Koha. * Submit by the 26th of the month. If you are working on an interesting project or development related to Koha, please let me know and I'll include it in the development section. Thank you! -- Chad Roseburg Editor, Koha Community Newsletter

1 0

payment for lost item not showing on account
by Scott Owen 13 Feb '18

13 Feb '18

Hi all, We have an issue with (at least) 1 patron that we have discovered. The issue as far as I can see..goes something like this: Patron checked out book Patron lost book. Circ marked book as lost, and applied the correct fine ($10.00) Patron paid fine. ...the issue is, the fine and lost book show on the patron account (in red text) , and the patron balance shows as "$.0.00" This is correct. ....but ...... nowhere in the patron record does it show the $10.00 payment for the lost book? Are we looking in the correct spot ? Seems that the patrons payment for the lost item should show somewhere in their history / account ? Thank you, -Scott Owen

2 1

Deleted the Admin User - Can't Login
by Balaji Ravichandran 13 Feb '18

13 Feb '18

Hi, I have accidentally deleted the Admin User Patron from the Patron List. Now I can't login to the Admin Panel in Koha. - How can I recover back? - How can recreate the User in Koha? - Is there any way to add the User to DB or through Scripts? Help needed. -- Best Regards, Balaji Ravichandran

2 1

Z39.50 authority server anyone?
by Rubeno Fernández 12 Feb '18

12 Feb '18

Hello, I'm trying to set up my Koha as a Z39.50 server. So far I can serve biblio data, but can't serve authorities. Has anybody achieved a working configuration? This is what yaz-client reports: yaz-client tcp:biblioteko.esperanto.cat:9999 Connecting...OK. Sent initrequest. Connection accepted by v3 target. ID : 81 Name : Zebra Information Server/GFS/YAZ Version: 4.2.30 98864b44c654645bc16b2c54f822dc2e45a93031 Options: search present delSet triggerResourceCtrl scan sort extendedServices namedResultSets Elapsed: 0.360845 Z> base biblios Z> find Zamenhof Sent searchRequest. Received SearchResponse. Search was a success. Number of hits: 509, setno 1 SearchResult-1: term=Zamenhof cnt=509 records returned: 0 Elapsed: 0.066083 Z> base authorities Z> find Zamenhof Sent searchRequest. Received SearchResponse. Search was a bloomin' failure. Number of hits: 0, setno 2 Result Set Status: none records returned: 0 Diagnostic message(s) from database: [109] Database unavailable -- v2 addinfo 'authorities' Elapsed: 0.054520 So, the biblio database is served, but the authority database is unavailable. To activate the server, I uncommented all the relevant parts of the file /etc/ koha/sites/esperanto/koha-conf.xml:  <listen id="publicserver" >tcp:@:9999</listen> However, if you uncomment that aforementioned section, you see it only relates to bibliographic records:   <server id="publicserver" listenref="publicserver"> <directory>/var/lib/koha/esperanto/biblios</directory> <config>/etc/koha/sites/esperanto/zebra-biblios-dom.cfg</config> <cql2rpn>/etc/koha/zebradb/pqf.properties</cql2rpn> <xi:include href="/etc/koha/marc21-retrieval-info-bib-dom.xml" xmlns:xi="http://www.w3.org/2001/XInclude"> <xi:fallback> <retrievalinfo> <retrieval syntax="marc21" name="F"/> <retrieval syntax="marc21" name="B"/> <retrieval syntax="xml" name="F"/> <retrieval syntax="xml" name="B"/> <retrieval syntax="xml" name="marcxml" identifier="info:srw/schema/1/marcxml-v1.1"> <backend syntax="marc21" name="F"> <marc inputformat="marc" outputformat="marcxml" inputcharset="utf-8"/> </backend> </retrieval> <retrieval syntax="xml" name="dc"> <backend syntax="marc21" name="F"> <marc inputformat="marc" outputformat="marcxml" inputcharset="utf-8"/> <xslt stylesheet="/usr/share/koha/intranet/htdocs/intranet-tmpl/ prog/en/xslt/MARC21slim2DC.xsl"/> </backend> </retrieval> <retrieval syntax="xml" name="mods"> <backend syntax="marc21" name="F"> <marc inputformat="marc" outputformat="marcxml" inputcharset="utf-8"/> <xslt stylesheet="/usr/share/koha/intranet/htdocs/intranet-tmpl/ prog/en/xslt/MARC21slim2MODS.xsl"/> </backend> </retrieval> <retrieval syntax="xml" name="rdfdc"> <backend syntax="marc21" name="F"> <marc inputformat="marc" outputformat="marcxml" inputcharset="utf-8"/> <xslt stylesheet="/usr/share/koha/intranet/htdocs/intranet-tmpl/ prog/en/xslt/MARC21slim2RDFDC.xsl"/> </backend> </retrieval> <retrieval syntax="xml" name="rss2"> <backend syntax="marc21" name="F"> <marc inputformat="marc" outputformat="marcxml" inputcharset="utf-8"/> <xslt stylesheet="/usr/share/koha/intranet/htdocs/intranet-tmpl/ prog/en/xslt/MARC21slim2RSS2.xsl"/> </backend> </retrieval> <retrieval syntax="xml" name="utils"> <backend syntax="marc21" name="F"> <marc inputformat="marc" outputformat="marcxml" inputcharset="utf-8"/> <xslt stylesheet="/usr/share/koha/intranet/htdocs/intranet-tmpl/ prog/en/xslt/MARC21slimUtils.xsl"/> </backend> </retrieval> </retrievalinfo> </xi:fallback> </xi:include> <xi:include href="__KOHA_CONF_DIR__/zebradb/explain-biblios.xml" xmlns:xi="http://www.w3.org/2001/XInclude"> <xi:fallback> <explain xmlns="http://explain.z3950.org/dtd/2.0/"> <serverInfo> <host>__ZEBRA_SRU_HOST__</host> <port>__ZEBRA_SRU_BIBLIOS_PORT__</port> <database>biblios</database> </serverInfo> </explain> </xi:fallback> </xi:include> </server> <serverinfo id="publicserver"> <ccl2rpn>/etc/koha/zebradb/ccl.properties</ccl2rpn> <user>Carles</user> <password>Puigdemont</password> </serverinfo> So, do I need a similar 'server' and 'serverinfo' section for authorities? In that case, should I also create a 'listen' entry with a different port? What's your configuration? Has anybody got an authority server running? Rubén Fernández

1 1

Re: [Koha] Data problems
by Johan Seyfferdt 10 Feb '18

10 Feb '18

Hi. Have you fixed your problem yet? I had a similar situation a few weeks ago and I am willing to help if you still need it. Johan On Feb 5, 2018 14:37, "Ashok Francis" <ashokfrancis.tgs(a)gmail.com> wrote: Dear All, I am using Koha 17.11.02 version. When I visit the page About Koha --- system information---, I am getting the information like data problem. Can anyone please help me how to solve this problem? Data problems Some of your tables have problems with their auto_increment values which may lead to data loss. *You should not ignore this warning.* The problem is that InnoDB does not keep auto_increment across SQL server restarts (it is only set in memory). So on server startup, the auto_increment values are set to max(table.id)+1. To know how to avoid this problem see the related wiki page: DBMS auto increment fix <https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix> Problems foundPatrons The following ids exist in both tables *borrowers* and *deletedborrowers*: 1322 Items The following ids exist in both tables *items* and *deleteditems*: 15979, 15980, 20761, 21245 Holds The following ids exist in both tables *holds* and *old_reserves*: 2, 3, 1 I will be thankful to you. Ashok. New Delhi. _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

3 2

Cronjob Settings Help ?
by SATISH 09 Feb '18

09 Feb '18

Hi, What is the correct procedure to use cronjobs for sending emails. With the package method installation of Koha 17.11.11 on Ubuntu 16.04 Server, postfix smtp setup has been done. I have a Koha instance called "igntucl" and koha user created as '"gntucl-koha" And cronjob entries are found in crontab.example @ * /usr/share/koha/bin/cronjobs* Should this be run as: crontab -u root crontab.example or crontab -u igntucl-koha crontab.example ? and crontab.example is edited for pointing to koha-conf.xml location export PERL5LIB=/usr/share/koha/lib export KOHA_CONF=/etc/koha/sites*/igntucl/*koha-conf.xml crontab -e (accessed from root user) shows __KOHA_USER__ $KOHA_CRON_PATH/ process_message_queue.pl But still I am getting error as: unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 243. Could you please explain what is correct way of enabling/ working with cron job for Koha? With Thanks Satish MV Librarian Govt. Engineering College, Hassan

5 10

Data problems
by Ashok Francis 08 Feb '18

08 Feb '18

Dear All, I am using Koha 17.11.02 version. When I visit the page About Koha --- system information---, I am getting the information like data problem. Can anyone please help me how to solve this problem? Data problems Some of your tables have problems with their auto_increment values which may lead to data loss. *You should not ignore this warning.* The problem is that InnoDB does not keep auto_increment across SQL server restarts (it is only set in memory). So on server startup, the auto_increment values are set to max(table.id)+1. To know how to avoid this problem see the related wiki page: DBMS auto increment fix <https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix> Problems foundPatrons The following ids exist in both tables *borrowers* and *deletedborrowers*: 1322 Items The following ids exist in both tables *items* and *deleteditems*: 15979, 15980, 20761, 21245 Holds The following ids exist in both tables *holds* and *old_reserves*: 2, 3, 1 I will be thankful to you. Ashok. New Delhi.

5 6

How to snapshot / restore a Koha Database?
by Chris Brown 08 Feb '18

08 Feb '18

Gentle Reader, I need to deliver multiple Koha training sessions for several groups of volunteers who work on our front desk. I'll be setting a specific series of tasks and it will be much easier if I can "reset" the database to a previous checkpoint before each session so we can re-run the same tasks. So ... I've tried the sequence koha-dump / koha-remove / koha-restore; I got a list of "File exists" errors when I did the koha-restore (mostly in /var/lib/koha/stand, where "stand" is my instance name). These didn't trouble me too much but I then had to fix a missing /etc/apache2/sites-enabled/stand.conf and a missing /var/log/koha/stand directory before apache would start up. Now, when I try to log in I get a perl error about an unblessed reference in /usr/share/koha/lib/Koha/Database.pm (line 56). This is getting too deep into the code for me to have much hope of debugging it, so before I spend more time on this (or give up entirely) does anyone have any advice on the right command sequence (with the right options) that I can use to achieve this in a clean, pain-free way? Thanks and Best Regards, Chris Brown

2 1

Re: [Koha] ailed to load external entity "/etc/koha/sites/-/koha-conf.xml
by takan bhatt 08 Feb '18

08 Feb '18

Sir While executing Create a Koha instance Only do this if you are running MySQL locally. Replace *libraryname* with the name of your library: $ sudo koha-create --create-db libraryname I am getting msg that /etc/../koha-conf.xml not found. I search code for this file and created using leafpad editor. But I falied. Now, I am requesting that from beginning which command line I should follow and in which order. I am using debian under VB (host is windows 7). Bcoz so many blogs and videos are confusing. From one to another, steps are different. As a beginner I am confused. So, Now, first I want to remove what have been installed. I installed koha-common and mariadb both. On 08-Feb-2018 11:15 PM, "Paul Hoffman" <paul(a)flo.org> wrote: On Thu, Feb 08, 2018 at 04:43:30AM -0500, takan bhatt wrote: > after installation over I am getting this msg > > ailed to load external entity "/etc/koha/sites/-/koha-conf.xml It sounds like you accidentally gave your Koha instance the name "-". Can you please tell us which instructions you were using? Also, what is the output of the following command? ls -l /etc/koha/sites Paul. -- Paul Hoffman <paul(a)flo.org> Software Manager Fenway Library Organization 550 Huntington Ave. Boston, MA 02115 (617) 442-2384 (FLO main number) _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

2 4