Issue #641 has been updated by Martin H.
It works. Thank you. I misunderstood the documentation. Small detail : in sample example, queries are not in the same order than in http://lsc-project.org/wiki/documentation/2.0/configuration/database/persistence also in http://lsc-project.org/wiki/documentation/2.1/configuration/service/sourceldap it was not completely clear for me that the attribute name (ie : {attr}) was to be the one that correspond to the SQL getInetOrgPersonList query. But now I know ;) ---------------------------------------- Bug #641: getOneFilter / {var} is not replaced in the search string http://tools.lsc-project.org/issues/641 Author: Martin H Status: Assigned Priority: Normal Assigned to: Clément OUDOT Category: Target version: Problem in version: 2.0.3 I am using LSC 2.0.3 / OpenJDK 1.7.0 and the following configuration : <pre> (...) <task> (...) <ldapDestinationService> (...) <pivotAttributes> <string>uid</string> </pivotAttributes> <fetchedAttributes> <string>description</string> <string>cn</string> <string>sn</string> <string>userPassword</string> <string>objectClass</string> <string>mail</string> <string>uid</string> </fetchedAttributes> <getAllFilter>(objectClass=inetOrgPerson)</getAllFilter> <getOneFilter>(&(objectClass=inetOrgPerson)(uid={uid}))</getOneFilter> (...) </ldapDestinationService> (...) </pre> When I run lsc with "-s all" I can see the following on my LDAP server logs : Jan 14 12:20:32 xxx slapd[19246]: conn=1248 op=5 SRCH base="ou=people,dc=my,dc=compagny,dc=org" scope=2 deref=0 filter="(&(objectClass=inetOrgPerson)(uid={uid}))" Notice the {uid} which is not replaced by any value. Here is my sqlmap file (that I've reviewed with Raphaël on IRC). <pre> <?xml version="1.0" encoding="UTF-8" standalone="no"?> <!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd";> <sqlMap namespace="InetOrgPerson"> <select id="getInetOrgPersonList" resultClass="java.util.HashMap"> SELECT user_name FROM user </select> <select id="getInetOrgPerson" resultClass="java.util.HashMap" parameterClass="java.util.Map"> SELECT user_name as uid, realname as cn, realname as sn, email as mail FROM user WHERE user_name = #user_name# </select> <select id="getInetOrgPersonClean" resultClass="java.util.HashMap" parameterClass="java.util.Map"> SELECT user_name as uid FROM user WHERE user_name = #uid# </select> </sqlMap> </pre> -- You have received this notification because you have either subscribed to it, or are involved in it. To change your notification preferences, please click here: http://tools.lsc-project.org/my/account
_______________________________________________________________ Ldap Synchronization Connector (LSC) - http://lsc-project.org lsc-dev mailing list [email protected] http://lists.lsc-project.org/listinfo/lsc-dev
