Hi,
I am just setting up LSC for the first time. I’ve done lots of searching,
reading the samples and documentation, and reading the mailing list. But I’m
still confused in places.
I have a MySQL source and OpenLDAP destination. When I’m reading the
documentation for the XML Persistence Map, in the section for getInetOrgPerson
the Select statements are:
SELECT id as uid,
lastname as sn,
name as cn,
etc….
FROM users
WHEREid = #uid#
but in the InetOrgPerson.xml file that is installed, the statements shown are:
Select
‘inetOrgPerson’ objectClass,
pers.“ID”,
pers.“UID”,
pers.“SN”,
pers.”MAIL”,
etc….
FROM csvdata pers
WHERE per.”MAIL” LIKE #mail#
Can someone explain the differences to me? The example in the documentation
seems to make sense to me and seems like a clear mapping of values: Select
“id" (from the table: users) to be the value “uid”. But I don’t understand the
purpose of:
‘inetOrgPerson’ objectClass and: pers.”ID”,
I don’t see a mapping of values. I also don’t understand the FROM statement.
I assume that the table name is csvdata, but I don’t know why pers follows the
table name.
Is there any reason to NOT go with the format used in the documentation? Just
in case it matters, I am using a custom objectClass in my LDAP schema:
gnPerson. So I’m modifying the name and values in the XML file to reflect
this: GNPerson.xml and <select id=“getGNPerson”…. I’m not sure that
this makes any difference, but thought I’d mention it.
I appreciate any help you can provide. I may have other questions in the
future, but I’m trying to work through this, and make sense of all the
configuration one step at a time.
Thanks!
_______________________________________________________________
Ldap Synchronization Connector (LSC) - http://lsc-project.org
lsc-users mailing list
[email protected]
http://lists.lsc-project.org/listinfo/lsc-users
