- Koha - lists.katipo.co.nz

Solaris/Zoom: Cannot get OPAC or Intranet to load
by Tom Metzger 26 Apr '07

26 Apr '07

Solaris 9. Perl 5.8.8 Got Zoom installed using mostly default options. Added the Include line to Apache conf and uncommented the Listen statements in koha-httpd.conf. /etc/koha.conf file looks like this: database=Koha hostname=localhost user=kohaadmin pass=XxXxXxXxX intranetdir=/usr/local/koha/intranet opacdir=/usr/local/koha/opac kohalogdir=/usr/local/koha/log kohaversion=2.2.8 httpduser=apache intrahtdocs=/usr/local/koha/intranet/htdocs/intranet-tmpl opachtdocs=/usr/local/koha/opac/htdocs/opac-tmpl When I try to load (example) the OPAC page, I get an "Internal Server Error" in my browser. Looking in /usr/local/koha/log/ I get this: cedar:/usr/local/koha/log# ls -al total 8 drwxrwx--- 2 root other 512 Apr 26 14:03 . drwxr-xr-x 5 root other 512 Apr 26 12:19 .. -rw-r--r-- 1 root other 0 Apr 26 14:03 koha-access_log -rw-r--r-- 1 root other 0 Apr 26 14:03 koha-error_log -rw-r--r-- 1 root other 169 Apr 26 14:03 opac-access_log -rw-r--r-- 1 root other 4570 Apr 26 14:03 opac-error_log cedar:/usr/local/koha/log# cat opac-access_log 208.119.83.102 - - [26/Apr/2007:14:03:28 -0400] "GET / HTTP/1.1" 304 - 208.119.83.102 - - [26/Apr/2007:14:03:28 -0400] "GET /cgi-bin/koha/ opac-main.pl HTTP/1.1" 500 674 cedar:/usr/local/koha/log# cat opac-error_log [Thu Apr 26 14:03:29 2007] [error] [client 208.119.83.102] read_config_file(/etc /koha.conf) returned undef at /usr/local/koha/intranet/modules/C4/ Context.pm lin e 229. [Thu Apr 26 14:03:29 2007] [error] [client 208.119.83.102] read_config_file(/etc /koha.conf) returned undef at /usr/local/koha/intranet/modules/C4/ Context.pm lin e 229. [Thu Apr 26 14:03:29 2007] [error] [client 208.119.83.102] read_config_file(/etc /koha.conf) returned undef at /usr/local/koha/intranet/modules/C4/ Context.pm lin e 229. [Thu Apr 26 14:03:29 2007] [error] [client 208.119.83.102] read_config_file(/etc /koha.conf) returned undef at /usr/local/koha/intranet/modules/C4/ Context.pm lin e 229. [Thu Apr 26 14:03:29 2007] [error] [client 208.119.83.102] read_config_file(/etc /koha.conf) returned undef at /usr/local/koha/intranet/modules/C4/ Context.pm lin e 229. [Thu Apr 26 14:03:29 2007] [error] [client 208.119.83.102] read_config_file(/etc /koha.conf) returned undef at /usr/local/koha/intranet/modules/C4/ Context.pm lin e 229. [Thu Apr 26 14:03:29 2007] [error] [client 208.119.83.102] read_config_file(/etc /koha.conf) returned undef at /usr/local/koha/intranet/modules/C4/ Context.pm lin e 229. [Thu Apr 26 14:03:29 2007] [error] [client 208.119.83.102] read_config_file(/etc /koha.conf) returned undef at /usr/local/koha/intranet/modules/C4/ Context.pm lin e 229. [Thu Apr 26 14:03:29 2007] [error] [client 208.119.83.102] read_config_file(/etc /koha.conf) returned undef at /usr/local/koha/intranet/modules/C4/ Context.pm lin e 229. [Thu Apr 26 14:03:29 2007] [error] [client 208.119.83.102] read_config_file(/etc /koha.conf) returned undef at /usr/local/koha/intranet/modules/C4/ Context.pm lin e 229. [Thu Apr 26 14:03:29 2007] [error] [client 208.119.83.102] read_config_file(/etc /koha.conf) returned undef at /usr/local/koha/intranet/modules/C4/ Context.pm lin e 229. [Thu Apr 26 14:03:29 2007] [error] [client 208.119.83.102] read_config_file(/etc /koha.conf) returned undef at /usr/local/koha/intranet/modules/C4/ Context.pm lin e 229. [Thu Apr 26 14:03:29 2007] [error] [client 208.119.83.102] read_config_file(/etc /koha.conf) returned undef at /usr/local/koha/intranet/modules/C4/ Context.pm lin e 229. [Thu Apr 26 14:03:29 2007] [error] [client 208.119.83.102] read_config_file(/etc /koha.conf) returned undef at /usr/local/koha/intranet/modules/C4/ Context.pm lin e 229. [Thu Apr 26 14:03:29 2007] [error] [client 208.119.83.102] DBD::mysql::st execut e failed: No database selected at /usr/local/koha/opac/cgi-bin/opac- main.pl line 18. [Thu Apr 26 14:03:29 2007] [error] [client 208.119.83.102] DBD::mysql::st fetchr ow_array failed: fetch() without execute() at /usr/local/koha/opac/ cgi-bin/opac- main.pl line 21. [Thu Apr 26 14:03:29 2007] [error] [client 208.119.83.102] DBD::mysql::db select row_array failed: No database selected at /usr/local/koha/intranet/ modules/C4/Co ntext.pm line 366. [Thu Apr 26 14:03:29 2007] [error] [client 208.119.83.102] DBD::mysql::db select row_array failed: No database selected at /usr/local/koha/intranet/ modules/C4/Co ntext.pm line 366. [Thu Apr 26 14:03:29 2007] [error] [client 208.119.83.102] DBD::mysql::db select row_array failed: No database selected at /usr/local/koha/intranet/ modules/C4/Co ntext.pm line 366. [Thu Apr 26 14:03:29 2007] [error] [client 208.119.83.102] HTML::Template->new() : Cannot open included file /css/en/opac-main.tmpl : file not found. at /usr/lo cal/lib/perl5/site_perl/5.8.7/HTML/Template.pm line 1658 [Thu Apr 26 14:03:29 2007] [error] [client 208.119.83.102] \tHTML::Template::_in it_template('HTML::Template=HASH(0x23cccc)') called at /usr/local/lib/ perl5/site _perl/5.8.7/HTML/Template.pm line 1238 [Thu Apr 26 14:03:29 2007] [error] [client 208.119.83.102] \tHTML::Template::_in it('HTML::Template=HASH(0x23cccc)') called at /usr/local/lib/perl5/ site_perl/5.8 .7/HTML/Template.pm line 1124 [Thu Apr 26 14:03:29 2007] [error] [client 208.119.83.102] \tHTML::Template::new ('HTML::Template', 'filename', '/css/en/opac-main.tmpl', 'die_on_bad_params', 0, 'global_vars', 1, 'path', 'ARRAY(0xdf72d0)', ...) called at /usr/ local/koha/int ranet/modules/C4/Output.pm line 77 [Thu Apr 26 14:03:29 2007] [error] [client 208.119.83.102] \tC4::Output::gettemp late('opac-main.tmpl', 'opac', 'CGI=HASH(0x1244c4)') called at /usr/ local/koha/i ntranet/modules/C4/Auth.pm line 114 [Thu Apr 26 14:03:29 2007] [error] [client 208.119.83.102] \tC4::Auth::get_templ ate_and_user('HASH(0x139e5c)') called at /usr/local/koha/opac/cgi-bin/ opac-main. pl line 30 [Thu Apr 26 14:03:29 2007] [error] [client 208.119.83.102] Premature end of scri pt headers: opac-main.pl cedar:/usr/local/koha/log# My eyes are literally crossing from looking at this the last 4 hours. Can anyone point me in the right direction for where I need to look next? I'm close...I know I am...it's just being very elusive right now. TIA. Tom Metzger INCOLSA Systems Administrator Sometimes you have to stride boldly up to Life, look it straight in the eye, and say "huh?"

