Hi,
I need a pointer please. I need to configure an LDAP server that presents (only read!) data from a mysql database. I have found some nice article for ndb configuration but I think that's not what I need, because this scenario is bi-directional, i.e. It assumes a clean mysql database and r/w access via LDAP that uses mysql as backend per say. What I want to do is to treat LDAP just as an "interface" to mysql database (or even one table). Can anybody point me to a good direction of reading?
Thanks.
Radosław Antoniuk radek.antoniuk@gmail.com writes:
Hi,
I need a pointer please. I need to configure an LDAP server that presents (only read!) data from a mysql database. I have found some nice article for ndb configuration but I think that's not what I need, because this scenario is bi-directional, i.e. It assumes a clean mysql database and r/w access via LDAP that uses mysql as backend per say. What I want to do is to treat LDAP just as an "interface" to mysql database (or even one table). Can anybody point me to a good direction of reading?
The source code provides some information servers/slapd/back-sql/rdbms_depend/mysql servers/slapd/back-sql/docs/
-Dieter
Em 9/2/2010 07:59, Radosław Antoniuk escreveu:
Hi,
I need a pointer please. I need to configure an LDAP server that presents (only read!) data from a mysql database. I have found some nice article for ndb configuration but I think that's not what I need, because this scenario is bi-directional, i.e. It assumes a clean mysql database and r/w access via LDAP that uses mysql as backend per say.
I don´t know about the article you read, but what if you follow that article and just create a mysql user with only select privileges to use from OpenLDAP? Even if openldap server tries to update something, would end in error, but read only would still work.
Never tried something similar.
On Tuesday, 9 February 2010 10:59:04 Radosław Antoniuk wrote:
Hi,
I need a pointer please. I need to configure an LDAP server that presents (only read!) data from a mysql database.
Assuming you are otherwise familiar with OpenLDAP, I would start with: -man slapd-sql -see the contents of servers/slapd/back-sql/rdbms_depend/mysql in the source tarball -see tests/scripts/sql-* in the source tarball
If not, you should probably read through at lest the quick start part of the admin guide before you get on to the back-sql bits.
I have found some nice article for ndb configuration but I think that's not what I need, because this scenario is bi-directional, i.e. It assumes a clean mysql database and r/w access via LDAP that uses mysql as backend per say.
ro or rw is purely up to access controls (on the database user as which OpenLDAP access the mysql db).
What I want to do is to treat LDAP just as an "interface" to mysql database (or even one table). Can anybody point me to a good direction of reading?
Regards, Buchan
openldap-technical@openldap.org