On Sun, 2013-12-01 at 12:56 +0100, Gino Semseo wrote: > > That's huge and rather excessive for whitelisting configuration. Are > > there really 100k+ options, or does that include empty lines and > > comments? > > > > No... each line, is a mail address.. > > > > What conf does it contain: whitelist_* options, or other styles of > > whitelisting? > > Do not understand your question... mmmm... the whitelist is just for > "whitelist_from" values for SA... and included at local.cf... > > Now I have reduced to 127000 addresses, but I can tell you I were > running almost 170000 rules without this problem time ago.. > ...... > > The whitelist is created every night from bash scripting and mysql > database... it contains the: > a) destinations from real emails sended from the server daily b) > emails whitelisted because users did include them... > WHY?
It its probably more efficient to write a plugin to query the mysql database directly and will certainly eliminate the need to stop and restart SA each time a new version of the whitelist is creates and well as getting rid of the delay between adding a new address to the database and making the updated whitelist available to SA. Martin
