[Koha] Import in koha 21.05 all users from LDAP

Javi Legido javi at legido.com
Fri Sep 10 20:52:40 NZST 2021

Hi there.

I'm not an expert on the subject, maybe others can reply, but this is the
classical behaviour of applications integrating with LDAP for
authentication (and sometimes also authorization): after first login the
application creates data in its database, in this example as "Patron".

No idea if there's anything out there, but a high level approach would be:

1. Create a test account in LDAP (Active Directory in your case)
2. Dump Koha database (one insert per line is useful)

mysqldump --extended-insert=FALSE my_koha_database -u root -psecret >

3. Perform first login with user created at step 1.
4. Repeat step 2:

mysqldump --extended-insert=FALSE my_koha_database -u root -psecret >

5. See differences

diff koha.sql koha_after.sql

Now you are very close to build the SQL statements to add a new Patron once



On Fri, 10 Sept 2021 at 10:46, Tadas G <tadas.kaupa at gmail.com> wrote:

> Hello,
> We have Koha 21.05 installed and configured to work with AD. Everything is
> fine, users can login to Koha using AD credentials, but in Patron list they
> appear only after successful authorisation. It is quite annoying, because
> if you want to assign book to the reader, he/she has to be in patron list.
> Is it possible to create Cron job to import users to patron list
> automatically from AD (it is enough to import only a few fields, all other
> fields can be updated after user login)?
> Thanks for the answers
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

More information about the Koha mailing list