2 2

Edit Items strangeness
by Huck 26 Apr '07

26 Apr '07

In the 'edit items' page (additem.pl) I'm attempting to add and item but the field 'p - Barcode*' is grey'd out and I can not enter any information and it's a required field. Is this a 'feature' in 2.2.8 ? ;) --Huck

4 5

installer database error
by Jochum van der Heide 26 Apr '07

26 Apr '07

Hi, I'm installing Koha on CentOS 4.3. I've installed mysql-4.1.12-3 and all required Perl mods. But it gives me the error: ERROR 1045 (28000): Access denied for user 'kohaadmin'@'localhost' (using password: YES) DBI connect('Koha:localhost','kohaadmin',...) failed: Access denied for user 'kohaadmin'@'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 1553. Problem updating database... I've searched the list archives and seen this error in relation to MySQL5, so doesn't seem applicable in my case. Any idea what I'm doing wrong? -- Jochum

8 17

OPAC--Koha home page
by Amber Amland 26 Apr '07

26 Apr '07

Does anyone know how to create a way for Koha to refresh the home search screen for patrons after a certain amount of time? I'd like my OPAC to go back to the home search screen after say four minutes or so. That way it will usually be on the home search screen when people approach it instead of on the last search that was done. Thanks! _________________________________________________________________ Interest Rates NEAR 39yr LOWS! $430,000 Mortgage for $1,299/mo - Calculate new payment http://www.lowermybills.com/lre/index.jsp?sourceid=lmb-9632-19132&moid=14888

