Not sure if I should be posting this here or sending to jengland... I already did that though...
Thanks in advance for looking at this... Any idea what I'm missing? The DBI tests did show success... I've also tried with a 127.0.0.1:3306 fir the dsn - now luck there either... I intentionally made an error in my config file to prove to myself it is being read... Here are the additions: user_scores_dsn DBI:mysql:MyDB:localhost user_scores_sql_username spamassassin user_scores_sql_password XXX user_scores_sql_table vUserSpamassassinOptions mysql -u spamassassin -pXXX MyDB select * from vUserSpamassassinOptions; +----+----------+----------------+--------------------+ | ID | username | preference | value | +----+----------+----------------+--------------------+ | 1 | root | whitelist_from | [EMAIL PROTECTED] | | 2 | root | score | GTUBE 100 | +----+----------+----------------+--------------------+ ** not sure these statements are right, but I'm not seeing the preferences retrieval message as indicated in the docs "retrieving prefs for <username> from SQL server" so I'm thinking that I have still got something missing... On startup: spamd -D debug: Score set 0 chosen. debug: Preloading modules with HOME=/tmp/spamd-56909-init debug: ignore: test message to precompile patterns and load modules debug: using "/usr/share/spamassassin" for default rules dir debug: using "/etc/mail/spamassassin" for site rules dir debug: bayes: no dbs present, cannot scan: /tmp/spamd-56909-init/.spamassassin/bayes_toks debug: Score set 1 chosen. debug: Initialising learner debug: bayes: Not available for scanning, only 0 spam(s) in Bayes DB < 200 debug: bayes: 56909 untie-ing debug: bayes: 56909 untie-ing db_toks debug: is Net::DNS::Resolver available? yes debug: trying (3) gwdg.de... debug: looking up MX for 'gwdg.de' debug: MX for 'gwdg.de' exists? 1 debug: MX lookup of gwdg.de succeeded => Dns available (set dns_available to hardcode) debug: is DNS available? 1 debug: all '*From' addrs: [EMAIL PROTECTED] debug: running header regexp tests; score so far=0 debug: running body-text per-line regexp tests; score so far=1.27 debug: Razor2 is not available debug: running raw-body-text per-line regexp tests; score so far=1.27 debug: running uri tests; score so far=1.27 debug: uri tests: Done uriRE debug: running full-text regexp tests; score so far=1.27 debug: Razor2 is not available debug: DCCifd is not available: no r/w dccifd socket found. debug: Current PATH is: /sbin:/usr/local/sbin:/usr/sbin:/bin:/usr/local/bin:/usr/bin:/usr/X11R6/bin debug: DCC is not available: no executable dccproc found. debug: Pyzor is not available: pyzor not found debug: all '*To' addrs: debug: RBL: success for 1 of 1 queries debug: running meta tests; score so far=1.27 debug: is spam? score=1.27 required=5 tests=DATE_MISSING,NO_REAL_NAME server started on port 783/tcp (running version 2.61) server pid: 56909 logmsg: server started on port 783/tcp (running version 2.61) On spamc -u sysop <sample-spam.txt logmsg: connection from localhost [127.0.0.1] at port 3809 logmsg: info: setuid to sysop succeeded debug: read_scoreonly_config: cannot open "/home/sysop/.spamassassin/user_prefs": No such file or directory debug: user has changed debug: bayes: 56929 untie-ing debug: bayes: no dbs present, cannot scan: /home/sysop/.spamassassin/bayes_toks debug: Score set 1 chosen. logmsg: processing message <[EMAIL PROTECTED]> for sysop:1001. debug: bayes: Not available for scanning, only 0 spam(s) in Bayes DB < 200 debug: bayes: 56929 untie-ing debug: bayes: 56929 untie-ing db_toks debug: is Net::DNS::Resolver available? yes debug: all '*From' addrs: [EMAIL PROTECTED] debug: running header regexp tests; score so far=0 debug: running body-text per-line regexp tests; score so far=0 debug: Razor2 is not available debug: running raw-body-text per-line regexp tests; score so far=0 debug: running uri tests; score so far=0 debug: uri tests: Done uriRE debug: running full-text regexp tests; score so far=0 debug: Razor2 is not available debug: DCCifd is not available: no r/w dccifd socket found. debug: DCC is not available: no executable dccproc found. debug: Pyzor is not available: pyzor not found debug: all '*To' addrs: [EMAIL PROTECTED] debug: DNS MX records found: 0 debug: DNS A records found: 1 debug: RBL: success for 1 of 1 queries debug: running meta tests; score so far=0 debug: auto-learn? ham=0.1, spam=12, body-hits=0, head-hits=0 debug: auto-learn: currently using scoreset 1. no need to recompute. debug: auto-learn? no: learner indicated spam (1000 > 1) debug: is spam? score=1000 required=5 tests=GTUBE logmsg: identified spam (1000.0/5.0) for sysop:1001 in 0.0 seconds, 799 bytes. ------------------------------------------------------- This SF.net email is sponsored by: IBM Linux Tutorials. Become an expert in LINUX or just sharpen your skills. Sign up for IBM's Free Linux Tutorials. Learn everything from the bash shell to sys admin. Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click _______________________________________________ Spamassassin-talk mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/spamassassin-talk
