December 2007 - Koha-devel - lists.koha-community.org

Re: RFC - installer changes
by Bradley Peters 13 Dec '07

13 Dec '07

I downloaded the tarball, and used the single installation method. The computer I tested on is running Ubuntu 7.10. The command line portion of the installer appeared to work very well. When I got to the web portion I wasn't sure which username to use as there were 2 in the commandline portion. The one I tried first (kohauser) was the wrong one. Further along at step 3, the installer said it had all the required privileges on the database but on the next screen I got the following error message. ERROR 1142 (42000) at line 22: DROP command denied to user 'kohaadmin'@'localhost' for table 'accountlines' Sincerley, Bradley Peters

2 4

small typo
by Ignacio Javier 12 Dec '07

12 Dec '07

Just a maybe "not to take a blind bit of notice" issue, there is an inversion letters typo in: http://www.kohadocs.org/koha_diary.html, chapter 9, in the title. Greetings, Ignacio

1 0

Two patches to the NPL z39.50 template
by Nicholas van Rheede van Oudtshoorn 10 Dec '07

10 Dec '07

Hi there, These two patches allow the NPL template to actually return meaningful search results. The first patch simply adds inverted commas to parameters (without them, it doesn't work!). The second patch changes the results table to show where each record comes from - much like the default template. These patches are to Koha 2.2.9 Hopefully this is of some use... Nicholas van Oudtshoorn Perth Bible College, Western Australia

1 0

Permissions, Staff category_type and 'kohaadmin'
by Ryan Higgins 09 Dec '07

09 Dec '07

To address the permissions issues wherein a user with the borrowers flag could edit login information for a user with more permissions, I've added a new category_type of 'Staff'. To edit permissions and login data for a patron in a 'Staff' category_type, the editing user must have the new flag 'staffaccess'. There are no limits on assignable permissions for a non-Staff member, though that's something that should happen in the near future. So any user with permission to edit borrowers should be in a category of type Staff. -- Ryan Higgins LibLime * Open-Source Solutions for Libraries Featuring KohaZOOM ILS 888-564-2457 x704

1 0

Any interest in adding MP3 ID3v2 read/write capability to Koha?
by Chris Nighswonger 05 Dec '07

05 Dec '07

Hi, We have a good sized collection (and growing) of MP3 encoded audio that we plan to use Koha to catalog. Most of our MP3's have to have tags created and added to them. A few have tags already. The job of creating them could be made a lot easier by adding the ability to write ID3v2 tags to the MP3's based on the corresponding marc record for the audio archive. (Our in-house software does this currently, but is coded in VB rather than Perl.) We have been looking at using MP3::Tag to incorporate this read/write capability into Koha. To do this right, I think some discussion is in order prior to beginning. I'd like to hear feedback on two points: 1. From the user prospective: Is there any interest/demand for this type of feature? 2. From the developer prospective: What is the best mapping plan for marc fields to ID3v2 frames and vise-versa? If you are not familiar with the ID3v2 standard, take a look at http://www.id3.org/id3v2.4.0-frames which is probably the relevant part for this discussion. Regards, Chris -- Chris Nighswonger Faculty Member Network & Systems Director Foundations Bible College & Seminary www.foundations.edu www.fbcradio.org

4 8

Tag error, and CGI::Carp and DebugLevel misbehaviour
by Ignacio Javier 05 Dec '07

05 Dec '07

Hi all: 1) When trying to add a MARC Record (Addbiblio.pl), appears a software error: Tag "" is not a valid tag. at /usr/local/share/perl/5.8.8/C4/Biblio.pm line 2307 CGI::Carp 2) On the other hand a: mysql> SELECT variable,value FROM systempreferences WHERE variable LIKE %debug%'; results in: +------------+-------+ | variable | value | +------------+-------+ | DebugLevel | 2 | +------------+-------+ 1 row in set (0.00 sec) Seems I've got maximum debug level set, but in fact is not sending to browser the perl call stack dump, as expected (and not any "debug level 2" message). Anybody knows why? ----------------- Dump of about.pl: Server information Koha version: 3.00.00.031 OS version ('uname -a'): Linux ignaciojavier 2.6.18-5-686 #1 SMP Wed Oct 3 00:12:50 UTC 2007 i686 GNU/Linux Perl version: 5.008008 MySQL version: mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2 Apache version: Zebra version: Zebra 1.3.50 $Date: 2007-10-16 10:10:37 $ (C) 1994-2005, Index Data ApS Using: libbzip2, (C) 1996-1999 Julian R Seward. All rights reserved. Using: Tcl 8.3 Perl modules Biblio::EndnoteStyle 0.05 CGI 3.15 CGI::Carp 1.29 CGI::Session 4.20 Class::Accessor 0.31 Class::Factory::Util 1.7 DBD::mysql 3.0008 DBI 1.53 Data::Dumper 2.121_08 Date::Calc 5.4 Date::Manip 5.44 Digest::MD5 2.36 File::Temp 0.19 GD::Barcode::UPCE 1.1 Getopt::Long 2.35 Getopt::Std 1.05 HTML::Template::Pro 0.65 HTTP::Cookies 1.39 HTTP::Request::Common 1.26 LWP::Simple 1.41 LWP::UserAgent 2.033 Lingua::Stem 0.82 List::Util 1.19 Locale::Language 2.07 MARC::Charset 0.98 MARC::Crosswalk::DublinCore 0.02 MARC::File::XML 0.86 MARC::Record 2.0.0 MIME::Base64 3.07 MIME::QuotedPrint 3.07 Mail::Sendmail 0.79 Net::Z3950::ZOOM 1.21 PDF::API2 2.014 PDF::API2::Page 2.001 PDF::API2::Util 2.000 PDF::Reuse 0.33 PDF::Reuse::Barcode 0.05 POSIX 1.09 Schedule::At 1.06 Term::ANSIColor 1.10 Test 1.25 Test::Harness 3.03 Test::More 0.72 Text::CSV 0.01 Text::Wrap 2005.082401 Time::HiRes 1.86 Time::localtime 1.02 Unicode::Normalize 0.32 XML::Dumper 0.81 XML::LibXML 1.65 XML::LibXSLT 1.63 XML::RSS 1.31 XML::SAX::ParserFactory 1.01 XML::Simple 2.14 ------------------------------------- Ignacio Javier Gómez Rodríguez Área de Consultoría Tfno: 902905590 - Fax: 981571425 ignacio.gomez(a)coremain.com www.coremain.com

