Re: Enabling per user rules in SQL db

[Henry F. Camacho Jr]

How is spamd getting called?  spamass-milter?

If so put the following in your sysconfig:  "-u -e"

HFC





Don O'Neil wrote:

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

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:


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

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

user_scores_sql_username spamassassin 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 So it seems to be connecting...

smime.p7s
Description: S/MIME Cryptographic Signature