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
