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 --------------------------------------------------------