January 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

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

Re: Follett to Koha migration
by KL Nasveschuk 31 Jan '06

31 Jan '06

This is not in production use yet. It is not even on a production server. I believe Koha supports all tags however if you use tags in MARC records in the 9xx range that are not listed in the default setup you would have to create the tags first then upload your data using bulkmarcimport. Clean data. In Koha my itemtype is mapped to 300f tag. Later I found out that some of the schools never used the 300 tag at all. As a result itemtype for some records shows no icon, and if I searched by itemtype those would be excluded also. I would say that clean data is important. The process of going from Follett to Koha is difficult. I started from what Mike Reavey's wiki and added to that. For example, all the records that come out of Follett need to be funneled into a specific itemtype. For Koha, I used the 300f tag mapped to Koha biblioitems.itemtype. The itemtype information I got from the leader in the record (characters 06 and 07), then made a decision what itemtype they would fall under. I believe that you could map other fields to itemtypes as NPL has but, the data that I got out of Follett between schools was not the same from school to school. I had to pick something that I could rely on from school to school that said, for example, the record is a book or a sound recording, blah, blah.. How involved was everyone. The 5 schools are faced with the cost of upgrading to a web version of Follett (expensive), moving to a Windows server and ongoing support contracts. At this point I don't see any money now for any of that. That means they stay with what they have, which is 5 independent library systems running on 5 different servers. The librarians are are not particularly pleased to stay where they are and not upgrade. I offered to get this working as a prototype to demonstrate with their records, that there is an alternative. Some are more receptive to the idea than others. The bottom line is that there is no money for the upgrades. Another benefit of Koha is that OpenLDAP is used for authentication. Right now all students in Middle School and High School and all staff district wide have LDAP accounts that could also be used to access Koha. That in itself makes Koha perfect for this environment. There are roughly 2500 user accounts in LDAP already. We live in a "push button get banana world". If the icon a user clicks doesn't do exactly what it did last time, is the wrong color, or is on the right side of the screen instead of the left, there will be complaints. There will be objections because it isn't Follett. There will be objections no matter what happens. Nothing is written in stone, all I can do is demonstrate that it works, the accessibility is much better than the current Follett solution, the cost benefits across the board and the future savings. Hopefully, I can post my notes on installation and migration soon. I've done it enough times and am feeling more comfortable with migrating MARC records and what Koha requires. There are still some problems, but at this point nothing I can't resolve. In the mean time here's the URL to look at my demo site. It's been loaded with biblios and copies from 5 schools: http://www.wareham.mec.edu:8000 Kent N On Mon, 2006-01-30 at 10:37 -0600, Cory Jaeger wrote: > At this point I don't actually have a ton of procedure-specific questions. Just some general ones. > > 1) Does "biblios" include full MARC record info? 2) If so, would you say that having "clean" MARC records is important? 3) How automated was the process? 4) How happy was everyone involved with the results of the migration? 4) And perhaps most importantly, how do the librarian's like the Koha system compared to the Follett system? > > Cory A. Jaeger > Network Manager > D.C. Everest Area Schools > 6300 Alderson ST > Weston, WI 54476 > (715) 359-4221 x1393 > > >>> kent <klnasveschuk(a)klnconsulting.net> 1/30/2006 5:16:22 AM >>> > Hi Cory, > Sorry not to get back to you sooner. The version of Follett in use is > Version 5.00 Rev. 12-01-A Dec 19,2001 running on 5 separate Netware 5.1 > servers. I'm going to post my notes on the Internet shortly. I'll post > the URL so you can look at the site also. This is not the final version > to be used for production use. > > What I migrated was biblios and copies from 5 schools. Users come from > LDAP. > > Kent N > > On Fri, 2006-01-27 at 11:07 -0600, Cory Jaeger wrote: > > > > > > In your post at http://article.gmane.org/gmane.comp.misc.koha/5434 you mention that you have "migrated 41,000 records from Follett that runs on Netware to Koha..." > > > > We are evaluating the possibility of switching from Follett to Koha as well. Did you migrate from Circ+/Catalog+ or from the older (DOS based) Union catalog, or one of their other products? > > > > Cory A. Jaeger > > Network Manager > > D.C. Everest Area Schools > > 6300 Alderson ST > > Weston, WI 54476 > > (715) 359-4221 x1393 > > > > > > > > > > >

1 0

RE: [Koha] South American libraries
by Han, Yan 31 Jan '06

31 Jan '06

I have been looking at different open source ILS, and is using koha for a union catalog. Namely, koha, openbiblio, WEBILS, and GNUTeca are some of the examples. A faculty member told me that GNUTeca is popular in South America. Here is a quick overview http://www.anctil.org/users/eric/oss4ils.html Koha probably is the most used and the one with most of features that libraries need. I had some comparisons between koha and other ils. In addition, when thinking of open source ILS, you probably should look at the changing env of information resources. ILS is no longer the only/central system of a library. ILS needs to talk to other digital systems to make an integrated information env for users. Yan Han U. of Arizona -----Original Message----- From: koha-bounces(a)lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Rosalie Blake Sent: Sunday, January 29, 2006 2:04 PM To: Koha-devel; koha(a)lists.katipo.co.nz Subject: [Koha] South American libraries Hi everyone Would some South American library please get in touch with Marcia? Thanks Rosalie Hello Rosalie, Thank for your answer, but I need one more helpfull: Do you know say me in which countries and/or libraries the software Koha is used? Best regards, Márcia ---------- Cabeçalho original ----------- De: "Rosalie Blake" rosalie(a)library.org.nz Para: "marciagrossi" marciagrossi(a)terra.com.br Cópia: Data: Fri, 27 Jan 2006 11:08:43 +1300 Assunto: Re: software Koha > Hello Marcia > I am not sure what you want to know. Koha was the first open-source > library sytem, and it is probably the most developed and the most used > open-source library system. But it is impossible to prove or disprove > this, because no-one knows how many people are using Koha. > You can discover more about Koha on http://www.koha.org > Good luck > Rosalie Blake > Horowhenua Library Trust > > marciagrossi wrote: > > > My name is Márcia Gorett Ribeiro Grossi. I´m electric engineer and I´m > > student in Information Science, in Federal University of Minas Gerais - > > Brazil. I need some information about koha´software. Inside the open > > source systems form libraries, is the koha the most use and why? > > > > > > My best regards, > > > > > > > > Márcia > > > >------------------------------------------------------------------------ > > > >No virus found in this incoming message. > >Checked by AVG Free Edition. > >Version: 7.1.375 / Virus Database: 267.14.23/240 - Release Date: 1/25/2006 > >

