** I wrote erroneously about working versions. Up to OpenLDAP 2.4.23 it
works great with Oracle DB as backend. From version 2.4.25 onwards
integration does not work.
El lun, 28 mar 2022 a las 15:33, Julián Sosa (<docldap(a)gmail.com>) escribió:
Hi all. As a demand from some client, we have to implement the
Oracle
backend, with idea of using an existing schema for authenticating users
using some mfa tool that only supports ldap.
I began for last version at this date (2.6.1), but have this error:
6241cb6b 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 "organization"
with param oc_id=3
6241cb6b Return code: -1
6241cb6b <==backsql_load_schema_map()
In order for doing some debugging, I changed slapd and unixodbc to point
to an mysql, and works fine. So I found some entry on internet from a
person who had it working on some version, but when changing it does not
work. Also, I monitored with sys user last queries on v$sql. and last query
that reached DB was , so it appears that error occurs at preparing the
attribute mapping query, and code breaks before sending the query.
I found another entry about this, where someone told that he have it
working on version 2.3.24 and he could not make it work on other version.
So I begin installing several OpenLDAP versions since mentioned one, and
from there to version 2.3.24 I found that Oracle backend is working fine.
Beginning 2.4.24, and onwards versions, it starts to show mentioned error.
I tried both on my Mint 20.3 personal machine, and with client's server
which is a CentOS 7.8.
For tests, I used same Oracle DB instance. Only copy the slapd.conf from
working OpenLDAP/Oracle to the version I tested.