July 2006 - Koha - lists.katipo.co.nz

Migrate all Koha data from old server to new server
by Greg Vickers 23 Sep '15

23 Sep '15

Hi all, We ae running Koha on a dodgy spare desktop that we scrounged up, now we have a nice shiny Dell server to run it on. What is the easiest method of transferring the data from the old server to the new server? (Using Koha 2.2.4 on both servers.) I'm guessing that all I have to do is install Koha on the new server (meet prerequisites etc) and move across the MySQL data to the new server. Am I missing something critical? Thanks, Greg

5 5

Label Printing
by Bruffey, Mark 29 Mar '13

29 Mar '13

How much flexibility is there in the use of different label configurations with the new label function in KOHA? Thanks, Mark L. Mark Bruffey Director Library Services Central Baptist Theological Seminary 900 Forestview Lane N Plymouth MN 55441 763 417 8264 mbruffey(a)centralseminary.edu <mailto:mbruffey@centralseminary.edu> Central Seminary www.centralseminary.edu <http://www.centralseminary.edu> Fourth Baptist Church www.fourthbaptist.org <http://www.fourthbaptist.org> WCTS Radio AM 1030 Online www.centralseminary.edu/wcts <http://www.centralseminary.edu/wcts> *************************************** Have you experienced the good news? "Every one who calls on the name of the Lord will be saved!" [Romans 10:13] ***************************************

2 1

error when creating database
by Wahyu Wijaya H. 23 Dec '07

23 Dec '07

Hi, this is my first time to installing koha on linux platform, so I'm a newbie. I'm using ubuntu linux ver. 2.12.1. I already finish my "apt-get" installation followed by the additional perl modules using MCPAN install. And when I try to install koha I see this message : ------------------------------------------------------------------------------------------- MYSQL ROOT USER PASSWORD To create the koha database, please enter your mysql server's root user password: Password: CREATING DATABASE Creating the MySQL database for Koha... ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) 256ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'syamsinar@localhost' (Using password: YES)' ERROR CREATING DATABASE Couldn't connect to the MySQL server for the reason given above. This is a serious problem, the database will not get installed. Press <ENTER> to continue: DBI connect('sd_yps:localhost','syamsinar',...) failed: Access denied for user: 'syamsinar@localhost' (Using password: YES) at /usr/local/koha/intranet/modules/C4/Context.pm line 411 Can't call method "prepare" on an undefined value at scripts/updater/updatedatabase line 1008. Problem updating database... root@yps-013:/home/syamsinar/koha-2.2.4# ------------------------------------------------------------------------------------------ I got a problem with mysql.... At first I thought, maybe it is because I haven't set the password for mysql (I put blank when the installation ask me to enter mysql root password), so I go back to the terminal and type mysqladmin password, and then I got this message : ------------------------------------------------------------------------------------------- root@yps-013:/home/syamsinar/koha-2.2.4# mysqladmin password mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' root@yps-013:/home/syamsinar/koha-2.2.4# ------------------------------------------------------------------------------------------- please help me, what should I do? I'm not familiar with sql database. Regards, Wahyu W. H. --------------------------------- Yahoo! Cars NEW - sell your car and browse thousands of new and used cars online search now ---------------------------------

3 4

Report on issues/returns
by Nitin Madhavan 02 Nov '07

02 Nov '07

1. How can I get a report of all the issues and returns in a given period, like yesterday? The report should include the details of the book issued and to whom, etc. 2. Could you pls give some idea of the expected release date of Koha 3.0 as I am putting everything on hold till it is released. Thanx Nitin

4 3

Hold/ reserve
by Dora Brach 21 Sep '07

21 Sep '07

Hi all, We are thinking about getting Koha for our school library. One thing that I didn't like when I tried a demo was the fact that when I put a book on hold and then the book was returned, there was no message showing me that there was a hold on that book. Am I overlooking something? This was one of the main problems I saw. With the present system I have, when a book is returned, if there is a hold on it, it comes up with a message in red that so and so has a hold on the book. Any help would be appreciated. And I'm in and out during the summer so may not get back to this for a week or so. Thanks, Dora Dora Brach Library Media Specialist Mountainburg Schools dorab(a)dragons.wsc.k12.ar.us

4 5

Moving from Fedora to Ubuntu
by Nigel Titley 22 Sep '06

22 Sep '06

I'm about to shift the server that currently runs Koha 2.2.3 from fedora Core 2 to Ubuntu Dapper Drake. I propose to use the opportunity to upgrade to the latest Koha (2.2.5). I'm proposing to do this as follows: 1. Dump Koha database 2. Wipe machine 3. Install Ubuntu 4. Install Koha pre-requisites 5. Install virgin Koha 2.2.5 6. Restore Koha database from (1) Does this look reasonable? Or should I restore the original database between (4) and (5) and let the installation have its wicked way with it? Help and advice very welcome. Thanks Nigel

