- Koha - lists.katipo.co.nz

RE: Koha Digest, Vol 24, Issue 40
by Phillips, Lee 07 Nov '07

07 Nov '07

Hello all I want to comment on the SirsiDynix migration possibilities. I have a bunch of library friends in a consortium with Sirsi and I wondered if they were ever going to be able to get out of the proprietary patch hell. I am currently in line to join their group but I am have serious doubts and that this would be a dead end in the near future. I am considering Koha for my mid sized library and I was hoping that there was a way to migrate my Sagebrush catalog into Koha with out having to datamap or bar code. Has anyone had any good experience with these issues? I have 76000 bib records and 14K users. We really need to decide soon Sagebrush doesn't answer their phone any more...if you catch my drift. Lee Phillips Butte Silver Bow Public Library Butte, Montana -----Original Message----- From: koha-bounces(a)lists.katipo.co.nz on behalf of koha-request(a)lists.katipo.co.nz Sent: Tue 10/30/2007 1:00 PM To: koha(a)lists.katipo.co.nz Cc: Subject: Koha Digest, Vol 24, Issue 40 Send Koha mailing list submissions to koha(a)lists.katipo.co.nz To subscribe or unsubscribe via the World Wide Web, visit http://lists.katipo.co.nz/mailman/listinfo/koha or, via email, send a message with subject or body 'help' to koha-request(a)lists.katipo.co.nz You can reach the person managing the list at koha-owner(a)lists.katipo.co.nz When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..." Today's Topics: 1. Koha Installation Error - BlueHost.com (Librarian, SAIACS) 2. Re: Koha became a little more of a certainty last night (Dan Scott) 3. Re: Koha on etch - a pain? (Grant Johnson) 4. Re: Koha on etch - a pain? (Beda Szukics) 5. Re: Koha on etch - a pain? (Beda Szukics) ---------------------------------------------------------------------- Message: 1 Date: Tue, 30 Oct 2007 19:52:37 +0530 From: "Librarian, SAIACS" <library(a)saiacs.org> Subject: [Koha] Koha Installation Error - BlueHost.com To: <koha(a)lists.katipo.co.nz> Message-ID: <20071030142511.C995910720(a)daddy.katipo.co.nz> Content-Type: text/plain; charset="us-ascii" Hi, while trying to install koha on Bluehost.com, I encountered following error; Use of uninitialized value in concatenation (.) or string at Install.pm line 1685, <STDIN> line 5. Use of uninitialized value in concatenation (.) or string at Install.pm line 1685, <STDIN> line 5. Use of uninitialized value in concatenation (.) or string at Install.pm line 1685, <STDIN> line 5. Use of uninitialized value in concatenation (.) or string at Install.pm line 1685, <STDIN> line 5. Use of uninitialized value in concatenation (.) or string at Install.pm line 1685, <STDIN> line 5. Use of uninitialized value in concatenation (.) or string at Install.pm line 1709, <STDIN> line 5. Please check permissions in /home/jlcopaco/koha/intranet/scripts/z3950daemon Use of uninitialized value in concatenation (.) or string at Install.pm line 2293, <STDIN> line 5. DBI connect(':','',...) failed: Access denied for user 'jlcopaco'@'localhost' (using password: NO) at /home/jlcopaco/koha/intranet/modules/C4/Context.pm line 411 Can't call method "prepare" on an undefined value at scripts/updater/updatedatabase line 1553. Problem updating database... Can any one help me to rectify this error? Mr. Yesan Sellan Chief Librarian South Asia Institute of Advanced Christian Studies, Kothanur PO Bangalore - 560077 INDIA Alternative Email: yesans(a)gmail.com Ph: 91-80-2846 5649/5235/5344 Fax: 91-80-2846 5412 ------------------------------ Message: 2 Date: Tue, 30 Oct 2007 13:08:50 -0400 From: "Dan Scott" <denials(a)gmail.com> Subject: Re: [Koha] Koha became a little more of a certainty last night To: "Joe Atzberger" <ohiocore(a)gmail.com> Cc: koha(a)lists.katipo.co.nz Message-ID: <fbb0d11d0710301008n36471abbh80270cd31401a1da(a)mail.gmail.com> Content-Type: text/plain; charset="iso-8859-1" On 23/10/2007, Joe Atzberger <ohiocore(a)gmail.com> wrote: > > On 10/23/07, Dan Scott <denials(a)gmail.com> wrote: > > > I would strongly suggest posting the code to the sirsiapi repository. > > I'm not a lawyer, but (to my understanding) sirsiapi.org is the only > > SirsiDynix-sanctioned location for hosting code that uses the Unicorn "API" > > to extract information from Unicorn. Sites that have signed a contract with > > SirsiDynix for Unicorn typically have agreed to not reverse-engineer the > > product (meaning that they agree to not try and figure out how the Unicorn > > "API" works) and if they have taken the "API" training course then they have > > agreed to not share any of that information (including code examples) > > outside of the SirsiDynix-sanctioned locations. > > > In my opinion, the repository is an unsuitable venue, since it requires > considerable cost and Sirsi's blessing to even evaluate the (mostly > tentative) code in it. There are less than 40 total contributors to it, all > time. So from a practical perspective, it's the wrong choice. > > As for the legal questions, I'm not a lawyer either, but I do take them > seriously. More seriously, I suspect, than the former management at Sirsi. > > > I attended SD's week-long "API Training" course while in the employ of a > 5-county educational consortium, with whom I had no non-disclosure > agreements at the time, nor any other kind of contract now. (I don't work > there anymore.) Since I was a public employee at the time, literally all > the code I wrote is is a public work-product and like all my correspondence > there, is subject to public disclosure laws. Anyone could ask for it today, > and my former employer would still be obligated to provide copies of it. > > The various warnings from SD about sharing materials did not amount to a > NDA, in my opinion, just an acknowledgment of their copyright to the actual > training materials. (That's funny, since their main docs are a handbook > containing mostly the STDERR "usage" messages from their various > executables, but in an even less readable format.) But even if they *did* > have a bulletproof NDA, I certainly wouldn't have any authority to suspend > state law in order to accept it. > > I would be concerned on behalf of the library posting Unicorn "API" code > > to a public site like SourceForge.net that they could be opening > > themselves up to lawsuits due to breach of contract, if the vendor was to > > get to such a bad state that they started suing their (former) customers. > > > It may be true that SirsiDynix eventually goes the way of SCO, adopting a > litigation-heavy business model. In either case, I don't consider it > ethical to limit my behavior because of this possibility, in particular if > the result is more people stuck paying a litigious vendor they'd prefer to > leave. If spurious liability is the real concern, in the modern era it > would not be difficult to post the code anonymously, or via foreign proxy. > > Any code dealing with the results of using the Unicorn "API" to extract > > data should be openly shareable, because at that point you're just dealing > > with data structures. But I would be worried about openly sharing the actual > > commands, err, "API instructions" required to get that data out of the > > system. > > > Unicorn uses either Oracle or an ancient version of Informix as the back > end database, in conjunction with a bunch of flat files. Nothing > particularly special is required for anyone to access the information > directly. In that way, the API question could be sidestepped entirely. > -- > Joseph Atzberger > SysAdmin, LibLime > http://liblime.com/koha > 1(888)KohaILS > > ps: Needless to say, my comments are my own. > > Fair enough, Joe. We each have our own, non-professional opinion of the legality of publicly publishing code that uses the Unicorn API as part of a migration process. I'm leaning towards the conservative side, whereas you're leaning towards the aggressive side. The original poster has to form their own opinion, and of course I would suggest that they seek out a professional legal opinion on the matter. But then, we've already established that I'm conservative in this regard. Rather than putting the original poster in that position, there is an alternative. As you have the required Unicorn and Koha skills, would you (and your employer) be willing to publish a complete Unicorn-to-Koha migration process & code to koha.org as a contribution from LibLime? I would see this as a great contribution to the open-source ILS community in general. Perhaps more valuable than the technical matters alone, it would be a great test of the matters we've discussed in this thread. -- Dan Scott Laurentian University -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20071030/2c0ebc73/atta… ------------------------------ Message: 3 Date: Tue, 30 Oct 2007 14:16:33 -0300 From: "Grant Johnson" <FGJohnson(a)upei.ca> Subject: Re: [Koha] Koha on etch - a pain? To: <koha(a)lists.katipo.co.nz>, "Beda Szukics" <beda(a)muri-gries.ch> Message-ID: <47273CC1.5AE3.007F.0(a)groupwise.upei.ca> Content-Type: text/plain; charset="us-ascii" Hi Beda et al, I've been trying to track this down for about 8 weeks now. Same issue. Apparently the caveats exist in the list archives someplace but I'd sure like them to be pointed out to me. My install works fine except for the addbiblio.pl module. It doesn't matter if I get a record from the "Reservoir or a Z39.50m search I get the same error. The log's don't help me much - But I may not be reading or understanding them properly. Let's keep in touch re this issue - I need to implement on a large scale and need to get this working. Cheers -- F. Grant Johnson 566-0630 / fgjohnson(a)upei.ca Skype ID = jetsongeorge Systems/Web Coordinator Robertson Library University of Prince Edward Island *************** Attitude is IT! >>> On 10/29/2007 at 4:47 PM, in message <20071029194741.14634.qmail(a)www.ksobwalden.ch>, "Beda Szukics" <beda(a)muri-gries.ch> wrote: > Hello people > > Has somebody succeeded in running a koha-2.2.9 recently installed on etch? > > My problem: I can't add new biblios. I had posted some of my problems > before. Now I thougt I'd start again from the buttom up. I deleted the > koha-database in MySQL did a rm -r /usr/lokal/koha and installed koha again. > After entering some library branches, some itemtypes, some borrower > catagories, some z3950-servers and _nothing_ _else_ I tried to add a work > (ISBN 3170183338) and got the same error again: > > [Mon Oct 29 20:32:16 2007] [error] [client 192.168.1.50] Q2 : select > distinct m1.bibid from biblio,biblioitems,marc_biblio,marc_word as > m1,marc_word as m2,marc_word as m3,marc_word as m4,marc_word as m5,marc_word > as m6,marc_word as m7,marc_word as m8,marc_subfield_table as m9 where > biblio.biblionumber=marc_biblio.biblionumber and > biblio.biblionumber=biblioitems.biblionumber and m1.bibid=marc_biblio.bibid > and (m1.bibid=m2.bibid and m1.bibid=m3.bibid and m1.bibid=m4.bibid and > m1.bibid=m5.bibid and m1.bibid=m6.bibid and m1.bibid=m7.bibid and > m1.bibid=m8.bibid and m1.bibid=m9.bibid) and ((m1.word like > 'Neutestamentliches' and m1.tagsubfield in ('245a'))and (m2.word like > 'Arbeitsbuch' and m2.tagsubfield in('245a'))and (m3.word like 'f\xc3\xbcr' > and m3.tagsubfield in('245a'))and (m4.word like 'Religionsp\xc3\xa4dagogen' > and m4.tagsubfield in('245a'))and (m5.word like 'Becker' and m5.tagsubfield > in('245b'))and (m6.word like 'Ulrich' and m6.tagsubfield in('245b'))and > (m7.word like '24' and m7.tagsubfield in('100a'))and (m8.word like 'cm' and > m8.tagsubfield in('100a'))and (m9.subfieldvalue = 'W. Kohlhammer,' and > concat(m9.tag,m9.subfieldcode) in ('300c'))) order by biblio.title ASC term > is Neutestamentliches Arbeitsbuch f\xc3\xbcr Religionsp\xc3\xa4dagogen > Becker Ulrich 24 cm W. Kohlhammer, at > /usr/local/koha/intranet/modules/C4/SearchMarc.pm line 274., referer: > http://bibliotheksverwaltung.kollegium-sarnen.ch/cgi-bin/koha/acqui.simple/a > ddbiblio.pl?oldbiblionumber=0&z3950=1&breedingid=1 > > [Mon Oct 29 20:32:17 2007] [error] [client 192.168.1.50] Arguments must be > MARC::Field object at /usr/local/koha/intranet/modules/C4/Biblio.pm line > 1440, referer: > http://bibliotheksverwaltung.kollegium-sarnen.ch/cgi-bin/koha/acqui.simple/a > ddbiblio.pl?oldbiblionumber=0&z3950=1&breedingid=1 > > [Mon Oct 29 20:32:17 2007] [error] [client 192.168.1.50] Premature end of > script headers: addbiblio.pl, referer: > http://bibliotheksverwaltung.kollegium-sarnen.ch/cgi-bin/koha/acqui.simple/a > ddbiblio.pl?oldbiblionumber=0&z3950=1&breedingid=1 > > I have the feeling koha won't work on etch ... > > Any hints ... Beda > > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha -------------- next part -------------- BEGIN:VCARD VERSION:2.1 X-GWTYPE:USER FN:Grant Johnson EMAIL;WORK;PREF:FGJohnson@groupwise.upei.ca N:Johnson;Grant END:VCARD ------------------------------ Message: 4 Date: Tue, 30 Oct 2007 19:40:26 +0100 From: "Beda Szukics" <beda(a)muri-gries.ch> Subject: [Koha] Re: Koha on etch - a pain? To: "Grant Johnson" <FGJohnson(a)upei.ca> Cc: koha(a)lists.katipo.co.nz Message-ID: <20071030184026.18615.qmail(a)www.ksobwalden.ch> Content-Type: text/plain; charset="utf-8"; format=flowed Hi Grant > I've been trying to track this down for about 8 weeks now. > Same issue. Lucky I'm not the only one. I was questioning my mental health :-) > Apparently the caveats exist in the list archives someplace but I'd sure like them to be pointed out to me. > My install works fine except for the addbiblio.pl module. > It doesn't matter if I get a record from the "Reservoir or a Z39.50m search I get the same error. Same with me. Unfortunately adding new records is what I intend to do every day :-( > Let's keep in touch re this issue - I need to implement on a large scale and need to get this working. I was upgrading a sarge server to etch. Afterwards I tried to install koha on it and had quite some problems with at least one of the required perl modules (I don't quite remember witch one, it had something to do with a new version, witch was buggy). With some help I managed to succeed the installation process. But now I have the mentioned problem. My guess is it has something to do with one of the perl modules, but I have no idea witch one. Unfortunately I wasn't very careful with documenting my steps. It looks like Koha would be the solution witch suited my needs quite well but maybe I have to consider some other solution ... (Do you know one?) Greetings Beda ------------------------------ Message: 5 Date: Tue, 30 Oct 2007 19:54:12 +0100 From: "Beda Szukics" <beda(a)muri-gries.ch> Subject: [Koha] Re: Koha on etch - a pain? To: "Pablo A. Bianchi" <pablo.bianchi(a)gmail.com> Cc: koha(a)lists.katipo.co.nz Message-ID: <20071030185412.18641.qmail(a)www.ksobwalden.ch> Content-Type: text/plain; charset="utf-8"; format=flowed Hi Pablo > I had installed successfully installed Koha v2.2.5 and v2.2.9 on > Debian etch and now on a Lenny, following the guidelines for Debian > sarge on www.kohadocs.org. I followed that useful document too. I managed to install 2.2.7 on sarge and I managed to upgrade that to 2.2.9 also. But I didn't give much attention to the enconding problem. So I wanted to start all over again and do it properly. (I need a good utf-8 support on Koha because I think that's the only way I can upload my old bibliographical data - I even managed to do so). > The changes are minimal. When did you do your install? Some weeks ago or more than two months? Because I have the feeling the problem has to do with new versions of some perl modules. By the way: Could you do a little test for me? Retrieving a record with the z3950-search I get the data entered in latin1 into the MARC-framework. But I'm quite sure the server delivers the record in utf8 (I checked with MarcEdit). So if you could search ISBN 3170183338 on server aleph.unibas.ch port 9909 database IDS_UTF language MARC21 you should get a title with Ã¼ and Ã¤ in it. With me the two letters are represented with ? and only if I change the display-encoding in the firefox they appear correctly. I would be most grateful to hear what you get. > Sorry, I couldn't > understand where is the problem on the logs you sent. If you install > it without problem and then it comes using Koha, I think the problem > might be the mysql database. Are you sure you have the right > permissions for all the tables? Yes. I can see everything. I can manage alterations in the sytem parameters. The only thing witch for me didn't work until now is addbiblio Thank you and greetings Beda ------------------------------ _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha End of Koha Digest, Vol 24, Issue 40 ************************************

