User Tools

Site Tools


start:howto:dovecot_plus_database_quota

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
Last revision Both sides next revision
start:howto:dovecot_plus_database_quota [2013/06/10 09:42]
aseques
start:howto:dovecot_plus_database_quota [2013/06/20 15:34]
aseques
Line 4: Line 4:
 The required dovecot version is now 1.2 (squeeze'​s default) or newer. The required dovecot version is now 1.2 (squeeze'​s default) or newer.
  
-===== Changes from standard mail setup in imscp =====+==== Changes from standard mail setup in imscp ====
   * Alias and subdomains can be used as a full mail domains   * Alias and subdomains can be used as a full mail domains
   * Global sieve filtering (already enabled by default but without config)   * Global sieve filtering (already enabled by default but without config)
  
-===== Reasons to use dovecot ​=====+==== Reasons to use dovecot ====
  
   * You can do server-side filtering with sieve (for example saving spam to junk folder)   * You can do server-side filtering with sieve (for example saving spam to junk folder)
Line 20: Line 20:
 Please report any bugs/​hints/​whatever in the following board thread: Please report any bugs/​hints/​whatever in the following board thread:
 http://​forum.i-mscp.net/​showthread.php?​tid=61 http://​forum.i-mscp.net/​showthread.php?​tid=61
-===== Replace Courier with Dovecot ​=====+==== Replace Courier with Dovecot ====
  
 You can do it by re-running the installer and changing the default imap server when asked you can choose between courier or dovecot. You can do it by re-running the installer and changing the default imap server when asked you can choose between courier or dovecot.
  
-===== Optional features ===== +===== Global sieve filtering ​=====
- +
-==== Global sieve filtering ====+
  
 Dovecot will look for the global sieve script located in /​etc/​dovecot/​sieve/​dovecot.sieve,​ it can be edited to suit your needs with more functionality. Dovecot will look for the global sieve script located in /​etc/​dovecot/​sieve/​dovecot.sieve,​ it can be edited to suit your needs with more functionality.
Line 41: Line 39:
 More info about sieve syntax and usage: http://​wiki.dovecot.org/​LDA/​Sieve More info about sieve syntax and usage: http://​wiki.dovecot.org/​LDA/​Sieve
  
-==== Use domain alias/​subdomain as a mail alias ====+===== Use domain alias/​subdomain as a mail alias =====
  
 By doing a small change in postfix configuration,​ we can use the domain alias as a mail ailas. By doing a small change in postfix configuration,​ we can use the domain alias as a mail ailas.
Line 52: Line 50:
 In the file main.cf (proposed changes are for the template), from: In the file main.cf (proposed changes are for the template), from:
   virtual_mailbox_domains = hash:​{MTA_VIRTUAL_DMN_HASH}   virtual_mailbox_domains = hash:​{MTA_VIRTUAL_DMN_HASH}
-  ​virtual_mailbox_maps ​= hash:{MTA_VIRTUAL_MAILBOX_HASH}+  ​virtual_alias_maps ​          = hash:{MTA_VIRTUAL_ALIAS_HASH}
  
 To:  To: 
Line 59: Line 57:
   virtual_mailbox_domains ​     = mysql:/​etc/​postfix/​mysql_virtual_domains.cf   virtual_mailbox_domains ​     = mysql:/​etc/​postfix/​mysql_virtual_domains.cf
   ​   ​
-  #virtual_mailbox_maps ​= hash:{MTA_VIRTUAL_MAILBOX_HASH}+  #virtual_alias_maps ​          = hash:{MTA_VIRTUAL_ALIAS_HASH}
   virtual_alias_maps ​          = hash:​{MTA_VIRTUAL_ALIAS_HASH},​ mysql:/​etc/​postfix/​mysql_virtual_forwards.cf   virtual_alias_maps ​          = hash:​{MTA_VIRTUAL_ALIAS_HASH},​ mysql:/​etc/​postfix/​mysql_virtual_forwards.cf
  
Line 74: Line 72:
                 INNER JOIN domain ​ ON domain_aliasses.domain_id=domain.domain_id ​                 INNER JOIN domain ​ ON domain_aliasses.domain_id=domain.domain_id ​
                 WHERE domain.domain_status='​ok'​                 WHERE domain.domain_status='​ok'​
 +                        AND domain_aliasses.alias_status='​ok'​
                         AND domain.domain_mailacc_limit > '​-1'​                         AND domain.domain_mailacc_limit > '​-1'​
                         AND domain_aliasses.alias_name='​%s'​)                         AND domain_aliasses.alias_name='​%s'​)
Line 126: Line 125:
   }   }
  
-===== Frequent issues ​=====+===== Deprecated documentation (pending to be purged) ​===== 
 + 
 +**NOTE:** In the SQL query for user_query there are uids and gids '​hardcoded'​. The uid must be the uid of your vmail user and gid the gid of the mail group. Maybe you have to change the defaults (1001/8)) 
 ==== Adapt postfix master.cf ==== ==== Adapt postfix master.cf ====
  
Line 147: Line 149:
     flags=DROhu user=vmail:​mail argv=/​usr/​libexec/​dovecot/​deliver -f ${sender} -d ${recipient}     flags=DROhu user=vmail:​mail argv=/​usr/​libexec/​dovecot/​deliver -f ${sender} -d ${recipient}
  
-===== Older documentation (pending to be purged) ===== 
- 
-**NOTE:** In the SQL query for user_query there are uids and gids '​hardcoded'​. The uid must be the uid of your vmail user and gid the gid of the mail group. Maybe you have to change the defaults (1001/8)) 
/var/www/virtual/i-mscp.net/wiki/htdocs/data/pages/start/howto/dovecot_plus_database_quota.txt · Last modified: 2013/06/21 07:36 by aseques