- Koha - lists.katipo.co.nz

independent and single branch option doesnt seem to work
by Jason 28 May '08

28 May '08

the default was chosen upon installation to allow sample material such as libraries and patrons. I created another library and set it as the library being used. After doing this I selected in the administration: system preferences: admin tab to "on" the independent and single branch feature. After this, I do a patron search and all of the sample patrons from the sample libraries still show. All of the drop down menus that pertain to libraries still have all of the sample libraries showing. Jason Smith Instructor in Christian Education Kentucky Mountain Bible College 1-800-879-5622 Home ext #754 Office ext #220

2 1

Re: [Koha] Hello and a problem w/ koha 3 on debian
by Steven Owley 28 May '08

28 May '08

Hi everyone and thanks, Well, a step forward. Now I am getting "production mode - trapped fatal error" on port 8080. I killed the koha database, and went through the koha installation again. I am not sure what the problem may be. "Make test" went without error. If I use koha.mydomain.org:8080 I get the error message I just mentioned. If I use localhost:8080 I get the apache default "it works" page. I tried a manual install of CGI::Session, and while it went OK, it did not fix the problem, as you can see below. (During installation of CGI::Session, tests indicated that it could not attach to the mysql db, but this did not stop the installation.) I get these errors in koha-error_log (there are no new errors in koha-opac-error_log): [Tue May 27 15:50:39 2008] [error] [client 198.xxx.xxx.5] [Tue May 27 15:50:39 2008] mainpage.pl: DBD::mysql::st execute failed: Table 'koha.language_descriptions' doesn't exist at /usr/share/koha/lib/C4/Languages.pm line 318. [Tue May 27 15:50:39 2008] [error] [client 198.xxx.xxx.5] [Tue May 27 15:50:39 2008] mainpage.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/lib/C4/Languages.pm line 319. <snip> [Tue May 27 15:50:40 2008] [error] [client 198.xxx.xxx.5] [Tue May 27 15:50:40 2008] install.pl: Use of uninitialized value in string eq at /usr/share/koha/lib/C4/Context.pm line 38. [Tue May 27 15:50:40 2008] [error] [client 198.xxx.xxx.5] [Tue May 27 15:50:40 2008] install.pl: Can't locate object method "generate_id" via package "CGI::Session::ID::" (perhaps you forgot to load "CGI::Session::ID::"?) at /usr/local/share/perl/5.8.8/CGI/Session.pm line 74. I created the koha database and kohaadmin user in phpmyadmin. The password for kohaadmin is the same as the makefile suggests. Thanks, Steve On Sun, May 25, 2008 at 6:19 PM, Garry Collum <gcollum(a)gmail.com> wrote: > Oops. I replied to Stephen, but didn't reply to the list. > > I did a "from scratch" install on Debian yesterday and actually documented > what I did. > > The 8080 error is easy. Just add "Listen 8080" to your apache2.conf or > httpd.conf file. > > The second problem seems to have been fixed when I either added the > CGI::Simple perl module or downloaded and compiled the most current > CGI::Session module from CPAN. I also downloaded DBI and DBD::mysql, but I > believe it was one of the CGI modules that fixed the problem. > > I also thought that it was because the table structure had not been > created, so I found the SQL file within the source code that creates the > table structure and created. No dice. I didn't get the same error but I > got a similar one. I dropped the database and recreated it. Then I did the > steps above. > > Garry > > > > On Sun, May 25, 2008 at 4:23 PM, Steven Owley <steveno(a)ohionet.org> wrote: > >> Hello everyone, >> >> Happy to be part of this list; hope to be of help as well as asking for >> it. >> >> I have installed koha 3 on debian etch. Getting no response on 8080 and >> this error on 80: >> >> [Sun May 25 16:03:14 2008] [error] [client 69.xxx.xxx.x] [Sun May 25 >> 16:03:14 2008] maintenance.pl: DBD::mysql::db selectrow_array failed: Table >> 'koha.systempreferences' doesn't exist at /usr/share/koha/lib/C4/Context.pm >> line 455., referer: http://198.xxx.xxx.x/cgi-bin/koha/maintenance.pl >> >> I've dug around a bit, but I don't see a definitive answer to this >> problem, though it does not seem uncommon. Do I need to reinstall >> something? I am guessing that my installation of DB::mysql is somehow >> wrong. >> >> Thanks, >> >> Steve >> >> >> _______________________________________________ >> Koha mailing list >> Koha(a)lists.katipo.co.nz >> http://lists.katipo.co.nz/mailman/listinfo/koha >> >> > -- Steven Owley Technology Specialist Ohionet 614-486-2966 x19

2 2

