protocols = imap imaps pop3 pop3s
 
disable_plaintext_auth = no
 
log_timestamp = "%Y-%m-%d %H:%M:%S "
 
ssl_cert_file = /etc/dovecot/mail.crt
ssl_key_file = /etc/dovecot/mail.key
 
login_user = dovecot
 
mail_location = maildir:%h
 
mail_privileged_group = mail
 
first_valid_uid = 109
 
protocol imap {
 
}
 
 
protocol pop3 {
 
  pop3_uidl_format = %08Xu%08Xv
 
}
 
auth default {
  mechanisms = plain
 
  passdb sql {
    args = /etc/dovecot/dovecot-sql.conf
  }
 
  userdb sql {
    args = /etc/dovecot/dovecot-sql.conf
  }
 
  user = root
 
}
 
dict {
}
 
plugin {
 
}

driver = pgsql
 
connect = host=localhost port=5433 dbname=authdb user=poczta password=poczta1
 
default_pass_scheme = PLAIN
 
password_query = select password from account where username = '%u'
 
user_query = select 109 as uid, 110 as gid, maildir as home from account where username = '%u'