Spamassassin Per User

[Eric "Shubes"]

Gilbert,
I'd try posting your original question to the qmail-toaster list. I know
there are some folks there who are running the bayes db under mysql.

P.S. With the standard bayes cdb, SA must be run as user vpopmail, so you'd
want to:
# sudo -u vpopmail -H spamassassin -D --lint
That might not be necessary when using mysql for bayes though. I'm not
certain about that.

Gilbert T. Gutierrez, Jr. wrote:
> What is confusing me is that spamc which runs queries through spamd is
> reporting properly, but actual mail is not.
> 
> Gilbert
> 
> -----Original Message-----
> From: plug-discuss-bounces at lists.plug.phoenix.az.us
> [mailto:plug-discuss-bounces at lists.plug.phoenix.az.us] On Behalf Of Craig
> White
> Sent: Wednesday, December 20, 2006 1:38 PM
> To: Main PLUG discussion list
> Subject: RE: Spamassassin Per User
> 
> That is a full debug and I was thinking that if it had trouble
> connecting to your sql database, that it would be revealed there.
> 
> That said, I have never used sql for bayes db so I am not likely to be
> much of a help
> 
> Craig
> 
> On Wed, 2006-12-20 at 12:39 -0700, Gilbert T. Gutierrez, Jr. wrote:
>> I have run "spamassassin -D --lint" before and seen nothing that could
> help
>> me.  What should I be looking for?
>>
>> Gilbert
>>
>> -----Original Message-----
>> From: plug-discuss-bounces at lists.plug.phoenix.az.us
>> [mailto:plug-discuss-bounces at lists.plug.phoenix.az.us] On Behalf Of Craig
>> White
>> Sent: Wednesday, December 20, 2006 11:38 AM
>> To: Main PLUG discussion list
>> Subject: Re: Spamassassin Per User
>>
>> try...
>>
>> spamassassin -D --lint
>>
>> Craig
>>
>> On Wed, 2006-12-20 at 11:20 -0700, Gilbert T. Gutierrez, Jr. wrote:
>>> Can someone tell me what I am doing wrong?  I don't believe spamassassin
>> is
>>> using the database.  Details are below.
>>>
>>> Gilbert
>>>
>>> Server: Centos4.4
>>> Mail: QMAIL-TOASTER
>>>
>>> I want to use MySQL with the server to allow users the ability to
>> customize
>>> spamassassin.
>>> http://wiki.apache.org/spamassassin/UsingSQL
>>>
>>> I added the spamassassin commands I think necessary to the file
>>> /etc/mail/spamassassin/local.cf
>>>
>>>   user_scores_dsn                  DBI:mysql:spamassassin:127.0.0.1
>>>   user_scores_sql_password         ****
>>>   user_scores_sql_username         spamassassin
>>>   user_scores_sql_custom_query     SELECT preference, value FROM _TABLE_
>>> WHERE \
>>>                                    username = _USERNAME_ OR username =
>>> '$GLOBAL' \
>>>                                    OR username = CONCAT('%',_DOMAIN_)
>> ORDER
>>> BY username ASC
>>>
>>> the user spamassassin has only SELECT privileges
>>>
>>> I have added a -q to the spamd service in /var/qmail/supervise/spamd
>>> exec /usr/bin/spamd -q -x -u vpopmail -s stderr 2>&1
>>>
>>> I run the command "echo -e "From: user\nTo:user\Subject: Test\n\n" |
> spamc
>>> -u 'gilbert.g at phoenixinternet.net'' to check if spamd is using my SQL
> rule
>>> set for gilbert.g at phoenixinternet.net and the response reports a
> required
>>> score of 4.0 which is the same as what I have in the SQL database.
>>>
>>> X-Spam-Status: No, score=2.8 required=4.0
>>> tests=EMPTY_MESSAGE,MISSING_SUBJECT,
>>>         NO_RECEIVED,NO_RELAYS autolearn=no version=3.1.7
>>>
>>> When I send a test message from my yahoo account to that same user, the
>>> header reports a 5.0.
>>>
>>> X-Spam-Status: No, score=0.0 required=5.0 tests=HTML_MESSAGE
>>>
>>>
>>> ---
>>> [ This E-mail was scanned for viruses by Phoenix Internet ]
>>> [ Phoenix Internet http://www.phoenixinternet.net ]
>>>
>>> ---------------------------------------------------
>>> PLUG-discuss mailing list - PLUG-discuss at lists.plug.phoenix.az.us
>>> To subscribe, unsubscribe, or to change  you mail settings:
>>> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss


-- 
-Eric 'shubes'