On Friday 16 September 2011 12:20:16 you wrote: > For some reasons i didn`t received this mail via the mailinglist - got > it from the digest... *confused
Change your configuration options in the ML manager ? http://lists.lsc-project.org/listinfo/lsc-users > > >Date: Thu, 15 Sep 2011 16:43:39 +0200 > >From: Xavier Montagutelli <[email protected]> > >Subject: Re: [lsc-users] modify does not work / mysql > openldap > >To: [email protected] > >Message-ID: <[email protected]> > >Content-Type: Text/Plain; charset="iso-8859-1" > > > > I think it looks good so far - err=68 means "Already Exists" ... > > > > > same as in the the lsc logs. > > > What i don`t get: Why is there an ADD - it should be MODIFY ?! > > > How does lsc decide if it sends a add or a modify to openldap ? > > > For me it seems like lcp does not compare the entries mysql <> ldap. > > > What are necessary settings ? > > > >Do you have a "cn" returned in your sql-map-config.d/XXX.xml file ? > >(in the select with id="getInetOrgPersonList_stud_vbk") > > What do you mean with "cn" returned ? > > Here`s my config : > > <sqlMap namespace="InetOrgPerson_stud_vbk"> > > <select id="getInetOrgPerson_stud_vbk" > resultClass="java.util.HashMap" parameterClass="java.util.Map"> > Select uid as uid, > benutzername as cn, > nachname as sn, > email as mail, > stg as description, > passwort as userPassword > FROM tbl_stu > WHERE uid = #uid# > </select> > > <select id="getInetOrgPersonList_stud_vbk" > resultClass="java.util.HashMap"> > SELECT uid > FROM tbl_stu WHERE stg ='VBK' > </select> > > </sqlMap> getInetOrgPersonList_stud_vbk is used to retrieve the full list of students (lsc.tasks.studenten_vbk.srcService.requestNameForList = getInetOrgPersonList_stud_vbk) Your pivot attr is supposed to be "cn" : lsc.tasks.studenten_vbk.dstService.filterId = (cn={cn}) But your SELECT only returns the uid ! It will be available as {uid}. So, if the uid is unique among all the entries, try to use it as the pivot attribute : lsc.tasks.studenten_vbk.dstService.filterId = (uid={uid}) lsc.tasks.studenten_vbk.dstService.pivotAttrs = uid Or you also have the option to return the cn in the SELECT : <select id="getInetOrgPersonList_stud_vbk" resultClass="java.util.HashMap"> SELECT uid, benutzername as cn FROM tbl_stu WHERE stg ='VBK' </select> I am not completely sure of the solution, but I really think you should try something like that. Just by curiosity : I am surprised you use the CN as the RDN in LDAP, "benutzername" (I don't understand that word) is different for all your students ? > > There is the Rest of the Config and Logs : > http://pastebin.com/tvFuA8wQ > > > Best regards, > micha -- Xavier Montagutelli Tel : +33 (0)5 55 45 77 20 Service Commun Informatique Fax : +33 (0)5 55 45 75 95 Universite de Limoges 123, avenue Albert Thomas 87060 Limoges cedex _______________________________________________________________ Ldap Synchronization Connector (LSC) - http://lsc-project.org lsc-users mailing list [email protected] http://lists.lsc-project.org/listinfo/lsc-users
