[Exim] http filter report

Top Page
Delete this message
Reply to this message
Author: René Küttner
Date:  
To: exim-users
Subject: [Exim] http filter report
hi,

i have to provide an http-interface to display a status report of filtered
messages (e.g. viruses or messages with unwanted file extensions)
i also use the exiscan acl patch for some checks

the best way to do this is to store this information in a database (isnt it?)
so i set up some lookups in the acl:

(example)

## blacklisted sender hosts
SECDB_BLACKLISTED = insert into email_blacklisted ( \
    server, sender_host, sender_address, dnslist, f_date, f_time ) \
    values ( \
    '${quote_mysql:${primary_hostname}}', \
    '${quote_mysql:${sender_host_address}}', \
    '${quote_mysql:${reply_address}}', \
    '${quote_mysql:${dnslist_domain}}', \
    now(), \
    now() );


deny    message = your host is blacklisted at $dnslist_domain
           dnslists = relays.ordb.org
           condition = ${lookup mysql{SECDB_BLACKLISTED}{1}}


where SECDB_BLACKLISTED is a "insert" query and expanded

is there a better solution? i'm not happy with this one because exim
gives temporary errors if there's a problem with the database
thats okay! the acl is a way to control access and not to log into database.
anyway .. i searched the specification up and down but did'nt find any other
way

thanks in advance