[Date Prev][Date Next] [Chronological] [Thread] [Top]

Problem configuring OpenLDAP with Oracle



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?