OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Postfix Archives: Re: Postfix vs. Oracle

Re: Postfix vs. Oracle

Subject: Re: Postfix vs. Oracle
From: Alessandro Oliveira (alessandro.onunoferreira.com.br)
Date: Tue Jan 04 2000 - 05:00:35 CST

> > Hi,
> >
> > I need to configure one system that recives e-mail (SMTP) and lookup for
> > valid address and make the delivery in an Oracle database, there is no
POP
> > access just SQL. If anyone have any kind of experience like this one,
> please
> > let me know.
>
> Just to be more specific - are you trying to authorize users via an Oracle
> database and then deliver mail normally (i.e. to a Unix mailbox file), or
> are you actually trying to store the mail itself in Oracle?

Just authorize and store, actually the message needs to be mime parsed and
the
attachments split to another table

> In either case, you'll probably have to write some code to do it, unless
> there's a patch floating around someplace already. For just doing map
> lookups (i.e. user verification, relay maps, virtual domain stuff, etc.)
> you'd need to write a new "dict" module; there's several existing ones
under
> the util/ directory of the source tree that you could use as guides. The
> "dict_mysql" module would probably be your best bet for a template since
it
> uses SQL already; you'll just need to change the API calls to use Oracle's
> stuff instead of MySQL's stuff.

can I write it in perl or I need to write in C ?

> For doing actual delivery and storage of messages into Oracle you'll need
to
> write your own local delivery agent, which would be a bit more involved.
If
> you do decide to code things yourself, you should also consider whether
you
> want to code directly to Oracle's API's or to some sort of ODBC interface
> (which may be more useful to the rest of the world). :)

I think that building a standard interface to databases and coding plugins
for especific
databases could be much faster.

Alessandro Oliveira
Nuno Ferreira Cargas Internacionais
alessandro.onunoferreira.com.br

This archive was generated by hypermail 2b27 : Tue Jan 04 2000 - 05:03:12 CST