Next, however you're calling spamc, you need to pass the user's username/domain. Using qmail-scanner requires a patch; search the archives and you'll find it, me thinks.
> -----Original Message----- > From: Upwood, James [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 29, 2003 10:50 AM > To: Shayne Lebrun; SpamAssassin > Subject: RE: [SAtalk] User_prefs without local users? > > > 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
