Re: replication between a back-sql master and back-hdb slave

2013-01-28 Thread Benin Technologies
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

Re: replication between a back-sql master and back-hdb slave

2013-01-28 Thread Benin Technologies
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

Re: replication between a back-sql master and back-hdb slave

2013-01-28 Thread Patrick Lists
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,

Re: replication between a back-sql master and back-hdb slave

2013-01-28 Thread Quanah Gibson-Mount
--On Monday, January 28, 2013 7:20 PM +0100 Benin Technologies 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 proba

Re: replication between a back-sql master and back-hdb slave

2013-01-28 Thread Benin Technologies
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 b

Re: replication between a back-sql master and back-hdb slave

2013-01-28 Thread Benin Technologies
Thanks I just didn't understand why I would need suffixmassaging and a relay database... All my data are stored in PostgreSQL, used as a backend for my OpenLDAP/back-sql server (which will become the master OpenLDAP server) After setting up a second OpenLDAP server with hdb/bdb backend, actin

Re: replication between a back-sql master and back-hdb slave

2013-01-28 Thread Dieter Klünter
Am Mon, 28 Jan 2013 14:19:44 +0100 schrieb Benin Technologies : > Hi, > > I set up a back-sql server to access some existing data in a > postgresql database. I was wondering if it's possible to replicate > that server to some (read-only) back-hdb servers. > Thanks This is possible, in principle

replication between a back-sql master and back-hdb slave

2013-01-28 Thread Benin Technologies
Hi, I set up a back-sql server to access some existing data in a postgresql database. I was wondering if it's possible to replicate that server to some (read-only) back-hdb servers. Thanks BT