[Koha] koha ldap AddMember fails

[mourik jan c heupink]

For the archive:

Turned out that access restrictions on my ldap server were a bit too 
tight... (found out by using an ldap browser to connect anonymously, and 
as my koha-testuser)

Hope this helps someone else.

mj

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