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
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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Hi mourik jan c heupink! I had complete config LDAP, but it give an error when i login: AddMember failed at /usr/share/koha/lib/C4/Auth_with_ldap.pm line 160. I try my best, :-( Help me pls! Thank so much! mourik jan c heupink-2 wrote:
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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- View this message in context: http://old.nabble.com/koha-ldap-AddMember-fails-tp26501712p29356409.html Sent from the Koha - Discuss mailing list archive at Nabble.com.
Bonjour, it seems that I encounter this error only if the user has a password with special characters like * or @. I will check the coding of Auth_with_ldap.pm to be sure. -- View this message in context: http://koha.1045719.n5.nabble.com/koha-ldap-AddMember-fails-tp3061535p337405... Sent from the Koha - Discuss mailing list archive at Nabble.com.
participants (3)
-
Gilles Carpentier -
HnauT -
mourik jan c heupink