On Fri, 13 May 2011 15:04:50 +0200, Mark Martinec wrote:
Yes, most of these features (not all). As per amavis release notes:

According to SpamAssassin documentation, a user preferences file or SQL preferences can include scoring options, scores, whitelists and blacklists, etc. If 'allow_user_rules' is enabled (local.cf), then user preferences file can also include rule definitions and privileged settings - but not
  administrator settings.

This is a standard SpamAssassin feature, it's just that an interface
to it was not available from amavisd. See files sql/README and
sql/userpref_mysql.sql in the SpamAssassin standard distribution.

Mark, sorry but something is unclear here. In your previous post you wrote:

That is correct: SpamAssassin can use SQL for AWL and Bayes,
SQL-based preferences as implemented by SpamAssassin
are NOT implemented

In my server i created the userpref table using sql/userpref_mysql.sql, the content of which is:
+--------------------+------------------------+---------------+
| username           | preference             | value         |
+--------------------+------------------------+---------------+
| $GLOBAL            | rewrite_header Subject | [***SPAM***]  |
| $GLOBAL            | use_bayes              | 1             |
| $GLOBAL            | use_pyzor              | 1             |
| $GLOBAL            | report_safe            | 0             |
| jimmi@********.net | blacklist_from         | *@spam.com    |
| $GLOBAL            | use_razor2             | 1             |
| $GLOBAL            | score RAZOR2_CHECK     | 2.500         |
| $GLOBAL            | ok_languages           | en it         |
| $GLOBAL            | ok_locales             | en it         |
| $GLOBAL            | skip_rbl_checks        | 0             |
| $GLOBAL            | bayes_auto_learn       | 1             |
| $GLOBAL            | bayes_auto_expire      | 0             |
| $GLOBAL            | required_score         | 5.0           |
| $GLOBAL            | use_dcc                | 0             |
+--------------------+------------------------+---------------+

All of them are working with spamd, but I have evidence that at least required_score, blacklist_from, ok_languages, ok_locales (on top of rewrite_header Subject) are not working. After discussing here I supposed that none of them were working, but I will do some additional test now.
--
jimmi

Reply via email to