- Koha - lists.katipo.co.nz

new Koha mailing list
by Pat Eyler 25 Jun '03

25 Jun '03

We've just created a new mailing list to support the Brazilian effort to create a Portuguese translation of Koha. If you're interested in helping out, or just interested in seeing how things go, please subscribe to the mailing list by sending email to: koha-subscribe(a)br.koha.org and following the directions in the response you receive. -pate Pat Eyler Kaitiaki/manager migrant Linux sys admin the Koha project ruby, shell, and perl geek http://www.koha.org http://pate.eylerfamily.org

1 0

[Koha-devel] 2.0 release meeting
by Pat Eyler 25 Jun '03

25 Jun '03

Hello everyone, With a 2.0.0 release rapidly approaching, and a bunch of bugs needing to be found, reported, prioritized, and fixed, we're going to institute a weekly irc meeting to help handle the load. We'll meet every Wednesday at 1900 UTC in the #koha channel at irc.katipo.co.nz -- Anyone is welcome to attend, please bring your bug reports. If you can't make it this week (short notice, I know), please drop in to any of the meetings you can make. (Here are a couple of conversions follow) UTC France Seattle New Zealand Wed 19:00 Wed 21:00 Wed 12:00 Thu 07:00 (Please feel free to translate and/or forward this message to other mailing lists as appropriate.) -pate Pat Eyler Kaitiaki/manager migrant Linux sys admin the Koha project ruby, shell, and perl geek http://www.koha.org http://pate.eylerfamily.org ------------------------------------------------------- This SF.Net email is sponsored by: INetU Attention Web Developers & Consultants: Become An INetU Hosting Partner. Refer Dedicated Servers. We Manage Them. You Get 10% Monthly Commission! INetU Dedicated Managed Hosting http://www.inetu.net/partner/index.php _______________________________________________ Koha-devel mailing list Koha-devel(a)lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/koha-devel

1 0

More on MARC records
by Anne Zarinnia 24 Jun '03

24 Jun '03

Re: access to supply of MARC records. The school library community uses LM_Net - the school library network (prolific, be warned) and posted the following page to provide sources of MARC records and directions for their use: http://groups.yahoo.com/group/Free_MARC_Records/message/53 For those with no library background, these may need editing: 1) Your location, shelving classification etc 2) Subject headings appropriate to your needs and master list 3) Quick addition of summary and other notes to enhance subject access beyond the minimalist LC headings. There are editors. The Library of Congress page has conversion utilities on the page given earlier (http://www.lcweb.loc.gov/marc/marctools.html) If you have a whole library to do, it is worth paying for access to a commercial source. Cheers, Anne E. Anne Zarinnia, Associate Professor zarinnie(a)uww.edu Dept. Educational Foundations 262 472-1463 Univ. Wisconsin-Whitewater 262 472-1380 (secretary)

1 0

Where do you get you cataloguing info from?
by Max Stam 24 Jun '03

24 Jun '03

Gidday All I'm the Computer Technician/Systems Admin at our new school and we are looking for a library system here at Great Southern Grammar (Albany Western Australia). Our librarian is concerned about the cataloguing and search facilities of koha. I've looked at the stuff on MARC and as far as I can see, it does provide what we need, but then I'm not a librarian. Are you using some version of MARC or do you get your cataloguing info from somewhere else? Are there any "free" versions/subscriptions available? (Being a new school we don't have a lot of money to play with yet.) Thanks for any help Max Stam

3 2

RE: Installing Koha
by Jones, Steven 24 Jun '03

24 Jun '03

