Good Morning all,
I work in a school where we have more than 2'000 people. We belong to a larger entity that includes all the schools in our state and they are using a Microsoft Active Directory.Everynight, they send us a scv file with all users of our school.
We have in our school some computers we want to manage (MAC and Windows) but we need the users to be authenticated. In this way, i'd like now to install 2 ClearOS (for replication) systems with OpenLDAp and create a script to synchronize it with the csv file.
My main idea was to create a ldif file including the new entries to add to clearos (the ones that are in my csv file and not in my ldap server), the ones I've to remove (entries that are in Openldap and not in my csv file). I first wanted to make that with a bash script but I wonder if there's a better way to achieve this. I've read a post where and Openldap server is syncronized with sql database ... (it seems that everynight, the database is cleaned and filled with the new file).
So, can you give me your advices and the best way to achieve this ?
Per advance, I thank you very much for your help
Kind regards
Arnaud
I work in a school where we have more than 2'000 people. We belong to a larger entity that includes all the schools in our state and they are using a Microsoft Active Directory.Everynight, they send us a scv file with all users of our school.
We have in our school some computers we want to manage (MAC and Windows) but we need the users to be authenticated. In this way, i'd like now to install 2 ClearOS (for replication) systems with OpenLDAp and create a script to synchronize it with the csv file.
My main idea was to create a ldif file including the new entries to add to clearos (the ones that are in my csv file and not in my ldap server), the ones I've to remove (entries that are in Openldap and not in my csv file). I first wanted to make that with a bash script but I wonder if there's a better way to achieve this. I've read a post where and Openldap server is syncronized with sql database ... (it seems that everynight, the database is cleaned and filled with the new file).
So, can you give me your advices and the best way to achieve this ?
Per advance, I thank you very much for your help
Kind regards
Arnaud
Share this post:
Responses (3)
-
Accepted Answer
Hello Nick,
Thanks for your answer but no worry ; at least it seems my problem is "understandable"
Finally, I probably found the solution to my problem : https://lsc-project.org
I need to go deeper and see if this can be used with my ClearOS system because it seems I'll have to install many things, first....
thanks again for your time
Best Regards
Arnaud -
Accepted Answer
-
Accepted Answer
Hello all,
finally was my Explanation not clear ; sorry for my poor english …
Everynight, I should receive (I hope) a csv file from a Microsoft Active Directory system. This file should contain the full names, login and email addresses of users.
The mai idea is to syncrhonize my OpenLDAP from ClearOS with that file … but what is the easisest way ?
My idea was to create a bash script that would be executed every night. I would then create a new ldif file. Inside, I would first add every new entries that are in my csv file and not in my clearos (for every entry, I should make a ldapsearch into my clearos I think). Than, I will have to add the ones to remove (entries that are in my Clearos and not in my csv file.
Finally, change the ones that are in both system but have not the same informations (Name, surname, etc...)
When this is over, I will have to Play that file and I hope my ldap will be synchronized
I first wanted to make that with a bash script but I wonder if there's a better way to achieve this….
I tank your for your help
Best Regards
Arnaud
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »