That is correct, it does have user email instead of user=clamav....
thanks
----- Original Message -----
From: "Jon Darrington" <[EMAIL PROTECTED]>
To: <qmailtoaster-list@qmailtoaster.com>
Sent: Friday, December 22, 2006 2:50 AM
Subject: RE: [qmailtoaster] Qmail Toaster Per User settings using MySQL
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: qmailtoaster-list@qmailtoaster.com
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: qmailtoaster-list@qmailtoaster.com
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]
---------------------------------------------------------------------
QmailToaster hosted by: VR Hosted <http://www.vr.org>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
