mysql userpref

Damian amavis at arcsin.de
Thu Dec 1 10:29:16 CET 2022


> I added such an entry in the amavis configuration, maybe you know why 
> it doesn't work?
> $sql_clause{'sel_wblist'} = 'SELECT "W" as wb';

Apparently the wblist code expects a user id. Try this sel_policy:

> SELECT username AS id, value AS spam_kill_level FROM userpref WHERE 
> preference = "required_score" AND username = %a
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.amavis.org/pipermail/amavis-users/attachments/20221201/09f2d02d/attachment.htm>


More information about the amavis-users mailing list