[Dovecot] postfix mysql quota map to dovecot dict in mysql
Robert Schetterer
robert at schetterer.org
Fri Aug 10 14:44:18 EEST 2012
Am 10.08.2012 13:03, schrieb Benny Pedersen:
>
> currently dovecot dict is
>
>
> CREATE TABLE IF NOT EXISTS `quota` (
> `username` varchar(100) COLLATE latin1_general_ci NOT NULL,
> `bytes` bigint(20) NOT NULL DEFAULT '0',
> `messages` int(11) NOT NULL DEFAULT '0',
> PRIMARY KEY (`username`)
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
>
>
> there is not field that says how much quota each user have, so one cant
> make a query on how much its left pr user
>
> how can i resolve this in dovecot dict ?
>
> i like to do an postfix mysql map to temp reject if quota is out of limit
>
you may use ideas
out of postfixadmin mysql layout
--
Best Regards
MfG Robert Schetterer
More information about the dovecot
mailing list