Sorry for this misunderstanding, but I meant: Can I use score tables for spam_checks, something like this ?<br><br><br><div>------+-----------------+-----------+------------------------------------ +----------------------+<br>
| id | address | rule | score | <br>
+----+-------------------------------+----------------------------------- +---------------------+ <br>
| 1 | <a href="mailto:kristoffer@nextnet.no" target="_blank">kristoffer@nextnet.no</a> | FSL_RU_URL | 1 2 2 2 | <br>
+----+-------------------------------+----------------------------------- +---------------------+</div><div>| | | | | <br>
| 2 | <a href="mailto:kristoffer@nextnet.no" target="_blank">test@example.com</a> | OCR_WRONG_CTYPE | 1 1.5 1.2 2 | <br>
+----+-------------------------------+-----------------------------------+--------------------- +</div>And if I understood you correctly, I can force SA to use any set of parameters, with sql_select_policy, ( for example enable\disable rbl checks) with just changing select policy from this:<br>
sql_select_policy =<br>
"SELECT id, NULL as spam_tag_level, spam_tag2_level, ".<br>
" spam_kill_level, spam_kill_level as spam_dsn_cutoff_level, ".<br>
" spam_modifies_subj, spam_subject_tag as spam_subject_tag2, ".<br>
" 'Y' as local ".<br>
" from amavis ".<br>
" where address IN (%k)";<br>
to this:<br>
sql_select_policy =<br>
"SELECT id, NULL as spam_tag_level, spam_tag2_level, ".<br>
" spam_kill_level, spam_kill_level as spam_dsn_cutoff_level, ".<br>
" spam_modifies_subj, spam_subject_tag as spam_subject_tag2, SKIP_RBL_CHECKS,SCORE_SET".<br>
" 'Y' as local ".<br>
" from amavis ".<br>
" where address IN (%k)";<br> <br><br><div class="gmail_quote">2011/3/14 Sergey Levchenko <span dir="ltr"><<a href="mailto:kazak.sergey72@gmail.com" target="_blank">kazak.sergey72@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi list, can Amavis use MySQL-based score-tables for SpamAssassin and how to do this ?<br>
</blockquote></div><br>