[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?