dovecot_config_version = 2.4.2
dovecot_storage_version = 2.4.2

!include_try conf.d/*.conf

protocols {
  imap = yes
  lmtp = yes
  sieve = yes
}

mail_home = /home/vmail/storage/%{user | domain}/%{user | username}
mail_driver = maildir
mail_path = ~/maildir

mail_uid = vmail
mail_gid = vmail

namespace inbox {
  inbox = yes
  separator = /
}

sql_driver = sqlite
sqlite_path = /home/vmail/database/vmail.sqlite3

passdb sql {
  query = SELECT username, domain, password FROM mailbox WHERE username = '%{user}' AND active = 1
}

userdb sql {
  query = SELECT CONCAT('/home/vmail/storage/', maildir) AS home, CONCAT('maildir:storage=', quota) AS quota FROM mailbox WHERE username = '%{user}' AND active = 1
  iterate_query = SELECT username AS user FROM mailbox
}