I'm having problems getting rules to be read from a DB: I'm launching spamd: /usr/local/bin/spamd -x -Q -s local5 -d (thanks for the brainfart fix on the logs)
And have /etc/mail/spamassassin/sql.cf: user_scores_dsn DBI:mysql:spamassassin:localhost user_scores_sql_password spamkiller user_scores_sql_username spamassassin And created the tables with the included templates, and installed one of the web based config tools (from http://mail.limelyte.net/webspam/ ) and it wrote: username preference value prefid [EMAIL PROTECTED] rewrite_header Subject ***SPAM*** 1 [EMAIL PROTECTED] report_safe 1 2 [EMAIL PROTECTED] use_terse_report 0 3 [EMAIL PROTECTED] always_add_headers 1 4 [EMAIL PROTECTED] always_add_report 0 5 [EMAIL PROTECTED] required_hits 5 6 To the userpref table... But it doesn't seem to be working. There is a message from the daemon: Feb 12 14:24:42 bigbird spamd[5154]: spamd: setuid to shcu0129 succeeded, reading scores from SQL So it seems to be connecting... But I never see a message "retrieving prefs for [EMAIL PROTECTED] from SQL server" I'm sending myself spam... And it gets flagged, but the subject isn't being rewritten. What am I doing wrong or missing? Thanks again!!!! Don
