Package: spamassassin Version: 3.1.7-1 Severity: important I have setup spamassassin with Bayes database kept in PostgreSQL:
--- local.cf starts loadplugin Mail::SpamAssassin::Plugin::DCC add_header spam Flag _YESNO_ _HOSTNAME_ _DCCR_ fold_headers 1 required_score 5 use_dcc 1 dcc_timeout 5 dcc_dccifd_path /var/lib/dcc/dccifd dcc_home /var/lib/dcc rbl_timeout 5 user_scores_dsn DBI:Pg:database=spamassassin;host=10.2.1.119;port=5800 user_scores_sql_username spamassassin user_scores_sql_password spamassassin use_bayes 1 use_bayes_rules 1 bayes_auto_learn 0 bayes_store_module Mail::SpamAssassin::BayesStore::PgSQL bayes_sql_password spamassassin bayes_sql_username spamassassin bayes_sql_dsn DBI:Pg:database=spamassassin;host=10.2.1.119;port=5800 [whitelist follows] --- local.cf ends I have migrated bayes database to the postgres via sa-learn --backup && sa-learn --restore. After restart, SA stopped checking bayes at all. Database logs show it connects to the database then does nothing about Bayes at all: [2006-12-12 13:58:34 CET] [28838] <[EMAIL PROTECTED]> LOG: connection authorized: user= spamassassin database=spamassassin [2006-12-12 13:58:34 CET] [28838] <[EMAIL PROTECTED]> LOG: duration: 3.351 ms statemen t: select preference, value from userpref where username = 'nobody' or username = '@GLOBAL' ord er by username asc [2006-12-12 13:58:34 CET] [28839] <[EMAIL PROTECTED]> LOG: connection authorized: user= spamassassin database=spamassassin [2006-12-12 13:58:34 CET] [28839] <[EMAIL PROTECTED]> LOG: duration: 0.100 ms statemen t: begin [2006-12-12 13:58:34 CET] [28826] <[EMAIL PROTECTED]> LOG: duration: 232.528 ms statem ent: SELECT value FROM bayes_global_vars WHERE variable = 'VERSION' [2006-12-12 13:58:34 CET] [28826] <[EMAIL PROTECTED]> LOG: duration: 0.034 ms statemen t: DEALLOCATE dbdpg_1 [2006-12-12 13:58:34 CET] [28826] <[EMAIL PROTECTED]> LOG: duration: 0.055 ms statemen t: rollback [2006-12-12 13:58:34 CET] [28839] <[EMAIL PROTECTED]> LOG: duration: 35.299 ms stateme nt: SELECT value FROM bayes_global_vars WHERE variable = 'VERSION' [2006-12-12 13:58:34 CET] [28840] <[EMAIL PROTECTED]> LOG: connection authorized: user= spamassassin database=spamassassin [2006-12-12 13:58:34 CET] [28840] <[EMAIL PROTECTED]> LOG: duration: 0.119 ms statemen t: begin [2006-12-12 13:58:34 CET] [28840] <[EMAIL PROTECTED]> LOG: duration: 0.059 ms statemen t: DEALLOCATE dbdpg_1 [2006-12-12 13:58:34 CET] [28840] <[EMAIL PROTECTED]> LOG: duration: 0.074 ms statemen t: rollback [2006-12-12 13:58:34 CET] [28844] <[EMAIL PROTECTED]> LOG: connection authorized: user= spamassassin database=spamassassin Alex -- System Information: Debian Release: testing/unstable APT prefers testing APT policy: (500, 'testing') Architecture: amd64 (x86_64) Shell: /bin/sh linked to /bin/bash Kernel: Linux 2.6.17-2-amd64 Locale: LANG=pl_PL, LC_CTYPE=pl_PL (charmap=ISO-8859-2) Versions of packages spamassassin depends on: ii libarchive-tar-perl 1.30-1 Archive::Tar - manipulate tar file ii libdigest-sha1-perl 2.11-1 NIST SHA-1 message digest algorith ii libhtml-parser-perl 3.55-1 A collection of modules that parse ii libsocket6-perl 0.19-1 Perl extensions for IPv6 ii libwww-perl 5.805-1 WWW client/server library for Perl ii perl 5.8.8-6.1 Larry Wall's Practical Extraction Versions of packages spamassassin recommends: ii libmail-spf-query-perl 1:1.999.1-2 query SPF (Sender Policy Framework ii libnet-dns-perl 0.59-1 Perform DNS queries from a Perl sc ii perl [libmime-base64-perl] 5.8.8-6.1 Larry Wall's Practical Extraction ii spamc 3.1.7-1 Client for SpamAssassin spam filte -- no debconf information -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
