This shows you the differences between two versions of the page.
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(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 === |