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

Benny Pedersen me at junc.org
Fri Aug 10 14:03:36 EEST 2012


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

-- 
Benny Pedersen




More information about the dovecot mailing list