Hi
I want use SpamAssassin 3.0.4 with Sql for put a personalized Tag.
I run spamd with daemontools :
/usr/bin/spamd -q -x -c -m5 -H
i don't have information into local.cf
my sql.cf:
user_scores_dsn DBI:mysql:SpamAssassin:localhost
user_scores_sql_username SpamAssassin
user_scores_sql_password XXXXXXX
user_scores_sql_custom_query SELECT preference,value from userpref
WHERE username = _USERNAME_ OR username = '$GLOBAL' OR username =
CONCAT('%',_DOMAIN_) ORDER BY username ASC
The access to the database work (tested in local)
Table:
mysql> select * from userpref;
+-----------------------+--------------------------------+----------------------------------------+--------+
| username | preference |
value | prefid |
+-----------------------+--------------------------------+----------------------------------------+--------+
| $GLOBAL | required_hits |
4.9 | 1 |
| $GLOBAL | subject_tag |
*****SPAM***** | 2 |
| $GLOBAL | rewrite_header Subject |
*****SPAM***** | 3 |
| $GLOBAL | score USER_IN_WHITELIST |
-150 | 4 |
| $GLOBAL | score USER_IN_BLACKLIST |
150 | 5 |
| $GLOBAL | report_safe |
1 | 6 |
| $GLOBAL | use_razor2 |
0 | 7 |
| $GLOBAL | ok_locales | en
fr | 8 |
| $GLOBAL | ok_languages | en
fr | 9 |
| $GLOBAL | skip_rbl_checks |
0 | 10 |
| $GLOBAL | use_auto_whitelist |
1 | 11 |
| $GLOBAL | auto_whitelist_path |
/var/spool/spamassassin/auto-whitelist | 12 |
| $GLOBAL | auto_whitelist_file_mode |
0666 | 13 |
| $GLOBAL | whitelist_from |
[EMAIL PROTECTED] | 14 |
| $GLOBAL | blacklist_from |
[EMAIL PROTECTED] | 15 |
| $GLOBAL | rewrite_subject |
1 | 16 |
| $GLOBAL | defang_mime |
1 | 17 |
| $GLOBAL | use_terse_report |
0 | 18 |
| $GLOBAL | dns_available |
yes | 19 |
| $GLOBAL | bayes_auto_learn |
1 | 20 |
| $GLOBAL | bayes_auto_learn_threshold_non |
0.5 | 21 |
| $GLOBAL | bayes_auto_learn_threshold_spa |
7.5 | 22 |
| %mydomain.com | required_hits |
5.0 | 23 |
| %mydomain.com | subject_tag |
***NON-SOLLICITE***UNSOLICITED*** | 24 |
| %mydomain.com | rewrite_header Subject |
***NON-SOLLICITE***UNSOLICITED*** | 25 |
when i start in debug, i don't see sql errors ...
But when mydomain.com receive a email, the required_hits are at 4.9 and
not 5.0 and the tag are
****SPAM**** ...
anyone can help me for understand why that's don't work ?
Thanks bye
