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?
--
regards,
Udhaya Kumar
_______________________________________________________________
Ldap Synchronization Connector (LSC) - http://lsc-project.org
lsc-users mailing list
[email protected]
http://lists.lsc-project.org/listinfo/lsc-users
