On 07/07/2020 13:58, Mike Tubby via Exim-users wrote:
> set (dkim_selector, dkim_dkim_canon, dkim_private_key, dkim_hash) =
> ${lookup mysql {SELECT selector,canon,private_key, hash FROM dkim WHERE
> domain='${quote_mysql:${dkim_domain}}' AND active=1}{$value}{false}}
That would be a whole new syntax for exim, so troublesome to
implement.
I didn't put is explicitly enough, with
>> or you could
>> just rely on the lookup caching.
but the current likely best would be
DSIGN_LOOKUP = ${lookup mysql{SELECT selector, canon, \
hash, private_key FROM dkim \
WHERE domain='${quote_mysql:${dkim_domain}}' AND active=1}}
...
dkim_selector = ${extract {selector} {DSIGN_LOOKUP}}
dkim_canon = ${extract {canon} {DSIGN_LOOKUP}}
dkim_hash = ${extract {hash} {DSIGN_LOOKUP}}
dkim_private_key = ${extract {private_key}{DSIGN_LOOKUP}}
--
Cheers,
Jeremy