2 2

Emilda and Koha: how to choose between them?
by Paul Gear 12 Sep '06

12 Sep '06

Hi folks, (Apologies in advance for the HTML mail, but i couldn't find a better way to represent the table below...) I've been evaluating implementing a couple of small libraries (my church and home, both around 1000 volumes) on Emilda and Koha, and i'd be interested in comments from people about their relative strengths and weaknesses. I'm coming from the perspective of a K-12 school IT manager with a Unix background. I don't know much about library cataloguing (although i'm learning), and MARC is almost incomprehensible to me (as it is to all of the librarians i know). :-) I'd really love to convert my school (about 80,000 resources) from a proprietary system to Koha, and i'm using these libraries as guinea pigs. However, my call is not final at school: there are a number of other staff to convince. The merits of free software would have to be pretty strong for us to only save around AU$1000/year (the maintenance contract on our existing library system), not to mention that there's no local phone support. Neither Koha nor Emilda seems to have the features to challenge the more school-oriented library systems yet. Here are my perceptions so far: Product Pros Cons Emilda * Very easy to install on Debian * Z39.50 cataloguing is easy to set up and robust * Simple interface * Easy to hack on (PHP-based) * Exposes a lot of MARC & Yaz; adding search and cataloguing fields requires advanced skills * Developer/user communities not so active (user mailing list about 1/10th the traffic of Koha's) * Requires login to self-loan and -return Koha * Nice features in interface (e.g. cover images) * Pretty (the suggested demo sites look awesome!) * Seems to have quite an active developer and user community * Install not so simple - no Debian package; requires messing about with CPAN * Requires separate Z39.50 daemon that, when last i used it (not the current version), broke easily and frequently * Interface is moderately complex (a moderate amount of MARC) * I hate Perl (i know it to a reasonable level of competency, and write scripts in it regularly - i just hate looking at it). Can anyone comment on whether: * Koha has pros for Emilda's cons? (Self-loan and return seems to be one.) * Koha's cons have improved since i last looked at it? Are there any other considerations that i should be looking at? Low maintenance is a priority for me - after i've implemented the systems, i won't have a lot of time to spend on them. Both products seem to fit the bill in this respect, although i haven't tried to restore one from backup yet. ;-) Thanks for listening, Paul <http://paulgear.webhop.net> -- Did you know? Microsoft Internet Explorer and Outlook have a poor track record for security <http://www.kb.cert.org/vuls/id/713878>. Why not try one of the more secure alternatives from <http://mozilla.org>?

5 6

Error Post Installation
by Jorge Tena 05 Aug '06

05 Aug '06

Hello, After succesfully installing koha on my web server, when I try to access the site, the page gets redirected to an error one wich says there's been an internal error and the webmaster should be contacted. I have a FC4 installation, running on a AMD Athlon 64 3200+, 2GB RAM and 120GB HDD with Koha 2.2.5. Find attached the OPAC error log and Koha error log. We're currently testing Koha to be used in a one of the biggest deployments of ILS in the Dominican Republic. I would apreciate any help regarding this issue. Yours truly, __ Jorge Tena Analista de Proyectos Corporativos Copy Solutions International T. 809-689-9777 ext. 242 F. 809-689-9850 M. 809-440-8697 E. j.tena(a)copysolutionsint.com

2 1

Post Installation Error
by Jorge Tena 02 Aug '06

02 Aug '06

