Re: User_prefs

i've made it ... with exim_acl + spamd +sql user_prefs...

*********local.cf**************

rewrite_subject                 1
report_safe                     1
user_scores_dsn                 DBI:mysql:courier_mail:localhost
user_scores_sql_username        <user>
user_scores_sql_password	<passw>
user_scores_sql_table           userprefs
rewrite_subject                 1
ok languages                    en de
allow_user_rules                1	<<<<<<<<a must !!!
timelog_path                    /var/spool/spamassasin
dcc_add_header                  1
use_terse_report                1

************exim.conf snipplet*************
exim configurated for use with mysql ...

SPAM_CHECK_USER=select spam_check from virtual_users where 
spam_check='yes' and address='${quote_mysql:$acl_m0}'

in acl_check_rcpt :

	set acl_m0    = $local_part@$domain
         set acl_m1    = $domain

...thats because $local_part and $domain are only available in 
acl_check_rcpt.... not in acl_check_content.....

in acl_check_content i wrote :

warn message = X-Spam-Report: $spam_report
       condition = ${if <{$message_size}{80k}{1}{0}}
            spam = $acl_m0
       condition = ${if eq {}{${lookup mysql 
{SPAM_CHECK_USER}}}{false}{true}}

    warn message = X-Spam-Score : $spam_score ($spam_bar)
            spam = $acl_m0
       condition = ${if eq {}{${lookup mysql 
{SPAM_CHECK_USER}}}{false}{true}}


the main thing is that spam is set to the full user email-adress which 
is in my db stored (as username replacement) ...





Marc MERLIN wrote:
> On Sun, Jul 06, 2003 at 05:00:47PM -0500, Ben Story wrote:
> 
>>First I'd like to thank all of the developers for making an excellent
>>product.  My managers have asked me to find out if I can make sa-exim use
>>individual user_pref information for Spam Assassin from the SA sql storage
>>method.  I noticed some chatter in the archives about this last month, but I
>>was wondering if anyone has come up with a preferred way to do this.
> 
> 
> The short answer is "no"
> 
> It is doable with exim ACL kludgery (see a message I posted about this),
> but no one has done it yet
> 
> Marc