On a new SA installation that's as identical to the other 3 we have running as possible, bayes is not running.
spamassassin -D --lint indicates that all is normal. The test message generates a Bayes score. sa-learn is able to talk to the mysql database: We're able to update the database using sa-learn. However, in production, spamassassin does not report any BAYES_ scores. When the spam value exceeds the threshold that would normally cause autolearning, "autolearn=no" changes to "autolearn=unavailable". Similarly, AWL entries are not being created. Can anyone see what's wrong? [3320] dbg: config: read file /usr/share/spamassassin/23_bayes.cf [3320] dbg: bayes: using username: root [3320] dbg: bayes: database connection established [3320] dbg: bayes: found bayes db version 3 [3320] dbg: bayes: Using userid: 1 [3320] dbg: bayes: corpus size: nspam = 178, nham = 168 [3320] dbg: bayes: tok_get_all: token count: 20 [3320] dbg: bayes: score = 0.913557143318889 [3320] dbg: rules: ran eval rule BAYES_80 ======> got hit [3320] dbg: auto-whitelist: sql-based connected to DBI:mysql:sa_bayes:ccim-mx2 [3320] dbg: auto-whitelist: sql-based finish: disconnected from DBI:mysql:sa_bayes:ccim-mx2 [3320] dbg: check: tests=BAYES_80,MISSING_SUBJECT,NO_REAL_NAME,NO_RECEIVED,NO_RELAYS,TO_CC_NONE # grep -i bayes local.cf # Enable the Bayes system use_bayes 1 # Enable Bayes auto-learning bayes_auto_learn 1 bayes_min_ham_num 100 bayes_min_spam_num 100 # bayes_path /var/spool/spamassassin/bayes bayes_store_module Mail::SpamAssassin::BayesStore::MySQL bayes_sql_dsn DBI:mysql:sa_bayes:ccim-mx2 bayes_sql_username spamass bayes_sql_password xxx bayes_sql_override_username root bayes_auto_expire 0 user_awl_dsn DBI:mysql:sa_bayes:ccim-mx2 # grep -i awl local.cf user_awl_dsn DBI:mysql:sa_bayes:ccim-mx2 user_awl_sql_table awl user_awl_sql_username spamass user_awl_sql_password xxx user_awl_sql_override_username root ]# ps -ef |grep spam root 2170 1 0 07:01 ? 00:00:04 /usr/bin/spamd -d -c -m5 -H -r /var/run/spamd.pid root 2247 2170 1 07:01 ? 00:00:20 spamd child root 2248 2170 0 07:01 ? 00:00:00 spamd child sa-milt 3264 1 0 07:15 pts/0 00:00:00 /bin/bash /usr/sbin/spamass-milter-wrapper -p /var/run/spamass-milter/spamass-milter.sock -P /var/run/spamass-milter.pid -i 127.0.0.1 -r 10 -- -d localhost -p 783 sa-milt 3265 3264 0 07:15 pts/0 00:00:00 /usr/sbin/spamass-milter -p /var/run/spamass-milter/spamass-milter.sock -P /var/run/spamass-milter.pid -i 127.0.0.1 -r 10 -- -d localhost -p 783 SpamAssassin version 3.1.1 running on Perl version 5.8.6 spamass-milter - Version 0.3.1 -- Steve
