Re: OpenLDAP with MySQL backend not working

[masarati@aero.polimi.it]

> Hi all,
>
> I am using OpenLDAP with MySQL backend for testing purpose, a future
> project
> of linux authentication via LDAP but with MySQL backend.

Did you check slapd-sql(5) and the example slapd.conf(5) for mysql that is
distributed with the package in
servers/slapd/back-sql/rdbms_depend/mysql/slapd.conf ?   The logs

>    backsql_dn2id("dc=example,dc=com"): id_query "SELECT
> id,keyval,oc_map_id,dn FROM `ldap_test`.`ldap_entries` WHERE dn=?"
>
>    backsql_dn2id("dc=example,dc=com"): upperdn="MOC=CD,ELPMAXE=CD"
>
> <==backsql_dn2id("dc=example,dc=com"): err=32

clearly show the DN is being reversed while uppercased for normalization. 
You need to set

has_ldapinfo_dn_ru	no

to prevent this, as in the example configuration.  I don't see it set in
your slapd.conf.

p.