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: [email protected]
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
--------------------------------------------------------
