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

[Duane Hill]

On Friday, August 10, 2012 at 15:18:07 UTC, me at 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.