- Koha - lists.katipo.co.nz

Re: [Koha] Disk space requirement for Web Server
by franweimer＠juno.com 21 Feb '08

21 Feb '08

Christopher (& Jesse), Would the calculation not be rounded up to 1 KB, not 1MB, per record? Thus, each set of 1,000 records (1K each) would equal 1MB? 13,000 bib records would need a minimum of 13MB of storage. Is that right? The next question is, "How many keywords and other index pointers does KOHA have taking additional space per record?" Authority records also take space if you use them. In a non-KOHA, commercial program, I have as many authority records as I do bib records. Fran __________________________ Fran Weimer Dallas, TX 75236 -- Christopher Brown-Syed <cbrownsyed(a)cogeco.ca> wrote: Return-Path: <koha-bounces(a)lists.katipo.co.nz> Received: from mx05.vgs.untd.com (mx05.vgs.untd.com [10.181.44.35]) by maildeliver07.vgs.untd.com with SMTP id AABD5YL4BAB6TDK2 for <franweimer(a)juno.com> (sender <koha-bounces(a)lists.katipo.co.nz>); Tue, 19 Feb 2008 11:17:21 -0800 (PST) Received: from daddy.katipo.co.nz (daddy.katipo.co.nz [202.50.109.200]) by mx05.vgs.untd.com with SMTP id AABD5YL4AAVQEJQS (sender <koha-bounces(a)lists.katipo.co.nz>); Tue, 19 Feb 2008 11:17:20 -0800 (PST) Received: from localhost (localhost.localdomain [127.0.0.1]) by daddy.katipo.co.nz (Postfix) with ESMTP id 8224811E5D; Wed, 20 Feb 2008 08:17:18 +1300 (NZDT) Received: from daddy.katipo.co.nz ([127.0.0.1]) by localhost (daddy [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 25882-02; Wed, 20 Feb 2008 08:17:17 +1300 (NZDT) Received: from daddy.katipo.co.nz (localhost.localdomain [127.0.0.1]) by daddy.katipo.co.nz (Postfix) with ESMTP; Wed, 20 Feb 2008 08:17:17 +1300 (NZDT) Received: from localhost (localhost.localdomain [127.0.0.1]) by daddy.katipo.co.nz (Postfix) with ESMTP id CE6BD11E88 for <koha(a)lists.katipo.co.nz>; Wed, 20 Feb 2008 06:15:29 +1300 (NZDT) Received: from daddy.katipo.co.nz ([127.0.0.1]) by localhost (daddy [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 20925-09 for <koha(a)lists.katipo.co.nz>; Wed, 20 Feb 2008 06:15:18 +1300 (NZDT) X-Greylist: delayed 1391 seconds by postgrey-1.21 at daddy; Wed, 20 Feb 2008 06:15:18 NZDT Received: from fep7.cogeco.net (smtp2.cogeco.ca [216.221.81.29]) by daddy.katipo.co.nz (Postfix) with ESMTP for <koha(a)lists.katipo.co.nz>; Wed, 20 Feb 2008 06:15:18 +1300 (NZDT) Received: from [192.168.0.3] (d141-150-5.home.cgocable.net [24.141.150.5]) by fep7.cogeco.net (Postfix) with ESMTP id 6D2502E06; Tue, 19 Feb 2008 11:51:54 -0500 (EST) Message-ID: <47BB0922.5050808(a)cogeco.ca> Date: Tue, 19 Feb 2008 11:51:46 -0500 From: Christopher Brown-Syed <cbrownsyed(a)cogeco.ca> User-Agent: Mozilla Thunderbird 1.0.7 (Macintosh/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Jesse <pianohacker(a)gmail.com> Subject: Re: [Koha] Disk space requirement for Web Server References: <003201c872a7$d2cb8fc0$7862af40$(a)org.au> <ab4467480802190754x53ad9a94of5f7785762ac50af(a)mail.gmail.com> In-Reply-To: <ab4467480802190754x53ad9a94of5f7785762ac50af(a)mail.gmail.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at example.com X-Mailman-Approved-At: Wed, 20 Feb 2008 08:13:48 +1300 Cc: Koha Mailing List <koha(a)lists.katipo.co.nz> X-BeenThere: koha(a)lists.katipo.co.nz X-Mailman-Version: 2.1.5 Precedence: list List-Id: Discussion list for the Koha Library system <koha.lists.katipo.co.nz> List-Unsubscribe: <http://lists.katipo.co.nz/mailman/listinfo/koha>, <mailto:koha-request@lists.katipo.co.nz?subject=unsubscribe> List-Archive: <http://lists.katipo.co.nz/pipermail/koha> List-Post: <mailto:koha@lists.katipo.co.nz> List-Help: <mailto:koha-request@lists.katipo.co.nz?subject=help> List-Subscribe: <http://lists.katipo.co.nz/mailman/listinfo/koha>, <mailto:koha-request@lists.katipo.co.nz?subject=subscribe> Sender: koha-bounces(a)lists.katipo.co.nz Errors-To: koha-bounces(a)lists.katipo.co.nz X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at example.com X-ContentStamp: 6:3:2785513255 X-MAIL-INFO:38250d550d19fcec7819b178792da888484d89894559f85d91c5c529c1090c9ce53c8c4d9c0d6c15cc81ccec7945e919cc08 X-UNTD-Peer-Info: 202.50.109.200|daddy.katipo.co.nz|daddy.katipo.co.nz|koha-bounces(a)lists.katipo.co.nz X-UNTD-UBE:-1 Jesse wrote: >the MySQL database is >184 MiB for our catalog of roughly 13,000 books and 2,000 patrons. > Back in the pre-history of library automation (the 1980s), when space was tight and disks expensive, we used to estimate the size of a bibliographic database at 768 bytes per MARC record. I suspect that rounding up to 1 MB/ bib record is probably still a good guess. That's for the generic "title level" description, not including information about all the copies of a title. Don't forget to allow for annual growth, and extra room for abstracts or lengthy notes (e.g. for archival items or rare books), and for local holdings information, especially if you record journal issues. Chris Brown-Syed _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha _____________________________________________________________ Click for free info on discount teaching degrees programs. http://thirdpartyoffers.juno.com/TGL2121/fc/Ioyw6i3njBiMFblJrl0PPMctdwEABfL…

1 0

[Need Advices] Best Hardware Specs & Apache-MySQL Setting for Big Libraries?
by Suyadi 20 Feb '08

20 Feb '08

Dear All, We are from a University Library in Indonesia. We've successfully migrated to koha 3.0. Please visit our OPAC at http://search.lib.ums.ac.id Total Number of Bibliography is about 45,000 and 130,000 Items. Circulation Transactions is 1600 check-outs/day. Currently we are using IBM X3400 Server (Xeon E5405 and 1 GB Memory), Ubuntu 7.10, Apache Web Server & MySQL. However, we feel the system works quite slow especially in cataloging and circulations. Do we need to upgrade the hardware? or I need to tweak apache & mysql to improve my system? Regards, Suyadi UMS Library -- View this message in context: http://www.nabble.com/-Need-Advices--Best-Hardware-Specs---Apache-MySQL-Set… Sent from the Koha - Discuss mailing list archive at Nabble.com.

2 1

Install on Debian Etch
by harry wykman 20 Feb '08

20 Feb '08

I am running Debian ETCH. I have followed the install instructions as well as installing requisite items using CPAN. I cannot, however, install the last couple. Having run 'perl Makefile.PL', at the end I get: [Mon Feb 18 21:43:35 2008] Makefile.PL: Warning: prerequisite DBD::mysql 4.004 not found. We have 3.0008. [Mon Feb 18 21:44:05 2008] Makefile.PL: Warning: prerequisite XML::LibXSLT 1.59 not found. Writing Makefile for koha In attempting to install these in CPAN I get the following errors: cpan> install DBD::mysql Running install for module DBD::mysql Running make for C/CA/CAPTTOFU/DBD-mysql-4.006.tar.gz Is already unwrapped into directory /root/.cpan/build/DBD-mysql-4.006 Makefile.PL returned status 512 Running make test Make had some problems, maybe interrupted? Won't test Running make install Make had some problems, maybe interrupted? Won't install AND make: *** [blib/arch/auto/XML/LibXSLT/LibXSLT.so] Error 1 /usr/bin/make -- NOT OK Running make test Can't test without successful make Running make install make had returned bad status, install seems impossible Then when I run 'make install' I get: biblio:/home/harry/Desktop/koha-3.00.00-alpha# make install /usr/bin/perl "-Iblib/arch" "-Iblib/lib" fix-perl-path.PL blib chown: `koha:koha': invalid user make: *** [set_koha_ownership] Error 1 Any ideas? Thanks, Harry Wykman

3 2

Re: [Koha] Disk space requirement for Web Server
by Wojciech Zatorski 19 Feb '08

19 Feb '08

> > Hello Everyone, > > What is the usage bandwidth for a typical Koha library catalogue? Is it > possible to go over 40 megabytes of disc space (on a Web Server) and over > 400 megabytes of traffic per month? We have 1500 items in our catalogue. hm.. our databases have 23GB (logs and other strange stuff;), about 200.000 biblios, 45MB for KOHA CGI, 2 servers and 1Gbit connection speed.. but we have ~9 branches;) so about 100megabytes of disc space and 400 megabytes traffic will be ok:) bye -- The Main Library of Szczecin University. Computerization Department. http://bg.univ.szczecin.pl

1 0

Open Sesame & Open Source Evangelism
by Nicole Engard 19 Feb '08

19 Feb '08

Hello all, I just want to announce that as part of my new role as Open Source Evangelist at LibLime I will be blogging about libraries and open source (not limited to LibLime) at Open Sesame http://blogs.liblime.com/open-sesame/ . My intro post is here: http://blogs.liblime.com/open-sesame/archives/6 and the RSS feed for subscribing is here: http://feeds.feedburner.com/LibLimeOpenSesame . I look forward to hearing from all of you regarding open source in general and in regards to libraries. Feel free to email me with any news you think I might be interested in. I also can be found presenting about open source all over the place. Keep an eye on my schedule: http://www.web2learning.net/about-me/my-presentinglearning-calendar and make sure you come by and say hi if you're at the same event as I am. -- Nicole C. Engard Open Source Evangelist, LibLime (888) Koha ILS (564-2457) ext. 714 nce(a)liblime.com AIM/Y!/Skype: nengard http://liblime.com

1 0

alexandria to koha conversion
by skeewhiz＠aol.com 19 Feb '08

19 Feb '08

Hi, I work in an elementary school with about 600 students and have approx. 7000 books on my shelves. We use Alexandria. Alexandria works fine but our staff is asking for more. We spend about $500 a year on Alexandria tech support, which we seldom use. We only have our one primary library station, so I am the only one with access to library records. It would cost too much money for our school to afford purchasing extra workstation licenses for student/teacher access. We have one district computer technician for five schools. We can't rely on him for help. SO Is Koha worth looking into? I would love to use an open-source library system. I would love to have multiple access stations. I would love to have internet access....but....is this a reasonable option for a school with little tech support? What are your thoughts? Does Koha compare favorably with Alexandria. Is it a stable reliable system? Do you need programming skills to keep it up and running? Thank you, D. B. N. ________________________________________________________________________ More new features than ever. Check out the new AOL Mail ! - http://webmail.aol.com

1 0

Importing Data from CDSISIS into Koha
by manillah 19 Feb '08

19 Feb '08

Hi, I have just mamaged to install Koha 2.x for our small college and would like to import the existing Data from our CDS_ISIS. I did export the data in XML format using the CDS_ISIS export tool and now need help with changing it into MARC21 so that i can load it into Koha... rgd PM

4 3

Organizational Meeting for Koha Users Group
by John Brice 19 Feb '08

19 Feb '08

Dear Koha Mail list Member: Announcement! We will be having a formal organizational meeting of Kudos (Koha Users Group) at PLA. We are still working on the date and time of the event. Once it is determined we will e-mail everyone on the list of current developments. The meeting will be broken into two parts first meeting will be for existing Koha users or Koha users planning to be up and running within six months. This meeting will be an organizational meeting to discuss what type of national organization to form the agenda will be as follows: 1. How did we get here? A short history of Koha 2. Do we need a formal users group for Koha? 3. Develop a mission statement. 4. What type of structure do we need? 5. Form a committee of three to write a by-laws proposal. 6. Schedule next meeting. The second part of the meeting will be a general interest session and will be opened to anyone who is interested in Koha. I understand that there is an IRC meeting being organized to talk about exactly these same issues. I request that the meeting be postponed to after PLA. I ask for this postponement based on the following reasons: Previous meetings between vested parties of Koha, from many different nations, asked that any organizations based on the Koha ILS be based on national boundaries, ie the French Koha Organization. I believe that any Users Groups should be limited to only those individuals who are using Koha presently or are planning to use Koha within a relatively short time, say six months or so. Using the IRC to form an new organization as complicated and unique as a Koha User's Group would be difficult at best and and anarchy at worst. Once we have some sort of structure in place we can then use the IRC channel to discuss specific steps and or issues. But to get started we need at least one sit down meeting with 7 to 10 vested users of the Koha ILS. I understand that many of you may be asking yourselves what the heck is going on here, who is in charge of the Koha Users Group? Well the answer is no one is at this time, hence the confusion and multiple paths of discussion. Each library has to make their own decision about the best path to follow in helping form a users group. Anyone else interested in discussing this matter with me can reach me at jbrice(a)ccfls.org or call me at 814-336-1773. Sincerely, John Brice System Administrator Crawford County Federated Library System Executive Director Meadville Public Library

3 3

koha alpha 3.0 Install
by Jim LaValle 18 Feb '08

18 Feb '08

I'm trying to install koha 3.0 alpha on Debian Etch i386 with mysql 5.0.32 I'm following the instruction files (I think). My problem; when I run make test I get an error that koha.systempreferences doesn't exist and also other mysql tables. When I look for mysql tables in my database, the database is there, but no tables. I don't understand when and where the tables get created? Help would be appreciated. jimlavalle(a)comcast.net

2 1

Limit on z39.50 search results?
by George Adams 18 Feb '08

18 Feb '08

I'm just getting started with Koha 3.0 alpha, and so far most things seem to be going smoothly. I've noticed, however, when I go to "Cataloguing" to add a new record, fill in the title, then use the z39.50 search to import the rest of the details, the window with search results only displays a maximum of 20 records. Now I know there are more results than just 20 for the titles I put in, especially if they're fairly generic (e.g. "Learning Biology"). Is there a configuration setting somewhere that will remove the 20-record limit I'm getting? (I know I could use a more specfic identifier like the ISBN, but sometimes it's handy to search by title even if I have to scroll through dozens of records. That is, if it's even possible not to have the 20-record limit). Thanks! _________________________________________________________________ Climb to the top of the charts! Play the word scramble challenge with star power. http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_jan

2 1