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

[Benny Pedersen]

Den 2012-08-10 13:03, Benny Pedersen skrev:

if others need something like this:

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',
   `quotamax` bigint(20) NOT NULL DEFAULT '0',
   PRIMARY KEY (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

# /etc/postfix/dovecot_quota_maps.cf


user = user
password = password
hosts = localhost
dbname = database
query = SELECT CONCAT('DEFER_IF_PERMIT Quotas Excceded') FROM quota 
WHERE username='%s' AND bytes>=quotamax


# /etc/postfix/main.cf
smtpd_recipient_restrictions =
  check_recipient_access mysql:/etc/postfix/dovecot_quota_maps.cf


enjoy

add to wiki if one could do this