[Dovecot] postfix mysql quota map to dovecot dict in mysql

[Robert Schetterer]

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