protocols = pop3 pop3s imap imaps managesieve
listen = *
mail_uid = 501
mail_gid = 502
first_valid_uid = 501
last_valid_uid = 501
log_path = /var/log/dovecot.log
mail_process_size = 1024
disable_plaintext_auth = no
login_process_per_connection=yes
auth_default_realm = domain.com
plugin {
    quota_warning = storage=85%% /usr/local/bin/dovecot-quota-warning.sh 85
    quota_warning2 = storage=90%% /usr/local/bin/dovecot-quota-warning.sh 90
    quota_warning3 = storage=95%% /usr/local/bin/dovecot-quota-warning.sh 95
}
ssl = yes
verbose_ssl = no
ssl_key_file = /etc/pki/tls/private/iRedMail.key
ssl_cert_file = /etc/pki/tls/certs/iRedMail_CA.pem
ssl_ca_file = /etc/pki/tls/certs/iRedMail_CA.pem
mail_location = maildir:/%Lh/Maildir/:INDEX=/%Lh/Maildir/
plugin {
    quota = dict:user::proxy::quotadict
    quota_rule = *:storage=0
}
dict {
    expire = db:/var/lib/dovecot/expire/expire.db
}
plugin {
    expire = Trash 7 Trash/* 7 Junk 30
    expire_dict = proxy::expire
    auth_socket_path = /var/run/dovecot/auth-master
}
plugin {
    sieve = /pathtovmail/sieve/%Ld/%Ln/dovecot.sieve
}
protocol lda {
    postmaster_address = root
    auth_socket_path = /var/run/dovecot/auth-master
    mail_plugins = quota sieve autocreate
    sieve_global_path = /pathtovmail/sieve/dovecot.sieve
    log_path = /var/log/sieve.log
}
protocol imap {
    mail_plugins = quota imap_quota autocreate
    imap_client_workarounds = tb-extra-mailbox-sep
}
protocol pop3 {
    mail_plugins = quota
    pop3_uidl_format = %08Xu%08Xv
    pop3_client_workarounds = outlook-no-nuls oe-ns-eoh
}
auth default {
    mechanisms = plain login
    user = vmail
    passdb sql {
        args = /etc/dovecot-mysql.conf
    }
    userdb sql {
        args = /etc/dovecot-mysql.conf
    }
    socket listen {
        master {
            path = /var/run/dovecot/auth-master
            mode = 0666
            user = vmail
            group = vmail
        }
        client {
            path = /var/spool/postfix/dovecot-auth
            mode = 0666
            user = postfix
            group = postfix
        }
    }
}
plugin {
    autocreate = INBOX
    autocreate2 = Sent
    autocreate3 = Trash
    autocreate4 = Drafts
    autocreate5 = Junk
    autosubscribe = INBOX
    autosubscribe2 = Sent
    autosubscribe3 = Trash
    autosubscribe4 = Drafts
    autosubscribe5 = Junk
}
dict {
    quotadict = mysql:/etc/dovecot-used-quota.conf
}
namespace private {
    separator = /
    prefix =
    inbox = yes
}
namespace shared {
    separator = /
    prefix = Shared/%%u/
    location = maildir:/%%Lh/Maildir/:INDEX=/%%Lh/Maildir/Shared/%%u
    subscriptions = yes
    list = children
}
plugin {
    acl = vfile
    acl_shared_dict = proxy::acl
}
dict {
    acl = mysql:/etc/dovecot-share-folder.conf
}
protocol managesieve {
    listen = 127.0.0.1:4190 # 原端口安装后是 2000,与 pysieved冲突，所以这里改了
}
plugin {
    sieve = /pathtovmail/sieve/%Ld/%Ln/dovecot.sieve
    sieve_dir = /pathtovmail/sieve/%Ld/%Ln/
}

driver = mysql
default_pass_scheme = CRYPT
connect = host=127.0.0.1 dbname=vmail user=vmail password=pwd
password_query = SELECT password FROM mailbox WHERE username='%u' AND active='1'
user_query = SELECT CONCAT(mailbox.storagebasedirectory, '/', mailbox.storagenode, '/', mailbox.maildir) AS home, CONCAT('*:bytes=', mailbox.quota*1048576) AS quota_rule FROM mailbox,domain WHERE mailbox.username='%u' AND mailbox.domain='%d' AND mailbox.enable%Ls%Lc=1 AND mailbox.domain=domain.domain AND domain.backupmx=0 AND domain.active=1 AND mailbox.active=1

connect = host=127.0.0.1 dbname=vmail user=vmailadmin password=pwd
map {
    pattern = priv/quota/storage
    table = mailbox
    username_field = username
    value_field = bytes
}
map {
    pattern = priv/quota/messages
    table = mailbox
    username_field = username
    value_field = messages
}

connect = host=127.0.0.1 dbname=vmail user=vmailadmin password=pwd
map {
    pattern = shared/shared-boxes/user/$to/$from
    table = share_folder
    value_field = dummy

    fields {
        from_user = $from
        to_user = $to
    }
}

SELECT `username` , `domain` , `name` , `transport` , `rank` , `local_part` , `storagebasedirectory` , `storagenode` , `maildir`
FROM `mailbox`
WHERE username = 'service@domain.com'