[Date Prev][Date Next]
- To: email@example.com
- Subject: back-sql/BDB question
- From: firstname.lastname@example.org
- Date: Tue, 02 Mar 2010 05:44:12 -0500
- Content-disposition: inline
- Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=default; d=relamp.tk; h=Message-ID:Date:From:To:Subject:MIME-Version:Content-Type:Content-Disposition:Content-Transfer-Encoding:User-Agent; b=pDlsq64Ez8WbPquCk9ruX0PRskiyqMxJqRj0Tjxi/ImWqGuQZcOnceY4eqi4DSAgP1em0z113bmAxVAU+dlpg6Ixq3LI0/4Oo9fEuOkrGJvedc8e9CvjZD/JroUxDrbL;
- User-agent: Internet Messaging Program (IMP) H3 (4.1.6)
I have an OpenLDAP server configured with back-sql. The reason for
this is that I need to export two simple tables as LDAP for contacts
(groups and users) and I don't want a cron job syncing the two every x
hours/minutes (ideally it should be instant). And also (ideally), if
the two programs access the same database there are no inconsistencies
between the two.
All is working perfectly fine, except that changes to existing rows in
the SQL database (MySQL) are not picked up until OpenLDAP is
restarted. Adding new rows works fine, however.
I guess that for each record in ldap_entries, OpenLDAP fetches the
values on startup, but does not check them again, unless there is a
new one which it has no data for. Am I correct here?
Now, I'm wondering if anyone has experienced the same problem, and if
there is a solution? Is this intentional? (could be)
I'm too considering dropping back_sql and just modify the web
application to also modify OpenLDAP directly via queries, however, I
fear that if one of them goes down, data inconsistency might occur.
(could be resolved with a cron script?)