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:
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:
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