Hi
I configured OpenLDAP with Oracle and I created the necessary metadata information. When I load the DN entries for my DN suffix (dc=tcs,dc=com,dc=ve) everything works fine and the institution and ldap_entries tables are filled. When I try to add a user I get
ldap_add: No such object (32)
So I check the log file and I see the following info:
==>backsql_dn2id(): dn="cn=manager,dc=tcs,dc=com,dc=ve" (no ID) id_query "SELECT id,keyval,oc_map_id FROM ldap_entries WHERE dn_ru=?" ==>backsql_dn2id(): upperdn="EV=CD,MOC=CD,SCT=CD,REGANAM=NC" <==backsql_dn2id(): no match ==>backsql_dn2id(): dn="dc=tcs,dc=com,dc=ve" id_query "SELECT id,keyval,oc_map_id FROM ldap_entries WHERE dn_ru=?" ==>backsql_dn2id(): upperdn="EV=CD,MOC=CD,SCT=CD" <==backsql_dn2id(): no match backsql_add("cn=manager,dc=tcs,dc=com,dc=ve"): could not lookup parent entry for new record "dc=tcs,dc=com,dc=ve" backsql_add: entry at root denied ==>backsql_dn2id(): dn="dc=com,dc=ve" (no ID) id_query "SELECT id,keyval,oc_map_id FROM ldap_entries WHERE dn_ru=?" ==>backsql_dn2id(): upperdn="EV=CD,MOC=CD" <==backsql_dn2id(): no match ==>backsql_dn2id(): dn="dc=ve" (no ID) id_query "SELECT id,keyval,oc_map_id FROM ldap_entries WHERE dn_ru=?" ==>backsql_dn2id(): upperdn="EV=CD" <==backsql_dn2id(): no match ==>backsql_dn2id(): dn="" (no ID) id_query "SELECT id,keyval,oc_map_id FROM ldap_entries WHERE dn_ru=?" ==>backsql_dn2id(): upperdn="" <==backsql_dn2id(): no match
The query is trying to look the DN in the dn_ru column, but my insert query is
insentry_query "INSERT INTO ldap_entries (id,dn,oc_map_id,parent,keyval) VALUES (ldap_entry_ids.nextval,UPPER(?),?,?,?)"
So it's never filled. I check other slapd.conf configurations and they add the following lines:
id_query "SELECT id,keyval,oc_map_id FROM ldap_entries WHERE dn=UPPER(?)"
But my OpenLDAP windows version 2.2.29 doesn't understand de id_query setting.
Any ideas?