start:howto:dovecot_plus_database_quota
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
start:howto:dovecot_plus_database_quota [2013/06/20 15:34] aseques |
start:howto:dovecot_plus_database_quota [2013/06/21 07:36] (current) aseques removed the subdomain part since it didn't work and isn't of much interest |
||
|---|---|---|---|
| Line 5: | Line 5: | ||
| ==== 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 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) | ||
| Line 39: | 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 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 94: | Line 94: | ||
| INNER JOIN domain_aliasses ON domain.domain_id = domain_aliasses.domain_id | INNER JOIN domain_aliasses ON domain.domain_id = domain_aliasses.domain_id | ||
| WHERE domain_aliasses.alias_name = '%d' AND mail_users.mail_acc = '%u' | WHERE domain_aliasses.alias_name = '%d' AND mail_users.mail_acc = '%u' | ||
| - | </code> | ||
| - | |||
| - | If you want the subdomains to be able to receive mail create this file: | ||
| - | **/etc/dovecot/dovecot-sql-subdomain.conf** | ||
| - | with the following content: | ||
| - | |||
| - | <code> | ||
| - | driver = mysql | ||
| - | connect = host=localhost dbname=imscp user=imscp_dovecot password=PASS_MAILRW | ||
| - | user_query = SELECT CONCAT('/var/mail/virtual/', subdomain.subdomain_name, ".", domain.domain_name, '/',mail_acc) AS home, '1001' AS uid, '8' AS gid FROM (mail_users INNER JOIN subdomain ON mail_users.sub_id = subdomain.subdomain_id) INNER JOIN domain ON mail_users.domain_id = domain.domain_id WHERE mail_acc='%n' and concat(subdomain.subdomain_name,".",domain.domain_name)='%d'; | ||
| </code> | </code> | ||
/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
