Book Image

SpamAssassin: A practical guide to integration and configuration

Book Image

SpamAssassin: A practical guide to integration and configuration

Overview of this book

As a busy administrator, you know Spam is a major distraction in todays network. The effects range from inappropriate content arriving in the mailboxes up to contact email addresses placed on a website being deluged with unsolicited mail, causing valid enquiries and sales leads to be lost and wasting employee time. The perception of the problem of spam is as big as the reality. In response to the growing problem of spam, a number of free and commercial applications and services have been developed to help network administrators and email users combat spam. Its up to you to choose and then get the most out of an antispam solution. Free to use, flexible, and effective, SpamAssassin has become the most popular open source antispam application. Its unique combination of power and flexibility make it the right choice. This book will now help you set up and optimize SpamAssassin for your network.
Table of Contents (24 chapters)
SpamAssassin
Credits
About the Author
About the Reviewers
Introduction
Glossary

Using SQL


SpamAssassin uses local databases for each user by default in the ~/.spamassassin directory. There are three types of databases: user preferences, the auto-whitelist, and the Bayesian database. SpamAssassin can use an SQL database to store any or all of these details.

When using SpamAssassin in a distributed environment where SpamAssassin may be run from one of many machines, using a single SQL database is an ideal solution. Using a centralized database also assists in centralized backup of the preferences, and gives the administrators the opportunity to modify many accounts easily.

SpamAssassin uses the modularity of Perl that allows the usage of different databases to be used without any changes to the application. SpamAssassin has been tested with MySQL, PostgreSQL, and SQLite. Due to the nature of the Perl database interface, most relational databases that are supported by Perl will work with SpamAssassin. The database driver modules are available on CPAN and have names beginning...