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@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 -- -Eric 'shubes' --------------------------------------------------- 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