issues with schema mapping on 2.4.39 with back-sql AND oracle

[Roberto Benedetti <r.benedetti@cineca.it>]

hello to everyone.


[I already tried to send this message to the list. as a list-subscriber I couldn't see it in my inbox neither I saw it on the web list archives. I hope you did not get this message twice]



* I was able to run tests against a 2.4.39 OpenLDAP server configured to make use of a MySQL server database.
* I have a properly installed Oracle client and also properly configured unixODBC to query Oracle via the "isql" command.
* I can see queries run against the oracle instance (although bind-values masquerade run-time queries)

after issuing all the DDL and DML statements that come with the distributed software and after modifying the slapd.conf as suggested, I run into problems when starting the server (enclosed please find the complete output with debug set to "-1"): I get the following error[1] even if the query with "2" as the bind value properly works.


*questions*

Q1) what am I missing? have you got any hint? (if needed, I can provide further information)

Q2) are the provided sample files supposed to work as-is?

Q3) if the answer to Q2 is "no" but you have been able to run back-sql and Oracle, could you please share DDL and metadata?



thanks for your support,
  roberto benedetti




[1]
5447ade2 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
5447ade2 Return code: -1
5447ade2 <==backsql_load_schema_map()
5447ade2 backsql_db_open(): schema mapping failed, exiting
5447ade2 backend_startup_one (type=sql, suffix="dc=example,dc=com"):
bi_db_open failed! (1)