From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from lists.gentoo.org ([140.105.134.102] helo=robin.gentoo.org) by nuthatch.gentoo.org with esmtp (Exim 4.62) (envelope-from ) id 1H3cQO-0005z7-Tx for garchives@archives.gentoo.org; Sun, 07 Jan 2007 18:07:17 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.13.8/8.13.8) with SMTP id l07I6sMU026838; Sun, 7 Jan 2007 18:06:54 GMT Received: from smtp.gentoo.org (smtp.gentoo.org [140.211.166.183]) by robin.gentoo.org (8.13.8/8.13.8) with ESMTP id l07I6r99011419 for ; Sun, 7 Jan 2007 18:06:53 GMT Received: from lark (lark.gentoo.osuosl.org [140.211.166.177]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by smtp.gentoo.org (Postfix) with SMTP id 74ED764916 for ; Sun, 7 Jan 2007 18:06:52 +0000 (UTC) Received: by lark (sSMTP sendmail emulation); Sun, 7 Jan 2007 18:06:34 +0000 From: "Josh Saddler" Date: Sun, 7 Jan 2007 18:06:34 +0000 To: gentoo-doc-cvs@lists.gentoo.org Subject: [gentoo-doc-cvs] cvs commit: mailfilter-guide.xml Message-Id: <20070107180652.74ED764916@smtp.gentoo.org> Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-doc-cvs@gentoo.org Reply-to: docs-team@lists.gentoo.org X-Archives-Salt: 5982ab2e-633c-48e8-80ca-fbd175666657 X-Archives-Hash: c9b8709950e47e7b9bf3ae3724f2f769 nightmorph 07/01/07 18:06:34 Modified: mailfilter-guide.xml Log: mailfilter guide updates, with much thanks to Francesco Riosa (vivo) for patches and review Revision Changes Path 1.17 xml/htdocs/doc/en/mailfilter-guide.xml file : http://sources.gentoo.org/viewcvs.py/gentoo/xml/htdocs/doc/en/mailfilter-guide.xml?rev=1.17&view=markup plain: http://sources.gentoo.org/viewcvs.py/gentoo/xml/htdocs/doc/en/mailfilter-guide.xml?rev=1.17&content-type=text/plain diff : http://sources.gentoo.org/viewcvs.py/gentoo/xml/htdocs/doc/en/mailfilter-guide.xml?r1=1.16&r2=1.17 Index: mailfilter-guide.xml =================================================================== RCS file: /var/cvsroot/gentoo/xml/htdocs/doc/en/mailfilter-guide.xml,v retrieving revision 1.16 retrieving revision 1.17 diff -u -r1.16 -r1.17 --- mailfilter-guide.xml 10 Dec 2006 04:51:21 -0000 1.16 +++ mailfilter-guide.xml 7 Jan 2007 18:06:34 -0000 1.17 @@ -1,6 +1,6 @@ - + @@ -23,8 +23,8 @@ -0.10 -2006-05-22 +0.11 +2007-01-07 Introduction @@ -292,10 +292,13 @@ -The smtp-amavis line specifies that a maximum of two of these -processes may run at any time. If you need a greater degree of -concurrency tune this number to fit your needs. Remember that to match -the number with $max_servers in amavisd.conf +The smtp-amavis line specifies that a maximum of two of these processes +may run at any time. If you need a greater degree of concurrency tune this +number to fit your needs. Remember that to match the number with +$max_servers in amavisd.conf. Keep in mind that +amavisd-new is quite memory-intensive and raising the amount of +amavisd-new processes too high can easily lead to memory starvation and +heavy swapping, which leads to drastically reduced performance. @@ -1635,7 +1638,7 @@ Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> create database maildb; -mysql> GRANT ALL PRIVILEGES ON maildb.* TO 'mail'@'localhost' IDENTIFIED BY 'very_secret_password'; +mysql> GRANT INSERT,UPDATE,DELETE,SELECT ON maildb.* TO 'mail'@'localhost' IDENTIFIED BY 'very_secret_password'; mysql> use maildb; @@ -1809,9 +1812,10 @@

-As of Spamassassin 3.0 it is possible to store the Bayes and AWL -data in a MySQL database. Here I will show how to easily -accomplish this. +As of Spamassassin 3.0 it is possible to store the Bayes and AWL data in a MySQL +database. We will use MySQL as the backend as it can generally outperform other +databases. Also, using MySQL for both sets of data makes system management much +easier. Here I will show how to easily accomplish this.

@@ -1827,7 +1831,7 @@ Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> create database dbname; -mysql> GRANT ALL PRIVILEGES ON dbname.* TO 'dbuser'@'localhost' IDENTIFIED BY 'another_very_secret_password'; +mysql> GRANT INSERT,UPDATE,DELETE,SELECT ON dbname.* TO 'dbuser'@'localhost' IDENTIFIED BY 'another_very_secret_password'; mysql> use dbname; @@ -1920,28 +1924,36 @@ -Note that the last step should only be performed after the MySQL database -and local.cf has been updated. +Note that the last step should only be performed after the MySQL database and +secrets.cf have been updated.

Now give Spamassassin the required info:

-
-(Tell Spamassissin to use MySQL for bayes data
+
+(Tell Spamassassin to use MySQL for bayes data
 bayes_store_module              Mail::SpamAssassin::BayesStore::SQL
 bayes_sql_dsn                   DBI:mysql:sa_bayes:localhost:3306
 bayes_sql_username              db_name
 bayes_sql_password              another_very_secret_password
 
-(Tell Spamassissin to use MySQL for AWL data
+(Tell Spamassassin to use MySQL for AWL data
 auto_whitelist_factory          Mail::SpamAssassin::SQLBasedAddrList
 user_awl_dsn                    DBI:mysql:sa_bayes:localhost:3306
 user_awl_sql_username           db_name
 user_awl_sql_password           another_very_secret_password
 

 
+

+Next, change its permissions for proper security:
+

+
+
+# chmod 400 /etc/mail/spamassassin/secrets.cf
+

+
 
 To create a very secret password use emerge
 app-admin/makepasswd and makepasswd -chars=8



-- 
gentoo-doc-cvs@gentoo.org mailing list