Re: Enabling per user rules in SQL db

[Henry F. Camacho Jr]

Very interesting.




HFC


Don O'Neil wrote:

Is the mysql server on the same machine spamassassin is running on? I assumed you have insured DBI and the DBD for MySQL is installed.

I've tride with both -Q and -q... But neither makes a difference.


-----Original Message-----

Don From: Henry F. Camacho Jr [mailto:[EMAIL PROTECTED] Sent: Sunday, February 12, 2006 3:11 PM

To: Don O'Neil
Subject: Re: Enabling per user rules in SQL db

I am using -q -x on spamd.

HFC


Don O'Neil wrote:

Spamd is being called through spamc in a | to the ifspamh wrapper....

http://www.gbnet.net/~jrg/qmail/ifspamh/


-----Original Message-----
From: Henry F. Camacho Jr [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 12, 2006 3:00 PM
To: Don O'Neil
Cc: users@spamassassin.apache.org
Subject: Re: Enabling per user rules in SQL db

How is spamd getting called?  spamass-milter?

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

HFC





Don O'Neil wrote:

It's a wrapper that is called from the virtual sql users .qmail file.

I'm having problems getting rules to be read from a DB:



And have /etc/mail/spamassassin/sql.cf:

user_scores_dsn                 DBI:mysql:spamassassin:localhost
user_scores_sql_password        spamkiller

I'm launching spamd: /usr/local/bin/spamd -x -Q -s local5 -d (thanks for the brainfart fix on the logs) 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:



To the userpref table... But it doesn't seem to be working.

There is a message from the daemon:







What am I doing wrong or missing?


Thanks again!!!!
Don

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 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.

smime.p7s
Description: S/MIME Cryptographic Signature