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 |