RE: lookup user_prefs in SQL database (not using spamc)

2009-03-29 Thread Guido Leisker
Have you restarted amavisd-new since you added the @lookup_sql_dsn? Yes, I did. What I tried for example is to add a score -111 to GTUBE manually in the local.cf. That does work. I think that makes sure that amavis(using SA) uses the latest local.cf, right? BTW: spamassassin should not try

Re: lookup user_prefs in SQL database (not using spamc)

2009-03-26 Thread Mark Martinec
Guido, I am trying to configure my system that it can assign user specific scores. I therefore set up a table like described in [1]. This runs fine, as long as I use spamc to scan mails. But actually I want to use Amavisd-new using spamassassin. Here spamassassin complety ignores the sql

Re: lookup user_prefs in SQL database (not using spamc)

2009-03-25 Thread Guido
On (09-03-24 11:10), McDonald, Dan wrote: On Tue, 2009-03-24 at 16:30 +0100, Guido wrote: - How can I convince spamassassin (used by amavisd-new) to care about my user_prefs in the database? What I mean is per recipient settings. Have you restarted amavisd-new since you added the

Re: lookup user_prefs in SQL database (not using spamc)

2009-03-25 Thread Guido
I believe it means you should take up this issue with the Amavisd-new support forum. Since you are not RUNNING SpamAssassin/spamc/spamd then some parts of the configuration simply are not made effective in your situation. You must look for a solution within the software that actually

Re: lookup user_prefs in SQL database (not using spamc)

2009-03-25 Thread Michael Parker
On Mar 25, 2009, at 9:30 AM, Guido wrote: I believe it means you should take up this issue with the Amavisd- new support forum. Since you are not RUNNING SpamAssassin/spamc/spamd then some parts of the configuration simply are not made effective in your situation. You must look for a

RE: lookup user_prefs in SQL database ( not using spamc)

2009-03-24 Thread Bowie Bailey
Guido wrote: Hi, I am trying to configure my system that it can assign user specific scores. I therefore set up a table like described in [1]. This runs fine, as long as I use spamc to scan mails. But actually I want to use Amavisd-new using spamassassin. Here spamassassin complety

RE: lookup user_prefs in SQL database (not using spamc)

2009-03-24 Thread Guido
- How can I convince spamassassin (used by amavisd-new) to care about my user_prefs in the database? Amavisd-new scans everything as a single user. It has no concept of per-user settings. What I mean is per recipient settings. And if that's the case, at least the default settings

RE: lookup user_prefs in SQL database (not using spamc)

2009-03-24 Thread McDonald, Dan
On Tue, 2009-03-24 at 16:30 +0100, Guido wrote: - How can I convince spamassassin (used by amavisd-new) to care about my user_prefs in the database? Amavisd-new scans everything as a single user. It has no concept of per-user settings You probably need to read the sql