Re: problem with spamassassin and sql

2011-07-13 Thread Kristian Kirilov
Ok, now my local.cf looking as follow: ifplugin Mail::SpamAssassin::Plugin::Shortcircuit rewrite_header Subject [* SPAM _SCORE_ *] required_score 5.0 report_safe 0 use_bayes 1 use_bayes_rules 1 bayes_auto_learn1 skip_rbl_checks 0 use_r

Re: problem with spamassassin and sql

2011-07-13 Thread Duane Hill
Wednesday, July 13, 2011, 3:14:53 AM, Kristian wrote: > Is it nessacary needed? When i start spamd in debug mode saw the > /usr/share/spamassassin/10_default_prefs.cf is proceeded. You shouldn't make any changes in the /usr/share/spamassassin directory as they could be overwritten when you upgrad

Re: problem with spamassassin and sql

2011-07-13 Thread Kristian Kirilov
Is it nessacary needed? When i start spamd in debug mode saw the /usr/share/spamassassin/10_default_prefs.cf is proceeded. > Wednesday, July 13, 2011, 1:23:51 AM, Kristian wrote: > >> Hello im using spamassassin and user prefs in mysql database, i have >> successfully setting up mysql table and al

Re: problem with spamassassin and sql

2011-07-13 Thread Duane Hill
Wednesday, July 13, 2011, 1:23:51 AM, Kristian wrote: > Hello im using spamassassin and user prefs in mysql database, i have > successfully setting up mysql table and all about correct work of > squirelmail plugin and from client site everything is ok. The problem is > spamassassin can't handle us

problem with spamassassin and sql

2011-07-12 Thread Kristian Kirilov
Hello im using spamassassin and user prefs in mysql database, i have successfully setting up mysql table and all about correct work of squirelmail plugin and from client site everything is ok. The problem is spamassassin can't handle username & domain variables.. I mean this: /usr/share/spamassas

Re: sendmail + spamassassin and SQL prefs

2011-05-16 Thread Scott
Thanks again! I updated my /etc/sysconfig/spamass-milter config with the following: EXTRA_FLAGS="-r 20 -u defaultuser -e defaultdomain" I also set the SQL query in SA's local.cf back to the default and it now filtered by email address instead of just the username. Scott. On Mon, May 16, 2011 a

Re: sendmail + spamassassin and SQL prefs

2011-05-16 Thread Matt Elson
> Ideally if spamass-milter could pass the entire email address to SA I > could deal with this in my control panel. I haven't used spamass-milter at all so take this with a grain of salt, but the following from the man page seems hopeful for your environment: http://linux.die.net/man/1/spamass-m

Re: sendmail + spamassassin and SQL prefs

2011-05-16 Thread Scott
Hi Matt! Thanks for the hints... I currently use spamass-milter which seems to send the email address to SA but excludes the domain. For example on a email like sa...@domain.com it seems to check the DB using sales. This generally wouldn't be a problem on a small corp server however I have many

Re: sendmail + spamassassin and SQL prefs

2011-05-16 Thread Matt Elson
On Fri, 13 May 2011 10:59 -0600, "Scott" wrote: > I am using Sendmail and SQL prefs with SA. The problem I am having is > that Sendmail seems to only send the username to SA when filtering so > our aliases only use the default settings. What "glue" are you using to have Sendmail call SpamAssas

sendmail + spamassassin and SQL prefs

2011-05-13 Thread Scott
I am using Sendmail and SQL prefs with SA. The problem I am having is that Sendmail seems to only send the username to SA when filtering so our aliases only use the default settings. I should mention that we are using system users and aliases. I have tried something like the following in the loc

Re: spamassassin and sql

2006-07-07 Thread Martin Schiøtz
On 7/6/06, Stuart Johnston <[EMAIL PROTECTED]> wrote: Martin Schiøtz wrote: > Hi > > I'm trying to setup spamassassin with postgres for with bayes_sql, > awl_sql, dcc, razor using sql user_pref etc. > > I have configured the database with: > http://spamassassin.apache.org/full/3.1.x/dist/sql/awl_

Re: spamassassin and sql

2006-07-06 Thread Stuart Johnston
Martin Schiøtz wrote: Hi I'm trying to setup spamassassin with postgres for with bayes_sql, awl_sql, dcc, razor using sql user_pref etc. I have configured the database with: http://spamassassin.apache.org/full/3.1.x/dist/sql/awl_pg.sql wget http://spamassassin.apache.org/full/3.1.x/dist/sql/bay

spamassassin and sql

2006-07-06 Thread Martin Schiøtz
Hi I'm trying to setup spamassassin with postgres for with bayes_sql, awl_sql, dcc, razor using sql user_pref etc. I have configured the database with: http://spamassassin.apache.org/full/3.1.x/dist/sql/awl_pg.sql wget http://spamassassin.apache.org/full/3.1.x/dist/sql/bayes_pg.sql wget http://s

Re: SpamAssassin and SQL problems

2005-10-28 Thread Dan
I use the following spamd flags: -d -x -q -r pidfile The -x is for ignoring userpref files. You are using -Q which is similar to -q, both of which are supposed to be used with -x. This is according to spamd's man file. So my suggestion would be try adding -x to your spamd flags. Also I don't k

RE: SpamAssassin and SQL problems

2005-10-28 Thread Matthew.van.Eerde
Jon Schulman wrote: > When I do a spamassassin --lint, I receive the following message: > > config: SpamAssassin failed to parse line, skipping: > user_scores_sql_table userpref ... > # Setup db vars to point to the MySQL prefs > user_scores_dsn DBI:mysql:mail:localhost

SpamAssassin and SQL problems

2005-10-28 Thread Jon Schulman
Hello –   I am trying to manage a SpamAssassin implementation with a MySQL backend for users to manage their own settings. I am running into some strange problems with this, however.   When I do a spamassassin –lint, I receive the following message:   config: SpamAssassin failed to