[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