Re: [exim] Tools for SQL export to CDB

Αρχική Σελίδα
Delete this message
Reply to this message
Συντάκτης: David Saez Padros
Ημερομηνία:  
Υ/ο: exim users
Αντικείμενο: Re: [exim] Tools for SQL export to CDB
Hi !!

> CDB # 1 is populated ONLY with those users who have forwarding switched
> ON. Hence one gets either a 'failure' return code or the needed
> address. The 'please do it' flag is implied.


we use something similar here:

# Local white/black email list
# acl_c5 = 0 unknown
# acl_c5 = 1 blacklisted
# acl_c5 = 2 whitelisted

   warn    set acl_c5     = ${lookup {$sender_address}\
                            cdb{/usr/local/exim/email_list.cdb}{$value}{0}}


if you need to get more than one 'field' for each key you could
store the field separeted by : in the cdb file and then use ${extract}
to get each field. As you have total control over the sql -> cdb
conversion process you could make the cdb data more exim friendly.

--
Best regards ...

----------------------------------------------------------------
    David Saez Padros                http://www.ols.es
    On-Line Services 2000 S.L.       e-mail  david@???
    Pintor Vayreda 1                 telf    +34 902 50 29 75
    08184 Palau-Solita i Plegamans   movil   +34 670 35 27 53
----------------------------------------------------------------