Forums

Resolved
0 votes
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
Friday, September 20 2019, 05:54 AM
Share this post:
Responses (3)
  • Accepted Answer

    Wednesday, September 25 2019, 08:51 AM - #Permalink
    Resolved
    0 votes
    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
    The reply is currently minimized Show
  • Accepted Answer

    Monday, September 23 2019, 09:02 PM - #Permalink
    Resolved
    0 votes
    I got the idea of what you want but no clue on how to achieve it. :(
    The reply is currently minimized Show
  • Accepted Answer

    Monday, September 23 2019, 12:59 PM - #Permalink
    Resolved
    0 votes
    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
    The reply is currently minimized Show
Your Reply