Im not asking for a one click install, far from it. What I am seeing is a broken installer, like I said Ive got further with attempting a manual install than I have using the installer. What I do need is a reliable install dependancy list in the manual, preferably backed up with some links to the perl modules, or an adequate description of each module so I can google it myself. I have made some notes while attempting the install over many days, here it is, Setting up mysql on RH9 (DRAFT) 1) Install the rpm. 2) a) Start at /etc/init.d/mysqld start b) service mysqld start 3) test with /usr/bin/mysqladmin version. # /usr/bin/mysqladmin version /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.56, for redhat-linux-gnu on i386 Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.56 Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 43 sec Threads: 1 Questions: 1 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.023 4) a) Set mysql and apache to start on boot chkconfig --level 235 httpd on 5) b) chkconfig --level 235 mysqld on c) check with chkconfig --list mysqld mysqld 0:off 1:off 2:on 3:on 4:off 5:on 6:off 6) change mysql root password with /usr/bin/mysqladmin -u root password <password> 7) create a Koha database instance /usr/bin/mysqladmin -uroot -p<password> create Koha 8) login to mysql user mysql -uroot -p<password> 9) create privs for the database mysql> grant all privileges on Koha.* to koha@localhost identified by 'koha-password'; mysql> grant all privileges on Koha.* to koha@localhost identified by '<koha-password>'; Query OK, 0 rows affected (0.00 sec) 10) Set up the script for koha, (from the install dir) mysql -ukoha -<password> Koha < koha.mysql 11) edit koha.conf to reflect the above changes, database=Koha hostname=localhost user=koha pass=<koha-pasword> 12) chown apache:apache /etc/koha.conf 13) chmod 0600 /etc/koha.conf 14) run perl script from the install dir, perl -I modules/ scripts/updater/updatedatabase Checking itemtypesearchgroups table... Adding itemtypesearchgroups table... Checking userflags table... Adding userflags table... Checking uploadedmarc table... Adding uploadedmarc table... Checking ethnicity table... Adding ethnicity table... Checking sessions table... Adding sessions table... Checking branchrelations table... Adding branchrelations table... Checking websites table... Adding websites table... Checking shelfcontents table... Adding shelfcontents table... Checking sessionqueries table... Adding sessionqueries table... Checking z3950results table... Adding z3950results table... Checking bookshelf table... Adding bookshelf table... Checking z3950queue table... Adding z3950queue table... Checking marcrecorddone table... Adding marcrecorddone table... Adding z3950servers table... Check table reserveconstraints Check column reserveid Adding reserveid field to reserveconstraints table... Execute: alter table reserveconstraints add column reserveid int Check table biblioitems Check column lccn Adding lccn field to biblioitems table... Execute: alter table biblioitems add column lccn char(25) Check column marc Adding marc field to biblioitems table... Execute: alter table biblioitems add column marc text Check column url Adding url field to biblioitems table... Execute: alter table biblioitems add column url varchar(255) Check table statistics Check column borrowernumber Check table deletedbiblio Check column abstract Adding abstract field to deletedbiblio table... Execute: alter table deletedbiblio add column abstract text Check table aqorders Check column budgetdate Adding budgetdate field to aqorders table... Execute: alter table aqorders add column budgetdate date Check table reserves Check column expires_date Adding expires_date field to reserves table... Execute: alter table reserves add column expires_date date Check column required_date Adding required_date field to reserves table... Execute: alter table reserves add column required_date date Check column id Adding id field to reserves table... Execute: alter table reserves add column id int auto_increment primary key Check table aqbooksellers Check column nocalc Adding nocalc field to aqbooksellers table... Execute: alter table aqbooksellers add column nocalc int(11) Check column invoicedisc Adding invoicedisc field to aqbooksellers table... Execute: alter table aqbooksellers add column invoicedisc float(6,4) Check table borrowers Check column password Adding password field to borrowers table... Execute: alter table borrowers add column password char(30) Check column flags Adding flags field to borrowers table... Execute: alter table borrowers add column flags int Check column userid Adding userid field to borrowers table... Execute: alter table borrowers add column userid char(30) Check table itemtypes Check column publictype Adding publictype field to itemtypes table... Execute: alter table itemtypes add column publictype char(30) Check table biblio Check column abstract Adding abstract field to biblio table... Execute: alter table biblio add column abstract text Check table deletedbiblioitems Check column lccn Adding lccn field to deletedbiblioitems table... Execute: alter table deletedbiblioitems add column lccn char(25) Check column marc Adding marc field to deletedbiblioitems table... Execute: alter table deletedbiblioitems add column marc text Check column url Adding url field to deletedbiblioitems table... Execute: alter table deletedbiblioitems add column url varchar(255) Check table branchtransfers Check column datearrived Check table printers Alter printername in printers Check table aqbookfund Alter bookfundid in aqbookfund Check table aqbooksellers Alter id in aqbooksellers Check table z3950servers Alter id in z3950servers Setting maximum barcode length to 20 (was 9). Setting type of datesent in branchtransfers to datetime. Setting type of datearrived in branchtransfers to datetime. Setting type of categorycode in branchcategories to varchar(4), and making the primary key. Changing branchcode in branchcategories to categoryname text. Replacing branchholding in branchcategories with codedescription text. Checking for data required in table userflags... Adding row to userflags: flagdesc => Access to all librarian functions bit => 0 defaulton => 0 flag => superlibrarian Adding row to userflags: flagdesc => Circulate books bit => 1 defaulton => 0 flag => circulate Adding row to userflags: flagdesc => View Catalogue (Librarian Interface) bit => 2 defaulton => 0 flag => catalogue Adding row to userflags: flagdesc => Set Koha system paramters bit => 3 defaulton => 0 flag => parameters Adding row to userflags: flagdesc => Add or modify borrowers bit => 4 defaulton => 0 flag => borrowers Adding row to userflags: flagdesc => Set user permissions bit => 5 defaulton => 0 flag => permissions Adding row to userflags: flagdesc => Reserve books for patrons bit => 6 defaulton => 0 flag => reserveforothers Adding row to userflags: flagdesc => Borrow books bit => 7 defaulton => 1 flag => borrow Adding row to userflags: flagdesc => Reserve books for self bit => 8 defaulton => 0 flag => reserveforself Adding row to userflags: flagdesc => Edit Catalogue (Modify bibliographic/holdings data) bit => 9 defaulton => 0 flag => editcatalogue Adding row to userflags: flagdesc => Update borrower charges bit => 10 defaulton => 0 flag => updatecharges Checking for data required in table systempreferences... Adding row to systempreferences: variable => autoMemberNum value => 1 Adding row to systempreferences: variable => acquisitions value => simple Adding row to systempreferences: variable => dateformat value => metric 15) add the following 3 lines to koha.conf. · includes=/var/www/koha/htdocs/includes to /etc/koha.conf, where /var/www/koha/htdocs/includes is indeed the path. (See the Hints file for the syntax). · opachtdocs=/var/www/koha/htdocs · intrahtdocs=/var/www/koha/htdocs 16) Once passwords have been set they will be required to get even basic functions to work /usr/bin/mysqladmin -<password> version 17) If faults occur locate check the logs install HTML-Template-2.6 (or higher) if a missing Template.pm is reported, download it from (www.cpan.org) 18) Other missing modules can be Set-Scalar-1.17 and Net-Z3950-0.34 (or higher) download, untar, make and install (In order) in the directory you untarred to with, · perl Makefile.PL · make · make test · make install 19) If Z3950 is needed yaz may need to be installed. http://ftp.indexdata.dk/pub/yaz/RedHat9.X/ (change 9 to X for other RH versions) root@elvis koha]# rpm -ivh libyaz-2.0.2-2.i386.rpm [root@elvis koha]# rpm -ivh libyaz-devel-2.0.2-2.i386.rpm [root@elvis koha]# rpm -ivh yaz-2.0.2-2.i386.rpm [root@elvis koha]# rpm -ivh yaz-2.0.2-2.src.rpm 20) Even with apache running as user apache, directories owned by apache seem to need a 0775 permissions (group write seems critical).? 21) www.activestate.com and download active perl 5.8 and install (maybe not this achieved nothing!) 22) um... 23) Get the perl support modules for koha off http://search.cpan.org/author/KOHA/Bundle-KohaSupport-0.08 24) Class-MakeMethods-1.003 from www.evoscript.org/Class-makeMethods or later (broken wont make) 25) Database.pm from MySQL-Diff-0.33 or later, (cant install as something is broken...) 26) PAN.pm, cannot locate it. 27) stop here regards Steven -----Original Message----- From: paul POULAIN [mailto:paul.poulain@free.fr] Sent: Monday, 23 June 2003 7:44 PM To: Jones, Steven Cc: koha(a)lists.katipo.co.nz Subject: Installing Koha Jones, Steven wrote: >I have to say this program is easily one of the worst to install Ive seen in >6 years of using open source. > > You never have build gnucash from sources... this one is a real pain. Koha has an installer, that works in most cases (hoped at least). Note, also, that i've a problem with "one click install". Even if we could install Koha in 1 click, that would be (almost) useless imho. why ? Because it requires some PARAMETERS setups (branches, budgets, z3950 server, MARC parameters tuning...) that MUST be done in order to see what Koha can do. and this task CAN'T BE AVOIDED. I think, it's the biggest caveat for Koha => helping setting up the software. However, that's also why I think there is a place for commercial services on Koha too :-)) -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

4 3

RE: [Koha] RE: Installing Koha
by Jones, Steven 24 Jun '03

24 Jun '03

proof reading is not a problem :) Send it my way. :D Steven -----Original Message----- From: Nicholas S. Rosasco [mailto:nsr@etome.net] Sent: Tuesday, 24 June 2003 10:33 AM To: koha(a)lists.katipo.co.nz Subject: RE: [Koha] RE: Installing Koha What I do need is a reliable install dependancy list in the manual, preferably backed up with some links to the perl modules, or an adequate description of each module so I can google it myself. This is being worked on right now (I'm in the midst of fixing SGML problems). Volunteers to proofread always welcome.... Nick _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

The hottest day of the summer so far was drawing to a close and a drowsy silence lay over SourceForge...
by paul POULAIN 23 Jun '03

23 Jun '03

... when Koha 2.0.0pre1 was released. RELEASE NOTES ============= This release add many bugfixes, and some improvment in z3950 and repetable fields management. It has been placed in the "unstable tree" because there are still some bugs. But it's fully usable, and should not be modified a lot until a stable version is released. PACKAGE NEEDED : --------- Nothing new. Note MARC::Record has new releases, but older one (1.26) works fine. DB modifications : --------- * added field in aqbudget, primary key : aqbudgetid tinyint(4) NOT NULL auto_increment PRIMARY KEY (aqbudgetid) * added field in systempref : options text * bibliothesaurus field father changed to char(80) (was bigint) added full text index : FULLTEXT KEY category_2 (category,freelib) z3950 : --------- * works on biblio adding & modifying * works on ISBN, author, title, the 1st found being the one used. various : ---------- * added subject and subtitle to MARC subfields mapped to Koha old-DB. * reordered bookfunds/budget admin tools. languages/languages : ------------- DEFAULT template : * english works. * french should work, mostly. If you experiment some problems, test with english templates, and report the problem as general or french specific NEW template : a "unido" template is in this release. It's uncomplete, and based on vanilla template. GUI reordering ------------------ * Some unused links have been dropped. * a "submenu" shows some operation below main menu. * the MARC link disappeared. It's managed by the MARC=ON/OFF systempref. (the breeding import is now in Parameters section) * acquisition and cataloguing are now separated. acquisition=simple/normal in systempref and cataloguing is MARC/nonMARC depending on MARC=ON/OFF systempref. Should be easier to understand. Bugs still open in bugs.koha.org ======================= always some, but less than in 1.9.3 (40 at this time. more than 20 of them are minor : spellcheck, image missing...) Some of them (for more details, see http://bugs.koha.org) : * 426 Reserving a book (with a reserve fee) results in a hostile message * 452 Payment due flags not showing up for children * 185 Barcode not auto-calculated when autobarcode is on * 425 Add new website feature doesn't work * 318 allow or not a book to be loan * 236 Reserve book on future date doesn't work or copy is wrong bugs not reported here are either unconfirmed, not understood, minor, or partially fixed. Feel free to ask for bugfixes and new features in bugs.koha.org. NOTE that NEW FEATURES or IMPROVEMENTS will only be for 2.0.1 unless it's a very trivial or blocking one. TODO ===== * bug fixes (everybody) * cleaning z3950 old searches (more than 1 hour/day old ?) (paul) -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

1 0

RE: [Koha] ANNOUNCE: Koha perl dependency RPMs for Red Hat 9
by Jones, Steven 23 Jun '03

23 Jun '03

Tis difficult to raise a bug report when the installer fails and I cant determine why. Steven -----Original Message----- From: Mike Hansen [mailto:mwhansen@hmc.edu] Sent: Monday, 23 June 2003 4:49 PM To: koha(a)lists.katipo.co.nz Cc: sjones08(a)eds.com Subject: Re: [Koha] ANNOUNCE: Koha perl dependency RPMs for Red Hat 9 Hello, Unlike the installation of many other open source programs, Koha requires more than merely copying a handful of files to their proper location. The complexity of a Koha installation arises from the fact that the installer has ot configure a number of different programs and get them to work together -- not from including "silly pretty pictures." It has to check for and install the required Perl modules, locate the Apache configuration, modify it to work with Koha, get information regarding the installation of MySQL, connect to the MySQL server, create the necessary database and associated tables, etc. It is not the simplest of processes. We are only able to personally test it out of a small number of configurations. That being said, I have done 4 Koha installs on three different operating systems and ran into no difficulty using the installer. I do not recall you submitting any bug reports at http://bugs.koha.org regarding the installer. The devlopers are unable to devine any problems or errors that you might run encounter. We rely on the feedback from users to work out any bugs. It is just as much of your responsibility as it is ours to help out with bugs. If you require assistance with the installation, you are always free to message us or stop by the IRC channel; just this last week, I did a remote install via SSH. I do not know the required modules off the top of my head; however, a quick glance at Install.pm informs me that they consist of the following: DBI Date::Manip DBD::mysql HTML::Template Digest::MD5 MARC::Record Mail::Sendmail Net::Z3950 I hope that helps. Mike On Mon, 23 Jun 2003 15:00:36 +1200 "Jones, Steven" <sjones08(a)eds.com> wrote: > I have to say this program is easily one of the worst to install Ive seen in > 6 years of using open source. > > Usually such a multitude of errors and omissions has been reserved for > commerical software, I find it very disappointing that koha is proving such > a time waste. I have also found OS installs generally as simple and reliable > as commercial stuff if not usually better, due usually to extream simplicity > with no silly pretty pictures. > > I can live with a manual install, indeed so far a manual install has almost > got me going where the auto install has failed badly. If the list of > dependancies is available I can work throughthem and get running, at present > I dont even seem to be able to do that! > > regards > > Steven >

4 4

Re: [Koha] Installing Koha
by COURYHOUSE＠aol.com 23 Jun '03

23 Jun '03

In the following information presented we are dealing with installers in a conceptual manner. any install dialog should query you item by item for setup options If there is no setup option given, or something incorrectly is input it should error check and query you for another correct option or give you the option not to set up. At the end of the instal, it should display a list of what options were set up and what they were set to pause and ask if you would like a printout of it. It should also save this information to a log file. OK now for today;s history lesson as I am not sure we have anyone on the list old enough to have used this old equipment..... Check out... <A HREF="http://www.smecc.org/burroughs.htm">http://www.smecc.org/burroughs.htm</A> Thanks Ed Sharpe, Archivist for SMECC See the Museum's Web Site at www.smecc.org We are always looking for items to add to the museum's display and ref. library please advise if you have anything we can use. mail: Coury House / SMECC 5802 W. Palmaire Ave. Glendale Az 85301 USA 623-435-1522 > Note, also, that i've a problem with "one click install". Even if we > could install Koha in 1 click, that would be (almost) useless imho. > why ? Because it requires some PARAMETERS setups (branches, budgets, > z3950 server, MARC parameters tuning...) that MUST be done in order to > see what Koha can do. > and this task CAN'T BE AVOIDED. > I think, it's the biggest caveat for Koha => helping setting up the > software. > However, that's also why I think there is a place for commercial > services on Koha too :-)) > > -- > Paul POULAIN > Consultant indépendant en logiciels libres > responsable francophone de koha (SIGB libre http://www.koha-fr.org) > Thanks Ed Sharpe, Archivist for SMECC See the Museum's Web Site at www.smecc.org We are always looking for items to add to the museum's display and ref. library please advise if you have anything we can use. mail: Coury House / SMECC 5802 W. Palmaire Ave. Glendale Az 85301 USA 623-435-1522

1 0

RE: [Koha] ANNOUNCE: Koha perl dependency RPMs for Red Hat 9
by Jones, Steven 23 Jun '03

23 Jun '03

I have to say this program is easily one of the worst to install Ive seen in 6 years of using open source. Usually such a multitude of errors and omissions has been reserved for commerical software, I find it very disappointing that koha is proving such a time waste. I have also found OS installs generally as simple and reliable as commercial stuff if not usually better, due usually to extream simplicity with no silly pretty pictures. I can live with a manual install, indeed so far a manual install has almost got me going where the auto install has failed badly. If the list of dependancies is available I can work throughthem and get running, at present I dont even seem to be able to do that! regards Steven On Mon 23 Jun 2003 at 08:22:06 +1200, Peter Harrison wrote: > On Monday 23 June 2003 01:22 am, COURYHOUSE(a)aol.com wrote: > > "it would really help a lot of not-so-IT librarians to just install Koha > > without them knowing the hard work." > > > > Correct.. In this manner and other things leading to the one click instal, > > shall any software package gain universal acceptance... > > A manager once put me right on this point. Your application might be the best > in the world, but if the install isn't easy, or doesn't work right, the user > will never see how good it is. That's a fair point, but it reminds me of the old adage: "Good, cheap, fast: choose any two." I'm not sure exactly how the adage would be worded as it relates to software installation, but I'm increasingly of the opinion that software which is functional, easy to install, and easy to upgrade is becoming increasingly harder to create. > This is a problem with open source in general - that installation is far > harder than with commercial applications. Developers know how to build and > deploy, while users are not conversant with the tools - and shouldn't need to > be. Again, I agree. But that's why there are IT people -- system administrators, in particular -- who bridge the gap between users and software developers/vendors by installing and maintaining software. And regarding open source, there are many reasons why installation is often harder than for a similar commercial application. But the blame for that should usually be shared between the open-source application and the open-source operating system it runs on. My own experience is that Debian GNU/Linux makes it much easier to install software than RPM-based distributions (such as Red Hat). But there's no free lunch: packaging software for Debian is harder because of the more stringent quality controls which are required. What does all this mean for Koha? Well, I'm not a Koha developer (not even a user yet, although I hope to persuade our library one day), but here are the options as I see them to make installation easier: 1. Provide Koha packaged for each OS you want to support (e.g. Red Hat, Debian, SuSE, etc., or Windows even). In some cases this might require also supplying the required supporting packages (which is what started this whole discussion thread, I believe). The packaging of Koha for different distributions could be contributed by people other than core development people if necessary. 2. Provide Koha packaged for a single Linux distribution, and possibly incorporated on a custom Linux install CD image. 3. Improve the install scripts to check for required Perl modules and install them from CPAN if necessary. Any of those would mean considerable work, but should improve the ease of installation. (If we ever moved to Koha, we'd probably be able to contribute Debian packages.) But I guess the main point I'm trying to make is that users need to be realistic in their expectations of the installation process. To quote (possibly misquote) Einstein, things should be made as simple as possible, but no simpler. Tim. -- Tim Bell -- bhat(a)trinity.unimelb.edu.au -- System Administrator Trinity College, Royal Parade, Parkville, Victoria, 3052, Australia _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

3 2