Hi Clement,
I have found the query which is as below but while syncing it is giving error
as below:
<sqlMap namespace="InetOrgPerson">
<select id="getInetOrgPerson" resultClass="java.util.HashMap"
parameterClass="java.util.Map">
Select
groupname,member
FROM user_grp_info where groupname like #(select groupname from
group_info)#
</select>
<select id="getInetOrgPersonList" resultClass="java.util.HashMap">
Select distinct groupname FROM user_grp_info
</select>
</sqlMap>
<string>
<![CDATA[js:
var membersSrcDn =
srcBean.getDatasetValuesById("uniqueMember");
var membersDstDn = [];
for (var i=0; i<membersSrcDn.size(); i++) {
var uid = membersSrcDn.get(i);;
var destDn = ldap.search("ou=Users,dc=testrjil,dc=net",
"(sAMAccountName=" + uid + ")");
if (destDn.size() == 0 || destDn.size() > 1) {
continue;
}
var destMemberDn = destDn.get(0) + "," +
ldap.getContextDn();
membersDstDn.push(destMemberDn);
}
membersDstDn
]]>
</string>
Jan 23 14:35:42 - INFO - Starting sync for adGroup
Jan 23 14:35:42 - ERROR - Synchronization aborted because no source object has
been found !
Jan 23 14:35:42 - ERROR - Synchronization aborted because no source object has
been found !
Jan 23 14:35:42 - ERROR - All entries: 2, to modify entries: 0, successfully
modified entries: 0, errors: 2
Jan 23 14:35:42 - INFO - Starting clean for adGroup
Jan 23 14:35:42 - ERROR - com.ibatis.sqlmap.client.SqlMapException: There is no
statement named null in this SqlMap.
-----Original Message-----
From: Clément OUDOT [mailto:[email protected]]
Sent: 21 January 2015 18:38
To: Hardik V Shah
Cc: lsc-userslsc-users
Subject: Re: [lsc-users] user add/remove to group in AD
2015-01-21 13:41 GMT+01:00 <[email protected]>:
> Sure Clement.
>
> But I don’t want to remove/add user or group using this connector to AD. And
> I will have separate records in mysql for each user to be added to multiple
> group or many users to be added to single group.
>
> So still it can be possible right using the link which you sent?
You need to find a SQL query that returns all members of a group, and use this
array of values in the member dataset of lsc.xml.
Clément.
"Confidentiality Warning: This message and any attachments are intended only
for the use of the intended recipient(s).
are confidential and may be privileged. If you are not the intended recipient.
you are hereby notified that any
review. re-transmission. conversion to hard copy. copying. circulation or other
use of this message and any attachments is
strictly prohibited. If you are not the intended recipient. please notify the
sender immediately by return email.
and delete this message and any attachments from your system.
Virus Warning: Although the company has taken reasonable precautions to ensure
no viruses are present in this email.
The company cannot accept responsibility for any loss or damage arising from
the use of this email or attachment."
_______________________________________________________________
Ldap Synchronization Connector (LSC) - http://lsc-project.org
lsc-users mailing list
[email protected]
http://lists.lsc-project.org/listinfo/lsc-users
