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@lists.plug.phoenix.az.us
[mailto:plug-discuss-bounces@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@lists.plug.phoenix.az.us
> [mailto:plug-discuss-bounces@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@phoenixinternet.net'' to check if spamd is using my SQL
rule
> > set for gilbert.g@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@lists.plug.phoenix.az.us
> > To subscribe, unsubscribe, or to change  you mail settings:
> > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
-- 
Craig White <craig@tobyhouse.com>

---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change  you mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
---
[ This E-mail was scanned for viruses by Phoenix Internet ]
[ Phoenix Internet http://www.phoenixinternet.net ]


---
[ This E-mail was scanned for viruses by Phoenix Internet ]
[ Phoenix Internet http://www.phoenixinternet.net ]

---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change  you mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss