Advice for building a smtp-relay mail server

[TuxNetrunner]

Hello everybody.
I am looking into building an smtp server for the company I work for. This server should only do outbound SMTP-relay (local deliveries and mailboxes are managed by another server). I would like to have Auth (plain, tls, etc) with credentials read from a mysql database. I would also need to log smtp activity in mysql (authed user, message size, sender, recipients, subject) and the delivery status (success, failure, etc.) of every message.
What do you think would be my best choice?
Thanks in advance

[cmaurand]

I've built a couple of these.

You want to use postfix, amavisd-new, clamav, spamassassin, spamassassin-fuzzyocr and cyrus-sasl.

you'll use the sasl-authd to have the user lookups and authentication done from the exchange server you're try to protect.

There is a another script that I run that gets clam-antivirus to do quite a bit of filtering. This will filter out much spam and most viruses as long as it is kept up to date.
_________________
Curtis

[cach0rr0]

another vote for postfix

though as this is an *outbound* mail relay, you wont need spamassassin, amavisd, or any of that;)

the biggest problem will be getting Exchange or whatever backend MTA to pass on the user's authentication data to postfix. Configuring a smarthost in exchange is easy, configuring exchange to send all of the data you're asking about is another matter.
_________________
Lost configuring your system?
dump lspci -n here | see Pappy's guide | Link Stash

[TuxNetrunner]

uhm... I have a read quite a bit around the net, but I think the main problem will be logging postfix's data to mysql. It seems like the only way is to have syslog-ng save to mysql and then filter out (and parse) the postifx entries, since postfix ONLY logs through system loggers. This sounds to me somehow trivial to do...
I wonder what it would take to make postfix log directly to mysql instead of letting it log to syslog and then re-parse all the logs via script...