Wilberth Pérez
2010-Mar-16 23:15 UTC
[Dovecot] how configure quotas with dovecot and mysql databases
some one knows, how to configure quotas with dovecot and mysql databases ?
my dovecot was compiled with:
CPPFLAGS=-I/opt/mysql/include/mysql LDFLAGS=-L/opt/mysql/lib/mysql ./
configure --with-sql --with-mysql
and my dovecot.conf and dovecot-sql.conf have the following configurations:
==========dovecot.conf
==========protocol imap {
listen = *:143
mail_plugins = quota imap_quota
}
protocol pop3 {
listen = *:110
mail_plugins = quota
}
plugin {
quota = maildir:storage=30M
quota_rule = *:storage=30M
quota_warning = storage=95%% /usr/local/bin/quota-warning.sh 95
quota_warning2 = storage=80%% /usr/local/bin/quota-warning.sh 80
}
===========dovecot-sql.conf
===========driver = mysql
connect = host=localhost dbname=mail user=mail password=mail
user_query = SELECT 1 AS gid, concat('maildir:storage= ', quota_kb)
AS quota
FROM users WHERE user = 'testuser';
I test my configuration and don't show errors , however, dovecot never
show me my quota configuration.
I will be omitting something ?
Cheers.
--
--------------------------------------------------------
LCC Wilberth de Jes?s P?rez Segura CCSA- Administraci?n de Servicios y Seguridad
de las TI
Correo: wilberth.perez at uady.mx
Universidad Aut?noma de Yucat?n
Secretar?a General
Coordinaci?n Administrativa de Tecnolog?as de Informaci?n
RIUADY
C-59 x Av. Itz?es (999)923-74-28 Ext. 1117
M?rida, Yucat?n, M?xico 2010
--------------------------------------------------------
