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: '[email protected]' 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'; [email protected] 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....@openldap.org [mailto:openldap-software-bounces+leon.king=verizonbusiness....@openldap.org] On Behalf Of Dieter Kluenter Sent: Wednesday, February 18, 2009 1:04 PM To: [email protected] Subject: Re: Verify Connection to LDAP with Oracle backend. "King, Leon C" <[email protected]> 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
