forum.lissyara.su

Код: Выделить всё

#!/bin/sh

driver = mysql
connect = host=localhost dbname=exim user=exim password=exim
#default_pass_scheme = PLAIN
default_pass_scheme = MD5-CRYPT

password_query = SELECT `username` as `user`, `password` \
FROM `mailbox` WHERE `username` = '%n@%d' AND `active`='1'

user_query = SELECT 26 AS `uid`, 26 AS `gid` FROM `mailbox` WHERE `username` = '%n@%d' AND `active`='1'

Код: Выделить всё

begin routers

dnslookup:
  driver = dnslookup
  domains = ! +local_domains
  transport = remote_smtp
  ignore_target_hosts = 0.0.0.0 : 127.0.0.0/8
  no_more

system_aliases:
  driver      = redirect
  allow_fail
  allow_defer
  data = ${lookup mysql{SELECT `goto` FROM `alias` WHERE \
          `address`='${quote_mysql:$local_part@$domain}' OR \
          `address`='${quote_mysql:@$domain}'}}

dovecot_user:
  driver = accept
  condition = ${lookup mysql{SELECT `goto` FROM `alias` WHERE \
               `address`='${quote_mysql:$local_part@$domain}' OR \
               `address`='${quote_mysql:@$domain}'}{yes}{no}}
  transport = dovecot_delivery

Код: Выделить всё

data = ${lookup mysql{SELECT `goto` FROM `alias` WHERE \
          ( LOCATE(CONCAT("+", `address`), '${quote_mysql:$local_part@$domain}') > 0 )}}