- Koha - lists.katipo.co.nz

How to know Table name used with column names where user login & passwords are stored in KOHA.
by Abdullah Al-Modabber 13 Nov '14

13 Nov '14

Hi Would you please guide me how to know Table name used with column names where user login & passwords are stored. This is needed to configure Ezproxy authentication through Koha Also How much previlege may be given to access to Koha Database to a user My Koha Details Koha version: 3.12.02.000 OS version ('uname -a'): Linux library 2.6.32-5-amd64 #1 SMP Fri May 10 08:43:19 UTC 2013 x86_64 GNU/Linux Perl interpreter: /usr/bin/perl Perl version: 5.010001 Perl @INC: /usr/share/koha/lib /etc/perl /usr/local/lib/perl/5.10.1 /usr/local/share/perl/5.10.1 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl . MySQL version: mysql Ver 14.14 Distrib 5.1.66, for debian-linux-gnu (x86_64) using readline 6.1 Apache version: Server version: Apache/2.2.16 (Debian) Zebra version: Zebra 2.0.44 (C) 1994-2010, Index Data ApS Zebra is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. SHA1 ID: 419ad759807269fdfa379799a051ed3a551c6541 Using ICU Thank you Abdullah al-Modabber New Delhi http://library.sau.ac.in

4 3

Restrict Patron just to the library the Item is from
by anjoze 12 Nov '14

12 Nov '14

Suppose I have libraries A, B and C. Patron X borrow a book on library A and then was restricted. Is there a way to restrict just to Library A and let him borrow on libraries A and C? Thanks ----- Koha version: 3.08.04 - - José Anjos -- View this message in context: http://koha.1045719.n5.nabble.com/Restrict-Patron-just-to-the-library-the-I… Sent from the Koha-general mailing list archive at Nabble.com.

4 6

Zebra indexing error
by Araik Manukyan 12 Nov '14

12 Nov '14

Hi List! We have upgraded our koha from 3.14 to 3.16 ,then removed zebra index. When we want to rebuild zebra using ./rebuild_zebra.pl -b -a -r -v , it brings such errors Please, help to solve this problem. Best regards, Araik ****************************************************************** b738e000-b738f000 rw-p 00017000 fc:00 59772527 /lib/i386-linux-gnu/libpthread-2.15.so b738f000-b7391000 rw-p 00000000 00:00 0 b7391000-b739b000 r-xp 00000000 fc:00 3152051 /usr/lib/libyaz_icu.so.4.0.0 b739b000-b739c000 ---p 0000a000 fc:00 3152051 /usr/lib/libyaz_icu.so.4.0.0 b739c000-b739d000 r--p 0000a000 fc:00 3152051 /usr/lib/libyaz_icu.so.4.0.0 b739d000-b739e000 rw-p 0000b000 fc:00 3152051 /usr/lib/libyaz_icu.so.4.0.0 b739e000-b739f000 rw-p 00000000 00:00 0 b739f000-b73b3000 r-xp 00000000 fc:00 59769060 /lib/i386-linux-gnu/libz.so.1.2.3.4 b73b3000-b73b4000 r--p 00013000 fc:00 59769060 /lib/i386-linux-gnu/libz.so.1.2.3.4 b73b4000-b73b5000 rw-p 00014000 fc:00 59769060 /lib/i386-linux-gnu/libz.so.1.2.3.4 b73b5000-b73c4000 r-xp 00000000 fc:00 59768837 /lib/i386-linux-gnu/libbz2.so.1.0.4 b73c4000-b73c5000 r--p 0000e000 fc:00 59768837 /lib/i386-linux-gnu/libbz2.so.1.0.4 b73c5000-b73c6000 rw-p 0000f000 fc:00 59768837 /lib/i386-linux-gnu/libbz2.so.1.0.4 b73c6000-b73ce000 r-xp 00000000 fc:00 59772524 /lib/i386-linux-gnu/libcrypt-2.15.so b73ce000-b73cf000 r--p 00007000 fc:00 59772524 /lib/i386-linux-gnu/libcrypt-2.15.so b73cf000-b73d0000 rw-p 00008000 fc:00 59772524 /lib/i386-linux-gnu/libcrypt-2.15.so b73d0000-b73f7000 rw-p 00000000 00:00 0 b73f7000-b73fa000 r-xp 00000000 fc:00 59769313 /lib/i386-linux-gnu/libdl-2.15.so b73fa000-b73fb000 r--p 00002000 fc:00 59769313 /lib/i386-linux-gnu/libdl-2.15.so b73fb000-b73fc000 rw-p 00003000 fc:00 59769313 /lib/i386-linux-gnu/libdl-2.15.so b73fc000-b75a0000 r-xp 00000000 fc:00 59769161 /lib/i386-linux-gnu/libc-2.15.so b75a0000-b75a2000 r--p 001a4000 fc:00 59769161 /lib/i386-linux-gnu/libc-2.15.so b75a2000-b75a3000 rw-p 001a6000 fc:00 59769161 /lib/i386-linux-gnu/libc-2.15.so b75a3000-b75a7000 rw-p 00000000 00:00 0 b75a7000-b7681000 r-xp 00000000 fc:00 3152050 /usr/lib/libyaz.so.4.0.0 b7681000-b7682000 r--p 000d9000 fc:00 3152050 /usr/lib/libyaz.so.4.0.0 b7682000-b7723000 rw-p 000da000 fc:00 3152050 /usr/lib/libyaz.so.4.0.0 b7723000-b77a8000 r-xp 00000000 fc:00 3152056 /usr/lib/libidzebra-2.0.so.0.0.1 b77a8000-b77a9000 r--p 00084000 fc:00 3152056 /usr/lib/libidzebra-2.0.so.0.0.1 b77a9000-b77aa000 rw-p 00085000 fc:00 3152056 /usr/lib/libidzebra-2.0.so.0.0.1 b77aa000-b77ac000 rw-p 00000000 00:00 0 b77ac000-b77af000 r-xp 00000000 fc:00 4720721 /usr/lib/idzebra-2.0/modules/mod-grs-xml.so b77af000-b77b0000 r--p 00002000 fc:00 4720721 /usr/lib/idzebra-2.0/modules/mod-grs-xml.so b77b0000-b77b1000 rw-p 00003000 fc:00 4720721 /usr/lib/idzebra-2.0/modules/mod-grs-xml.so b77b1000-b77b3000 rw-p 00000000 00:00 0 b77b3000-b77b4000 r-xp 00000000 00:00 0 [vdso] b77b4000-b77d4000 r-xp 00000000 fc:00 59772531 /lib/i386-linux-gnu/ld-2.15.so b77d4000-b77d5000 r--p 0001f000 fc:00 59772531 /lib/i386-linux-gnu/ld-2.15.so b77d5000-b77d6000 rw-p 00020000 fc:00 59772531 /lib/i386-linux-gnu/ld-2.15.so bf972000-bf9b4000 rw-p 00000000 00:00 0 [stack] ==================== H

