can't get SQL AWL working in 3.0.0
I have the following /etc/mail/spamassassin/settings.cf: = user_scores_dsn DBI:mysql:spamassassin:localhost user_scores_sql_usernamemail user_scores_sql_passwordmypassword bayes_store_module Mail::SpamAssassin::BayesStore::SQL bayes_sql_dsn DBI:mysql:spamassassin:localhost bayes_sql_username mail bayes_sql_password mypassword user_awl_dsnDBI:mysql:spamassassin:localhost user_awl_sql_username mail user_awl_sql_password mypassword = SA 3.0.0 is picking up the user scores and bayes from SQL without any problems, but it seems to be ignoring the awl settings completely -- it is still writing to /root/.spamassassin/auto-whitelist. I have the database set up correctly, I think: = mysql show tables; ++ | Tables_in_spamassassin | ++ | awl| | bayes_expire | | bayes_global_vars | | bayes_seen | | bayes_token| | bayes_vars | | userpref | ++ 7 rows in set (0.00 sec) mysql describe awl; +--+--+--+-+-+---+ | Field| Type | Null | Key | Default | Extra | +--+--+--+-+-+---+ | username | varchar(100) | | PRI | | | | email| varchar(200) | | PRI | | | | ip | varchar(10) | | PRI | | | | count| int(11) | YES | | 0 | | | totscore | float| YES | | 0 | | +--+--+--+-+-+---+ 5 rows in set (0.00 sec) = ... and yet, after several thousand emails processed: = mysql select * from awl; Empty set (0.00 sec) = Here is output from spamd -D --sql-config --nouser-config : = trying to connect to syslog/unix... no error connecting to syslog/unix logging enabled: facility: mail socket: unix output: syslog creating INET socket: Listen: 128 LocalAddr: 127.0.0.1 LocalPort: 783 Proto: 6 ReuseAddr: 1 Type: 1 debug: SpamAssassin version 3.0.0 debug: Score set 0 chosen. debug: Storable module v2.13 found debug: Preloading modules with HOME=/tmp/spamd-12206-init debug: ignore: test message to precompile patterns and load modules debug: using /etc/mail/spamassassin/init.pre for site rules init.pre debug: config: read file /etc/mail/spamassassin/init.pre debug: using /usr/share/spamassassin for default rules dir debug: config: read file /usr/share/spamassassin/10_misc.cf debug: config: read file /usr/share/spamassassin/20_anti_ratware.cf debug: config: read file /usr/share/spamassassin/20_body_tests.cf debug: config: read file /usr/share/spamassassin/20_compensate.cf debug: config: read file /usr/share/spamassassin/20_dnsbl_tests.cf debug: config: read file /usr/share/spamassassin/20_drugs.cf debug: config: read file /usr/share/spamassassin/20_fake_helo_tests.cf debug: config: read file /usr/share/spamassassin/20_head_tests.cf debug: config: read file /usr/share/spamassassin/20_html_tests.cf debug: config: read file /usr/share/spamassassin/20_meta_tests.cf debug: config: read file /usr/share/spamassassin/20_phrases.cf debug: config: read file /usr/share/spamassassin/20_porn.cf debug: config: read file /usr/share/spamassassin/20_ratware.cf debug: config: read file /usr/share/spamassassin/20_uri_tests.cf debug: config: read file /usr/share/spamassassin/23_bayes.cf debug: config: read file /usr/share/spamassassin/25_body_tests_es.cf debug: config: read file /usr/share/spamassassin/25_hashcash.cf debug: config: read file /usr/share/spamassassin/25_spf.cf debug: config: read file /usr/share/spamassassin/25_uribl.cf debug: config: read file /usr/share/spamassassin/30_text_de.cf debug: config: read file /usr/share/spamassassin/30_text_fr.cf debug: config: read file /usr/share/spamassassin/30_text_nl.cf debug: config: read file /usr/share/spamassassin/30_text_pl.cf debug: config: read file /usr/share/spamassassin/50_scores.cf debug: config: read file /usr/share/spamassassin/60_whitelist.cf debug: using /etc/mail/spamassassin for site rules dir debug: config: read file /etc/mail/spamassassin/misc.cf debug: config: read file /etc/mail/spamassassin/settings.cf debug: plugin: loading Mail::SpamAssassin::Plugin::URIDNSBL from @INC debug: plugin: registered Mail::SpamAssassin::Plugin::URIDNSBL=HASH(0x83b4ba4) debug: plugin: loading Mail::SpamAssassin::Plugin::Hashcash from @INC debug: plugin: registered Mail::SpamAssassin::Plugin::Hashcash=HASH(0x8e08a5c) debug: plugin: loading Mail::SpamAssassin::Plugin::SPF from @INC debug: plugin:
Re: can't get SQL AWL working in 3.0.0
On Sun, Sep 26, 2004 at 09:27:04PM +, Daniel M. Drucker wrote: I have the following /etc/mail/spamassassin/settings.cf: = user_scores_dsn DBI:mysql:spamassassin:localhost user_scores_sql_usernamemail user_scores_sql_passwordmypassword bayes_store_module Mail::SpamAssassin::BayesStore::SQL bayes_sql_dsn DBI:mysql:spamassassin:localhost bayes_sql_username mail bayes_sql_password mypassword user_awl_dsnDBI:mysql:spamassassin:localhost user_awl_sql_username mail user_awl_sql_password mypassword = SA 3.0.0 is picking up the user scores and bayes from SQL without any problems, but it seems to be ignoring the awl settings completely -- it is still writing to /root/.spamassassin/auto-whitelist. [ SNIP ] Can anyone tell me what I'm doing wrong? Go back and read sql/README.awl, pay special attention to the second paragraph. Michael
Re: can't get SQL AWL working in 3.0.0
On 2004-09-26, Michael Parker [EMAIL PROTECTED] wrote: Go back and read sql/README.awl, pay special attention to the second paragraph. I bow my head in humble shame. Thank you! -- Daniel Drucker / [EMAIL PROTECTED]
RE: can't get SQL AWL working in 3.0.0
Can anyone tell me what I'm doing wrong? See the line debug: auto-whitelist (db-based): [EMAIL PROTECTED]|ip=none scores 0/0 And then see the man... auto_whitelist_factory module (default: Mail::SpamAssassin::DBBasedAddrList) Select alternative whitelist factory module. My factory looks like this.. [EMAIL PROTECTED] spamassassin]# grep factory local.cf auto_whitelist_factory Mail::SpamAssassin::SQLBasedAddrList D