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