Paulo Andre wrote: > Renaud Allard wrote: >> Paulo Andre wrote: >> >>> Can someone please suggest a greylisting solution for exim with a >>> MySQL backend. >>> >>> >> >> I use this one slightly modified: >> http://www.slett.net/spam-filtering-for-mx/exim-greylisting.html#exim-greylist-mysql >> >> It works quite well with multi master MySQL replicas. >> >> > > Hi Renaud, I was using this system for quiet sometime and found that as > the database got bigger, then exim would use all connections to the > database, break other solutions. I tried increasing max connections and > it still did not help. I think that the problem would most likely be a > db issue, and obviously not to do with this list. For this greylisting > do you delete all the 'old' entries? >
To delete old entries, I just added this line in the defined macros:
GREYLIST_CLEAN = DELETE FROM GREYLIST_TABLE WHERE now() > record_expires
And I run it from time to time with:
warn condition = ${lookup mysql{GREYLIST_CLEAN}}
But you could also schedule this in a crontab of course.
You can easily increase the number of allowed connections by just
setting this in your my.cnf: "set-variable = max_connections=2048"
smime.p7s
Description: S/MIME Cryptographic Signature
-- ## List details at http://www.exim.org/mailman/listinfo/exim-users ## Exim details at http://www.exim.org/ ## Please use the Wiki with this list - http://www.exim.org/eximwiki/
