May 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

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

still looking for mysql @ localhost
by eric salayon 02 Jun '06

02 Jun '06

guys, gud day! i just successfully installed KOHA but mysql is not residing on the same pc. i'd tweaked some statements in the Install.pm (include -h $hostname to every mysql and mysqladmin commands) to make it work. but now, when im trying to search for a book, the system still looks @ localhost for the database. below is the logs: [Tue May 30 09:33:50 2006] [error] [client 10.0.0.10] read_config_file(/etc/koha.conf) returned undef at /www/koha/intranet/modules/C4/Context.pm line 229. [Tue May 30 09:33:50 2006] [error] [client 10.0.0.10] read_config_file(/etc/koha.conf) returned undef at /www/koha/intranet/modules/C4/Context.pm line 229. [Tue May 30 09:33:50 2006] [error] [client 10.0.0.10] read_config_file(/etc/koha.conf) returned undef at /www/koha/intranet/modules/C4/Context.pm line 229. [Tue May 30 09:33:50 2006] [error] [client 10.0.0.10] read_config_file(/etc/koha.conf) returned undef at /www/koha/intranet/modules/C4/Context.pm line 229. [Tue May 30 09:33:50 2006] [error] [client 10.0.0.10] read_config_file(/etc/koha.conf) returned undef at /www/koha/intranet/modules/C4/Context.pm line 229. [Tue May 30 09:33:50 2006] [error] [client 10.0.0.10] read_config_file(/etc/koha.conf) returned undef at /www/koha/intranet/modules/C4/Context.pm line 229. [Tue May 30 09:33:50 2006] [error] [client 10.0.0.10] read_config_file(/etc/koha.conf) returned undef at /www/koha/intranet/modules/C4/Context.pm line 229. [Tue May 30 09:33:50 2006] [error] [client 10.0.0.10] read_config_file(/etc/koha.conf) returned undef at /www/koha/intranet/modules/C4/Context.pm line 229. [Tue May 30 09:33:50 2006] [error] [client 10.0.0.10] read_config_file(/etc/koha.conf) returned undef at /www/koha/intranet/modules/C4/Context.pm line 229. [Tue May 30 09:33:50 2006] [error] [client 10.0.0.10] read_config_file(/etc/koha.conf) returned undef at /www/koha/intranet/modules/C4/Context.pm line 229. [Tue May 30 09:33:50 2006] [error] [client 10.0.0.10] DBI->connect(:) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /www/koha/intranet/modules/C4/Context.pm line 411 [Tue May 30 09:33:50 2006] [error] [client 10.0.0.10] read_config_file(/etc/koha.conf) returned undef at /www/koha/intranet/modules/C4/Context.pm line 229. [Tue May 30 09:33:50 2006] [error] [client 10.0.0.10] DBI->connect(:) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /www/koha/intranet/modules/C4/Context.pm line 411 [Tue May 30 09:33:50 2006] [error] [client 10.0.0.10] Can't call method "prepare" on an undefined value at /www/koha/opac/cgi-bin/opac-main.pl line 16. [Tue May 30 09:33:50 2006] [error] [client 10.0.0.10] Premature end of script headers: opac-main.pl how should i go about this? thanks in advance eric

3 7

translation
by Daniel Armando Rodriguez 31 May '06

31 May '06

someone has a koha 2.2.5 spanish translated templates?? regards Daniel A. Rodriguez Departamento Informático Ministerio de Cultura y Educación (03752) 44-7352/62 int. 161 daniel(a)mcye.misiones.gov.ar

1 0

Spine labels
by Christine Gordon 31 May '06

31 May '06

Can you print spine labels from the Koho Win32 platform? Christine Gordon Librarian Townsville RSL PO Box 3202, Hermit Park, QLD 4812 Ph: 07 4759 9536 Fax: 07 4771 2127 Email: cgordon(a)tsvrsl.com.au

1 0

z3950 daemon stops working
by Erich Beyer 30 May '06

30 May '06

Dear sirs, We have been using koha for about 3 weeks and the z3950 utility has helped us to speed up the cataloging process; it works for a while, but for some unknown reason the daemon stops working, it just won't do anything. To get around this problem I can go into the linux server, kill the process and then restart it. This is done at least 3 times a day and sometimes even more. Any ideas as to how it can be a bit more stable? Thanks Erich Beyer IT Intern FSU London Study Center Library __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

1 0

How to link the field
by JIT lib 30 May '06

30 May '06

Dear frenz hi I am using koha window version. following is the specifications Koha version 2.2.4 OS version Microsoft Windows XP [Version 5.1.2600] Perl version5.008007 MySQL versionmysql Ver 12.22 Distrib 4.0.26, for Win32 (ia32) Apache version Since I am handling a film library, we have the documents like video tape contains so many subjects within a single tape. So I want to create a new field of time duration in Cataloguing module. I also want to show this field in Opac. So anybody plz tell me how to create a new field and how to link it with opac module so that it could be shown during the catalogue search. Thanx in advance regards Librarian Jahangirabad Media Institute Barabnki U.P. India Ph. 05248-243372

1 0

Re: About Reports
by thandu venkat narayana 30 May '06

30 May '06

Sir, I am using Koha 2.2.4 on Windows XP, I am facing three important problems any one can help me. 1) I am able to add records from add biblio, but I have 18,000 books in our library how can I add all records data at a time? 2) When we issued a book to member, from opac login to user account that particular issued book details is not appearing in user account it is display like there is no issues. 3) In report generation I could not get any report. Sincerely Venkat __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

1 0