[Koha] koha ldap AddMember fails

[mourik jan c heupink]

no reactions at all... :-(

Nobody has an idea? Do I need to provide more info?

Any pointers would be very much appreciated..!

Kind regards,
Mourik Jan

mourik jan c heupink wrote:
> 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
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha