Gentoo Archives: gentoo-doc-cvs

From: Josh Saddler <nightmorph@×××××××××××.org>
To: gentoo-doc-cvs@l.g.o
Subject: [gentoo-doc-cvs] cvs commit: mailfilter-guide.xml
Date: Sun, 07 Jan 2007 18:07:17
Message-Id: 20070107180652.74ED764916@smtp.gentoo.org
1 nightmorph 07/01/07 18:06:34
2
3 Modified: mailfilter-guide.xml
4 Log:
5 mailfilter guide updates, with much thanks to Francesco Riosa (vivo) for patches and review
6
7 Revision Changes Path
8 1.17 xml/htdocs/doc/en/mailfilter-guide.xml
9
10 file : http://sources.gentoo.org/viewcvs.py/gentoo/xml/htdocs/doc/en/mailfilter-guide.xml?rev=1.17&view=markup
11 plain: http://sources.gentoo.org/viewcvs.py/gentoo/xml/htdocs/doc/en/mailfilter-guide.xml?rev=1.17&content-type=text/plain
12 diff : http://sources.gentoo.org/viewcvs.py/gentoo/xml/htdocs/doc/en/mailfilter-guide.xml?r1=1.16&r2=1.17
13
14 Index: mailfilter-guide.xml
15 ===================================================================
16 RCS file: /var/cvsroot/gentoo/xml/htdocs/doc/en/mailfilter-guide.xml,v
17 retrieving revision 1.16
18 retrieving revision 1.17
19 diff -u -r1.16 -r1.17
20 --- mailfilter-guide.xml 10 Dec 2006 04:51:21 -0000 1.16
21 +++ mailfilter-guide.xml 7 Jan 2007 18:06:34 -0000 1.17
22 @@ -1,6 +1,6 @@
23 <?xml version='1.0' encoding='utf-8'?>
24
25 -<!-- $Header: /var/cvsroot/gentoo/xml/htdocs/doc/en/mailfilter-guide.xml,v 1.16 2006/12/10 04:51:21 nightmorph Exp $ -->
26 +<!-- $Header: /var/cvsroot/gentoo/xml/htdocs/doc/en/mailfilter-guide.xml,v 1.17 2007/01/07 18:06:34 nightmorph Exp $ -->
27
28 <!DOCTYPE guide SYSTEM "/dtd/guide.dtd">
29 <guide link="/doc/en/mailfilter-guide.xml">
30 @@ -23,8 +23,8 @@
31 <!-- See http://creativecommons.org/licenses/by-sa/2.5 -->
32 <license/>
33
34 -<version>0.10</version>
35 -<date>2006-05-22</date>
36 +<version>0.11</version>
37 +<date>2007-01-07</date>
38
39 <chapter>
40 <title>Introduction</title>
41 @@ -292,10 +292,13 @@
42 </pre>
43
44 <note>
45 -The <c>smtp-amavis</c> line specifies that a maximum of two of these
46 -processes may run at any time. If you need a greater degree of
47 -concurrency tune this number to fit your needs. Remember that to match
48 -the number with <c>$max_servers</c> in <path>amavisd.conf</path>
49 +The <c>smtp-amavis</c> line specifies that a maximum of two of these processes
50 +may run at any time. If you need a greater degree of concurrency tune this
51 +number to fit your needs. Remember that to match the number with
52 +<c>$max_servers</c> in <path>amavisd.conf</path>. Keep in mind that
53 +<c>amavisd-new</c> is quite memory-intensive and raising the amount of
54 +<c>amavisd-new</c> processes too high can easily lead to memory starvation and
55 +heavy swapping, which leads to drastically reduced performance.
56 </note>
57
58 <note>
59 @@ -1635,7 +1638,7 @@
60
61 Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
62 mysql> <i>create database maildb;</i>
63 -mysql> <i>GRANT ALL PRIVILEGES ON maildb.* TO 'mail'@'localhost' IDENTIFIED BY 'very_secret_password';</i>
64 +mysql> <i>GRANT INSERT,UPDATE,DELETE,SELECT ON maildb.* TO 'mail'@'localhost' IDENTIFIED BY 'very_secret_password';</i>
65 mysql> <i>use maildb;</i>
66 </pre>
67
68 @@ -1809,9 +1812,10 @@
69 <body>
70
71 <p>
72 -As of Spamassassin 3.0 it is possible to store the Bayes and AWL
73 -data in a MySQL database. Here I will show how to easily
74 -accomplish this.
75 +As of Spamassassin 3.0 it is possible to store the Bayes and AWL data in a MySQL
76 +database. We will use MySQL as the backend as it can generally outperform other
77 +databases. Also, using MySQL for both sets of data makes system management much
78 +easier. Here I will show how to easily accomplish this.
79 </p>
80
81 <p>
82 @@ -1827,7 +1831,7 @@
83
84 Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
85 mysql> <i>create database dbname;</i>
86 -mysql> <i>GRANT ALL PRIVILEGES ON dbname.* TO 'dbuser'@'localhost' IDENTIFIED BY 'another_very_secret_password';</i>
87 +mysql> <i>GRANT INSERT,UPDATE,DELETE,SELECT ON dbname.* TO 'dbuser'@'localhost' IDENTIFIED BY 'another_very_secret_password';</i>
88 mysql> <i>use dbname;</i>
89 </pre>
90
91 @@ -1920,28 +1924,36 @@
92 </pre>
93
94 <note>
95 -Note that the last step should only be performed after the MySQL database
96 -and <path>local.cf</path> has been updated.
97 +Note that the last step should only be performed after the MySQL database and
98 +<path>secrets.cf</path> have been updated.
99 </note>
100
101 <p>
102 Now give Spamassassin the required info:
103 </p>
104
105 -<pre caption="Modifying /etc/mail/spamassassin/local.cf">
106 -<comment>(Tell Spamassissin to use MySQL for bayes data</comment>
107 +<pre caption="Modifying /etc/mail/spamassassin/secrets.cf">
108 +<comment>(Tell Spamassassin to use MySQL for bayes data</comment>
109 bayes_store_module Mail::SpamAssassin::BayesStore::SQL
110 bayes_sql_dsn DBI:mysql:sa_bayes:localhost:3306
111 bayes_sql_username db_name
112 bayes_sql_password another_very_secret_password
113
114 -<comment>(Tell Spamassissin to use MySQL for AWL data</comment>
115 +<comment>(Tell Spamassassin to use MySQL for AWL data</comment>
116 auto_whitelist_factory Mail::SpamAssassin::SQLBasedAddrList
117 user_awl_dsn DBI:mysql:sa_bayes:localhost:3306
118 user_awl_sql_username db_name
119 user_awl_sql_password another_very_secret_password
120 </pre>
121
122 +<p>
123 +Next, change its permissions for proper security:
124 +</p>
125 +
126 +<pre caption="Changing permissions">
127 +# <i>chmod 400 /etc/mail/spamassassin/secrets.cf</i>
128 +</pre>
129 +
130 <note>
131 To create a very secret password use <c>emerge
132 app-admin/makepasswd</c> and <c>makepasswd -chars=8</c>
133
134
135
136 --
137 gentoo-doc-cvs@g.o mailing list