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
(text/plain)