Re: Question about Openldap+Oracle10g

["Pierangelo Masarati" <ando@sys-net.it>]

Pu,

I'm currently maintaining back-sql, and I have no experience in using it
with Oracle as RDBMS (nor I have the chance, the time or the resources to
test it).  The only databases that are actively maintained are (in order
of preference, based on our customers' requirements) PostgreSQL, IBM
DB2/UDB and MySQL.  I suggest you look at the files provided in the pgsql
directory, and at the README in rdbms_depend/ of HEAD, and modify them in
order to comply with Oracle's needs.  I'd appreciate if, in case of
success (e.g. with sql-test000 and sql-test900 that are available in HEAD
code) you send back the working files to update the distribution.  There
should be someone out there that happily uses back-sql with Oracle (don't
know what version, if it ever matters); they might be able to help you,
although I suspect the problem essentially related to some silly error in
the example files.  BTW; I note that the corresponding files in HEAD
underwent some updates, which didn't make it into the distribution
essentially because they're untested.  I suggest you try the files in HEAD
first, and, in case of failure, you try to fix those instead of the
distributed ones.

p.

PS: in the mailing list address you're sending to there's a non-ASCII char
which renders like a "t" (in "openldap-software").  This is causing one of
my mail clients to fail.  Unless it's intended, I suggest you replace that
char with a regular ASCII "t".

> Hello
>
> I configured an OpenLDAP2.2.19+UnixODBC(OracleDriver)+Oracle10g on a
> solaris
> 9 machine. But if loaded the default sql files (which have been stored in
> directory /servers/slapd/back-sql/rdbms_depend/oracle), SLAPD can not be
> started
> with the error below:
> -------
> backsql_load_schema_map(): duplicate objectClass "document" in objectClass
> by ID map
>
> * What's this error?
>
> If I hold only one objectclass definition, and delete other objectclass in
> testdb_metadata.sql file, SLAPD can be started without problem.
> -----------
> Example:
> insert into ldap_oc_mappings
> (id,name,keytbl,keycol,create_proc,delete_proc,expect_return)
> values (1,'person','persons','id','call create_person(?)','call
> delete_person(?)',0);
>
> --delete these--
> --insert into ldap_oc_mappings
> (id,name,keytbl,keycol,create_proc,delete_proc,expect_return)
> --values (2,'document','documents','id','call create_document(?)','call
> delete_document(?)',0);
>
> --insert into ldap_oc_mappings
> (id,name,keytbl,keycol,create_proc,delete_proc,expect_return)
> -- values (3,'organization','institutes','id','call create_org(?)','call
> delete_org(?)',0);
>
> Does anyone know this?
> Has anyone configured the OpenLDAP+Oracle10g successfully?
>
> Thanks & regards
> Pu
>


-- 
Pierangelo Masarati
mailto:pierangelo.masarati@sys-net.it


    SysNet - via Dossi,8 27100 Pavia Tel: +390382573859 Fax: +390382476497