FYI... I did some research into the sql commands that were being sent to my RDBMS when starting slapd and I found out the issue was with the column DN_RU not being populated. Anyhow, I configured slapd to not use this column from the entries table by adding the 'has_ldapinfo_dn_ru no' to my slapd.conf file. Hope this helps others who have issues configuring slapd with an oracle database.
# $OpenLDAP: /servers/slapd/back-sql/rdbms_depend/oracle/slapd.conf,v 1.5 2005/0
1/05 15:23:00 ando Exp $
#
# See slapd.conf(5) for details on configuration options.
# This file should NOT be world readable.
#
include /usr/local/etc/openldap/schema/core.schema
include /usr/local/etc/openldap/schema/cosine.schema
include /usr/local/etc/openldap/schema/inetorgperson.schema
# Define global ACLs to disable default read access.
#include /usr/local/etc/openldap/slapd.access.conf
# Do not enable referrals until AFTER you have a working directory
# service AND an understanding of referrals.
#referral ldap://root.openldap.org
pidfile /usr/local/var/slapd.pid
argsfile /usr/local/var/slapd.args
#defaultsearchbase dc=example,dc=com
#make sure you have (or the apropriate monitor module)
#moduleload back_sql
#access to * by * read
#######################################################################
# sql database definitions
#######################################################################
database sql
suffix "dc=example,dc=com"
rootdn "cn=Manager,dc=example,dc=com"
rootpw XXXX
dbname XXXX
dbuser XXXX
dbpasswd XXXX
subtree_cond "UPPER(ldap_entries.dn) LIKE CONCAT('%',UPPER(?))"
insentry_stmt "INSERT INTO ldap_entries (id,dn,oc_map_id,parent,keyval) VALUES
(ldap_entry_ids.nextval,?,?,?,?)"
upper_func UPPER
has_ldapinfo_dn_ru no
Leon King
________________________________
From: King, Leon C Sent: Wednesday, February 18, 2009 1:13 PM To: 'openldap-software@openldap.org' Subject: RE: Verify Connection to LDAP with Oracle backend.
Here is my LDAP_ENTRIES table.
"ID"
"DN"
"DN_RU"
"OC_MAP_ID"
"PARENT"
"KEYVAL"
1
dc=example,dc=com
1
3
0
1
2
cn=Mitya Kovalev,dc=example,dc=com
2
1
1
1
3
cn=Torvlobnor Puzdoy,dc=example,dc=com
3
1
1
2
4
cn=Akakiy Zinberstein,dc=example,dc=com
4
1
1
3
5
documentTitle=book1,dc=example,dc=com
5
2
1
1
6
documentTitle=book2,dc=example,dc=com
6
2
1
2
Thanks,
Leon King
-----Original Message----- From: King, Leon C Sent: Wednesday, February 18, 2009 1:10 PM To: 'Dieter Kluenter'; openldap-software@openldap.org Subject: RE: Verify Connection to LDAP with Oracle backend.
Thanks for the reply. I'm getting a 'No such object' response from the server.
ldapsearch -x -b 'dc=example,dc=com' -s one "*" (running locally on the ldap server)
# extended LDIF
#
# LDAPv3
# base <dc=example,dc=com> with scope oneLevel
# filter: (objectclass=*)
# requesting: *
#
# search result
search: 2
result: 32 No such object
Leon King
Development Team Lead OASIS/ICIS WEB
Service Assurance
Outside: 919-378-6626
v-net: 965-6626
-----Original Message-----
From: openldap-software-bounces+leon.king=verizonbusiness.com@openldap.org [mailto:openldap-software-bounces+leon.king=verizonbusiness.com@openldap.org] On Behalf Of Dieter Kluenter
Sent: Wednesday, February 18, 2009 1:04 PM
To: openldap-software@openldap.org
Subject: Re: Verify Connection to LDAP with Oracle backend.
"King, Leon C" leon.king@verizonbusiness.com writes:
I've finally configured openldap-2.4.11, back_sql, and oracle. I've imported
the test database implemented by database scripts online which creates the
tables ( persons, documents, etc ). Now my problem is how do I view all of
the LDAP entries? I'm a newbie at this, so any help would be appreciated.
ldapsearch -H ldap://your.host -b dc=example,dc=com -s one "*" -x
Or get a graphical ldap-browser to search this tree.
-Dieter