- Koha - lists.katipo.co.nz

Zebra Indexing
by Phillip Ponchot 20 Aug '13

20 Aug '13

Koha installed version: 3.00.00.107 I'm trying to re-index my catalog and of course, something is not working. I've read tons of documentation and I am still having an issue as the catalog search is not working. As I understand, you must export these two variables before beginning: export KOHA_CONF=/usr/local/koha/etc/koha-conf.xmlexport PERL5LIB=/usr/local/koha/lib I've tried to export them both as root and the user www-data.to whom the files belong I then run the following command: /usr/local/koha/bin/migration_tools/rebuild_zebra.pl -r -b -a If I run the command as root, the indexing starts but I get some rights issues. If I run the command as www-data, the indexing stops immediately on line 5 of the zebra script complaining that it can't find the C4 directory (even though it is exported - (export PERL5LIB=/usr/local/koha/lib) If anyone can give me the correct steps to get the indexing working again, I would be eternally grateful as I've spent the last 15 hours trying to get the index back up. I even went into koha and gave total rights to root where the scripting was failing. Finally it ran and there are files new files created in /usr/local/koha/var/lib/zebradb/authorities/register and in /usr/local/koha/var/lib/zebradb/biblios/register (i.e. sort12-0.mf) but when I restart the server, the catalog search is still not working. I'm assuming that zebra gets the files for indexing from /usr/local/koha/var/lib/zebradb/authorities/register and /usr/local/koha/var/lib/zebradb/biblios/register. Thanks for any suggestions and/or help. Phillp

2 2

Koha reindexing - What to do now
by Phillip Ponchot 20 Aug '13

20 Aug '13

Hi everyone: I re-indexed my Koha search using the following procedures: 1. Run sudo -s 2. Export these variables: a. export KOHA-CONF=/usr/local/koha/etc/koha-conf.xml b. export PERL5LIB=/usr/local/koha/lib/ 3. Run /usr/local/koha/bin/migration_tools/rebuild_zebra.pl -r -b -a 4. Everything went ok without error. I then went to the following directories and verified they had new files: /usr/local/koha/var/lib/zebradb/authorities/register /usr/local/koha/var/lib/zebradb/biblios/register New files were in this directory but was showing the owner and group was root. Since before they were www-data:www-data I changed the ownership. 5. I restarted the zebra daemons: restart zebra daemon: /etc/init.d/koha/zebra-daemon restart restart zebra-queue /etc/init.d/koha/zebraqueue-daemon restart note: not sure that the zebra-queue was previous running. Tried only doing the zebra-daemon by itself also. When I logged into the website and tried a catalog search on "testing" and then on "king" I received this message for each search. I know "testing" worked before. o Result found ! No results match your search for “testing” in Livingston-Park County Public Library Catalog. Does anyone know how the zebra-daemon loads these files: usr/local/koha/var/lib/zebradb/authorities/register /usr/local/koha/var/lib/zebradb/biblios/register Thanks for any suggestions as I'm trying to decide what to do next to get this to work.

1 0

RE : [Koha-devel] errors ldap
by Eric Bégin 19 Aug '13

19 Aug '13

Bonjour Samuel, It seems the category codes you are receiving from your LDAP server doesn't match your patrons' categories defined in Koha. Double check also your date formats. You have some warning related to this too. I think they must be formatted as specified in you system preferences. Regards, Eric Bégin Tél : 1-888-604-2627 Cell : 514-777-6572 inLibro | pour esprit libre | www.inLibro.com -------- Message d'origine -------- De : Samuel Desseaux <samuel.desseaux(a)ecp.fr> Date : 19/08/2013 10:54 (GMT-05:00) À : koha(a)lists.katipo.co.nz, koha-devel(a)lists.koha-community.org Objet : [Koha-devel] errors ldap Hi, Our koha is connected to our ldap now. During tests, we have some problems. We have added 2 members the first time and it worked but we have this error opac-user.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`bibecp`.`borrowers`, CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`)) at /home/koha/kohaclone/C4/Auth_with_ldap.pm line 296, <DATA> line 581., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-main.pl?logout.x=1 Now, we can't add members any more These are the logs tail -f koha-opac-error_log [Mon Aug 19 15:20:06 2013] [error] [client 138.195.48.28] File does not exist: /home/koha/kohaclone/koha-tmpl/images, referer: http://tst-koha.ecp.fr/ [Mon Aug 19 15:20:08 2013] [error] [client 138.195.48.28] client denied by server configuration: /home/koha/kohaclone/koha-tmpl/opac-tmpl/prog/fr-FR/includes/favicon.ico [Mon Aug 19 15:20:10 2013] [error] [client 138.195.48.28] File does not exist: /home/koha/kohaclone/koha-tmpl/images, referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl [Mon Aug 19 15:20:22 2013] [error] [client 138.195.48.28] [Mon Aug 19 15:20:22 2013] opac-user.pl: Use of uninitialized value in string ne at /home/koha/kohaclone/C4/Auth.pm line 670, <DATA> line 581., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl [Mon Aug 19 15:20:22 2013] [error] [client 138.195.48.28] [Mon Aug 19 15:20:22 2013] opac-user.pl: Use of uninitialized value $pki_field in string eq at /home/koha/kohaclone/C4/Auth.pm line 780, <DATA> line 581., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl [Mon Aug 19 15:20:22 2013] [error] [client 138.195.48.28] [Mon Aug 19 15:20:22 2013] opac-user.pl: Use of uninitialized value $pki_field in string eq at /home/koha/kohaclone/C4/Auth.pm line 780, <DATA> line 581., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl [Mon Aug 19 15:20:22 2013] [error] [client 138.195.48.28] [Mon Aug 19 15:20:22 2013] opac-user.pl: Illegal Date ' ' does not match 'metric' format: dd/mm/yyyy at /home/koha/kohaclone/C4/SQLHelper.pm line 407., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl [Mon Aug 19 15:20:22 2013] [error] [client 138.195.48.28] [Mon Aug 19 15:20:22 2013] opac-user.pl: Illegal Date ' ' does not match 'metric' format: dd/mm/yyyy at /home/koha/kohaclone/C4/SQLHelper.pm line 407., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl [Mon Aug 19 15:20:22 2013] [error] [client 138.195.48.28] [Mon Aug 19 15:20:22 2013] opac-user.pl: DBD::mysql::st execute failed: Column 'categorycode' cannot be null at /home/koha/kohaclone/C4/SQLHelper.pm line 184, <DATA> line 581., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl [Mon Aug 19 15:20:22 2013] [error] [client 138.195.48.28] [Mon Aug 19 15:20:22 2013] opac-user.pl: AddMember failed at /home/koha/kohaclone/C4/Auth_with_ldap.pm line 156., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl [Mon Aug 19 16:43:57 2013] [error] [client 138.195.30.33] client denied by server configuration: /home/koha/kohaclone/koha-tmpl/opac-tmpl/prog/fr-FR/includes/favicon.ico [Mon Aug 19 16:43:57 2013] [error] [client 138.195.30.33] File does not exist: /home/koha/kohaclone/koha-tmpl/images, referer: http://tst-koha.ecp.fr/ [Mon Aug 19 16:43:58 2013] [error] [client 138.195.30.33] client denied by server configuration: /home/koha/kohaclone/koha-tmpl/opac-tmpl/prog/fr-FR/includes/favicon.ico [Mon Aug 19 16:44:13 2013] [error] [client 138.195.30.33] [Mon Aug 19 16:44:13 2013] opac-user.pl: Use of uninitialized value in string ne at /home/koha/kohaclone/C4/Auth.pm line 670, <DATA> line 581., referer: http://tst-koha.ecp.fr/ [Mon Aug 19 16:44:13 2013] [error] [client 138.195.30.33] [Mon Aug 19 16:44:13 2013] opac-user.pl: Use of uninitialized value $pki_field in string eq at /home/koha/kohaclone/C4/Auth.pm line 780, <DATA> line 581., referer: http://tst-koha.ecp.fr/ [Mon Aug 19 16:44:13 2013] [error] [client 138.195.30.33] [Mon Aug 19 16:44:13 2013] opac-user.pl: Use of uninitialized value $pki_field in string eq at /home/koha/kohaclone/C4/Auth.pm line 780, <DATA> line 581., referer: http://tst-koha.ecp.fr/ [Mon Aug 19 16:44:13 2013] [error] [client 138.195.30.33] [Mon Aug 19 16:44:13 2013] opac-user.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`bibecp`.`borrowers`, CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`)) at /home/koha/kohaclone/C4/Auth_with_ldap.pm line 296, <DATA> line 581., referer: http://tst-koha.ecp.fr/ [Mon Aug 19 16:44:15 2013] [error] [client 138.195.30.33] File does not exist: /home/koha/kohaclone/koha-tmpl/images, referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl [Mon Aug 19 16:44:52 2013] [error] [client 138.195.30.33] File does not exist: /home/koha/kohaclone/koha-tmpl/images, referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-main.pl?logout.x=1 [Mon Aug 19 16:44:54 2013] [error] [client 138.195.30.33] [Mon Aug 19 16:44:54 2013] 404.pl: Use of uninitialized value $lasttime in numeric lt (<) at /home/koha/kohaclone/C4/Auth.pm line 694, <DATA> line 581., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-main.pl?logout.x=1 [Mon Aug 19 16:45:05 2013] [error] [client 138.195.30.33] [Mon Aug 19 16:45:05 2013] opac-user.pl: Use of uninitialized value in string ne at /home/koha/kohaclone/C4/Auth.pm line 670, <DATA> line 581., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-main.pl?logout.x=1 [Mon Aug 19 16:45:05 2013] [error] [client 138.195.30.33] [Mon Aug 19 16:45:05 2013] opac-user.pl: Use of uninitialized value $pki_field in string eq at /home/koha/kohaclone/C4/Auth.pm line 780, <DATA> line 581., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-main.pl?logout.x=1 [Mon Aug 19 16:45:05 2013] [error] [client 138.195.30.33] [Mon Aug 19 16:45:05 2013] opac-user.pl: Use of uninitialized value $pki_field in string eq at /home/koha/kohaclone/C4/Auth.pm line 780, <DATA> line 581., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-main.pl?logout.x=1 [Mon Aug 19 16:45:05 2013] [error] [client 138.195.30.33] [Mon Aug 19 16:45:05 2013] opac-user.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`bibecp`.`borrowers`, CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`)) at /home/koha/kohaclone/C4/Auth_with_ldap.pm line 296, <DATA> line 581., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-main.pl?logout.x=1 An idea? Best regards samuel

1 0

errors ldap
by Samuel Desseaux 19 Aug '13

19 Aug '13

Hi, Our koha is connected to our ldap now. During tests, we have some problems. We have added 2 members the first time and it worked but we have this error opac-user.pl <http://opac-user.pl>: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`bibecp`.`borrowers`, CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`)) at /home/koha/kohaclone/C4/Auth_with_ldap.pm line 296, <DATA> line 581., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-main.pl?logout.x=1 Now, we can't add members any more These are the logs tail -f koha-opac-error_log [Mon Aug 19 15:20:06 2013] [error] [client 138.195.48.28] File does not exist: /home/koha/kohaclone/koha-tmpl/images, referer: http://tst-koha.ecp.fr/ [Mon Aug 19 15:20:08 2013] [error] [client 138.195.48.28] client denied by server configuration: /home/koha/kohaclone/koha-tmpl/opac-tmpl/prog/fr-FR/includes/favicon.ico [Mon Aug 19 15:20:10 2013] [error] [client 138.195.48.28] File does not exist: /home/koha/kohaclone/koha-tmpl/images, referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl [Mon Aug 19 15:20:22 2013] [error] [client 138.195.48.28] [Mon Aug 19 15:20:22 2013] opac-user.pl <http://opac-user.pl>: Use of uninitialized value in string ne at /home/koha/kohaclone/C4/Auth.pm line 670, <DATA> line 581., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl [Mon Aug 19 15:20:22 2013] [error] [client 138.195.48.28] [Mon Aug 19 15:20:22 2013] opac-user.pl <http://opac-user.pl>: Use of uninitialized value $pki_field in string eq at /home/koha/kohaclone/C4/Auth.pm line 780, <DATA> line 581., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl [Mon Aug 19 15:20:22 2013] [error] [client 138.195.48.28] [Mon Aug 19 15:20:22 2013] opac-user.pl <http://opac-user.pl>: Use of uninitialized value $pki_field in string eq at /home/koha/kohaclone/C4/Auth.pm line 780, <DATA> line 581., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl [Mon Aug 19 15:20:22 2013] [error] [client 138.195.48.28] [Mon Aug 19 15:20:22 2013] opac-user.pl <http://opac-user.pl>: Illegal Date ' ' does not match 'metric' format: dd/mm/yyyy at /home/koha/kohaclone/C4/SQLHelper.pm line 407., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl [Mon Aug 19 15:20:22 2013] [error] [client 138.195.48.28] [Mon Aug 19 15:20:22 2013] opac-user.pl <http://opac-user.pl>: Illegal Date ' ' does not match 'metric' format: dd/mm/yyyy at /home/koha/kohaclone/C4/SQLHelper.pm line 407., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl [Mon Aug 19 15:20:22 2013] [error] [client 138.195.48.28] [Mon Aug 19 15:20:22 2013] opac-user.pl <http://opac-user.pl>: DBD::mysql::st execute failed: Column 'categorycode' cannot be null at /home/koha/kohaclone/C4/SQLHelper.pm line 184, <DATA> line 581., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl [Mon Aug 19 15:20:22 2013] [error] [client 138.195.48.28] [Mon Aug 19 15:20:22 2013] opac-user.pl <http://opac-user.pl>: AddMember failed at /home/koha/kohaclone/C4/Auth_with_ldap.pm line 156., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl [Mon Aug 19 16:43:57 2013] [error] [client 138.195.30.33] client denied by server configuration: /home/koha/kohaclone/koha-tmpl/opac-tmpl/prog/fr-FR/includes/favicon.ico [Mon Aug 19 16:43:57 2013] [error] [client 138.195.30.33] File does not exist: /home/koha/kohaclone/koha-tmpl/images, referer: http://tst-koha.ecp.fr/ [Mon Aug 19 16:43:58 2013] [error] [client 138.195.30.33] client denied by server configuration: /home/koha/kohaclone/koha-tmpl/opac-tmpl/prog/fr-FR/includes/favicon.ico [Mon Aug 19 16:44:13 2013] [error] [client 138.195.30.33] [Mon Aug 19 16:44:13 2013] opac-user.pl <http://opac-user.pl>: Use of uninitialized value in string ne at /home/koha/kohaclone/C4/Auth.pm line 670, <DATA> line 581., referer: http://tst-koha.ecp.fr/ [Mon Aug 19 16:44:13 2013] [error] [client 138.195.30.33] [Mon Aug 19 16:44:13 2013] opac-user.pl <http://opac-user.pl>: Use of uninitialized value $pki_field in string eq at /home/koha/kohaclone/C4/Auth.pm line 780, <DATA> line 581., referer: http://tst-koha.ecp.fr/ [Mon Aug 19 16:44:13 2013] [error] [client 138.195.30.33] [Mon Aug 19 16:44:13 2013] opac-user.pl <http://opac-user.pl>: Use of uninitialized value $pki_field in string eq at /home/koha/kohaclone/C4/Auth.pm line 780, <DATA> line 581., referer: http://tst-koha.ecp.fr/ [Mon Aug 19 16:44:13 2013] [error] [client 138.195.30.33] [Mon Aug 19 16:44:13 2013] opac-user.pl <http://opac-user.pl>: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`bibecp`.`borrowers`, CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`)) at /home/koha/kohaclone/C4/Auth_with_ldap.pm line 296, <DATA> line 581., referer: http://tst-koha.ecp.fr/ [Mon Aug 19 16:44:15 2013] [error] [client 138.195.30.33] File does not exist: /home/koha/kohaclone/koha-tmpl/images, referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl [Mon Aug 19 16:44:52 2013] [error] [client 138.195.30.33] File does not exist: /home/koha/kohaclone/koha-tmpl/images, referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-main.pl?logout.x=1 [Mon Aug 19 16:44:54 2013] [error] [client 138.195.30.33] [Mon Aug 19 16:44:54 2013] 404.pl <http://404.pl>: Use of uninitialized value $lasttime in numeric lt (<) at /home/koha/kohaclone/C4/Auth.pm line 694, <DATA> line 581., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-main.pl?logout.x=1 [Mon Aug 19 16:45:05 2013] [error] [client 138.195.30.33] [Mon Aug 19 16:45:05 2013] opac-user.pl <http://opac-user.pl>: Use of uninitialized value in string ne at /home/koha/kohaclone/C4/Auth.pm line 670, <DATA> line 581., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-main.pl?logout.x=1 [Mon Aug 19 16:45:05 2013] [error] [client 138.195.30.33] [Mon Aug 19 16:45:05 2013] opac-user.pl <http://opac-user.pl>: Use of uninitialized value $pki_field in string eq at /home/koha/kohaclone/C4/Auth.pm line 780, <DATA> line 581., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-main.pl?logout.x=1 [Mon Aug 19 16:45:05 2013] [error] [client 138.195.30.33] [Mon Aug 19 16:45:05 2013] opac-user.pl <http://opac-user.pl>: Use of uninitialized value $pki_field in string eq at /home/koha/kohaclone/C4/Auth.pm line 780, <DATA> line 581., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-main.pl?logout.x=1 [Mon Aug 19 16:45:05 2013] [error] [client 138.195.30.33] [Mon Aug 19 16:45:05 2013] opac-user.pl <http://opac-user.pl>: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`bibecp`.`borrowers`, CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`)) at /home/koha/kohaclone/C4/Auth_with_ldap.pm line 296, <DATA> line 581., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-main.pl?logout.x=1 An idea? Best regards samuel

1 0

New Koha User
by Hilton Gibson 19 Aug '13

19 Aug '13

Hi All Just wanted to tell you we are evaluating Koha. And I have setup a wiki page recording my installation procedure. See: http://wiki.lib.sun.ac.za/index.php/KOHA The public website is: http://lib.sun.ac.za Regards -- *Hilton Gibson* Ubuntu Linux Systems Administrator JS Gericke Library Room 1025D Stellenbosch University Private Bag X5036 Stellenbosch 7599 South Africa Tel: +27 21 808 4100 | Cell: +27 84 646 4758 http://library.sun.ac.za http://za.linkedin.com/in/hiltongibson http://staff.lib.sun.ac.za/~hgibson/docs/cv/cv.html

2 1

(no subject)
by Richard Maileseni 19 Aug '13

19 Aug '13

hi guys! could anyone please give pointers into the basics I should know for implementing KOha! Im new to this, but my task is to do a migration of our old system into koha. Thanks

2 1

Single OPAC for multiple Koha instances
by Vimal Kumar V. 19 Aug '13

19 Aug '13

Dear Friends, We successfully created multiple instances of Koha by following the link, http://kohageek.blogspot.in/2013/08/installing-multiple-instances-of-koha.h… Is it possible to create a single OPAC for all mutiple instances? Our aim is to provide a single OPAC to users to retrieve resources from multiple Koha instances. Regards, -- Vimal Kumar V. Technical Assistant Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: http://www.vimalkumar.info Blog: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

2 1

Koha installation in windows 7
by tara singh danu 17 Aug '13

17 Aug '13

Dear sir, Can i installed koha in windows 7 OS. If yes please guide me. -- Thanks & Regards, Tara Singh Danu 9953056925 Badarpur, Delhi, India

3 2

CAS Authentication Explained
by Chandrashekar Singh 16 Aug '13

16 Aug '13

I have tried search the forums to find this info but it seems to be missing. I have installed koha through the koha on ubuntu - packages guide. The installed version is Koha 3.12.03.000 I setup the preferences for CAS authentication in koha administration pages. However two problems I encountered are: The service link that is sent the CAS server by the link on koha OPAC login page does not include the domain. https://{cas_server}:8443/cas/login?service=%2Fcgi-bin%2Fkoha%2Fopac-user.pl What do I have to setup in Patrons on koha for it to begin accepting logins from the CAS server? I added one patron to Koha then use the same person to login to cas and then have the CAS server redirect to koha. Koha then says "CAS login failed". Any help appreciated. -- View this message in context: http://koha.1045719.n5.nabble.com/CAS-Authentication-Explained-tp5764435.ht… Sent from the Koha-general mailing list archive at Nabble.com.

1 1

Date does not display in fine slip
by Vimal Kumar V. 16 Aug '13

16 Aug '13

Dear Friend, Date does not display in fine slip. Where we can edit the elements in fine slip? Regards, -- Vimal Kumar V. Technical Assistant Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: http://www.vimalkumar.info Blog: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

1 0