1 0

Email notices
by CTS-Programmer 3 (Paul Dokken) 12 Nov '14

12 Nov '14

I am trying to get email notification working correctly. I have check-in and checkout notices working fine. I even get a list of items when a patron checks in/out multiple items. The problems I have are I get duplicate messages for overdue items. The date and time is the same for both emails going out. The other problem is that when the DUEDGST notice goes out it does not show details of the items that are due. I am looking at the patron category where this is happening and I have the Advance notice set to 2 days and have Digests only checked. The only other options I have set are checkout check-in. Thanks, Paul Paul Dokken Software Developer SIL PNG Communication and Technology Services Ukarumpa EHP 444 | Papua New Guinea cts-prog3(a)sil.org.pg +675-537-3544 x4404 {Telecom} +675-7081-8666 {Digicel}

3 3

Getting error-site library does not exist
by Nilratan Bhattacharjee 12 Nov '14

12 Nov '14

During installation of koha on Ubuntu 12.04 LTS, I have found 1 error message.... when I have given command.... "sudo a2ensite library" I got a error "ERROR: Site library does not exist! Now problem is that I am able to run both Koha staff client and OPAC from the host computer i.e from my computer but i can't access my koha staff client from any other computer on my LAN network although I am able to access my koha OPAC using the ip address of my LAN network. Please help and solve the issue.

3 2

(Hour) Fine charging interval
by Jerwyn Fernandez 12 Nov '14

12 Nov '14

Amigos! How can I set in http://bywatersolutions.com/2013/05/08/circ-rules-koha310/ -- *BE AMAZING. BE SOUTHVILLE.* Jerwyn G. Fernadez, RL Basic Education Librarian Southville International School and Colleges Tel: 825-6374 loc.117/146 *Like us https://www.facebook.com/sisc.monarchs <https://www.facebook.com/sisc.monarchs>* *Follow us https://twitter.com/SISCMonarchs <https://twitter.com/SISCMonarchs>* * www.southville.edu.ph <http://www.southville.edu.ph/>* * https://www.youtube.com/watch?v=CEeXh3JyXRg <https://www.youtube.com/watch?v=CEeXh3JyXRg>* *http://library.southville.edu.ph* <http://library.southville.edu.ph>

1 0

help
by Olawale Ilesanmi 11 Nov '14

11 Nov '14

Hello , please, I am trying to install koha all over since I didnt get it right at first. When I copied and pasted the below command on the terminal it was a blank file that came up. Please, see the attached . AND I also noticed I have 2 koha_library on the database. I have also included the screen shot in the attached file. 1. *Edit configuration file:* *$ **sudo vi /etc/apache2/sites-available/library* Change intranet port to: *:8080 Please, I need help on how to fix this . Looking forward to reading from you. Many Thanks Olawale

1 0

Complete Data Migration solution from Libsys ILMS (Books and Journals)
by Vinod Kumar Mishra 11 Nov '14

11 Nov '14

