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: Jason Hoos (jhoosthwack.net)
Date: Mon Jan 03 2000 - 18:04:36 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?

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.

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). :)

Jason Hoos
jhoosthwack.net

This archive was generated by hypermail 2b27 : Mon Jan 03 2000 - 18:08:33 CST