thank you very much Clément,

Unfortunately, I didn't find any log on my server for OpenLDAP.

But it's nice to know my file seems to be fine .. so maybe I should investigate some time in my posixaccount.xml file ...  ;)

Have a very nice week-end :)


Le 02.04.2020 à 19:15, Clément OUDOT a écrit :
Le 02/04/2020 à 12:29, Arnaud Gymnase a écrit :
This is very kind to you....


I see nothing obvious. Could you check your OpenLDAP server logs when
your are doing the sync? You should see a search with (uidnumber=14200)
filter, and this search should return 1 entry.


<?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="getInetOrgPerson" resultClass="java.util.HashMap" parameterClass="java.util.Map">
		Select 
         'InetOrgPerson' objectClass,
         'PosixAccount' objectClass,
         pers.EventoID as uidnumber,
         pers.Login as uid,
         pers.Vorname as givenName,
         pers.Nachname as sn,
         pers.Mailadresse as mail,
<!--         pers.Mailadresse as uid,   
         pers.Username as uid,-->
         CONCAT(pers.VorName , ' ',pers.Nachname) as cn,
 <!--         CONCAT(pers.Nachname,pers.Vorname) as HomeDirectory, -->
         pers.Login as HomeDirectory,
         pers.Veranstalter as businessCategory,
         pers.Typ as employeeType,
         pers.Sprache as preferredLanguage
<!-->         var date = new(Date();
         var timestamp = Math.floor(date/1000);
         -->
<!--         unix_timestamp(pers.date) as TimeStamp                 -->
  FROM Evento pers WHERE pers.EventoID = #uidnumber#
	</select>

	<select id="checkPersonForClean" resultClass="java.util.HashMap" parameterClass="java.util.Map">
		Select pers.EventoID as uidnumber
            FROM Evento pers WHERE pers.EventoID = #uidnumber#
	</select>

	<select id="getInetOrgPersonList" resultClass="java.util.HashMap">
		SELECT pers.EventoID as uidnumber
		FROM Evento pers
	</select>
</sqlMap>
_______________________________________________________________
Ldap Synchronization Connector (LSC) - http://lsc-project.org

lsc-users mailing list
lsc-users@lists.lsc-project.org
https://lists.lsc-project.org/cgi-bin/mailman/listinfo/lsc-users

Reply via email to