RE: Verify Connection to LDAP with Oracle backend.

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