ok thanks
I found that in the mailing list archive, dating back from 2007 (http://www.openldap.org/lists/openldap-software/200708/msg00015.html)
Indeed back-sql was intended to loosely support acting as a syncrepl provider (limited to refreshOnly), but it's currently broken, and it's never been fixed (mostly due to lack of interest). Patches (or sponsorships) are welcome. Ing. Pierangelo Masarati OpenLDAP Core Team
So I was wondering if it has been fix since...
your question is, can I use back-sql as syncperov. A sql backend is not a fully featered database to use with slapd.
-Dieter
--On Monday, January 28, 2013 7:20 PM +0100 Benin Technologies benintechnologies@yahoo.fr wrote:
ok thanks
back-sql is an experimental backend, it has no official support. Any development on it is purely based on the needs of people who use it and submit patches to enhance it in the ways they need. There are probably better ways to do what you want.
For example, when I was at a previous job, we had written a program that could convert our oracle DB to LDIF, and import then we would import that into LDAP. We used an event system as well, that when there were updates to the Oracle DB, would trigger ldap writes to the master of the changes as well (using the same program, it could run in a one-off LDIF mode or as an event driven program pushing updates to LDAP).
--Quanah
--
Quanah Gibson-Mount Sr. Member of Technical Staff Zimbra, Inc A Division of VMware, Inc. -------------------- Zimbra :: the leader in open source messaging and collaboration
On 01/28/2013 07:52 PM, Quanah Gibson-Mount wrote: [snip]
For example, when I was at a previous job, we had written a program that could convert our oracle DB to LDIF, and import then we would import that into LDAP. We used an event system as well, that when there were updates to the Oracle DB, would trigger ldap writes to the master of the changes as well (using the same program, it could run in a one-off LDIF mode or as an event driven program pushing updates to LDAP).
That sounds similar to http://lsc-project.org/wiki/about/start
Regards, Patrick
thank you for that pointer, yes that seems to be what I was looking for
Le 28/01/2013 22:01, Patrick Lists a écrit :
On 01/28/2013 07:52 PM, Quanah Gibson-Mount wrote: [snip]
For example, when I was at a previous job, we had written a program that could convert our oracle DB to LDIF, and import then we would import that into LDAP. We used an event system as well, that when there were updates to the Oracle DB, would trigger ldap writes to the master of the changes as well (using the same program, it could run in a one-off LDIF mode or as an event driven program pushing updates to LDAP).
That sounds similar to http://lsc-project.org/wiki/about/start
Regards, Patrick
thanks, yes there are probably many ways to replicate a SQL database to LDAP by writing the right code I just thought that since back-sql does already the job of mapping SQL databases to an LDAP tree, maybe there was a replication tool between that SQL backed LDAP tree and another LDAP tree with bdb/hdb backend
the LSC project someone pointed seems to be the right tool, I'll have a look into it
Le 28/01/2013 19:52, Quanah Gibson-Mount a écrit :
--On Monday, January 28, 2013 7:20 PM +0100 Benin Technologies benintechnologies@yahoo.fr wrote:
ok thanks
back-sql is an experimental backend, it has no official support. Any development on it is purely based on the needs of people who use it and submit patches to enhance it in the ways they need. There are probably better ways to do what you want.
For example, when I was at a previous job, we had written a program that could convert our oracle DB to LDIF, and import then we would import that into LDAP. We used an event system as well, that when there were updates to the Oracle DB, would trigger ldap writes to the master of the changes as well (using the same program, it could run in a one-off LDIF mode or as an event driven program pushing updates to LDAP).
--Quanah
--
Quanah Gibson-Mount Sr. Member of Technical Staff Zimbra, Inc A Division of VMware, Inc.
Zimbra :: the leader in open source messaging and collaboration
openldap-technical@openldap.org
-
Benin Technologies -
Patrick Lists -
Quanah Gibson-Mount