Re: [qmailtoaster] Spamassassin user preferences
I've got mysql-based SA user prefs working. Here are the changes necessary to
add this to the qmail toaster.
1. Add --enable-spamc-user option to %configure in the simscan-toaster.spec
2. Add -q to the spamd run file. Here's mine:
[EMAIL PROTECTED] ~]$cat /var/qmail/supervise/spamd/run
#!/bin/sh
exec /usr/bin/spamd -q -x -u vpopmail -s stderr -P -m 15 --min-spare=2
--max-spare=5 --max-conn-per-child=50 --timeout-child=20 --timeout-tcp=20 21
3. Add a new spamassassin cf file with user_score parameters. Here's mine:
[EMAIL PROTECTED] ~]$cat /etc/mail/spamassassin/sql.cf:
user_scores_dsn DBI:mysql:spamassassin:localhost
user_scores_sql_username spamassassin
user_scores_sql_password sSeEcCrReEtT
user_scores_sql_custom_query SELECT preference, value FROM _TABLE_ WHERE
username = _USERNAME_ OR username = '$GLOBAL' OR username =
CONCAT('%',_DOMAIN_) ORDER BY username ASC
4. Have a script that creates a mysql database. Here are the commands necessary:
CREATE DATABASE `spamassassin`;
GRANT ALL ON `spamassassin`.* TO 'spamassassin'@'localhost' IDENTIFIED BY
'sSeEcCrReEtT';
USE spamassassin;
CREATE TABLE userpref (
username VARCHAR(255) NOT NULL DEFAULT '',
preference VARCHAR(30) NOT NULL DEFAULT '',
value VARCHAR(100) NOT NULL DEFAULT '',
prefid INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
PRIMARY KEY (prefid),
INDEX (username)
) ENGINE=MyISAM;
5. Include the SquirrelMail plugin. I don't know how to do this since I don't
use it. I found the Horde group has a spamassassin configuration plugin called
SAM that is simple and works.
Quinn
I'll get this going on my migration server and report back.
Quinn
On Mon, 09 Oct 2006 12:21:06 -0700, Eric Shubes wrote:
I'd like to see the basic toaster move in this direction. What will
it take
to make this happen?
-
QmailToaster hosted by: VR Hosted http://www.vr.org
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: [qmailtoaster] Spamassassin user preferences
I also was wondering about this. With unix accounts + sendmail every user has their own SA config file at ~/.spamassassin/user_prefs. But with vpopmail I don't think SA knows where to look for the file. I think the best option is to move all SA configuration into MySQL and then it can be managed by the user via a web-based interface. Does anybody know how this works? I will check into it and report back. Quinn On Fri, 29 Sep 2006 11:17:30 -0700, Eric Shubes wrote: There is some user level control available in /var/qmail/control/simcontrol. You can vary the level at which spam is dropped (spam_hits setting). See http://wiki.qmailtoaster.com/index.php/Simscan I don't know if you can adjust the score at which something is considered spam or not though. Please let us know what you find out (and update the wiki accordingly!). ;) - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [qmailtoaster] Spamassassin user preferences
Quinn Comendant wrote: I also was wondering about this. With unix accounts + sendmail every user has their own SA config file at ~/.spamassassin/user_prefs. But with vpopmail I don't think SA knows where to look for the file. I think the best option is to move all SA configuration into MySQL and then it can be managed by the user via a web-based interface. Does anybody know how this works? I will check into it and report back. I use MySQL db configuration exclusively. No directory files, Squirrelmail, all userprefs can be controlled through Squirrelmail, and the db is dumped every night (BTW, all the addressbook stuff, is included in this dump). Quinn On Fri, 29 Sep 2006 11:17:30 -0700, Eric Shubes wrote: There is some user level control available in /var/qmail/control/simcontrol. You can vary the level at which spam is dropped (spam_hits setting). See http://wiki.qmailtoaster.com/index.php/Simscan I don't know if you can adjust the score at which something is considered spam or not though. Please let us know what you find out (and update the wiki accordingly!). ;) - 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]
Re: [qmailtoaster] Spamassassin user preferences
I'd like to see the basic toaster move in this direction. What will it take to make this happen? Mark Samples wrote: Quinn Comendant wrote: I also was wondering about this. With unix accounts + sendmail every user has their own SA config file at ~/.spamassassin/user_prefs. But with vpopmail I don't think SA knows where to look for the file. I think the best option is to move all SA configuration into MySQL and then it can be managed by the user via a web-based interface. Does anybody know how this works? I will check into it and report back. I use MySQL db configuration exclusively. No directory files, Squirrelmail, all userprefs can be controlled through Squirrelmail, and the db is dumped every night (BTW, all the addressbook stuff, is included in this dump). Quinn On Fri, 29 Sep 2006 11:17:30 -0700, Eric Shubes wrote: There is some user level control available in /var/qmail/control/simcontrol. You can vary the level at which spam is dropped (spam_hits setting). See http://wiki.qmailtoaster.com/index.php/Simscan I don't know if you can adjust the score at which something is considered spam or not though. Please let us know what you find out (and update the wiki accordingly!). ;) -- -Eric 'shubes' - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [qmailtoaster] Spamassassin user preferences
Eric Shubes wrote: I'd like to see the basic toaster move in this direction. What will it take to make this happen? Mark Samples wrote: Quinn Comendant wrote: I also was wondering about this. With unix accounts + sendmail every user has their own SA config file at ~/.spamassassin/user_prefs. But with vpopmail I don't think SA knows where to look for the file. I think the best option is to move all SA configuration into MySQL and then it can be managed by the user via a web-based interface. Does anybody know how this works? I will check into it and report back. I use MySQL db configuration exclusively. No directory files, Squirrelmail, all userprefs can be controlled through Squirrelmail, and the db is dumped every night (BTW, all the addressbook stuff, is included in this dump). Quinn On Fri, 29 Sep 2006 11:17:30 -0700, Eric Shubes wrote: There is some user level control available in /var/qmail/control/simcontrol. You can vary the level at which spam is dropped (spam_hits setting). See http://wiki.qmailtoaster.com/index.php/Simscan I don't know if you can adjust the score at which something is considered spam or not though. Please let us know what you find out (and update the wiki accordingly!). ;) The score at which something is considered spam is set in /etc/mail/spamassassin/local.cf with the required_hits variable. The score at which spam is dropped is in /var/qmail/control/simcontrol with the spam_hits variable. To have spam flagged at 5.0 and dropped if = 6.0 set 'required_hits 5.0' in /etc/mail/spamassassin/local.cf and 'spam_hits=6.0' in /var/qmail/control/simcontrol. Then run /var/qmail/bin/simscanmk and restart SpamAssassin. Adam - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[qmailtoaster] Spamassassin user preferences
Hi all; I have setup Spamassassin score relatively low at the moment (at 3), but would like to lower it still for one user. Default conf file mentions the possibility of providing an overwrite in user home directory but this did not really have any effect, probably that's expected, as qmailtoaster has virtual email users. Is there a way to control spamassassin at the email user level ? George - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [qmailtoaster] Spamassassin user preferences
George M. wrote: Hi all; I have setup Spamassassin score relatively low at the moment (at 3), but would like to lower it still for one user. Default conf file mentions the possibility of providing an overwrite in user home directory but this did not really have any effect, probably that's expected, as qmailtoaster has virtual email users. Is there a way to control spamassassin at the email user level ? George There is some user level control available in /var/qmail/control/simcontrol. You can vary the level at which spam is dropped (spam_hits setting). See http://wiki.qmailtoaster.com/index.php/Simscan I don't know if you can adjust the score at which something is considered spam or not though. Please let us know what you find out (and update the wiki accordingly!). ;) -- -Eric 'shubes' - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
