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

On Friday, August 10, 2012 at 15:18:07 UTC, me@junc.org confabulated:

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

No need to CONCAT when you are not concatenating anything. Just:

SELECT 'DEFER_IF_PERMIT Quotas Exceeded' FROM quota ...

# /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

-- If at first you don't succeed... ...so much for skydiving.