Glenn wrote: > Martin Svensson said the following on 1/9/2006 5:44 AM: >> Remove the big evil rules and move the Bayes DB to a Mysql database >> and amavisd/SA will really perform! :) > Some questions...
> I've been running Postfix+Procmail+Amavisd-new+SA for a while now... > Since setting up the server, I've set up PostfixAdmin and a couple of > virtual domains (for myself and friends). > Right now I'm running SA through procmail (spamd/c), and I'd like to > switch over to running through Amavisd-new with a MySQL backend. > Searching for HOWTOs has been disheartening and the HOWTOs seem to very > lamely go "Oh I just loaded Spamassassin..." instead of any real *meat* > to the article. > So my questions are: > 1) How many nights/weekends am I going to sacrifice trying to get SA to > work with a MySQL backend along with importing the old user_prefs? Where > can I find decent documentation for this switch? See if this at least gives you a start on the project: http://marc.theaimsgroup.com/?l=amavis-user&m=113479225731661&w=2 http://www.ijs.si/software/amavisd/amavisd-new-docs.html#score_sender also helps explain SQL w/b lists. Keep in mind not all user_prefs settings will carry over. The most critical will, the ones shown in the SQL fields. > 2) Does anyone run Procmail on their virtual accounts? If so, could you > point me in the right direction? This is something where the results on > Google have been less than stellar :-/ > 3) Running SA through Amavisd-new is probably going to hurt. A lot. > (performance/memory-wise) Any suggestions on how to make this less-painful? Since amavisd-new only calls SA once for a given message regardless of the number recipients, and it has the ability to cache previous results for messages with identical body, it is often more efficient than spamc/spamd. The amount of memory used is controllable, but should be tuned to match the power of your CPU(s) and throughput needs. > This is on a FreeBSD 4.11-RELEASE box, running: > postfix-2.2.8 > SA 3.1.0_5 > pyzor-0.4.0_3 > razor-agents-2.77 > amavisd-new-2.3.3_1 > Thanks in advance, > Best, > --Glenn Gary V ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click _______________________________________________ AMaViS-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