2 2

field 856 not in record.abs
by Paul POULAIN 05 Dec '07

05 Dec '07

Hello, I just noticed that the field 856 (URLs, same field in MARC21 and UNIMARC) is not in record.abs, and thus not indexed. Not sure it's a real problem, but just to let you know. -- Paul POULAIN BibLibre SARL Expert en Logiciels Libres pour l'info-doc Tel : 04 91 31 45 19

1 0

stats.print.pl requires Text::CSV_XS ??
by Joe Atzberger 05 Dec '07

05 Dec '07

In reports, the script reports/stats.print.pl requires module Text::CSV_XS. Is this script current or is it obsolete? The module dependency does not seem to be explicit in our installation scripts or documentation. --Joe Atzberger LibLime

2 1

flavour as UNIMARC
by Ignacio Javier 05 Dec '07

05 Dec '07

Hi all: I continue in my persistence on paths to reach "the unobtrusive panelled krakatoa firing guide": ** Where can I define flavour as UNIMARC from the koha 3.00 administrative panel? Again, tachyonic thanks, Ignacio

2 1

Different KOHA databases on same Server
by ZANG 05 Dec '07

05 Dec '07

Is it possible to have multiple KOHA databases on the same Server. With other words is there a way to force one group of clients to use one database and the other group a different database? Does KOHA make provision for that? I will appreciate help on that!

3 2