OPAC search problems in version 3
by Tim McMahon - West Liberty Public Library 28 May '08

28 May '08

Searching seems to be working on the intranet side of things, but I get no search results on the OPAC. The only thing I found in the logs for the search was in /var/log/koha/koha-zebradaemon-output.log. 15:22:52-13/04 zebrasrv(19) [request] Search biblios ERROR 114 1 1+0 RPN @attrset Bib-1 @and @or @or @or @or @or @attr 1=36 @attr 4=1 @attr 6=3 @attr 9=32 @attr 2=102 something @attr 1=4 @attr 4=1 @attr 6=3 @attr 9=28 @attr 2=102 something @attr 1=4 @attr 4=1 @attr 9=26 @attr 2=102 something @attr 4=6 @attr 5=103 @attr 9=16 @attr 2=102 something @attr 4=6 @attr 5=1 @attr 9=14 @attr 2=102 "someth? " @attr 4=6 @attr 9=14 @attr 2=102 something @or @attr 1=8002 @attr 4=109 @attr 2=2 0 @not @attr "1=_ALLRECORDS" @attr 2=103 '' @attr 1=8002 @attr 2=103 '' 15:22:52-13/04 zebrasrv(19) [session] Connection closed by client Yup. I was searching for 'something'. The intranet search returned 90 results. -- Tim McMahon Technical Services West Liberty Public Library 400 N. Spencer St. West Liberty, IA 52776 Phone: 319-627-2084 Fax: 319-627-2135 tmcmahon(a)wlpl.org http://www.wlpl.org

5 6

Koha without MARC
by Gautam John 28 May '08

28 May '08

Hello: I've been looking to use Koha without MARC support. Is this possible in Koha 3 and what are the upsides and downsides to not using MARC? The reason I ask is that it'll be so much easier to import books into the system, from our current Excel sheets, rather than using MARC or so I assume. Best, Gautam -- Please read our new blog at: http://blog.prathambooks.org/

4 5

Newbie - cannot query online catalogs
by George B. Dennis 28 May '08

28 May '08

Hi list, I have Koha 2.2.9 installed on Apache 2.2.4 and openSuSE 10.3. I am having troubles with running a z39.50 search on other online libraries. I keep getting prompted to download the file "search.pl". Here is an excerpt from /usr/local/koha/log/library-error_log after a search for a book by ISBN: [Tue May 27 11:47:16 2008] [error] [client 192.168.0.33] something went wrong: No error at /usr/local/koha/intranet/cgi-bin/z3950/search.pl line 135., referer: http://192.168.0.7:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=1 904811418 [Tue May 27 11:47:16 2008] [error] [client 192.168.0.33] doing the search at /usr/local/koha/intranet/cgi-bin/z3950/search.pl line 145., referer: http://192.168.0.7:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=1 904811418 [Tue May 27 11:47:16 2008] [error] [client 192.168.0.33] connection 0: event 1 (connect), referer: http://192.168.0.7:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=1 904811418 [Tue May 27 11:47:16 2008] [error] [client 192.168.0.33] connection 0: event 6 (send apdu), referer: http://192.168.0.7:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=1 904811418 [Tue May 27 11:47:16 2008] [error] [client 192.168.0.33] connection 0: event 2 (send data), referer: http://192.168.0.7:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=1 904811418 [Tue May 27 11:47:16 2008] [error] [client 192.168.0.33] connection 0: event 10 (end), referer: http://192.168.0.7:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=1 904811418 [Tue May 27 11:47:16 2008] [error] [client 192.168.0.33] library.anu.edu.au at /usr/local/koha/intranet/cgi-bin/z3950/search.pl line 166., referer: http://192.168.0.7:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=1 904811418 [Tue May 27 11:47:16 2008] [error] [client 192.168.0.33] 0 library.anu.edu.au error @attr 1=7 "1904811418": Connect failed (10000) library.anu.edu.au:210, referer: http://192.168.0.7:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=1 904811418 [Tue May 27 11:47:16 2008] [error] [client 192.168.0.33] Premature end of script headers: search.pl, referer: http://192.168.0.7:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&isbn=1 904811418 Can anyone on the list point me in the right direction? George B. Dennis

1 0

Re: [Koha] Latest patched files for V2.2.9]
by Rob Weir 27 May '08

27 May '08

