Re: [exim] Feature Request - Exim needs more MySQL Support

Pàgina inicial
Delete this message
Reply to this message
Autor: Jakob Hirsch
Data:  
A: John W. Baxter
CC: exim-users
Assumpte: Re: [exim] Feature Request - Exim needs more MySQL Support
John W. Baxter wrote:

> It would indeed be nice to be able to produce arbitrary queries within
> Exim (not just for MySQL although that's the one we use).


Um... the exim spec doesn't limit queries to SELECTs and say you have to
use the results of a query, so something like this works perfectly
(directly copied from my greylisting howto):

  condition = ${lookup sqlite {GREY_DB \
    insert into greylist (host, sender, rcpt, created, updated) \
    values ('${quote_sqlite:$sender_host_address}', \
            '${quote_sqlite:$sender_address}', \
            '${quote_sqlite:${local_part}@${domain}}', \
             $tod_epoch, $tod_epoch)} {1}{1}}