3 3

Koha/Solaris 9 install problem
by Tom Metzger 26 Apr '07

26 Apr '07

I'm running into a problem trying to install Koha on Solaris 9. Here is the output which is torturing me: cedar:/usr/local/src/koha/koha-2.2.8# perl installer.pl WELCOME TO THE KOHA INSTALLER This program will ask some questions and try to install koha for you. You need to know: where most koha files should be stored (you can set the prefix environment variable for this); the username and password of a mysql superuser; and details of your library setup. You may also need to know details of your Apache setup. If you want to install the Koha configuration files somewhere other than /etc (for installing not as root, or to have many Kohas on one system, for example), you should set the etcdir environment variable. Please look at your manuals for details of how to set that. Recommended answers are given in brackets after each question. To accept the default value for any question (indicated by []), simply hit Enter at the prompt. Note that you also can define an auto_install_file, that will answer every question automatically. To use this feature, run ./installer.pl -i /path/to/auto_install_file Are you ready to begin the installation? ([Y]/N): y Great! Continuing... PERL MODULES Checking perl modules ... could not find ParserDetails.ini in /usr/local/lib/perl5/site_perl/ 5.8.7/XML/SAX Subroutine PDF::API2::Resource::Font::Postscript::O_RDONLY redefined at /usr/local/lib/perl5/5.8.7/Exporter.pm line 65. at /usr/local/lib/perl5/site_perl/5.8.7/PDF/API2/Resource/Font/ Postscript.pm line 46 MISSING PERL MODULES You are missing some Perl modules required by Koha. Please run this again after installing them. They may be installed by finding packages from your operating system supplier, or running (as root) the following commands: perl -MCPAN -e 'install "MARC::File::XML"' perl -MCPAN -e 'install "You will need Net::LDAP if you want to authentify patrons through a LDAP"' cedar:/usr/local/src/koha/koha-2.2.8# perl -MCPAN -e 'install "MARC::File::XML"' CPAN: Storable loaded ok (v2.13) Going to read /.cpan/Metadata Database was generated on Mon, 23 Apr 2007 13:09:44 GMT MARC::File::XML is up to date (0.85). cedar:/usr/local/src/koha/koha-2.2.8# The MARC::File::XML, as you can see, is installed and up-to-date, but the installer continues to warn about it (and die). Any suggestions from others who have been there? Tom Metzger INCOLSA Systems Administrator Sometimes you have to stride boldly up to Life, look it straight in the eye, and say "huh?"

2 10

Re: [Koha] Re: Koha/Solaris 9 install problem
by BWS Johnson 26 Apr '07

26 Apr '07

