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

 

--

Dieter Klünter | Systemberatung

http://www.dpunkt.de/buecher/2104.html

sip: +49.180.1555.7770535

GPG Key ID:8EF7B6C6

53°08'09,95"N

10°08'02,42"E