I did exactly what your URL suggests in the sql/README, but it assumes
that you still have local users or at least local user accounts. I ran
the test and looked at the output of spamd and it isn't even querying
the DB :(
Here is my config:
/etc/mail/spamassassin/local.cf
# This is the right place to customize your installation of
SpamAssassin.
# See 'perldoc Mail::SpamAssassin::Conf' for details of what can be
# tweaked.
#
########################################################################
###
#
#rewrite_subject 0
#report_safe 1
auto_whitelist_path /var/spool/spamassassin/auto-whitelist
auto_whitelist_file_mode 0666
#Bayes Config
#Read Individual User Prefs from MySQL Database
user-scores-dsn DBI:mysql:spamassassin:localhost
user_scores_sql_username sa
user_scores_sql_password wegmans
user_scores_sql_table userprefs
# SpamAssassin config file for version 2.5x
# generated by http://www.yrex.com/spam/spamconfig.php (version 1.01)
# How many hits before a message is considered spam.
required_hits 5.0
# Whether to change the subject of suspected spam
rewrite_subject 1
# Text to prepend to subject if rewrite_subject is used
subject_tag *****Possible Spam***** -->
# Encapsulate spam in an attachment
report_safe 1
# Use terse version of the spam report
use_terse_report 0
# Enable the Bayes system
use_bayes 1
# Enable Bayes auto-learning
auto_learn 1
# Enable or disable network checks
skip_rbl_checks 0
use_razor2 1
use_dcc 1
use_pyzor 1
# Mail using languages used in these country codes will not be marked
# as being possibly spam in a foreign language.
# - english
ok_languages en
# Mail using locales used in these country codes will not be marked
# as being possibly spam in a foreign language.
ok_locales en
# Default template. Try to keep it under 76 columns (inside the the dots
below).
# Bear in mind that EVERY line will be prefixed with "SPAM: " in order
to make
# it clear what's been added, and allow other filters to *remove*
spamfilter
# modifications, so you lose 6 columns right there.
#
#
......................................................................
clear_report_template
report Welcome to the BS&K AntiSpam Initiative
report
report This mail is probably spam. The original message has been
attached
report along with this report, so you can recognize or block similar
unwanted
report mail in future. If you are tired of seeing these messages, you
can create
report an Outlook rule to either permanently delete them, or move them
to a
report different folder for later viewing. Call x8651 if you need
assistance in
report doing this.
report
report Content preview:
report
report _PREVIEW_
report
report Content analysis details: (_HITS_ points, _REQD_ required)
report
report _SUMMARY_
#
......................................................................
#Terse report template.
#
#
......................................................................
clear_terse_report_template
terse_report ---- Start SpamAssassin results
terse_report _HITS_ points, _REQD_ required;
terse_report _SUMMARY_
terse_report ---- End of SpamAssassin results
#
......................................................................
MYSQL Config:
DB Name is spamassassin
Table is userpref
Fields are setup as per readme
Thanks,
-Jim
-----Original Message-----
From: Andreas Haase [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 28, 2003 11:08 AM
To: SpamAssassin
Subject: Re: [SAtalk] User_prefs without local users?
On Wed, 28 May 2003, Upwood, James wrote:
> All I am interested in is maintaining whitelists/blacklists - per
> user. Is this possible? It would be neat to be able to put a command
> in like this into the /etc/mail/spamassassin/local.cf file:
that's possible if you use mysql as a backend for spamassassin. The
options for local.cf are
user-scores-dsn DBI:mysql:spamassassin:localhost
user_scores_sql_username uname
user_scores_sql_password passwd
user_scores_sql_table tablename
You can find more information about this under
http://www.spamassassin.org/dist/sql/README
Bye,
Andreas Haase
EastLink GmbH
--
-------------- professional INTERNET services -------------
EastLink GmbH - Leipziger Strasse 46 - D-09113 Chemnitz
voice: +49-180-5432060 fax: +49-371-4320626 www.eastlink.de
-------------------------------------------------------
This SF.net email is sponsored by: ObjectStore.
If flattening out C++ or Java code to make your application fit in a
relational database is painful, don't do it! Check out ObjectStore. Now
part of Progress Software. http://www.objectstore.net/sourceforge
_______________________________________________
Spamassassin-talk mailing list [EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/spamassassin-talk
-------------------------------------------------------
This SF.net email is sponsored by: eBay
Get office equipment for less on eBay!
http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5
_______________________________________________
Spamassassin-talk mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/spamassassin-talk
