Mysql – Spamassassin: store bayes per user in thesql (with amavis)

amavisMySQLpostfixspamassassin

I use postfix (mysql virtual users) + amavis + spamassassin and configured spamassassin to use mysql for storing the bayes data:

use_bayes                       1
bayes_auto_learn                1

bayes_store_module              Mail::SpamAssassin::BayesStore::MySQL
bayes_sql_dsn                   DBI:mysql:<db>:localhost
bayes_sql_username              <user>
bayes_sql_password              <password>

In the mysql table "bayes_vars" I found only a row with the username "amavis".

Is it possible for spamassassin to use the e-mail address as username instead "amavis" for each mail?

Best Answer

Yes, you could use sa_username_maps to split it up.

Related Solutions

Stop Outgoing Spam Already Tagged as Spam

You can delete emails with a particular tag in header.

See Postfix Header Checks Man page for details.

Example:

In "/etc/postfix/main.cf", add

header_checks = regexp:/etc/postfix/header_checks

In "/etc/postfix/header_checks", have

/^(Subject: \[SPAM\])(.+)$/ DISCARD

The above will discard all emails whose Subject starts with "[SPAM]".

EDIT: I only wish to delete the messages that are both spam AND being forwarded to other servers. I don't want to delete all mails marked as spam. Is there a way to distinguish between the two?

This could be done by running two instances within Postfix. The first instance will forward the email to second instance (instead of to Remote email server). The same can be achieved by specifying a local transport.

The second instance will have the above header_checks. This way only emails to remote server will have their SPAM deleted.

Some references:

Specifying Transport
You can run multiple instances of Postfix by specifying additional entries in master.cf file. Details here

Linux – SA with or without amavis-new – whats faster

is it ever possible to force SA and amavis to use database?

It should be since the 2.7.0 version of Amavisd-new which introduces the @sa_userconf_maps configuration parameter. From the Amavisd-new release notes:

SpamAssassin will be requested to load a user preferences configuration through its read_scoreonly_config() or load_scoreonly_sql() method, which otherwise (in spamd) serves to load user's .spamassassin/user_prefs file or SQL preferences when switching users. See SpamAssassin documentation file sql/README for SQL details.

[...]

Example:

@sa_userconf_maps = (
  { 'user1@example.com' =>
      '/etc/mail/spamassassin/special_user_config',
    '.example.org' => 'sql:',
  }
);

If not, what will be performace influence when i drop amavis and use SA directly with postfix?

Spamassassin/spamd would be able to filter mail, but Amavisd-new does a lot more than that. Your impact would not be not so much performance-wise (since Amavisd-new does just invoke the appropriate SpamAssassin functions, similar to what spamd is doing too) but you would lose Amavisd-new specific functionality like the lovers maps, the destiny configurations, the antivirus scanner integration, the attachment file type recognition, ...

Best Answer

Related Solutions

Stop Outgoing Spam Already Tagged as Spam

Linux – SA with or without amavis-new – whats faster

Related Topic