4 3

Re: [Koha] Koha VMWare Virtual appliance problem
by cyberarian 07 Nov '07

07 Nov '07

Thanks Jim for response. You have made a valid point. But as I mentioned earlier I am using vmware player at windows XP. How should I know the ip address of that virtual machine and how can i determine whether apache is running or not. I am not aware of linux commands... Cyberarian On Oct 26, 2007 10:38 PM, Jim Kronebusch <jim(a)winonacotter.org> wrote: > On Thu, 25 Oct 2007 12:51:43 +0500, cyberarian wrote > > Dear All > > > > I have downloaded koha vmware virtual appliance. It is working fine in > > VMware player. But i am unable to load its gui. I used startx command > on > > shell but it says that is a wrong command. What should i do to access > > intranet and opac? > > > > Cyberarian > > If I understand correctly, it sounds as though you are trying to access > the web gui via > the server itself. This won't work by default. The VMware image does not > include a > desktop (as far as I'm aware) by default. Use another machine on the > network and access > the server via the browser via the servers IP address such as > > http://ser.ver.ip.address/cgi-bin/koha/opac-main.pl > > Hope this helps. > > Jim > > -- > This message has been scanned for viruses and > dangerous content by the Cotter Technology > Department, and is believed to be clean. > >

4 4

upgrading from 2.2.5 to 2.2.9
by Huck 07 Nov '07

