Exim使用正则expression式查找MySQL

我有以下工作Exim4路由器:

dovecot_user: driver = accept condition = ${lookup mysql{SELECT CONCAT(mailboxes.local_part,'@',domains.fqdn) AS goto FROM domains,mailboxes WHERE \ mailboxes.local_part='${quote_mysql:$local_part}' AND \ mailboxes.active=1 AND \ mailboxes.domain_id=domains.id AND \ domains.fqdn='${quote_mysql:$domain}' AND \ domains.active=1}{yes}{no}} transport = dovecot_delivery 

我想修改它,以便它可以接受表格的地址(然后发送到crm-bounce收件箱):

 [email protected] [email protected] 

我知道以下SQL正确地从testing数据库中select:

 SELECT * FROM regexptest.test WHERE email REGEXP '^crm-bounce([\+].*)?$'; 

我修改了这一行:

 mailboxes.local_part='${quote_mysql:$local_part}' AND \ 

所以它写道:

 mailboxes.local_part REGEXP '^${quote_mysql:$local_part}([\+].*)?\$' AND \ 

但是当运行exim -bt [email protected]undeliverable: Unrouteable address

看起来我这样做是错的。 我想在路由器中启用local_part_suffix,方法是添加:

 local_part_suffix = +* local_part_suffix_optional