start:howto:dovecot_plus_database_quota
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
start:howto:dovecot_plus_database_quota [2012/01/09 13:17] aseques [Adapt postfix master.cf] |
start:howto:dovecot_plus_database_quota [2012/01/09 14:35] aseques |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | **__ALERT: This is a document being rewritten, only experienced people should use this__** | + | **__ALERT: This document is currently being rewritten, only experienced people should use this__** |
| ====== Dovecot modifications from default imscp install ====== | ====== Dovecot modifications from default imscp install ====== | ||
| Line 32: | Line 32: | ||
| ===== Optional features ===== | ===== Optional features ===== | ||
| + | ==== Sieve filtering ==== | ||
| Create the sieve script to redirect spam to junk folder | Create the sieve script to redirect spam to junk folder | ||
| **/etc/dovecot/sieve/dovecot.sieve** | **/etc/dovecot/sieve/dovecot.sieve** | ||
| - | If you have a spam filter such as amavis, it will add the header "X-Spam-Flag = yes", with this little sieve all this mail will go to Junk folder in webmail. Very practical because all the users can check their own spam without the need of the server admin. | + | If you have a spam filter such as amavis, it will add the header "X-Spam-Flag = yes", with this little sieve script all this mail will go to Junk folder (can be seen both in webmail or any IMAP client). It's really usefull because all the users can check their own spam without the need of the server admin. |
| mkdir /etc/dovecot/sieve | mkdir /etc/dovecot/sieve | ||
| Line 52: | Line 52: | ||
| - | Set correct permissions for dovecot.conf (the deliver command accesses this file too) | + | Set correct permissions for dovecot.conf (the deliver command will access this file too) |
| chmod 0644 /etc/dovecot/dovecot.conf | chmod 0644 /etc/dovecot/dovecot.conf | ||
| - | |||
| ==== Use domain alias as mail alias too ==== | ==== Use domain alias as mail alias too ==== | ||
| + | |||
| Making a small change in postfix configuration, we can use the domain alias as a mail ailas. | Making a small change in postfix configuration, we can use the domain alias as a mail ailas. | ||
| Being example2.com an alias of example1.com, whenever I create a mailbox in example1.com the same mailbox in example2.com becomes a redirection. | Being example2.com an alias of example1.com, whenever I create a mailbox in example1.com the same mailbox in example2.com becomes a redirection. | ||
| Line 126: | Line 126: | ||
| For more information about this have a look at http://wiki.dovecot.org/Quota/1.1 | For more information about this have a look at http://wiki.dovecot.org/Quota/1.1 | ||
| - | |||
| ===== Frequent issues ===== | ===== Frequent issues ===== | ||
| Line 149: | Line 148: | ||
| 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 ===== | + | ===== Older documentation (pending to be purged) ===== |
| - | + | ||
| - | + | ||
| - | === 1. Create a new table in ispcp called quota_dovecot === | + | |
| - | + | ||
| - | This will create also the database to store quota | + | |
| - | mysql -u root -p mysql | + | |
| - | mysql> USE ispcp; | + | |
| - | mysql> CREATE TABLE quota_dovecot ( | + | |
| - | username varchar(100) not null, | + | |
| - | bytes bigint not null default 0, | + | |
| - | messages integer not null default 0, | + | |
| - | primary key (username) | + | |
| - | ); | + | |
| - | + | ||
| - | === 2. Granting permissions to the sql user === | + | |
| - | + | ||
| - | mysql> GRANT SELECT,INSERT,UPDATE ON imscp.quota_dovecot to 'ispcp_dovecot'@'localhost' | + | |
| - | mysql> FLUSH PRIVILEGES; | + | |
| - | mysql> QUIT; | + | |
| === 4. Configure Dovecot === | === 4. Configure Dovecot === | ||
/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