07 Nov '07

are there any 'gotchas' that one needs to worry about or will a SQL backup of 2.2.5 easily restore into 2.2.9 ? or should one do the upgrade from 2.2.5 --> 2.2.6/7/8/9 ? --Huck

2 1

questions about item description
by Bojan Macan 06 Nov '07

06 Nov '07

Hi, I'm a new user of Koha and now I'm in phase of configuring Koha for my library needs. I have a few questions and I would be grateful if anyone can answer me: 1. How can I import in Koha our information about borrowing. In UNIMARC we have had one field in bibliographic record in which we have put the name of person which borrowed specific item (we have one bibliographic record for each item). We would like to import our data from this field to Koha. Which MARC21 field designated the person who borrowed the specific item? 2. In Borrowing rules we have defined our borrowing policy for specific groups of items (book, referenced literature, serials) but where can we mark a specific item and as reference item or book item? Which MARC21 field is designated for this? And finally: does item level use MARC21 standard at all and where can we choose which fields do we want to use for our item level description? Thank you in advance! Bojan Macan

1 0

Re: Koha on etch - a pain?
by Beda Szukics 06 Nov '07

06 Nov '07

Hi Pablo > I had installed successfully installed Koha v2.2.5 and v2.2.9 on > Debian etch and now on a Lenny, following the guidelines for Debian > sarge on www.kohadocs.org. I followed that useful document too. I managed to install 2.2.7 on sarge and I managed to upgrade that to 2.2.9 also. But I didn't give much attention to the enconding problem. So I wanted to start all over again and do it properly. (I need a good utf-8 support on Koha because I think that's the only way I can upload my old bibliographical data - I even managed to do so). > The changes are minimal. When did you do your install? Some weeks ago or more than two months? Because I have the feeling the problem has to do with new versions of some perl modules. By the way: Could you do a little test for me? Retrieving a record with the z3950-search I get the data entered in latin1 into the MARC-framework. But I'm quite sure the server delivers the record in utf8 (I checked with MarcEdit). So if you could search ISBN 3170183338 on server aleph.unibas.ch port 9909 database IDS_UTF language MARC21 you should get a title with ü and ä in it. With me the two letters are represented with ? and only if I change the display-encoding in the firefox they appear correctly. I would be most grateful to hear what you get. > Sorry, I couldn't > understand where is the problem on the logs you sent. If you install > it without problem and then it comes using Koha, I think the problem > might be the mysql database. Are you sure you have the right > permissions for all the tables? Yes. I can see everything. I can manage alterations in the sytem parameters. The only thing witch for me didn't work until now is addbiblio Thank you and greetings Beda

