Log Basic Message Information to Database

["J.T. Moore" <jt...@mogul.dyndns.org>]

Hello,

    Does anyone know of a way to log basic information about messages processed by Spamassassin to a database (ideally mysql)?

    The fields i'm interested in logging are:

        ip address of remote smtp server
        score assigned to message by spamassassin
        date and time message was received (processed by spamassassin)

    Optionally I'd also like to be able to log:

        host name of remote smtp server that was sent in HELO/ELHO command
        host name of remote smtp server resolved for remote smtp servers PTR DNS record
        email address of sender in smtp envelope
        email address of recipient in smtp envelope
        original message subject

    This would make it easier to create and maintain a black list of remote ip addresses that are not allowed to establish a tcp connection to the SMTP server and thereby reduce the bandwidth and server resources used to process spam, i.e  address that have sent a lot messages receiving a score over a threshold value and haven't sent any messages below the threshold during a specified time period could be added to hosts.deny or a firewall acl.

Thanks,

J.T.