- Koha - lists.katipo.co.nz

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

Web Installer: authorities_normal_marc21 incorrect integer value & mysql 5.6 warning message on password
by Victor Pang 15 Aug '13

15 Aug '13

I just ran through Step 3 of Web Installer and I encountered this error in authorities_normal_marc21.sql: ERROR 1366 (HY000) at line 272: Incorrect integer value: '' for column 'linkid' at row 1 and peeking into that file is this error SQL statement line: INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES How do I correct this error? I am using MySQL 5.6.13 on Mac OS X 10.8.3. Also, MySQL 5.6.x now warns users when you enter your password on the command line via "-p<password>" or "-p" and prompted: Warning: Using a password on the command line interface can be insecure. So I got all these warnings for every SQL files imported. In fact, when the Web Installer imports the database structure, it ended with the warning message and I couldn't continue without starting from Step 1 again. Luckily, the Web Installer knows when it stops and let me continue to set the basic default settings. -- View this message in context: http://koha.1045719.n5.nabble.com/Web-Installer-authorities-normal-marc21-i… Sent from the Koha-general mailing list archive at Nabble.com.

2 2

(no subject)
by Richard Maileseni 14 Aug '13

14 Aug '13

Hi My name is Richard. Im an IT student from the island of Tonga currently studying in NZ, Im working on a project which is generally to do a migration of our current library system from spidus to Koha. Just wondering if any of yous have done something along that line and if you could give me pointers into how i could do this,. Thanks!! -- Richard W. Maileseni Mob: 027-934-2039 PH: 042367222 Email: lisiate.maileseni(a)tti.to facebook: www.facebook.com/rmaileseni scype: ma_richie ~\\~

1 0