Issue with per-user bayes filter

[Antoine Nguyen]

Hi all,

I'm still trying to setup per-user bayes filter. The sa-learn part work 
as expected but I encounter difficulties with amavis. I'm using a SQL 
database to store per-user policies. I can see in the logs that amavis 
seems to find the right record and sends the information to spamassassin :

/usr/sbin/amavisd-new[8967]: (08967-01) SpamControl: calling spam 
scanner SpamAssassin
/usr/sbin/amavisd-new[8967]: (08967-01) get_deadline spam_scan_sa_pre - 
deadline in 479.9 s, set to 476.000 s
/usr/sbin/amavisd-new[8967]: (08967-01) prolong_timer spam_scan_sa_pre: 
timer 476, was 336, deadline in 479.9 s
/usr/sbin/amavisd-new[8967]: (08967-01) lookup_sql_field(sa_userconf) 
rec=0, "user at demo.local" result: undef
/usr/sbin/amavisd-new[8967]: (08967-01) lookup_sql_field(sa_userconf) 
rec=1, "user at demo.local" result: undef
/usr/sbin/amavisd-new[8967]: (08967-01) lookup [sa_userconf] => undef, 
"user at demo.local" does not match
/usr/sbin/amavisd-new[8967]: (08967-01) lookup_sql_field(sa_username) 
rec=0, "user at demo.local" result: undef
/usr/sbin/amavisd-new[8967]: (08967-01) lookup_sql_field(sa_username) 
rec=1, "user at demo.local" result: "user at demo.local"
/usr/sbin/amavisd-new[8967]: (08967-01) lookup [sa_username] => true,  
"user at demo.local" matches, result="user at demo.local", matching_key="/cached/"
/usr/sbin/amavisd-new[8967]: (08967-01) SA user config: "", username: 
"user at demo.local", 0
/usr/sbin/amavisd-new[8967]: (08967-01) switching SA (0) username 
"amavis" -> "user at demo.local"
/usr/sbin/amavisd-new[8967]: (08967-01) calling SA parse (0), SA vers 
3.3.2, 3.003002, data as GLOB, recips_ind [0], user: "user at demo.local"
/usr/sbin/amavisd-new[8967]: (08967-01) get_deadline SA check - deadline 
in 479.9 s, set to 475.000 s
/usr/sbin/amavisd-new[8967]: (08967-01) CALLING SA check (0)
/usr/sbin/amavisd-new[8967]: (08967-01) DONE SA check (0)
/usr/sbin/amavisd-new[8967]: (08967-01) get_deadline spam_scan_sa - 
deadline in 474.1 s, set to 332.000 s
/usr/sbin/amavisd-new[8967]: (08967-01) prolong_timer spam_scan_sa: 
timer 332, was 471, deadline in 474.1 s
/usr/sbin/amavisd-new[8967]: (08967-01) spam_scan: score=1007.68 
autolearn=no 
tests=[DCC_CHECK=4,DIGEST_MULTIPLE=0.001,DKIM_ADSP_NXDOMAIN=0.8,GTUBE=1000,NO_DNS_FOR_FROM=0.379,PYZOR_CHECK=2.5] 
recips=0

But the *bayes_vars* table (spamassassin side) stays empty! Do I 
misunderstand something?

I'm using amavis 2.7.1 and spamassassin 3.3.2 on Debian Wheezy.

Thanks for your help,
Antoine Nguyen