Le 16/05/2011 14:25, schwitzd a écrit :

I configured koha-conf.xml but there is something wrong...

the error log say this:

[Mon May 16 14:23:08 2011] [error] [client X.X.X.X] [Mon May 16 14:23:08 2011] opac-user.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha`.`borrowers`, CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`)) at /usr/share/koha/lib/C4/SQLHelper.pm line 147, <DATA> line 522., referer: http://hbcdsl10/cgi-bin/koha/opac-user.pl [Mon May 16 14:23:08 2011] [error] [client X.X.X.X]] [Mon May 16 14:23:08 2011] opac-user.pl: AddMember failed at /usr/share/koha/lib/C4/Auth_with_ldap.pm line 152., referer: http://hbcdsl10/cgi-bin/koha/opac-user.pl

Thanks Daniel

You have a configuration problem : Your borrowers categories are not correctly set. -- Henri-Damien LAURENT

Le 16/05/2011 14:56, schwitzd a écrit :

Hi laurent

Sorry but how I can check my borrowers category? you mean the Patron Category?

Thanks a lot Daniel

Yes. Patron Category is a mandatory field. And it has to be described when adding a new borrower. If the patron category is not set, then it will fail adding the patron. you can set that with describing it in the koha-conf.xml If you have more than one library to set, then it may be more complex to have that correctly set, and would require adjustments in C4::Auth_with_ldap. -- Henri-Damien LAURENT

Le 16/05/2011 16:25, schwitzd a écrit :

This is my koha-conf.xml and the printscreen is my Patron Category http://imageshack.us/photo/my-images/718/patrona.png

at the moment we have just one library.

-- View this message in context: http://koha.1045719.n5.nabble.com/koha-Active-Directory-tp4399726p4400560.ht... Sent from the Koha - Discuss mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

In the koha-conf.xml, add a <categorycode is="employeetype">YOURHARDCODEDCATEGORYCODE</categorycode>

Le 16/05/2011 16:54, schwitzd a écrit :

Hi

Sorry but in the koha-conf there is already a categorycode <categorycode is="category">Default Catefory Code</categorycode>

I have to delete this and add yours?

Well it is quite the same. But you may.

What I have to insert isteadof YOURHARDCODEDCATEGORYCODE? S could be a first good guess. hope that helps.

Thanks a lot Daniel

-- View this message in context: http://koha.1045719.n5.nabble.com/koha-Active-Directory-tp4399726p4400656.ht... Sent from the Koha - Discuss mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

Le 16/05/2011 17:08, schwitzd a écrit :

I tried but in the log file there is the same error message... one question the attribute employeetype in active directory must be one of the patron category code?

It would be better if it could be, yes. But you could take a custom ldap field. Hope that helps. -- Henri-Damien LAURENT

any ideas? -- View this message in context: http://koha.1045719.n5.nabble.com/koha-Active-Directory-tp4399726p4406006.ht... Sent from the Koha - Discuss mailing list archive at Nabble.com.

Thanks a lot for your support. I will waiting this new feature :D -- View this message in context: http://koha.1045719.n5.nabble.com/koha-Active-Directory-tp4399726p4406157.ht... Sent from the Koha - Discuss mailing list archive at Nabble.com.