Re: OpenLDAP with MySQL backend not working

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.