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 11:36] aseques |
start:howto:dovecot_plus_database_quota [2012/01/09 11:51] aseques |
||
|---|---|---|---|
| Line 3: | Line 3: | ||
| ====== Dovecot modifications from default imscp install ====== | ====== Dovecot modifications from default imscp install ====== | ||
| This is an improved version from the original article in ispcp (http://isp-control.net/documentation/howto:mail:replace_courier_with_dovecot) | This is an improved version from the original article in ispcp (http://isp-control.net/documentation/howto:mail:replace_courier_with_dovecot) | ||
| - | I stripped all the parts related to the default install (imscp already takes care of that) and focus to the functionality that is available only on doecot (instead of courier). | + | All the parts related to the default install where removed since imscp already takes care of that, and it's focused to add the functionality that is available only on dovecot (instead of courier). |
| - | ===== The improvements from the original document ===== | + | ===== Changes from standard dovecot in imscp ===== |
| - | * Quotas are stored on database so they will be shown from the control panel | + | * Quotas are stored on database so they can be shown from the control panel |
| - | * Required dovecot version is now 1.2 (almost everything could be done in 1.1 but with 1.2 it's easier and cleaner) | + | * Required dovecot version is now 1.2 (squeeze's default) |
| - | * Filtering is enabled by default | + | * Filtering is enabled by default (to archive spam) |
| - | * Following the installation is easier now. | + | |
| ===== Reasons to use dovecot ===== | ===== Reasons to use dovecot ===== | ||
| Line 23: | Line 22: | ||
| http://forum.i-mscp.net/showthread.php?tid=61 | http://forum.i-mscp.net/showthread.php?tid=61 | ||
| - | **NOTE:** i-MSCP is already assigning 10MB quota to each mail account created, but currently it is not editable by default (ticket #2219). To be able to edit the quota from the control panel you will have to follow this thread, as a bonus you will see the current values. | + | **NOTE:** There are currently no means to configure the quota for imscp other than fiddling with the database. The functionality from http://www.isp-control.net/forum/thread-8483.html should be imported. |
| - | http://www.isp-control.net/forum/thread-8483.html | + | |
| **NOTE:** If you want to edit the quota directly; it is stored in bytes in the table "mail_users" in a field named "quota". | **NOTE:** If you want to edit the quota directly; it is stored in bytes in the table "mail_users" in a field named "quota". | ||
| - | |||
| - | ===== Prerequisites ===== | ||
| ===== Replace Courier with Dovecot ===== | ===== Replace Courier with Dovecot ===== | ||
| Line 47: | Line 43: | ||
| ); | ); | ||
| | | ||
| - | ==== 2. Add sql user ==== | + | ==== 2. Granting permissions to the sql user ==== |
| - | mysql -u root -p mysql | + | |
| - | mysql> GRANT SELECT ON ispcp.* to 'ispcp_dovecot'@'localhost' identified by 'PASS_MAILRW'; | + | mysql> GRANT SELECT,INSERT,UPDATE ON imscp.quota_dovecot to 'ispcp_dovecot'@'localhost' |
| - | mysql> GRANT SELECT,INSERT,UPDATE ON ispcp.quota_dovecot to 'ispcp_dovecot'@'localhost' | + | |
| mysql> FLUSH PRIVILEGES; | mysql> FLUSH PRIVILEGES; | ||
| - | mysql> quit; | + | mysql> QUIT; |
| ==== 4. Configure Dovecot ==== | ==== 4. Configure Dovecot ==== | ||
| - | |||
| Replace /etc/dovecot/dovecot.conf with the following one (you should backup the original because there are a lot of comments in it explaining all the configuration parameters). | Replace /etc/dovecot/dovecot.conf with the following one (you should backup the original because there are a lot of comments in it explaining all the configuration parameters). | ||
| Line 279: | Line 273: | ||
| 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} | ||
| </code> | </code> | ||
| - | |||
| - | ==== 6. Migrate existing maildirs ==== | ||
| - | |||
| - | If you are using existing maildirs which were accessed by courier you have to migrate the maildirs. | ||
| - | This can be easily done with the courier-dovecot-migrate.pl script from http://wiki.dovecot.org/Migration/Courier Be sure to pick the one that corresponds with your Dovecot version. | ||
| ==== 7. Enable SSL support ==== | ==== 7. Enable SSL support ==== | ||
/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
