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