[Koha] koha ldap AddMember fails
mourik jan c heupink
heupink at merit.unu.edu
Wed Nov 25 08:10:18 NZDT 2009
Hi all,
I have installed koha-3.00.04_fixed on debian 5 x64, with an ldap
backend, and I'm running into problems. Creating users in koha and then
logging in works. However, logging in with an LDAP user account gives
this error:
AddMember failed at /usr/share/koha/lib/C4/Auth_with_ldap.pm line 146.
When checking the logs, I see:
[Tue Nov 24 16:40:53 2009] [error] [client 82.169.x.x] [Tue Nov 24
16:40:53 2009] mainpage.pl: DBD::mysql::st execute failed: Cannot add or
update a child row: a foreign key constraint fails (`koha3/borrowers`,
CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES
`categories` (`categorycode`)) at /usr/share/koha/lib/C4/Members.pm line
730, <DATA> line 253., referer:
http://192.87.y.y:8080/cgi-bin/koha/mainpage.pl?logout.x=1
[Tue Nov 24 16:40:53 2009] [error] [client 82.169.x.x] [Tue Nov 24
16:40:53 2009] mainpage.pl: AddMember failed at
/usr/share/koha/lib/C4/Auth_with_ldap.pm line 146., referer:
http://192.87.y.y:8080/cgi-bin/koha/mainpage.pl?logout.x=1
I searched the archives, and it seems that my problem is that ldap
contains a borrower category that doesn't exist in koha.
However: In koha I have two borrower categories: code PT (Patron) and
code A (Adult), verified through phpMyAdmin, both category_type A. My
ldap user (verified in an ldif dump) has "employeeType" A.
In /etc/koha/koha-conf.xml I have defined:
<categorycode is="employeeType" >A</categorycode>
As far as I understand things, everything is correct, and yet it doesn't
seem work. :-(
Can anyone help me?
Regards,
Mourik Jan
More information about the Koha
mailing list