2 2

Still having expiry date problems in koha 2.2.9
by bluejaydesign＠sympatico.ca 06 Nov '07

06 Nov '07

Hi all, I thought the issues with expiry dates and child card things were resolved in 2.2.9, I wonder if I missed something? Do I need another perl module or something? As for now, on 2 separate systems I have installed koha 2.2.9 on Debian Etch. They both do NOT automatically assign the expiry date, which is set to a year from the entry date. If I need to change something in a Child record, on both systems I will still loose the postal address AND the expiry date. So, if I have missed the solution, sorry, please lead me in the right direction! I couldn't find much related to it. But then, my wife tells me I cannot search... And, so far, no issues running Koha on Etch, apart form what's mentioned above. It works nicely! Marty _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Problems with Koha 2.2.8 and MySQL 4.1
by Meiling Li 06 Nov '07

06 Nov '07

I see in the list archive there was a thread on this problem discussed from May 17-19, 2007 but there was no final solution. I'm running a test installation on a Windows box and I'm experiencing similar problems: 1. On the intranet I have to log in every time I go to a different page, each time it shows: "Login Error! You are accessing Koha from a different ip address! Please login again." 2. The NPL templates no longer load the stylesheets (both OPAC and intranet). In the HTML source it seems to be trying to load "/opac-tmpl/npl/en/includes/" (the directory the stylesheets are in). Fresh install of Apache2.2.6 / ActivePERL5.8.8 / Mysql4.1.22 / Koha2.2.8. I'm new to all of these. Thanks for the help anyone can offer. ****************************************** Meiling Li LA Law Library ******************************************