I made the mistake of sending a message on a Friday afternoon, and got no responses, probably because everyone was gone for the weekend. Is there anyone reading the list today that could help me? I would like to get a copy of the most stable, bug-free set of V2.2.9 files that I can find so I can rebuild the win32 install package. I am hoping to reduce the amount of frustration users encounter when they do a new install and run into bugs that have already been squashed and patched. Hopefully it should also cut down on the amount of repeat traffic on the list. Is there any chance that Liblime, BibLibre, or one of the other organizations would be willing to provide me with a tarball of 2.2.9 files that would include patches and fixes that have been made since the original release? Or is there a repository somewhere that would include bug fixes? Thanks much! Rob -------- Original Message -------- Subject:[Koha] Latest patched files for V2.2.9 Date: Fri, 16 May 2008 16:08:18 -0400 From: Rob Weir <robweir(a)alum.drexel.edu> To: koha(a)lists.katipo.co.nz Where can I find a complete set of V2.2.9 files with all the latest patches and bug fixes? The download link on koha.org still takes you to the original release which includes a number of bugs. If I recall correctly, we started using git sometime after 2.2.9 was released. Were the 2.2.9 files moved over into git, and have any 2.2.9 bug fixes since the release been added to the git repository? Or is there an up-to-date copy of 2.2.9 including bug fixes in some other repository? Or is there at least a list of known issues with suggested patches somewhere? Since 2.2.9 is the latest "stable" release, I am hoping those files have been maintained somewhere and patches for bugs applied as they were discovered and fixed. Thanks, Rob _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

2 2

HTTP OPAC Vhost - Koha 3 on OpenSuse 10.3
by gsl 27 May '08

27 May '08

We are still having problems http'ing into the OPAC using Koha 3 on OpenSuse 10.3. We've tried setting the Koha virtual/localhost on 127.0.0.2 (and others, like 127.0.0.5 and 127.0.0.10). From the browser we get the following error: ------------------- Forbidden You don't have permission to access / on this server. /*what would it be trying to access / for anyway? Additionally, a 403 Forbidden error was encountered while trying to use an ErrorDocument to handle the request. Apache/2.2.4 (Linux/SUSE) Server at 127.0.0.5 Port 80 ---------------- These are the errors listed in the /var/log/apache2/error_log file: [Tue May 27 10:29:26 2008] [error] Failed to change_hat to 'HANDLING_UNTRUSTED_INPUT' [Tue May 27 10:29:34 2008] [error] Failed to change_hat to 'HANDLING_UNTRUSTED_INPUT' [Tue May 27 10:31:39 2008] [error] Failed to change_hat to 'HANDLING_UNTRUSTED_INPUT' [Tue May 27 10:32:22 2008] [error] Failed to change_hat to 'HANDLING_UNTRUSTED_INPUT' ---------------- One of the (same/related) issues seems to be that /etc/apache2/vhost.d/koha-httpd.conf can't call a line which creates the web page, "opac-main.pl". We turned off AppArmor, opened up permissions on /usr/share/koha/opac, and kicked the trashcan several times, no luck. Any ideas? Greg Greg Lawson Rolling Hills Consolidated Library 1912 N. Belt Highway St. Joseph, MO 64506 ------------------

2 1

insall koha 3 on debian
by William Danial 27 May '08

27 May '08

hi every one i want to install koha on debian i was reading alot in this point but i need some one take my hand and guide me to install koha.any help

2 1

KOHA 3.0 beta
by Thomas Clark Wilson 27 May '08

27 May '08

I read at http://www.koha.org/about-koha/news/nr1206253557.html that the new version runs under Windows (and others). Has anyone any experience with running under Windows? I am currently running 2.2.9 for windows, but am away from the office and cannot check out the new one. Thanks, TW -- Dr. Thomas Wilson, VSO Tanzania - Zanzibar Library Dar es Salaam, TANZANIA Tel: (+255) (0)75 4978468 Email: tom.wilson.87(a)alumni.concordia.ca

1 0

Re: [Koha] Hello and a problem w/ koha 3 on debian
by José Miguel Parrella Romero 27 May '08

27 May '08

Steven Owley escribió: > I have installed koha 3 on debian etch. Getting no response on 8080 and > this error on 80: > > [Sun May 25 16:03:14 2008] [error] [client 69.xxx.xxx.x] [Sun May 25 > 16:03:14 2008] maintenance.pl: DBD::mysql::db selectrow_array failed: > Table 'koha.systempreferences' doesn't exist at > /usr/share/koha/lib/C4/Context.pm line 455., referer: > http://198.xxx.xxx.x/cgi-bin/koha/maintenance.pl OPAC will output this when the system has not been installed yet. After using the Makefiles to put everything in place in your system, you still have to visit the Intranet at :8080 and go through some steps on the web installer. This should not happen, however, when upgrading between git revisions of Koha3. As it was stated, add 8080 to your Apache listen ports and go through all steps of the web installer. HTH, Jose

1 0