Re: [AMaViS-user] lookup SA user_prefs in SQL database

[Mark M. <Mar...@ij...>]

Guido,

> I am running amavisd-new 2.6.1 with SA 3.2.4.
> Sql lookups by amavis for sa_tag_level e.g. work fine.
>
> But I would like to configure my system that it can assign
> user specific scores. An user should be able to set the BAYES_99
> score to 5 for example, despite the default is 3.5.
> (User means recipient, there are no corresponding system users)
>
> AFAIK I have to configure that within SA. But SA completely ignores
> the sql settings in the local.cf file.
>
> If I use spamc to check a mail manually, the user specific sores work.
> So my SA sql setup should be fine.
>
> Generally SA threads the settings in the local.cf file. I tested that by
> adding lines like score GTUBE 111 directly in the file.
>
> - So, how can i convince SA--when invoked by amavis--to care
> - about my sql settings?

> PS There is a related diskussion on the SA user list.
> http://www.nabble.com/lookup-user_prefs-in-SQL-database-(not-using-spamc)-t
>d22681836.html

There is one fundamental problem which is difficult to overcome:
A mail message may have multiple recipients, yet amavisd calls
SpamAssassin only once per message. The SA SQL access to scores
in principle works, but which username will you specify when there
are several???

There is some example code/hack to load SQL user scores when there
is exactly one recipient to a message - search for: load_scoreonly
and the surrounding commented-out code.

A true solution while keeping a one-spam-check-per-message paradigm
would require modifying SpamAssassin to allow recomputing scores
repeatedly after spam checking, without having to evaluate rules
every time.

  Mark