I've tride with both -Q and -q... But neither makes a difference. Don
-----Original Message----- 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/ > >It's a wrapper that is called from the virtual sql users .qmail file. > >-----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: > > > >>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 >> >> >> >>