IRedMail/FAQ/Store.SpamAssassin.Bayes.In.SQL - Revision history

ZhangHuangbin: /* Enable Bayes modules in SpamAssassin */

ZhangHuangbin — Sat, 09 Jun 2012 13:57:16 GMT

Enable Bayes modules in SpamAssassin

← Older revision		Revision as of 13:57, 9 June 2012
Line 60:		Line 60:
	# Store bayesian data in MySQL		# Store bayesian data in MySQL
	bayes_store_module Mail::SpamAssassin::BayesStore::MySQL		bayes_store_module Mail::SpamAssassin::BayesStore::MySQL
-	bayes_sql_dsn DBI:mysql:sa_bayes:127.0.0.1:~~3006~~	+	bayes_sql_dsn DBI:mysql:sa_bayes:127.0.0.1:3306

	# Store bayesian data in PostgreSQL		# Store bayesian data in PostgreSQL

ZhangHuangbin — Wed, 16 May 2012 14:45:05 GMT

Enable Roundcube plugin: markasjunk2

← Older revision		Revision as of 14:45, 16 May 2012
Line 172:		Line 172:
	Note: You may get different result number as shown above.		Note: You may get different result number as shown above.

-	So far so good.	+	So far so good. That's all we need to do.
		+
		+	= References =
		+	* [http://wiki.apache.org/spamassassin/BayesInSpamAssassin Bayes Introduction]. Please do read section '''Things to remember'''.
		+	* [http://wiki.apache.org/spamassassin/BayesFaq SpamAssassin Bayes Frequently Asked Questions]

ZhangHuangbin — Wed, 16 May 2012 14:43:19 GMT

Summary

← Older revision		Revision as of 14:43, 16 May 2012
Line 25:		Line 25:
	* The bayesian classifier can only score new messages if it already has 200 known spams and 200 known hams.		* The bayesian classifier can only score new messages if it already has 200 known spams and 200 known hams.
	* If Spamassassin fails to identify a spam, teach it so it can do better next time. e.g. Mark it as spam in roundcube webmail.		* If Spamassassin fails to identify a spam, teach it so it can do better next time. e.g. Mark it as spam in roundcube webmail.
		+	* Read '''References''' section at the end of this article before asking.

	= Create required SQL database used to store bayes data =		= Create required SQL database used to store bayes data =

ZhangHuangbin — Wed, 16 May 2012 14:42:16 GMT

Summary

← Older revision		Revision as of 14:42, 16 May 2012
Line 24:		Line 24:

	* The bayesian classifier can only score new messages if it already has 200 known spams and 200 known hams.		* The bayesian classifier can only score new messages if it already has 200 known spams and 200 known hams.
		+	* If Spamassassin fails to identify a spam, teach it so it can do better next time. e.g. Mark it as spam in roundcube webmail.

	= Create required SQL database used to store bayes data =		= Create required SQL database used to store bayes data =

ZhangHuangbin — Wed, 16 May 2012 14:40:46 GMT

Summary

← Older revision		Revision as of 14:40, 16 May 2012
Line 20:		Line 20:
	* This article should work with all backends: OpenLDAP, MySQL, PostgreSQL. We take MySQL backend for example.		* This article should work with all backends: OpenLDAP, MySQL, PostgreSQL. We take MySQL backend for example.
	* This article should work with Amavisd-new-2.6.0 and later versions, includes Amavisd-new-2.7.x.		* This article should work with Amavisd-new-2.6.0 and later versions, includes Amavisd-new-2.7.x.
		+
		+	IMPORTANT NOTE:
		+
		+	* The bayesian classifier can only score new messages if it already has 200 known spams and 200 known hams.

	= Create required SQL database used to store bayes data =		= Create required SQL database used to store bayes data =

ZhangHuangbin — Wed, 16 May 2012 14:37:50 GMT

Enable Roundcube plugin: markasjunk2

← Older revision		Revision as of 14:37, 16 May 2012
Line 139:		Line 139:

	[[image:Markasjunk2_toolbar_button.png]]		[[image:Markasjunk2_toolbar_button.png]]
		+
		+	Check SQL database '''sa_bayes''' before we testing this plugin:
		+	{{cmd\|<pre>
		+	# mysql -uroot -p
		+	mysql> USE sa_bayes;
		+	mysql> SELECT COUNT(*) FROM bayes_token;
		+	+----------+
		+	\| count(*) \|
		+	+----------+
		+	\| 65 \|
		+	+----------+
		+	</pre>}}
		+
		+	Back to Roundcube webmail, select a spam email (or a testing email), click "Mark as Junk" button, then this email will be scanned by command '''sa-learn'''. Check database '''sa_bayes''' again to make sure it's working:
		+	{{cmd\|<pre>
		+	# mysql -uroot -p
		+	mysql> USE sa_bayes;
		+	mysql> SELECT COUNT(*) FROM bayes_token;
		+	+----------+
		+	\| count(*) \|
		+	+----------+
		+	\| 143 \|
		+	+----------+
		+	</pre>}}
		+
		+	Note: You may get different result number as shown above.
		+
		+	So far so good.

ZhangHuangbin — Wed, 16 May 2012 14:28:51 GMT

Enable Bayes modules in SpamAssassin

← Older revision		Revision as of 14:28, 16 May 2012
Line 75:		Line 75:
	# amavisd -c /etc/amavisd/amavisd.conf debug 2>&1 \| grep -i 'bayes'		# amavisd -c /etc/amavisd/amavisd.conf debug 2>&1 \| grep -i 'bayes'
	May 16 09:59:33 ... SpamAssassin loaded plugins: ..., Bayes, ...		May 16 09:59:33 ... SpamAssassin loaded plugins: ..., Bayes, ...
-	May 16 10:27:38 ... extra modules loaded after daemonizing/chrooting: Mail/SpamAssassin/BayesStore/MySQL.pm, Mail/SpamAssassin/BayesStore/SQL.pm, ...	+	May 16 10:27:38 ... extra modules loaded after daemonizing/chrooting:
		+	Mail/SpamAssassin/BayesStore/MySQL.pm, Mail/SpamAssassin/BayesStore/SQL.pm, ...
	</pre>}}		</pre>}}
	Looks fine. Now press 'Ctrl-C' to terminate above command.		Looks fine. Now press 'Ctrl-C' to terminate above command.

