Guest User

Untitled

a guest
Oct 3rd, 2018
193
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.55 KB | None | 0 0
  1. Jul 31 19:26:40 mail dovecot: imap(user@mx.domain): Error: Dictionary URI is missing ':': quota
  2. Jul 31 19:26:40 mail dovecot: imap(user@mx.domain): Error: user user@mx.domain: Initialization failed: Failed to initialize quota: Quota root storage=0 proxy: init() failed
  3. Jul 31 19:26:40 mail dovecot: imap(user@mx.domain): Error: Invalid user settings. Refer to server log for more information.
  4.  
  5. dovecot version: 1:2.0.13-1ubuntu2
  6.  
  7. dovecot.conf:
  8.  
  9. disable_plaintext_auth = no
  10. dotlock_use_excl = yes
  11. first_valid_gid = 8
  12. first_valid_uid = 8
  13. last_valid_gid = 8
  14. last_valid_uid = 8
  15. login_greeting = Mail Server Ready.
  16. mail_location = maildir:/home/vmail/%d/%n
  17. mail_privileged_group = mail
  18. passdb {
  19. args = /etc/dovecot/dovecot-sql.conf
  20. driver = sql
  21. }
  22. protocols = imap pop3
  23. service auth {
  24. unix_listener /var/spool/postfix/private/auth {
  25. group = postfix
  26. mode = 0660
  27. user = postfix
  28. }
  29. user = root
  30. }
  31. ssl_cert = </etc/ssl/private/crt.pem
  32. ssl_key = </etc/ssl/private/crt.pem
  33. userdb {
  34. args = /etc/dovecot/dovecot-sql.conf
  35. driver = sql
  36. }
  37. verbose_proctitle = yes
  38. protocol imap {
  39. imap_client_workarounds = delay-newmail tb-extra-mailbox-sep
  40. mail_plugins = quota imap_quota
  41. }
  42. protocol pop3 {
  43. mail_plugins = quota
  44. pop3_client_workarounds = outlook-no-nuls oe-ns-eoh
  45. pop3_uidl_format = %08Xu%08Xv
  46. }
  47. protocol lda {
  48. mail_plugins = quota
  49. postmaster_address = postmaster@mx.domain.de
  50. sendmail_path = /usr/sbin/sendmail
  51. }
  52. dict {
  53. quotadict = mysql:/etc/dovecot/dovecot-dict-quota.conf
  54. }
  55. plugin {
  56. quota = dict:user::proxy::quotadict
  57. }
  58. !include conf.d/10-logging.conf
  59.  
  60.  
  61. /etc/dovecot/dovecot-dict-quota.conf:
  62. driver = mysql
  63. connect = host=localhost dbname=postfix user=postfix password=password
  64. default_pass_scheme = MD5
  65. table = quota2
  66. select_field = current
  67. where_field = path
  68. username_field = username
  69.  
  70. # HERE I dont know if that is correct, as the quota2 table created by postfixadmin has different row
  71. # names:
  72. # username, bytes and messages ..
  73.  
  74.  
  75. /etc/dovecot/dovecot-sql.conf
  76. driver = mysql
  77. connect = host=localhost dbname=postfix user=postfix password=password
  78. default_pass_scheme = MD5
  79. password_query = SELECT password FROM mailbox WHERE username = '%u'
  80. user_query = SELECT maildir, 8 AS uid, 8 AS gid, CONCAT('dict:storage=',floor(quota/1000),' proxy::quota') as quota FROM mailbox WHERE username = '%u' AND active='1'
Add Comment
Please, Sign In to add comment