Salvete! >Do questions not get answered on the list unless we pay for support? Some of them do. It helps to list the real command line error and the version and platform that you use. Also, if you aren't paying, it helps to be patient, because you needs wait for folks with time on their hands to get back to you if they've enough information to help. And, for folks like me, I can answer librarian questions, but it would be a scary thing if I tried to tackle a tech question. Overall, I've found support for Koha to be superior to a commercial ILS - for free! Cheers, Brooke @ Hinsdale MA

2 1

Several Issues
by George Kraniotis 26 Apr '07

26 Apr '07

1. When a book is issued to a patron, it doesn't load into the user-side to show them what they have been issued. The only place we can view the books that have been issued are within the individual patron's account on the admin side. Our initial analysis has brought us to believe that there is something in the Perl code that is incorrect. 2. After searching for a book, the barcode image comes up with an image error (red 'x'). 3. When you add a book to the catalog, you must select a branch for that book. Is there a way where you can make the branch default, instead of selecting it every time. (We only have one branch.) I appreciate your help with all these problems. Let me know if you need things explained further. -George

2 3

Re: [Koha] opac not showing REAL info...
by Chris Cormack 26 Apr '07

26 Apr '07

On 26/04/2007, at 9:59 AM, Huck wrote: > it was the template set... > > in fixing the z39.50 issue I reverted to older(pre 2.2.8) templates > and that broke the opac searching... > > so I re-ran the upgrade script and ONLY fixed the intranet > templates for 2.2.8 to resolve the z39.50 search issue. > > But there is ONE last error I am coming across...after inputting a > ISBN and doing the z39.50 search and importing the biblio... when > attempting to 'add item' the 'barcode' field does not allow ANY > input from keyboard/scanner...can not 'tab' into the field and can > not click into the field with the mouse either...yet it is a > required field(for obvious reasons) in order to add an item. > Hmmm thats an interesting one Ive heard that from another Koha user too, ill go look into it Chris -- Chris Cormack chris.cormack(a)liblime.com VP Research and Development www.liblime.com LibLime +64 21 542 131

1 0

opac not showing REAL info...
by Huck 25 Apr '07

25 Apr '07

A new question arose, as I was looking at the z39.50 problem(solved thanks to Mike pointing out that the NPL template didn't work)... all of a sudden when I do a search from the opac page I get 'No Title' listed in the Summary column, Item Type is blank as is Location and Item Count says 0, for 225 "hits" that the search found. There was information on Monday when I was demo-ing the opac search site for another library... That is very disconcerting as I KNOW there are 6500+ records in their as of Monday and were returning properly in the search! any ideas?

2 1

koha installation and the perl environment - errors trying to install rt-tracker
by fharrington＠ocln.org 25 Apr '07

25 Apr '07

trying to install rt-tracker using ./configure, make testdeps and make fixdeps I got the following error: ( I only installed koha to check it out - I have since deleted it but the error seems to be rooted in changes made to the perl environment - the errors persist) Going to read /koha/koha-2.2.8/perl -MCPAN -e 'install "Mail::Sendmail"'/sources/authors/01mailrc.txt.gz Unrecognized switch: --decompress (-h will show valid options). Going to read /koha/koha-2.2.8/perl -MCPAN -e 'install "Mail::Sendmail"'/sources/modules/02packages.details.txt.gz Unrecognized switch: --decompress (-h will show valid options). Warning: Your /koha/koha-2.2.8/perl -MCPAN -e 'install "Mail::Sendmail"'/sources/modules/02packages.details.txt.gz does not contain a Line-Count header. Please check the validity of the index file by comparing it to more than one CPAN mirror. I'll continue but problems seem likely to happen. Warning: Your /koha/koha-2.2.8/perl -MCPAN -e 'install "Mail::Sendmail"'/sources/modules/02packages.details.txt.gz does not contain a Last- Updated header. Please check the validity of the index file by comparing it to more than one CPAN mirror. I'll continue but problems seem likely to happen. Going to read /koha/koha-2.2.8/perl -MCPAN -e 'install "Mail::Sendmail"'/sources/modules/03modlist.data.gz Unrecognized switch: --decompress (-h will show valid options). Failed to load module CPAN. Frank Harrington Systems Manager Old Colony Library Network 220 Forbes Road Braintree, MA 02184 (781)794-2513 ext 3 fharrington(a)ocln.org

2 1