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 2>&1
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]
