The following really helped me, you need to recompile simscan. Quinn really helped me out on this one, I'm just pasting what he sent me.
I finally got it up and going. The issue is that simscan is not compiled to pass the username to spamassassin. You have to follow the following steps. >> So you're still in? I'm in a rush out of the office, but here are >> some quick steps: >> >> ============================================================= >> REBUILDING SIMSCAN RPMs TO SUPPORT PER-USER SPAMC INVOCATION: >> ============================================================= >> >> 1. Install the RPMS files from simscan-toaster-3.1.7-1.3.6.src.rpm: >> >> # rpm -Uvh simscan-toaster-3.1.7-1.3.6.src.rpm >> >> 2. Edit the simscan-toaster.spec file: >> >> # vi /usr/src/redhat/SPECS/simscan-toaster.spec >> >> You can change the configure options at around line 434. You will >> only need to set --enable-spamc-user option. Here is this part of my >> simscan-toaster.spec file: >> >> --enable-user=clamav \ >> --enable-attach \ >> --enable-ripmime=/usr/bin/ripmime \ >> --enable-per-domain \ >> --enable-spam \ >> --enable-spam-hits=20 \ >> --enable-spamc-user \ >> --enable-received \ >> --enable-clamavdb-path=/usr/share/clamav \ >> --enable-custom-smtp-reject >> >> 3. Build an RPM from this spec file: >> >> # rpmbuild -bb --with cnt40 --target $(uname -m) >> /usr/src/redhat/SPECS/simscan-toaster.spec >> >> (Replace cnt40 with the flag for your distro.) >> >> 4. Install the RPM (the usual disclaimers apply): >> >> # rpm -Uvh --force >> /usr/src/redhat/RPMS/<ARCH>/simscan-toaster-<VERSION>.<ARCH>.rpm >> >> (Replace <ARCH> with yours: i386, i686, etc) -----Original Message----- From: Gilbert T. Gutierrez, Jr. [mailto:[EMAIL PROTECTED] Sent: Thursday, December 21, 2006 4:59 PM To: [email protected] Subject: [qmailtoaster] Qmail Toaster Per User settings using MySQL Can someone tell me what I am doing wrong? I don't believe spamassassin is using the database. When I use the "spamc" utility I get a response saying that my threshold is 4.0 which is what I have in the database. When I send a mail to myself from an outside source, I get a threshold of 5.0. 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 mysql 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 '[EMAIL PROTECTED]'' to check if spamd is using my SQL rule set for [EMAIL PROTECTED] 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 --------------------------------------------------------------------- QmailToaster hosted by: VR Hosted <http://www.vr.org> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- QmailToaster hosted by: VR Hosted <http://www.vr.org> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
