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

10 Aug 2012


      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