23.11.2013, 15:38, "Benny Pedersen" <m...@junc.eu>: > Гуляев Гоша skrev den 2013-11-23 10:10: > >> Benny thanks a lot for your attention! >> >> I install that modules. >> Now all modules are installed, and I think maybe that lines are >> reasons of problem: > > replyed offlist, if my sql setup solves it, make a bug report if you > used setup from spamassassin and it did not work
No, your sql setup not solves situation. I'm try to check spam message manually: spamassassin -D < /var/spool/mail/spam@../spammsg and it has such strings related to SQL collation: =============================================================== ноя 23 15:42:39.896 [21238] dbg: rules: run_eval_tests - compiling eval code: 11, priority -400 ноя 23 15:42:39.897 [21238] dbg: plugin: Mail::SpamAssassin::Plugin::WLBLEval=HASH(0x805330bd0) implements 'check_wb_list', priority 0 ноя 23 15:42:39.897 [21238] dbg: bayes: corpus size: nspam = 781, nham = 1951 ноя 23 15:42:39.901 [21238] dbg: bayes: tok_get_all: token count: 156 ноя 23 15:42:39.902 [21238] dbg: bayes: tok_get_all: SQL error: Illegal mix of collations for operation ' IN ' ноя 23 15:42:39.902 [21238] dbg: bayes: cannot use bayes on this message; none of the tokens were found in the database ноя 23 15:42:39.902 [21238] dbg: bayes: not scoring message, returning undef ноя 23 15:42:39.903 [21238] dbg: bayes: DB expiry: tokens in DB: 144186, Expiry max size: 150000, Oldest atime: 1292224411, Newest atime: 1385168707, Last expire: 0, Current time: 1385199759 ноя 23 15:42:39.903 [21238] dbg: rules: running rawbody tests; score so far=0 ноя 23 15:42:39.903 [21238] dbg: rules: flush_evalstr (run_generic_tests) compiling 235 chars of Mail::SpamAssassin::Plugin::Check::_rawbody_tests_neg400_1 ноя 23 15:42:39.903 [21238] dbg: rules: run_generic_tests - compiling eval code: rawbody, priority -400 Maybe some helps info about my MySQL server configuration? MySQL ver: mysql-server-5.5.32 I have such settings in my.cnf =============================================================== init_connect = 'SET NAMES utf8' character-set-server = utf8 collation-server = utf8_general_ci -------------------------------------------- С уважением, Гуляев Гоша.
