RE: Question about how to invoke spamd for SQL.

[Nate Schindler]

I don't store bayes or awl in mysql, just some global config and all user 
config information.  So, this isn't exactly what you're looking for, but it may 
help until somebody else gives you a better answer. ;)

I start spamd with: -d -m5 -x -q -u sharedspam -H /home/sharedspam 
--max-conn-per-child=100
"sharedspam" is a dummy account.  It's where I keep the .spamassassin folder.

I start spamass-milter with this: -f -i 10.10.3.0/24 -e riconcorp.com -u 
sharedspam -m -r -1 -p /var/run/sendmail/spamass.sock
10.10.3.0/24 is our internal server range and riconcorp.com is our internet 
domain.

in local.cf:

# User-level exceptions database
user_scores_dsn DBI:mysql:spamassassin:localhost
user_scores_sql_username <database_username>
user_scores_sql_password <database_password>

# Home directory and permissions
bayes_path /home/sharedspam/.spamassassin/bayes
auto_whitelist_path /home/sharedspam/.spamassassin/auto-whitelist
bayes_file_mode 777
auto_whitelist_file_mode 777
hashcash_doublespend_path /home/sharedspam/.spamassassin/hashcash_seen
hashcash_doublespend_file_mode 777

# Bayes config
lock_method flock
use_bayes 1
use_auto_whitelist 1


-----Original Message-----
From: address@hidden
[mailto:address@hidden
Behalf Of Steven W. Orr
Sent: Friday, April 29, 2005 8:57 AM
To: spamassassin-users; spamass-milt list
Subject: Question about how to invoke spamd for SQL.


I'm sure that others have already figured this one out.

What options should spamd and spamass-milter be started with in a MySQL 
environment?

My goal is to use SQL per-user configs, and also SQL autowhitelists and 
SQL Bayes data. I run a server here at home with (effectively) two users, 
myself and my wife. (The reason for using MySQL is partially for education 
and partially because spamass-milter sort of requires it to avoid use of 
sitewide bayesian data.)

For SA, I see -q and -Q. It says that if I use either of those then I 
*have* to use -x.

For spamass-milter I see the -u option but I'm not confident of the 
interplay of the SA options. I'd like to hear what other people have 
already worked out.

TIA

-- 
Time flies like the wind. Fruit flies like a banana. Stranger things have  .0.
happened but none stranger than this. Does your driver's license say Organ ..0
Donor?Black holes are where God divided by zero. Listen to me! We are all- 000
individuals! What if this weren't a hypothetical question?
steveo at syslang.net


_______________________________________________
Spamass-milt-list mailing list
address@hidden
http://lists.nongnu.org/mailman/listinfo/spamass-milt-list