1 0

Re: new to koha: where to get z39.50 servers?
by Beda Szukics 05 Nov '07

05 Nov '07

H.S. schrieb: > I > am wondering, how do I add Z39.50 servers? You can add the servers in the section parameter of tht intranet interface. > Do I need any kind of > authorization to connect to various such servers (username and > password)? Usually not. > Are there any open ones? A lot. I good starting point is http://www.indexdata.dk/technologies/z3950/ BTW. I would recomend not to use npl-framework when working with z3950. At least in my case z3950 configuration and search works only with the default framework. I don't know why. Greetings Beda

2 3

new to koha: where to get z39.50 servers?
by H.S. 05 Nov '07

05 Nov '07

Hello, I maintain a little bunch of computers in a local community center. They wanted to make a catalog of all the media and books that they have in their little library (a few thousand books). I am learning about library management stuff as I go along ... and only as much as I need to know for installing Koha. I have installed Koha on Ubuntu Feisty (soon to be upgraded to Gutsy). I am wondering, how do I add Z39.50 servers? Do I need any kind of authorization to connect to various such servers (username and password)? Are there any open ones? thanks for all the help, ->HS

1 0

Error 403
by vimal kumar 03 Nov '07

03 Nov '07

Dear Friends, When i trying to start koha 2.28 in Win XP after fresh installation, It shows the following error. I am not able to open the INTRANET .But OPAC work well. I installed the Koha as non Root user in Windows. What I do? My friends also confronted with this problem. Please give us a solution. "Access forbidden! You don't have permission to access the requested directory. There is either no index document or the directory is read-protected. If you think this is a server error, please contact the webmaster. Error 403 localhost 11/03/07 11:21:41 Apache/2.0.59 (Win32) " Vimal Kumar Asst. Librarian Asian School of Business Technopark Trivandrum-695 581 www.asb.edu.in/vimal ---------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

2 1