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 Both sides next revision
start:howto:dovecot_plus_database_quota [2012/01/09 13:58]
aseques
start:howto:dovecot_plus_database_quota [2012/01/09 14:35]
aseques
Line 148: 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(100not 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