Ronnie, Can you confirn that the logfile /var/log/qmail/spamd/current now contains the correct username rather than user=clamav for all emails. Thanks.
Erik, If this is the case,is it possible to have the --enable-spamc-user added to the default simscan-toaster spec file, I can't think that it should affect anything else and think that this would be an improvement to the logging. Might need to add the paths to the bayes filter to /etc/mail/spamassassin/local.cf so everyone picks up the same db. I am still (slowly) working on converting sa-stats.pl to php and was wanting to enable filtering by user but since the current spamd log files don't capture it have been unable to do so with the stock simscan setup. Jon -----Original Message----- From: Ronnie Tartar [mailto:[EMAIL PROTECTED] Sent: 22 December 2006 02:47 To: [email protected] Subject: RE: [qmailtoaster] Qmail Toaster Per User settings using MySQL 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] --------------------------------------------------------------------- QmailToaster hosted by: VR Hosted <http://www.vr.org> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
