On 9/14/2015 2:24 PM, Jeremy Harris wrote:
> On 14/09/15 12:05, Marius Stan wrote:
>> warn authenticated = *
>> ratelimit = ${lookup mysql{Q_RATELIMIT}} / 1h / strict /
>> $authenticated_id
>> log_message = Authenticated sender rate $authenticated_id
>> $authenticated_sender $sender_rate / $sender_rate_period
> So what is Q_RATELIMIT? And what ends up in the ratelimit db?
Q_RATELIMIT is a mysql query thet yelds 30 as a result. That would mean
a message every 2 minutes, which should be sufficient for most cases.
Q_RATELIMIT=SELECT rate FROM mxauth \
WHERE username='${quote_mysql:${local_part:$authenticated_id}}' \
AND domain = '${quote_mysql:${domain:$authenticated_id}}' \
LIMIT 1
I tried looking into the db, but all I could see were some kind of hashes ?
# db_dump ratelimit
VERSION=3
format=bytevalue
type=hash
h_nelem=244
db_pagesize=4096
HEADER=END
31682f7065725f6d61696c2f6175746f7363616e40617365736f66742e726f00
fd8ff655000000000ee903000000000005f3c9355dfd2140
31682f7065725f6d61696c2f63617269657265403336307265766f6c7574696f6e2e726f00
897bf65500000000dba00d0000000000000000000000f03f
[... & so on ...]