Hi Koha Developers, I'm looking for support regarding an issue I'm facing right after I install Koha on my FC4 web server. The first time I try to browse the system just after finishing a new, clean installation I get this Internal Server Error that doesnt allow me to browse the system. If I look into the opac error log I find the following error messages: [Sat Jul 29 14:02:11 2006] [error] [client 127.0.0.1] File does not exist: /usr/local/koha/opac/htdocs/favicon.ico [Sat Jul 29 14:02:11 2006] [error] [client 127.0.0.1] HTML::Template->new() : Cannot open included file /usr/local/koha/opac/htdocs/opac-tmpl/default/en/opac-main.tmpl : file not found. at /usr/lib/perl5/site_perl/5.8.6/HTML/Template.pm line 1632 [Sat Jul 29 14:02:11 2006] [error] [client 127.0.0.1] \tHTML::Template::_init_template('HTML::Template=HASH(0x9d05a38)') called at /usr/lib/perl5/site_perl/5.8.6/HTML/Template.pm line 1205 [Sat Jul 29 14:02:11 2006] [error] [client 127.0.0.1] \tHTML::Template::_init('HTML::Template=HASH(0x9d05a38)') called at /usr/lib/perl5/site_perl/5.8.6/HTML/Template.pm line 1099 [Sat Jul 29 14:02:11 2006] [error] [client 127.0.0.1] \tHTML::Template::new('HTML::Template', 'filename', '/usr/local/koha/opac/htdocs/opac-tmpl/default/en/opac-main.tmpl', 'die_on_bad_params', 0, 'global_vars', 1, 'path', 'ARRAY(0xa63dabc)', ...) called at /usr/local/koha/intranet/modules/C4/Output.pm line 77 [Sat Jul 29 14:02:11 2006] [error] [client 127.0.0.1] \tC4::Output::gettemplate('opac-main.tmpl', 'opac', 'CGI=HASH(0x9cf7cd4)') called at /usr/local/koha/intranet/modules/C4/Auth.pm line 114 [Sat Jul 29 14:02:11 2006] [error] [client 127.0.0.1] \tC4::Auth::get_template_and_user('HASH(0xa64ffd0)') called at /usr/local/koha/opac/cgi-bin/opac-main.pl line 32 [Sat Jul 29 14:02:11 2006] [error] [client 127.0.0.1] Premature end of script headers: opac-main.pl [Sat Jul 29 14:02:11 2006] [error] [client 127.0.0.1] File does not exist: /usr/local/koha/opac/htdocs/favicon.ico Any help around this subjetc!? __ Jorge Tena Analista de Proyectos Corporativos Copy Solutions International T. 809-689-9777 ext. 242 F. 809-689-9850 M. 809-440-8697 E. j.tena(a)copysolutionsint.com

2 3

Re: [Koha] Using Koha
by Steven F.Baljkas 01 Aug '06

01 Aug '06

Sunday, July 30, 2006 20:20 CDT Hi, Trupti, In answer to your questions ... > Are the tags below 010 required? ... If you are talking about MARC21 (formerly USMARC, CANMARC, etc., harmonized: note that UKMARC will be 'joined' with this, too; UNIMARC, chiefly continental European, is markedly different, clearly distinguishable by where Title and Statement of Responsibility are coded, 200, vs. 245 in MARC21 and its precedents/parallels), the following fields below 010 are required according to MARC development and usage standards: the Leader (what you have referred to as 000), and the 008 (and sometimes 006 and 007, depending on the exact nature of the record). > ... If so does Koha recognize it? Koha previously could be made to recognise these fields (though not included with Koha as distributed) but a newer version of the MARC framework is now apparently downloadable and is able to process the data. Like many ILS, however, it does not appear that Koha actually does anything with the data at present (many ILS don't make full use of all the data that a MARC record encodes). That may change in future versions. > Also since we have not used Marc, we would like to know how do we enter > data. For example, should the title be entered as > > 245 10 $a Computer Science OR > Computer Science. How data should be entered is up to you when you do things locally. MARC is actually quite flexible. However other accompanying standards are much more rigid. If you hope to make use of shared data (i.e. download records via Z39.50 or otherwise), you have to keep those standards in mind unless you want to be making a lot of 'corrections' to what you download to match your local practices. For example, most North American libraries would use MARC standards to code information for their ILS in conjunction with the standards prescribed in (some version of) the Anglo-American Cataloging Rules 2nd edition (AACR2R), which include standards for capitalization and punctuation from the International Standard for Bibliographic Description (General) or ISBD(G). Taking your example from above, then, a work with the title _Computer Science_ would be encoded as follows according to those standards: 245 10 $a Computer science or 245 10 $a Computer science. *** You could also encode it as 245 10 $a Computer science. -- if you really wanted to follow the full traditional punctuation (which most libraries and ILS don't). *** I would include the period at the end just for clarity. Note the punctuation prescribed by common standards. The standards that you are using, incidentally, are encoded in the Leader (sometimes called the 000). If you would like some example records, please feel free to send me some data (a small dataset or list) off listserv and I'll do what I can to help you out. Cheers, Steven F. Baljkas library tech at large Koha neophyte Winnipeg, MB, Canada ============================================================ From: "Truptee Shah" <truptee.shah(a)gmail.com> Date: 2006/07/28 Fri AM 06:07:33 CDT To: koha(a)lists.katipo.co.nz Subject: [Koha] Using Koha We have installed KOha and are trying to use it for our library. We have some problems using MARC tags. We seek your help for the same. Are the tags below 010 required? If so does Koha recognize it? Also since we have not used Marc, we would like to know how do we enter data. For example, should the title be entered as 245 10 $a Computer Science OR Computer Science. Do we need to enter anything in the tag 000 or is it machine generated. --Trupti (koha user from India)

2 1