back-sql/BDB question

[beniwtv@relamp.tk]

Hello,

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?)

Any ideas?

Thanks,
Benedikt