Great, that worked... Only problem is, it is only seeing the user "root" in the DB. This makes me assume that I still have to have a local user accounts? For example, I put my work account in the table under the username field as [EMAIL PROTECTED] and tried to whitelist [EMAIL PROTECTED] and it only works if I specify root as the username but not [EMAIL PROTECTED] :(
-Jim -----Original Message----- From: Shayne Lebrun [mailto:[EMAIL PROTECTED] Sent: Thursday, May 29, 2003 10:13 AM To: SpamAssassin Subject: RE: [SAtalk] User_prefs without local users? You need to run spamd with a flag to use sql prefs; -q as I recall. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of > Upwood, James > Sent: Thursday, May 29, 2003 10:04 AM > To: Andreas Haase; SpamAssassin > Subject: RE: [SAtalk] User_prefs without local users? > > > 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 > ------------------------------------------------------- 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 ------------------------------------------------------- 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
