# 2.4.1-4 (7d8c0e5759): /etc/dovecot/dovecot.conf
# Pigeonhole version 2.4.1-4 (0a86619f)
# OS: Linux 6.12.43+deb13-cloud-amd64 x86_64 Debian 13.1 ext4
# Hostname: mx.yorkshiremail.com
# 4 default setting changes since version 2.4.0
dovecot_config_version = 2.4.0
auth_debug_passwords = yes
auth_mechanisms = plain login
auth_verbose = yes
dovecot_storage_version = 2.4.0
fts_autoindex = yes
fts_autoindex_max_recent_msgs = 999
fts_search_add_missing = yes
mail_driver = maildir
mail_gid = vmail
mail_home = /var/vmail/mailboxes/%{user|domain}/%{user|username}
mail_path = /var/vmail/mailboxes/%{user|domain}/%{user|username}/mail
mail_privileged_group = mail
mail_uid = vmail
protocols {
  imap = yes
  lmtp = yes
  sieve = yes
  pop3 = yes
}
sieve_plugins = sieve_imapsieve sieve_extprograms
sieve_trace_addresses = yes
sieve_trace_debug = yes
sql_driver = mysql
mysql 127.0.0.1 {
  dbname = vimbadmin
  password = # hidden, use -P to show it
  user = vimbadmin
}
passdb sql {
  default_password_scheme = SHA512-CRYPT
  query = SELECT username as user, password as password, concat('*:bytes=', quota) as userdb_quota_rule FROM mailbox WHERE username = '%{user}' AND active = '1'
}
userdb sql {
  iterate_query = SELECT userid AS username, domain FROM mailbox INNER JOIN domain ON mailbox.Domain_id = domain.d
  query = SELECT 'vmail' as uid, 'vmail' as gid, '/var/vmail/mailboxes/%{user|domain}/%{user|username}' as home, concat('*:bytes=', quota) as quota_rule FROM mailbox WHERE username = '%{user}'
}
namespace inbox {
  inbox = yes
  mailbox Drafts {
    special_use = "\\Drafts"
  }
  mailbox Junk {
    special_use = "\\Junk"
  }
  mailbox Trash {
    special_use = "\\Trash"
  }
  mailbox Sent {
    special_use = "\\Sent"
  }
  mailbox "Sent Messages" {
    special_use = "\\Sent"
  }
}
service imap-login {
  inet_listener imap {
  }
  inet_listener imaps {
  }
}
service pop3-login {
  inet_listener pop3 {
  }
  inet_listener pop3s {
  }
}
service submission-login {
  inet_listener submission {
  }
  inet_listener submissions {
  }
}
service lmtp {
  unix_listener /var/spool/postfix/private/dovecot-lmtp {
    group = postfix
    mode = 0600
    user = postfix
  }
}
service imap {
}
service pop3 {
}
service submission {
}
service auth {
  unix_listener /var/spool/postfix/private/auth {
    group = postfix
    mode = 0660
    user = postfix
  }
}
service auth-worker {
}
service dict {
  unix_listener dict {
  }
}
ssl_server {
  cert_file = /etc/certhelper/certs/yorkshiremail.com/fullchain.pem
  key_file = /etc/certhelper/certs/yorkshiremail.com/privkey.pem
}
protocol imap {
  mail_plugins {
    notify = yes
    mail_log = yes
    imap_sieve = yes
  }
}
protocol lmtp {
  auth_username_format = %{user}
  mail_plugins {
    sieve = yes
  }
}
service managesieve-login {
  inet_listener sieve {
    port = 4190
  }
  inet_listener sieve_deprecated {
    port = 2000
  }
}
service managesieve {
}
sieve_script personal {
  driver = file
  path = /var/vmail/sieve/%{user|domain}/%{user|username}
}