- Koha - lists.katipo.co.nz

koha on debian etch 4.0
by penelope defreitas 31 Oct '07

31 Oct '07

I recently installed koha sucessfully on debian etch 4.0. However, I was unable to start the mysql service and restart apache. I tried starting the Mysql service using: mysql start command But the dollowing error was obtained: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) When i tried restarting Apache I got the following error: Could not reliably determine the server's fully qualified domain name, using 127.0.0.1 for ServerName [Fri Sep 14 16:44:06 2007] [warn] NameVirtualHost *:8080 has no VirtualHosts [Fri Sep 14 16:44:06 2007] [warn] NameVirtualHost *:80 has no VirtualHosts. We have the following settings for our httpd.conf file: # Koha 2.2 Apache Virtual Host Config File # # Please include this file in your apache configuration. # The best way to do that depends on your site setup. # Some like an Include adding to /etc/apache/httpd.conf # and some prefer a symlink to this file from some dir. # Please refer to your system manuals. # Ports to listen to for Koha # uncomment these if they aren't already in main httpd.conf # #Listen 8080 # NameVirtualHost is used by one of the optional configurations detailed below # Please make sure this line is correct before uncommenting. # See http://httpd.apache.org/docs/vhosts/ for some guides. NameVirtualHost *:80 # KOHA's OPAC Configuration <VirtualHost *:80> ServerAdmin user(a)domain.edu DocumentRoot /usr/local/koha/opac/htdocs ServerName debian ScriptAlias /cgi-bin/koha/ /usr/local/koha/opac/cgi-bin/ Redirect permanent index.html http://opac.ugcsi.edu/cgi-bin/koha/opac-main.pl ErrorLog /usr/local/koha/log/opac-error_log TransferLog /usr/local/koha/log/opac-access_log SetEnv PERL5LIB "/usr/local/koha/intranet/modules" SetEnv KOHA_CONF "/etc/koha.conf" </VirtualHost> # KOHA's INTRANET Configuration NameVirtualHost *:8080 <VirtualHost *:8080> ServerAdmin user(a)domain.edu DocumentRoot /usr/local/koha/intranet/htdocs ServerName debian ScriptAlias /cgi-bin/koha/ "/usr/local/koha/intranet/cgi-bin/" Redirect permanent index.html http://intranet.ugcsi.edu:8080/cgi-bin/koha/mainpage.pl ErrorLog /usr/local/koha/log/koha-error_log TransferLog /usr/local/koha/log/koha-access_log SetEnv PERL5LIB "/usr/local/koha/intranet/modules" SetEnv KOHA_CONF "/etc/koha.conf" </VirtualHost> # If you want to use name based Virtual Hosting: # 1. remove the two Listen lines # 2. replace koha:80 with your.opac.domain.name # 3. replace ServerName koha with ServerName your.opac.domain.name # 4. replace koha:8080 with your intranet domain name # 5. replace ServerName koha with ServerName your.intranet.domain.name # # If you want to use NameVirtualHost'ing (using two names on one ip address): # 1. Follow steps 1-5 above # 2. Uncomment the NameVirtualHost line and set the correct ip address Our ServerName debian is actually the host name of the computer that's running Debian AND ugcsi.edu is our domain name. Any thoughts? Would greatly appreciate your input. Penelope DeFreitas ____________________________________________________________________________________ Got a little couch potato? Check out fun summer activities for kids. http://search.yahoo.com/search?fr=oni_on_mail&p=summer+activities+for+kids&…

4 6

Koha on etch - a pain?
by Beda Szukics 30 Oct '07

30 Oct '07

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

2 2

Re: [Koha] Koha became a little more of a certainty last night
by Joe Atzberger 30 Oct '07

30 Oct '07

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.

2 1

Koha Installation Error - BlueHost.com
by Librarian, SAIACS 30 Oct '07

30 Oct '07

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

1 0

Koha MARC fields 090 $c, $d and 952 $u
by Tim Morris 29 Oct '07

29 Oct '07

I am just another newbie, so here goes? During the test phase of finding a replacement ILS, I found KOHA!! YEA!! It is load on a Windows XP Box with Apache 2.2.4, MYSQL 5.0.45, ActivePerl 5.8.8 (Build 822) and KOHA 2.2.8. After exporting the MARCs record from our old ILS (Athena) and then fixing them with (MARCeditor) They were seccessfully imported into KOHA with the bulkload utility. I decided at some point to Dump the records with the KOHA export function to see if there were any problems: As you can see by the attached sample records, the 090 $c / $d tag and the 952 $u show a problem. Koha asigned the same number to to different Books (952$u19849). It also cause the 090 $c and $d fields to go out of sync. Not sure if the maters or not. I looked at the Database and found that this happened five/six times in 39000 records. Can any tell me how to fix this problem? http://www.nabble.com/file/p13475843/Koha_952%2524u_error.txt Koha_952%24u_error.txt -- View this message in context: http://www.nabble.com/Koha-MARC-fields-090-%24c%2C-%24d-and-952-%24u-tf4714… Sent from the Koha - Discuss mailing list archive at Nabble.com.

