2014-12-02 15:40 GMT+01:00 Udhaya Kumar <[email protected]>: > Hi, > > I want synchronize group from LDAP to Mysql Database. > In LDAP I have following 2 group and 2 user. > *ou=Groups* > * ou=Group1* > * member = uid=User1* > * ou=Group2* > * member = uid=User2* > *ou=Users* > * uid=User1* > * uid=User2* > In Mysql Database ,I have three tables like below > *Users* > *id - Primary Key,Auto increment* > *username - Primary Key* > *password* > *firstname* > *lastname* > *Groups* > *id - Primary Key,Auto increment* > *groupName* > > *User_Group* > *user_id - id of User Table* > *group_id - id of Group Table* > > *Query:* > 1) How to synchronize groups from LDAP to "Groups" table in Database. > How to configure Ibatis xml file. *In LDAP I have un and member > attribute.but in table I have id and groupName(i.e cn in LDAP).* > *Whether I need create "member" column in table?* In pivot attribute in > lsc.xml which attribute I will use to create,update and delete? > 2) How to synchronize when user added group in LDAP to "User_Group" table. > How to write Ibatis xml for above scenario? *How to get user_id and > group_id when user added to group and how to insert user_id and group_id to > User_Group table?* > > *LSC - 2.1* > *MySQL- 5.5* > > Please can any one help me? > > >
I am not sure it is possible. You need to define at least 3 task : user, group and user_group. The two first are simple, because you associate one LDAP entry to one SQL row, but the last may be difficult to code. As I never created such connector, I can't send you any ready configuration. You need to try to implement it yourself. Clément.
_______________________________________________________________ Ldap Synchronization Connector (LSC) - http://lsc-project.org lsc-users mailing list [email protected] http://lists.lsc-project.org/listinfo/lsc-users