1 0

Re: Follett to Koha migration
by kent 30 Jan '06

30 Jan '06

Hi Cory, Sorry not to get back to you sooner. The version of Follett in use is Version 5.00 Rev. 12-01-A Dec 19,2001 running on 5 separate Netware 5.1 servers. I'm going to post my notes on the Internet shortly. I'll post the URL so you can look at the site also. This is not the final version to be used for production use. What I migrated was biblios and copies from 5 schools. Users come from LDAP. Kent N On Fri, 2006-01-27 at 11:07 -0600, Cory Jaeger wrote: > > > In your post at http://article.gmane.org/gmane.comp.misc.koha/5434 you mention that you have "migrated 41,000 records from Follett that runs on Netware to Koha..." > > We are evaluating the possibility of switching from Follett to Koha as well. Did you migrate from Circ+/Catalog+ or from the older (DOS based) Union catalog, or one of their other products? > > Cory A. Jaeger > Network Manager > D.C. Everest Area Schools > 6300 Alderson ST > Weston, WI 54476 > (715) 359-4221 x1393 > > > >

1 0

South American libraries
by Rosalie Blake 29 Jan '06

29 Jan '06

Hi everyone Would some South American library please get in touch with Marcia? Thanks Rosalie Hello Rosalie, Thank for your answer, but I need one more helpfull: Do you know say me in which countries and/or libraries the software Koha is used? Best regards, Márcia ---------- Cabeçalho original ----------- De: "Rosalie Blake" rosalie(a)library.org.nz Para: "marciagrossi" marciagrossi(a)terra.com.br Cópia: Data: Fri, 27 Jan 2006 11:08:43 +1300 Assunto: Re: software Koha > Hello Marcia > I am not sure what you want to know. Koha was the first open-source > library sytem, and it is probably the most developed and the most used > open-source library system. But it is impossible to prove or disprove > this, because no-one knows how many people are using Koha. > You can discover more about Koha on http://www.koha.org > Good luck > Rosalie Blake > Horowhenua Library Trust > > marciagrossi wrote: > > > My name is Márcia Gorett Ribeiro Grossi. I´m electric engineer and I´m > > student in Information Science, in Federal University of Minas Gerais - > > Brazil. I need some information about koha´software. Inside the open > > source systems form libraries, is the koha the most use and why? > > > > > > My best regards, > > > > > > > > Márcia > > > >------------------------------------------------------------------------ > > > >No virus found in this incoming message. > >Checked by AVG Free Edition. > >Version: 7.1.375 / Virus Database: 267.14.23/240 - Release Date: 1/25/2006 > >

1 0

Re: [Koha] New Chinese document on kohadocs
by BWS Johnson 27 Jan '06

27 Jan '06

>I am pleased to announce the first Chinese (Traditional) document on >http://www.kohadocs.org : >Koha 2.2 ?? -- a translation of Paul Poulain's Logiciel >documentaire by ? ?? (Anthony Mao) Excellent! I love having new languages. :) Cheers, Brooke @ Hinsdale MA

1 0

New Chinese document on kohadocs
by Stephen Hedges 26 Jan '06

26 Jan '06

I am pleased to announce the first Chinese (Traditional) document on http://www.kohadocs.org : Koha 2.2 簡介 -- a translation of Paul Poulain's Logiciel documentaire by 毛 慶禎 (Anthony Mao) -- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges(a)skemotah.com

1 0

Barcode Generator Error
by Amzari Abu Bakar 26 Jan '06

26 Jan '06

Hi everyone, Anybody can help me with barcode generator. I'm using Win2003 Server Std Edition, Apache 2.0.54, Mysql 4.0.15-nt and Koha 2.2.4b for Windows. other configuration: perl located at c:\usr\bin\ koha located at c:\usr\koha224\ in Apache intranet-error log, it says something like this: [ Thu Jan 26 20:48:35 2006] [error] [client 202.190.131.164] Unable to open /tmp/875885-202.190.131.164-(From to )-[26.1.2006]-[20:48:35].pdf for writing at C:/usr/site/lib/PDF/API2/PDF/File.pm line 420., referer: http://localhost/cgi-bin/koha/barcodes/barcodes.pl please.. anyone can help me? __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

2 1

New document on kohadocs
by Stephen Hedges 26 Jan '06

26 Jan '06

A new document has been added to http://www.kohadocs.org -- "Installing Koha on Mac OS X" by Stephen Hedges. -- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges(a)skemotah.com

1 0