1 0

Re: How do I configure KOHA INTRANET for LAN ACCESS
by Beda Szukics 29 Oct '07

29 Oct '07

Phil Lathroum schrieb: > I have a box running KOHA with Apache on it... Witch OS? IP of the box runnung KOHA? > I want to be able to access the intranet portion of KOHA from any > machine in the building... > Basically... I want to keep the box in my office.... And have the > librarian log in from her computer... Should all be possible. It's a matter of configuration (apache on the koha box, nameserver, gateways etc.). > All this is inhouse... If I put HTTP://LIBRARY in on our machines in > the building I get the OPAC... Just a thougt: try http://library:8080/ Greetings Beda

1 0

need help viewing Koha on ubuntu 6.06.1 LTS
by Edwards, Ryan 29 Oct '07

29 Oct '07

Hello, I managed to install Koha on Ubuntu 6.06: http://matthew.metzger.cc/wiki/index.php?title=Install_Koha_on_Ubuntu_6. 06, but I can't get to the interface. Do I need to set up any virtual hosts? What url should I go to to view the interface? Thanks, Ryan

2 1

How do I configure KOHA INTRANET for LAN ACCESS
by Phil Lathroum 29 Oct '07

29 Oct '07

I checked online and found a few answers each with slightly different info... Neither one worked... How do I configure APACHE to access the INTRANET side accross the lan... THANKS Philip Lathroum Technology Coordinator Cardinal Shehan School 410-433-2775 x107

3 2

Reserve Error fixed... 1 error/bug left (for now)
by Phil Lathroum 29 Oct '07

29 Oct '07

OK... I downloaded MYSQL ADMINISTRATOR to try and fix the error in the RESERVE LIST and it would not work... It would not let me edit the data... Do I Downloaded SQL-FRONT (formerly MYSQL-FRONT) and it worked like a charm... I just added a date for when the reserve was cancelled and it is gone from the list on the Intranet now... Still need to know if there is a fix for Patrons not being able to see what they have on reserve... THANKS Philip Lathroum Technology Coordinator Cardinal Shehan School 410-433-2775 x107

1 0

ZOOM Perl Module - Error
by Librarian, SAIACS 29 Oct '07

29 Oct '07

