- Koha - lists.katipo.co.nz

Spam in logs
by James Weinheimer 27 Jun '08

27 Jun '08

All, I am working with Koha 2.2.7 (trying to get 3 going!) and I have had problems with the computer crashing lately. (It's on a poor machine) But in my kohalogs, I have found some spam such as: [Wed Jun 25 06:49:57 2008] [error] [client 91.151.224.21] Q2 : select distinct m1.bibid from biblio,biblioitems,marc_biblio,marc_word as m1,marc_subfield_table as m2,marc_subfield_table as m3,marc_subfield_table as m4,marc_subfield_table as m5,marc_subfield_table as m6,marc_subfield_table as m7,marc_subfield_table as m8,marc_subfield_table as m9 where biblio.biblionumber=marc_biblio.biblionumber and biblio.biblionumber=biblioitems.biblionumber and m1.bibid=marc_biblio.bibid and (m1.bibid=m2.bibid and m1.bibid=m3.bibid and m1.bibid=m4.bibid and m1.bibid=m5.bibid and m1.bibid=m6.bibid and m1.bibid=m7.bibid and m1.bibid=m8.bibid and m1.bibid=m9.bibid) and ((m1.word like 'RESM') (m2.subfieldvalue 'RES') (m3.subfieldvalue 'http://freedeliverypillz.bravehost.com/freedeliverypillz.html free delivery pillz\\r\\n<a href=\\"http://freedeliverypillz.bravehost.com/freedeliverypillz.html\\">fre e delivery This URL is repeated lots of times in the same error message, and afterwards the system does a separate search for each url in my catalog, and eventually crashes the machine. [Wed Jun 25 06:49:57 2008] [error] [client 91.151.224.21] eliverypillz.bravehost.com/freedeliverypillz.html]free delivery pillz[/url] http://freedeliverypillz.bravehost.com/freedeliverypillz.html free delivery pillz\r, referer: http://www.galileo.aur.it/cgi-bin/koha/opac-search.pl This has happened with different urls, some much more rude that this one! 1) how is this insinuating itself into search m3.subfieldvalue, and 2) how do I deal with it? Just through the apache server with mod_security? Do I have to worry about somebody messing up my database? Thanks in advance, Jim James Weinheimer j.weinheimer(a)aur.edu Director of Library and Information Services The American University of Rome via Pietro Roselli, 4 00153 Rome, Italy voice- 011 39 06 58330919 ext. 327 fax-011 39 06 58330992

2 2

Prerequisites for Koha 3 on Debian 4.0 r 3 Etch
by Ata ur Rehman 27 Jun '08

27 Jun '08

Dear All I have been using Koha on Windows XP. Now I am installing Koha 3 stable release on Debian 4.0 r3 Etch. I have installed Debian on HP Pavilion dv6500 Notebook. I am new to linux too. I am looking for some detailed information about pre-requisites for Koha 3 (Versions of Apache, MySQL, Perl, Zebra, Yaz, etc). Also some detailed installation guide for Koha 3. Thank you in anticipation Regards, Ata ur Rehman LISolutions http://www.lisolutions.org/

2 1

error in install koha3 on ubuntu8.04
by mohamed megahed 27 Jun '08

27 Jun '08

Hi to all i need to help im trying to install koha3 beta 2 on ubuntu 8.04, Apache2, mysql 5 when i run : perl Makefile.PL i get that error in end please help me make: *** No rule to make target `fix-perl-path.PL', needed by `blib'. Stop. thnks _________________________________________________________________ Explore the seven wonders of the world http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE

1 0

Koha 3 users guide
by Michael Lasater 26 Jun '08

26 Jun '08

Hello all, I was wondering if there was a document for Koha 3 similar to the one for version 2.2 that is located at http://www.kohadocs.org/usersguide/ ? Even an incomplete document would be wonderful. Thank you, Michael

2 1

Announcing Koha 3.0 (RC1)
by Joshua Ferraro 26 Jun '08

26 Jun '08

Hi folks, I'm happy to announce that a packaged RC1 release of Koha 3 is now available. You can download from the usual location: http://download.koha.org/koha-3.00.00-stableRC1.tar.gz http://download.koha.org/koha-3.00.00-stableRC1.tar.gz.sig You can check the integrity of the package; either by verifying the provided GPG signature (.sig) or by comparing the MD5 checksum: 5cc0914c5e8250c2491f4dbcf27d4301 koha-3.00.00-stableRC1.tar.gz I've also tagged this in Git as "version 3.00.00 stableRC1" v3.00.00-stableRC1 This is the third packaged release of Koha 3. Prior to the official stable release of Koha 3.0, translations will be updated; additional issues and bugs may be be addressed. A list of these are documented on Koha's Bugzilla: http://bugs.koha.org and organized on the 3.0 RM's QA notes Wiki page: http://wiki.koha.org/doku.php?id=en:development:qanotes3.0 The release notes for this RC1 version are pasted in below, and will also on the koha.org website sometime soon. Cheers, -- Joshua Ferraro Koha 3.0 Release Manager ============================================================================== RELEASE NOTES FOR KOHA 3.0 RC1 ============================================================================== Koha 3 is the next-generation release of the award-winning Koha open-source integrated library system. You can obtain Koha 3.0 RC1 from the following URL: http://download.koha.org/koha-3.00.00-stableRC1.tar.gz These Release Notes cover What's New in Koha 3, information about the new Revision control system (Git), and Version-release process, pointers to Download, Installation, and Upgrade documentation, a brief introduction to the new Templates, a call to Translation and Documentation writers, and finally, Known Issues with this version. ============================================================================== WHAT'S NEW IN KOHA 3? ============================================================================== 1. Zebra plugin - Zebra is a high-performance, general-purpose structured text indexing and retrieval engine. It supports large data sets (tens of millions of records) and includes support for SRU, Z39.50 and several query languages: CCL, CQL, and PQF. For more information about Zebra, please see: http://indexdata.dk/zebra Koha's new search engine, built on top of Zebra, supports features such as relevance ranking, field weighting, truncation, stemming, use of fuzzy operators, language-specific indexing, sorting, etc. Indexes are updated in real-time with circulation transactions, enabling limits by availability and statuses. Faceted refine-by limits are available from both staff and opac interfaces. For libraries that don't want the overhead of maintaing Zebra, Koha 3 ships with a NoZebra option, in which bibliographic and authority data is indexed in the RDBMS. 2. New installer - based on the common Perl module ExtUtils::MakeMaker, the new installer makes it a snap to get Koha running on just about any platform. The installer comes complete with a Developer's Toolkit target ('dev') that can be used to get a development environment linked directly to revision control, to support rapid prototyping and an agile development process. 3. Standard APIs - Koha 3 supports a number of important library search and retrieval standards and microformats, such as SRU/W, Z39.50 (http://www.loc.gov/standards/sru/) UnAPI (http://unapi.info/) and COinS/OpenURL (http://ocoins.info; http://www.niso.org/committees/committee_ax.html) Also supported is the popular Internet standard: OpenSearch (http://opensearch.a9.com/) created by Amazon's A9. Records are stored internally in an SGML-like format and can be retrieved in MARCXML, Dublin Core, MODS, RSS, Atom, RDF-DC, SRW-DC, OAI-DC, and EndNote; and the OPAC can be used by citation tools such as Zotero. Creating new export formats is a trivial exercise in writing XSLT; records can be passed through XSLT transformations either directly out of the index, or via a separate parsing function. To retrieve and interact with Circulation and Patron data, Koha 3 includes support for 3M's Standard Interchange Protocol (SIP2), using the OpenNCIP libraries (http://openncip.org) There are also an ever-expanding set of native REST APIs to handle interoperability with external tools such as third-party cataloging clients. These APIs provide authentication as well as add/edit/delete control over bibliographic data within a Koha system. For more information, see: http://wiki.koha.org/doku.php?id=en:development:web_services Koha 3 also includes pluggable authentication - easy integration with LDAP and Active Directory via the Auth_with_ldap module. The Amazon.com module can be enabled to enrich bibliographic data with jacket covers, professional reviews, ratings and comments from Amazon users, as well as point to 'Similar Items' within the catalog. OCLC's xISBN, and LibraryThing's ThingISBN can likewise be enabled to provide an 'Editions' tab on item detail pages. New with Koha 3 is service throttling for these services, to keep within subscription limits. 4. Cross-platform, multi-RDBMS, Web-server agnostic - Run Koha on the platform of your choice: Linux, Windows, Mac OS X, FreeBSD, Solaris. Koha 3 also includes better support for multi-RDBMS (MySQL 5.0 and PostgreSQL), and runs under Apache2, IIS, or the web server of your choosing. 5. Multi-lingual support - Koha was designed from the ground up for multilingual libraries. Koha 3 can handle Chinese, Japanese, and even right-to-left languages such as Arabic and Hebrew with ease (BiDi). Koha's index engine (Zebra) can handle record formats containing any UNICODE compliant script, such as Arabic, Chinese, Hebrew, Japanese and Korean. Zebra has this support via the ICU libraries created and maintained by IBM. You can translate Koha into your language using the built-in translation tools, or by visiting http://translate.koha.org. 6. New templates - Koha's staff and patron interfaces are developed with a template system that's easy to theme. The default templates are composed of 100% valid XHTML and CSS. Koha aims to meet or exceed U.S. Government Section 508 and W3C's WAI-AA standards for sight and motor impaired individuals. All Javascript usage comes with fallback modes that work in any web browser. 7. Koha 3 has quite a few new modules, as well as enhancements to existing modules, including: news writer, label creator, calendar, OPAC comments, MARC staging and overlay, notices, transaction logs, guided reports with a data dictionary and task scheduler, classification sources/filing rules. ============================================================================== REVISION CONTROL ============================================================================== With Koha 3, we've started using a new distributed revision control system called Git; it's the same system in use by many other projects, including the Linux Kernel. To learn more about how to develop Koha using Git, please see the Wiki page: http://wiki.koha.org/doku.php?id=en:development:git_usage ============================================================================== VERSION NUMBERING ============================================================================== With Koha 3, version numbering has been changed to use a method similar to Perl's: major.minor[.revision[.build]] * major: one digit * minor: two-digit * revision: two-digit * build: three-digit This release of Koha 3.0 is versioned 3.00.00.092. Every database change or significant enough code change requires an update to the 'build' number, and developers will be able to easily upgrade their systems using the built-in updater. Koha 3.0 Release Schedule: This release of Koha 3.0 includes the following general improvements over the beta release: * General Bugfixing (everyone) * New messaging enhancements (acmoore) * Lots of nomenclature cleanup * New testing suite (acmoore and gmcharlt) * SIP2 and LDAP fixes (atz) * Improved I18N/L10N, lang detection (kados) * Additional translations * Lots more, consult git.koha.org for the complete changelog This release candidate of Koha 3.0 will be followed by a stable release. Subsequent releases of 3.0 will be bugfix releases, and won't include any new features. New features will be available in Koha 3.2 and subsequent releases. ============================================================================== UPGRADING FROM A PREVIOUS VERSION OF KOHA ============================================================================== The upgrade process from a previous version of Koha is documented on the Wiki at the following page: Upgrading from 2.2 or earlier version: http://wiki.koha.org/doku.php?id=22_to_30 Upgrading from a previous version of 3.0: Please consult INSTALL files for details on how to upgrade ============================================================================== TEMPLATES ============================================================================== You may have heard that the templates for Koha 3 have been re-skinned; there is also the start of a template style guide on the Wiki: http://wiki.koha.org/doku.php?id=en:documentation:templates_style_guide Kudos to Owen Leonard and the Nelsonville Public Library for their contributions! ============================================================================== TRANSLATIONS ============================================================================== Koha 3.0 (this release) currently has complete translations for the following languages: OPAC: de-DE (German), el-GR (Greek), es-ES (Spanish), en (English), fr-FR (French) hu-HU (Hungarian), it-IT (Italian), pt-PT (Portuguese), tr-TR (Turkish), ru-RU (Russian), uk-UA (Ukranian) zh-Hans-CN (Simplified Chinese in China), zh-Hans-TW (Simplified Chinese in Taiwan) Staff Client fr-FR (French), en (English), hy-Armn (Armenian), ru-RU (Russian), uk-UA (Ukranian) zh-Hans-CN (Simplified Chinese in China), zh-Hans-TW (Simplified Chinese in Taiwan) Additionally, Koha 3 (this release) has partial translations for the following languages: OPAC: am-Ethi (Amharic), bg-Cyrl (Bulgarian), fa-Arab (Persian), fi-FI (Finnish) gl (Galego), he-Hebr (Hebrew), id-ID (Indonesian), ja-Japn (Japanese), kn-Knda (kannada), ko-Kore (Korean), mi-NZ (Maori), pl-PL (Polish), tet (Tetum) Staff Client: de-DE (German), el-EL (Greek), es-ES (Spanish), hu-HU (Hungarian), ja-Japn (Japanese), tr-TR (Turkish), The Koha Team welcomes additional translations; please see http://www.kohadocs.org/usersguide/apb.html for information about translating Koha, and join the koha-translate list to volunteer: http://lists.nongnu.org/mailman/listinfo/koha-translate ============================================================================== DOCUMENTATION ============================================================================== User-contributed documentation for Koha 3 is available on the Koha Wiki (http://wiki.koha.org) The Koha Team welcomes documentation contributions; please join the Koha-devel list to volunteer: http://lists.nongnu.org/mailman/listinfo/koha-devel ============================================================================== KNOWN ISSUES ============================================================================== Known bugs are documented on the Koha wiki: http://bugs.koha.org and at the 3.0 RM's QA notes Wiki page: http://wiki.koha.org/doku.php?id=en:development:qanotes3.0

5 4

Documentation - Koha 3 Outline
by gsl 25 Jun '08

25 Jun '08

All: We have started an outline of the functions found on various pages in Koha 3. Please understand this is a work in progress and just for our own internal use as we try to document some of the things that we need for our testing of Koha 3. However, thinking that it might be of some value to others I've posted it to our website. If this grows up and seems to help others I'll slap a Creative Commons License statement on it somewhere, but for now it's just our (no longer totally) private notes. www.rollinghills.lib.mo.us/pages/RHCL_Koha3_Outline.pdf I realize a pdf isn't very friendly to modify; if anyone needs a copy in .odf let me know and I'll post that too. Also, we are doing a complete, total, new-from-the-ground-up rewrite of our website. If we lose this link in the next couple of days you can email me or Michael (mlasater(a)rollinghills.lib.mo.us) for a copy, or wait until the site comes back up. And finally, my thanks to Michael for doing the work on it. Greg Lawson Network Administrator Rolling Hills Consolidated Library 1912 N. Belt Highway St. Joseph, MO 64506 816-232-5479 x2303

1 0

Editing staged records
by Tim McMahon 25 Jun '08

25 Jun '08

In 2.2, records could be edited before they were moved from the reservoir into the catalog. There doesn't seem to be a way to edit staged records before moving them to the catalog. This is kind of like bug #2197 except the items would be edited before the transfer to the catalog instead of after. -- Tim McMahon Technical Services West Liberty Public Library 400 N. Spencer St. West Liberty, IA 52776 Phone: 319-627-2084 Fax: 319-627-2135 tmcmahon(a)wlpl.org http://www.wlpl.org

3 3

internal server error
by Carmel Young 25 Jun '08

25 Jun '08

Koha 2.2.9 on Windows. After many power and Internet hassles, we are back. Still haveing trouble with two functions of Koha 2.2.9. 1. Can't get the loc search funtion to work. 2. Can't generate barcodes. The following mesage is displayed; Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, webmaster@dummy-opac and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. As suggested, I went to the error folder in Apache config. and read from the HTTP_INTERNAL_SERVER_ file and read this: The server encountered an internal error and was unable to complete your request.  But I did not know where to insert this!!! Sorry!!! Looking for help, again! Thanks in anticipation, Carmel

1 0

koha.org down
by "Thommy M. Malmström" 25 Jun '08

25 Jun '08

I can't access anything on koha.org. Is it down? /Thommy M.

1 1

Display of book jacket images
by vimal kumar 25 Jun '08

25 Jun '08

Dear Friends, I would like to insert book cover images without depending Amazon. We work with Koha 2.2.9. I tried http://lists.katipo.co.nz/public/koha/2006/009892.html as per this old posting in Koha List. But this method work successful with Koha 2.2.5. I tried this method with Koha 2.2.9 with some modifications. I created a folder in our website space to deposit images as below. <img src="http://www.ourwebsite.com/P/.jpg" alt="Book Cover Image" /> But this does not working. Koha only take picture from root directory? as in <img src="/opac-tmpl/npl/en/images/P/.jpg" alt="Book Cover Image" /> I request your help to solve this problem. Any alternatives available? Vimal Kumar Asst. Librarian Asian School of Business Technopark Trivandrum-695 581 http://www.asb.edu.in/vimal ---------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

1 0