Spamassassin configuration files not working

[Jimmi]

 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