(ITS#7619) Unable to start OpenLDAP 2.4.35 with Oracle 10g

[lokesh.kumar1@thomsonreuters.com]

Full_Name: Lokesh Kumar
Version: 2.4.35
OS: Linux 2.6
URL: ftp://ftp.openldap.org/incoming/
Submission from: (NULL) (163.231.6.66)


I am unable to start the LDAP on my linux machine with openldap-2.4.35 using
back-sql with Oracle 10g as my datasource. I am able to connect to the Oracle
database, but it fails to load the data on to the LDAP object schema. I am using
the default sample data for Oracle RDBMS and the schema files which comes with
the installable. Can you please look into this and let me know if I am missing
something here?

My sladp.config file looks like this:

include         <InstallFolder>/etc/openldap/schema/core.schema
include         <InstallFolder>/etc/openldap/schema/cosine.schema
include         <InstallFolder>/etc/openldap/schema/inetorgperson.schema

pidfile         <InstallFolder>/var/run/slapd.pid
argsfile        <InstallFolder>/var/run/slapd.args

database        sql
suffix          "dc=example,dc=com"
rootdn          "cn=root,dc=example,dc=com"
rootpw          secret
dbname          OracleODBC-10g
dbuser          username
dbpasswd        password
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


The startup console output looks something like this:
.
.
.
51b70f81 backsql_load_schema_map(): oc_query "SELECT
id,name,keytbl,keycol,create_proc,delete_proc,expect_return FROM
ldap_oc_mappings"
51b70f81 objectClass: id="1" name="inetOrgPerson" keytbl="persons" keycol="id"
create_proc="call create_person(?)" create_keyval="" delete_proc="call
delete_person(?)" expect_return="0"create_hint=""
51b70f81 backsql_load_schema_map(): objectClass "inetOrgPerson":
    keytbl="persons" keycol="id"
51b70f81     create_proc="call create_person(?)"
51b70f81     delete_proc="call delete_person(?)"
51b70f81     expect_return: add=0, del=0; attributes:
51b70f81 objectClass: id="2" name="document" keytbl="documents" keycol="id"
create_proc="call create_document(?)" create_keyval="" delete_proc="call
delete_document(?)" expect_return="0"create_hint=""
51b70f81 backsql_load_schema_map(): objectClass "document":
    keytbl="documents" keycol="id"
51b70f81     create_proc="call create_document(?)"
51b70f81     delete_proc="call delete_document(?)"
51b70f81     expect_return: add=0, del=0; attributes:
51b70f81 objectClass: id="3" name="organization" keytbl="institutes" keycol="id"
create_proc="call create_org(?)" create_keyval="" delete_proc="call
delete_org(?)" expect_return="0"create_hint=""
51b70f81 backsql_load_schema_map(): objectClass "organization":
    keytbl="institutes" keycol="id"
51b70f81     create_proc="call create_org(?)"
51b70f81     delete_proc="call delete_org(?)"
51b70f81     expect_return: add=0, del=0; attributes:
51b70f81 backsql_load_schema_map(): at_query "SELECT
name,sel_expr,from_tbls,join_where,add_proc,delete_proc,param_order,expect_return,sel_expr_u
FROM ldap_attr_mappings WHERE oc_map_id=?"
51b70f81 backsql_oc_get_attr_mapping(): executing at_query
    "SELECT name,sel_expr,from_tbls,join_where,add_proc,delete_proc,param_order,expect_return,sel_expr_u
FROM ldap_attr_mappings WHERE oc_map_id=?"
    for objectClass "document"
    with param oc_id=2
51b70f81 backsql_oc_get_attr_mapping(): error executing at_query
    "SELECT name,sel_expr,from_tbls,join_where,add_proc,delete_proc,param_order,expect_return,sel_expr_u
FROM ldap_attr_mappings WHERE oc_map_id=?"
    for objectClass "document"
    with param oc_id=2
51b70f81 Return code: -1
51b70f81 <==backsql_load_schema_map()
51b70f81 backsql_db_open(): schema mapping failed, exiting
51b70f81 backend_startup_one (type=sql, suffix="dc=example,dc=com"): bi_db_open
failed! (1)
51b70f81 slapd shutdown: initiated
.
.
.