Dear All, The following ( https://drive.google.com/file/d/0B2Cmcc6xutSgY3RFMmc3TTZpenc/view?pli=1 )are the General steps to get your libsys data in excel format for final conversion into Marc format to switching into other ILMS software. Please note that there are several other tips and tricks which you can use to convert your libsys data in excel, so that you can migrate in some other desired software like Koha, Newgenlib, Evergreen etc. The reports module given under Cataloging/Circulation/Serial of Libsys software can be used to get the data in Excel format. In-case you are not getting subject heading than it can be added at the time of excel data conversion as well as you can also group together all the same titles, but you should have at least ISBN/ISSN number in your records. Marc editor and excel (http://marcedit.reeset.net/downloads ) is wonderful software which not only converts your data in marc format but it also gives you opportunity to make your data standard before importing in new ILMS. In case of any help needed in this regard please feel free to contact. Thanking You With regards, Vinod Kumar Mishra, Assistant Librarian, Biju Patnaik Central Library, NIT Rourkela, Mob:91+9439420860 91+6612462103 (O) email: vinod_librarian(a)rediffmail.com : mishravk79(a)gmail.com

1 0

Request to be listed as Koha Support Provider (Koha Support Schweiz)
by Marc Véron 10 Nov '14

10 Nov '14

Dear List, We kindly request to list "Koha Support Schweiz" (www.koha-support.ch) as Support Provider. Koha Support Schweiz was founded in December 2011. Members of Koha Support Schweiz (www-koha-support.ch) are the companies 'marc veron ag' (www.veron.ch) and 'Pro Acta GmbH' (www.proacta.ch) Since 2012 we contribute to Koha (Marc Véron's first patch was pushed in April 2012). Our aim is to provide support for libraries, institutions and companies who want to evaluate and/or use mainstream Koha in Switzerland, and to contribute to the Koha Community. We help to translate Koha to German, and since version 3.8 we maintain the translation to German with Swiss orthography (important for schools). In 2014 we did about 100 signoffs and we had about 20 patches pushed. Some of our contributions for enhancements since 2012 are: Bug 7563 - Silently print slips using Firefox PlugIn jsPrintSetup Bug 7621 - Circulation: Match age restriction of title with borrower's age without using categories Bug 8301 - Display additional system information (preferences) on About page to minimize support cases Bug 12162 - Add class="branchcode" to body tag to make OPAC CSS-styleable per branch Bug 12763 - Add more information for users to OPAC Error 404 page Information for listing: ------------------------ Company Name: Koha Support Schweiz Contact Person: Marc Véron Contact email: koha(a)koha-support.ch Website: www.koha-support.ch Telephone: +41 61 483 84 61 Address: c/o marc veron ag Baslerstrasse 50 CH-4123 Allschwil Switzerland Short description of your services: Koha Support Schweiz provides consulting, support and services for libraries, institutions and companies who want to evaluate and/or use mainstream Koha in Switzerland. Please list our Demo- and Test-Server as well: http://kohademo-staff.mvlib.ch http://kohademo.mvlib.ch Thanks and kind regards For 'Koha Support Schweiz' Marc Véron www.koha-support.ch ------------------- marc veron ag informatik information internet Baslerstrasse 50 CH - 4123 Allschwil +41 61 483 84 61 www.veron.ch Acrobat / PDF - Lösungen seit 1995 Partner für Internet und Content Management Mitglied Koha Support Schweiz www.koha-support.ch

1 0

Koha 3.16.4 & http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7756
by Hugo Agud 10 Nov '14

10 Nov '14

Hello We are testing Koha 3.16 and we are having problems to send mail claim late issue. when we try to claim, we push to button, the serial changes into 'cliamed, but no mail sent, in order to make sure that somethings is wrong, we have checked logs from apache claims.pl: Bad or missing From address: '', referer: http://formacion-intra.orex.es/cgi-bin/koha/serials/claims.pl [Sat Nov 08 19:41:23 2014] [error] [client 83.55.68.172] [Sat Nov 8 19:41:23 2014] claims.pl: at /usr/share/koha/intranet/cgi-bin/serials/ claims.pl line 83, referer: http://formacion-intra.orex.es/cgi We have checked that was a bug for 3.8 and compared the patch with the current files and are identical, then it should work. We have check that provider has contact mail, we have added also booksellermail directly to mysql just in case, but the issue is still there Before adding this potential bug to bugzilla, we would ask if anybody have seen this issue also on 3.16.4? Note: installed via packagess Kindest Regards -- *Hugo Agud - Orex Digital * *www.orex.es <http://www.orex.es>* Director Passatge de la Llançadera, 3 · 08338 Premià de Dalt - Tel: 93 539 40 70 hagud(a)orex.es · http://www.orex.es/ No imprima este mensaje a no ser que sea necesario. Una tonelada de papel implica la tala de 15 árboles y el consumo de 250.000 litros de agua. Aviso de confidencialidad Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni está autorizado a recibirlo por el remitente), no está autorizado a copiar, reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje por error, por favor, notifíquenoslo inmediatamente y bórrelo de su sistema.

2 2