While installing ZOOM perl module I encounter following error message. Can any one there to solve/offer a help? 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 ============================================================================ Method: Perl Expect Fetching CPAN timestamp...Done Testing connection speed...(this could take a while)...Done Ping:20.246 Testing connection speed to httpupdate.cpanel.net using pureperl...(61780.00 bytes/s)...Done Ping:1000 Testing connection speed to ftp.kfki.hu using pureperl...(14866.67 bytes/s)...Done Ping:1000 Testing connection speed to cpan.wanadoo.nl using pureperl...(10096.77 bytes/s)...Done Three usable mirrors located Mirror Check passed for httpupdate.cpanel.net (/index.html) CPAN: File::HomeDir loaded ok (v0.66) CPAN: Storable loaded ok (v2.16) Going to read /home/jlcopaco/.cpan/Metadata Database was generated on Mon, 24 Sep 2007 09:36:43 GMT Running install for module 'ZOOM' Running make for M/MI/MIRK/Net-Z3950-ZOOM-1.20.tar.gz CPAN: Digest::SHA loaded ok (v5.45) CPAN: Compress::Zlib loaded ok (v1.42) Checksum for /home/jlcopaco/.cpan/sources/authors/id/M/MI/MIRK/Net-Z3950-ZOOM-1.20.tar.gz ok Net-Z3950-ZOOM-1.20/ Net-Z3950-ZOOM-1.20/samples/ Net-Z3950-ZOOM-1.20/samples/zoom/ Net-Z3950-ZOOM-1.20/samples/zoom/trivial-async.pl Net-Z3950-ZOOM-1.20/samples/zoom/zdump.pl Net-Z3950-ZOOM-1.20/samples/zoom/async.pl Net-Z3950-ZOOM-1.20/samples/zoom/zoomscan.pl Net-Z3950-ZOOM-1.20/samples/zoom/zhello.pl Net-Z3950-ZOOM-1.20/samples/zoom/zoomtst1.pl Net-Z3950-ZOOM-1.20/samples/zoom/zselect Net-Z3950-ZOOM-1.20/samples/zoom/update.pl Net-Z3950-ZOOM-1.20/samples/zoom/zoomtst3.pl Net-Z3950-ZOOM-1.20/samples/README Net-Z3950-ZOOM-1.20/samples/net-z3950/ Net-Z3950-ZOOM-1.20/samples/net-z3950/zoomtst1.pl Net-Z3950-ZOOM-1.20/samples/records/ Net-Z3950-ZOOM-1.20/samples/records/esdd0006.grs Net-Z3950-ZOOM-1.20/samples/ccl/ Net-Z3950-ZOOM-1.20/samples/ccl/default.bib Net-Z3950-ZOOM-1.20/samples/cql/ Net-Z3950-ZOOM-1.20/samples/cql/pqf.properties Net-Z3950-ZOOM-1.20/samples/net-z3950-zoom/ Net-Z3950-ZOOM-1.20/samples/net-z3950-zoom/async.pl Net-Z3950-ZOOM-1.20/samples/net-z3950-zoom/zoomtst1.pl Net-Z3950-ZOOM-1.20/samples/net-z3950-zoom/zoomtst3.pl Net-Z3950-ZOOM-1.20/README Net-Z3950-ZOOM-1.20/Changes Net-Z3950-ZOOM-1.20/META.yml Net-Z3950-ZOOM-1.20/MANIFEST Net-Z3950-ZOOM-1.20/ZOOM.xs Net-Z3950-ZOOM-1.20/MANIFEST.SKIP Net-Z3950-ZOOM-1.20/Makefile.PL Net-Z3950-ZOOM-1.20/t/ Net-Z3950-ZOOM-1.20/t/29-events.t Net-Z3950-ZOOM-1.20/t/11-option-callback.t Net-Z3950-ZOOM-1.20/t/15-scan.t Net-Z3950-ZOOM-1.20/t/16-packages.t Net-Z3950-ZOOM-1.20/t/13-resultset.t Net-Z3950-ZOOM-1.20/t/24-sorting.t Net-Z3950-ZOOM-1.20/t/17-logging.t Net-Z3950-ZOOM-1.20/t/20-options.t Net-Z3950-ZOOM-1.20/t/12-query.t Net-Z3950-ZOOM-1.20/t/10-options.t Net-Z3950-ZOOM-1.20/t/1-Net-Z3950-ZOOM.t Net-Z3950-ZOOM-1.20/t/22-query.t Net-Z3950-ZOOM-1.20/t/27-logging.t Net-Z3950-ZOOM-1.20/t/25-scan.t Net-Z3950-ZOOM-1.20/t/19-events.t Net-Z3950-ZOOM-1.20/t/14-sorting.t Net-Z3950-ZOOM-1.20/t/28-charset.t Net-Z3950-ZOOM-1.20/t/23-resultset.t Net-Z3950-ZOOM-1.20/t/26-packages.t Net-Z3950-ZOOM-1.20/t/18-charset.t Net-Z3950-ZOOM-1.20/t/2-ZOOM.t Net-Z3950-ZOOM-1.20/t/21-option-callback.t Net-Z3950-ZOOM-1.20/typemap Net-Z3950-ZOOM-1.20/lib/ Net-Z3950-ZOOM-1.20/lib/ZOOM.pm Net-Z3950-ZOOM-1.20/lib/ZOOM.pod Net-Z3950-ZOOM-1.20/lib/Net/ Net-Z3950-ZOOM-1.20/lib/Net/Z3950/ Net-Z3950-ZOOM-1.20/lib/Net/Z3950/ZOOM.pm Net-Z3950-ZOOM-1.20/lib/Net/Z3950.pm CPAN: File::Temp loaded ok (v0.16) CPAN: YAML loaded ok (v0.65) CPAN.pm: Going to build M/MI/MIRK/Net-Z3950-ZOOM-1.20.tar.gz perl-64bit-hack: enabled ERROR: Unable to call script: yaz-config If you are using a YAZ installation from the Debian package "yaz", you will also need to install "libyaz-dev" in order to build this module. make: *** No targets specified and no makefile found. Stop. MIRK/Net-Z3950-ZOOM-1.20.tar.gz /usr/bin/make PREFIX=/home/jlcopaco/perl/usr OTHERLDFLAGS=-L/usr/lib64 LDFLAGS=-L/usr/lib64 EXTRALIBDIR=/usr/lib64 PREFIX=/home/jlcopaco/perl/usr OTHERLDFLAGS=-L/usr/lib64 LDFLAGS=-L/usr/lib64 EXTRALIBDIR=/usr/lib64 -- NOT OK Running make install Make had returned bad status, install seems impossible perlmod--Install done

2 1