ZhangHuangbin — Wed, 16 May 2012 14:28:16 GMT

Enable Bayes modules in SpamAssassin

← Older revision		Revision as of 14:28, 16 May 2012
Line 75:		Line 75:
	# amavisd -c /etc/amavisd/amavisd.conf debug 2>&1 \| grep -i 'bayes'		# amavisd -c /etc/amavisd/amavisd.conf debug 2>&1 \| grep -i 'bayes'
	May 16 09:59:33 ... SpamAssassin loaded plugins: ..., Bayes, ...		May 16 09:59:33 ... SpamAssassin loaded plugins: ..., Bayes, ...
		+	May 16 10:27:38 ... extra modules loaded after daemonizing/chrooting: Mail/SpamAssassin/BayesStore/MySQL.pm, Mail/SpamAssassin/BayesStore/SQL.pm, ...
	</pre>}}		</pre>}}
	Looks fine. Now press 'Ctrl-C' to terminate above command.		Looks fine. Now press 'Ctrl-C' to terminate above command.

ZhangHuangbin — Wed, 16 May 2012 14:25:49 GMT

Create required SQL database used to store bayes data

← Older revision		Revision as of 14:25, 16 May 2012
Line 33:		Line 33:
	# mysql -uroot -p		# mysql -uroot -p
	mysql> CREATE DATABASE sa_bayes;		mysql> CREATE DATABASE sa_bayes;
		+	mysql> USE sa_bayes;
	mysql> SOURCE /root/bayes_mysql.sql;		mysql> SOURCE /root/bayes_mysql.sql;
	</pre>}}		</pre>}}
Line 39:		Line 40:
	* Note: Please replace password '''sa_user_password''' by your own.		* Note: Please replace password '''sa_user_password''' by your own.
	{{cmd\|<pre>		{{cmd\|<pre>
-	mysql> GRANT SELECT, INSERT, UPDATE, DELETE ON sa_bayes.* TO sa_user@localhost IDENTIFIED BY 'sa_user_password';	+	mysql> GRANT SELECT, INSERT, UPDATE, DELETE ON sa_bayes.* TO sa_user@localhost IDENTIFIED BY 'sa_user_password';
	mysql> FLUSH PRIVILEGES;		mysql> FLUSH PRIVILEGES;
	</pre>}}		</pre>}}

ZhangHuangbin — Wed, 16 May 2012 14:23:39 GMT

Summary

← Older revision		Revision as of 14:23, 16 May 2012
Line 4:		Line 4:

	= Summary =		= Summary =
-	This article is used to configure related components to store SpamAssassin Bayes data in SQL server.	+	This article is used to configure related components to store SpamAssassin Bayes data in SQL server, and allow webmail users to report spam with one click.

	Tested with:		Tested with:
Line 13:		Line 13:
	* Amavisd-new-2.6.6		* Amavisd-new-2.6.6
	* MySQL-5.1.61		* MySQL-5.1.61
		+	* Roundcubemail-0.7.2

	Notes:		Notes: