Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Sendmail and Oracle Internet Directory

RE: Sendmail and Oracle Internet Directory

From: Jesse, Rich <>
Date: Mon, 24 Mar 2003 14:31:06 -0600
Message-Id: <>

EGAD!!! I just fired up ODM on an old OID (been awhile -- forgot passwords, etc) and sure enough: it doesn't allow you to create or modify and Matching Rules! AAAAAAAAAAAAAAAUUGH! I'm thinking that you could still add this with the command line tools, though. The problem's that Oracle Corp will probably stomp over that OID (Object ID) with one of it's proprietary matching rules or something and you'll be S.O.L. It may also break future patches and "upgrades". If you're using OID's f'd-up version of Replication, well that's just asking for trouble.

Good gravy. I think you're beginning to see some of the reasons why we dumped OID in favor of a *REAL* LDAP.

Sorry I couldn't help more. Start yelling (nicely) at your Oracle salesman! Maybe they can get some input into The Powers That Be (or directly to the OID product manager for anyone on this list who may have that contact <wink wink>).


Rich Jesse                        System/Database Administrator           Quad/Tech International, Sussex, WI USA

-----Original Message-----
From: Peter Johnson [] Sent: Friday, March 21, 2003 5:14 PM
To: Multiple recipients of list ORACLE-L Subject: RE: Sendmail and Oracle Internet Directory


         I am trying to import the sendmail.schema file from The problem is that it contains a matching rule called caseIgnoreIA5SubstringsMatch which OID doesn't support. There is a caseIgnoreSubstringsMatch rule. I don't know if the IA5 part is important to sendmail.

Oracle's response is "you can't add it and any attempts to add it are unsupported."
>You can add new object classes and objects by modifying subSchemaSubentry.
>You cannot, however, add new matching rules and syntaxes beyond those
>already supported by Oracle Internet Directory. "
>You cannot add caseIgnoreIA5SubstringsMatch, nor can you modify existing
>Matching Rules. Attempting to add or modify existing Matching Rules is not

At 02:13 PM 03/21/2003 -0800, you wrote:
>So Oracle doesn't support it (go figure), what about adding the schema
>yourself? That can't void Oracle Support can it?
>I think you're looking for RFC2307. I can't find the doc at Sun, but there
>is a PDF at
>You may need to rework the LDIFs to get it imported into OID.
>As a second option, you may be able to use SunOne (or OpenLDAP) *with* OID.
>Oracle Internet Directory Administrator's Guide
>Release 9.2
>Part Number A96574-01
>Part VIII
>Rich Jesse System/Database Administrator
> Quad/Tech International, Sussex, WI USA
>"Beer is proof God loves us."
> -- Benjamin Franklin
>-----Original Message-----
>Sent: Friday, March 21, 2003 3:24 PM
>To: Multiple recipients of list ORACLE-L
>I'm trying to setup the sendmail feature ldap_routing using
>Oracle Internet Directory (OID)for the LDAP server.
>There is a matching rule in the sendmail schema called
>caseExactIA5SubstringsMatch not doesn't exist in OID.
>Has anyone found a way to resolve this problem?
>I opened a tar with Oracle and was basically told 'to bad, use openldap'.
> >Matching rules are part of the basic Oracle OID schema and it is not
> >possible to add new or modify existing matching rules that are part of
> >schema. If you want to use sendmail with LDAP you will need to use
> >something like openldap that does support the required matching rules you
> >
> >The caseExactIA5SubstringsMatch matching rule has not been coded into the
> >OID schema up to this point because there has not been a requirement for
> >
> >You can create an enhancement request to have this added into OID by
Received on Mon Mar 24 2003 - 14:31:06 CST

Original text of this message