[sam] unable to retrive preferences from sql

[張良文]

Hi all:
I have installed SAM with MYSQL as storage,when i
start spamd daemon with debug 
mode(spamd -C /etc/mail/spamassassin -D -q -x -a -u
spamd),and i saw messages  
shown at console .......
 
logmsg: connection from webmail [ 127.0.0.1 ] at port
36388
debug: retrieving prefs for txg16 from SQL server

And here are the entries store in mysql :
prefid horde_id username preference value 
 1   txg16@thbuo.gov.tw   txg16@thbuo.gov.tw  
required_hits   3  
 2   txg16@thbuo.gov.tw   txg16@thbuo.gov.tw  
subject_tag   ISSPAM  
 3   txg16@thbuo.gov.tw   txg16@thbuo.gov.tw  
rewrite_subject   1   
 4   txg16@thbuo.gov.tw   txg16@thbuo.gov.tw  
spam_level_stars   0   
 5   txg16@thbuo.gov.tw   txg16@thbuo.gov.tw  
report_header   0   
 6   txg16@thbuo.gov.tw   txg16@thbuo.gov.tw  
use_terse_report   0   
 7   txg16@thbuo.gov.tw   txg16@thbuo.gov.tw  
defang_mime   0  

I think ,that because username:txg16@thbuo.gov.tw was
different from "txg16" so 
spamassassin could not get the correctly preference.So
i modified username  
from txg16@thbuo.gov.tw to txg16 ,and that's work !!

Is that SAM's bug or something i missed while config
spamassassin ?

Thanks !!
Alex


-----------------------------------------------------------------
< 每天都 Yahoo!奇摩 >  www.yahoo.com.tw