wma wrote:
> I use SpamAssassin-3.4.1p2 on OpenBSD 5.9.
> I also use sauserprefs plugin (v1.15-git) in Roundcube 1.1.4.
>
> I have a database 'mail' with the table 'userpref'.
> Through the sauserprefs, i can fill the userpref table.
> | username | preference | value | prefid
> +------------------+-----------------+-----------------------------
> | t...@domn2.net | blacklist_from | hiddenu...@gmail.com | 1
> | he...@domn1.net| blacklist frol | anyu...@anydomains.com| 2
^^^^^^^^^^^^^^^
(I'm assuming that's a copy-paste-typo with "blacklist frol" in that
second record.)
> May 27 09:46:51 openbsd spamd[22270]: spamd: processing message
> <CAEyg2TeAy2ZOz0Atp0rgRKKJhYvHevgPKHU=nxyobpj-4mv...@mail.gmail.com>
> for _spamdaemon:506
^^^^^^^^^^^^^^^
There's most of your problem; SA isn't being called with the
username(s) that you've entered the preferences for.
I'm not sure it's possible to do so sanely at this stage of mail
processing; for a multi-recipient message, whose preferences do you
use? (Especially when recipient A has a whitelist entry, and recipient
B has a blacklist entry, for the same sender.)
> And if i use spamd -D -xq
> Logs :
> May 26 14:56:31.329 [13829] dbg: config: Conf:QL: executing SQL: select
> preference, value from userpref where username = '_spamdaemon' or username =
^^^^^^^^^^^
> '@GLOBAL' order by username asc
> May 26 14:56:31.330 [13829] dbg: config: retrieving prefs for
> _spamdaemon from SQL server
^^^^^^^^^^^
Your debug logging is showing the same issue; spamd is being asked to
process messages for user "_spamdaemon", but you've entered preferences
for "t...@domn2.net" and "he...@domn1.net".
For per-user preferences I would strongly recommend switching to calling
SA on mail delivery, where you are (supposedly) guaranteed exactly one
recipient/"user", and you can use unique preferences on a per-user
basis. Or do your per-user whitelist/blacklist in your mail delivery
handler, entirely outside of SA.
-kgd
