June 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

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

Koha Installation
by veena bhat 30 Jun '06

30 Jun '06

Dear Sir/ Madam, I have received many mails for my query. Thanks a lot. Can you please guide me the steps involved in Koha Installation? Best Regards, Veena Bhat --------------------------------- Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1¢/min.

3 2

Licence
by veena bhat 30 Jun '06

30 Jun '06

Dear Sir/ Madam, I would like to install Koha. I need to sign on any terms and conditions or Licence I need to take? Please let me know. Best Regards, Veena Bhat IIIT, Pune --------------------------------- Do you Yahoo!? Next-gen email? Have it all with the all-new Yahoo! Mail Beta.

3 2

Continuting z3950 madness
by Greg Vickers 29 Jun '06

29 Jun '06

Hi all, I am still trying to get the biblio search working with this z39.50 daemon. I click on Catalogue, then 'Add biblio', then enter some data in the title and isbn fields, and click the Go button. The search fails to return any information and I click the 'Add New Biblio' button. From that screen I click on the 'z3950 search' and get the 'Z3950 Search Results' window up with the 'Still ?? requests to go' information bar. I find in the following files: #tail /usr/local/koha/log/z3950-daemon-20060519-0953.log DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 140. DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 143. DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 148. DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 149. and in #tail /var/log/apache/koha/koha-error.log 220.239.73.84 - - [07/Jun/2006:22:01:43 +1000] "GET /cgi-bin/koha/z3950/search.pl?bibid=&random= HTTP/1.1" 200 1526 220.239.73.84 - - [07/Jun/2006:22:01:43 +1000] "GET /intranet-tmpl/default/en/includes/common-style.css HTTP/1.1" 200 7431 DBD::mysql::st execute failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at /usr/local/koha/intranet/modules/C4/Breeding.pm line 167. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/koha/intranet/modules/C4/Breeding.pm line 168. So I know the z3950 daemon is running and I walked through all the scripts that are used to call it and I know it is passed all the correct environment information: #cat /usr/local/koha/intranet/scripts/z3950daemon/z3950-daemon-options RunAsUser=www-data KohaZ3950Dir=/usr/local/koha/intranet/scripts/z3950daemon KohaModuleDir=/usr/local/koha/intranet/modules LogDir=/usr/local/koha/log It looks like the z3950 daemon doesn't know how to talk to the local mysql server - is there a place that I have to give the z3950 daemon a username and password for accessing the mysql database? Thanks, Greg

5 10

My Local Koha Installation and Demo installation On http://koha.liblime.com
by lalitanand dandge 29 Jun '06

29 Jun '06

Hi, I installed Koha on my linux system successfully, while studying the demo ( on http://koha.liblime.com) and my local installation i found that in catalogue while adding the empty biblio there are many more and additional fields in the Demo while lesser in my local installation. I also checked the version both are same (i installed koha2.2.5 and the about of demo also saying same). So this make me little confused, since i am new to the koha and also i am form the open source development and not have library management experience as such. So please anybody having any inforamtion regarding this kindly help. Also i searched for the properly documented (rather easy step-by-step) manuals for how to use and administer koha, but I am sorry i could not get that useful for me, so please also help in this regard. Thank you, Lalitanand. Project Engineer. -- "Talk is cheap. Show me the code. Think Open, use Open Source!" Visit & Register at http://www.ossrc.org.in

2 1