[prev in list] [next in list] [prev in thread] [next in thread] 

List:       spamassassin-users
Subject:    Re: Welcome/unwelcome list not working correctly.
From:       Tom Hendrikx <tom () whyscream ! net>
Date:       2023-07-24 20:24:07
Message-ID: 6cb6c005-251c-eb15-04b9-129d2c27c4a1 () whyscream ! net
[Download RAW message or body]

On 22-07-2023 13:31, Henrik K via users wrote:
> On Sat, Jul 22, 2023 at 10:13:42AM +0200, Benny Pedersen wrote:
>> Henrik K via users skrev den 2023-07-22 06:50:
>>
>>>> | gvk      | unwhitelist_from        |
>>>> grant.keller@sonic.com   | 7421538 |
>>>> | gvk      | whitelist_from          | *@sonic.com   | 7526210 |
>>
>> user_prefs in sql/ldap can not do unwhitelist, it
>> missing priority field in sql/ldap for this to work,
>> only thing that is possible as now is to remove the
>> whitelist not add unwhitelist, would need feature
>> request for priority field
> 
> No need for feature request, already exists:
> 
> user_scores_sql_custom_query
> 
> Create own SQL that sorts as you want, for example MySQL ORDER BY
> FIELD(...).
> 
> Then again why even write unneeded stuff in DB.  Fix it in the backend or
> create triggers etc to cleanup redundant stuff.
> 

I do agree with Benny that if the order of directives matterbecause of 
the way it is implemented in SA, then the default/example implementation 
should enforce a clear (if not useful) order.

There is nothing mentioned regarding order in 
https://cwiki.apache.org/confluence/display/SPAMASSASSIN/usingsql, or in 
https://svn.apache.org/repos/asf/spamassassin/tags/spamassassin_current_release_4.0.x/sql/README


Kind reagards,
Tom
[prev in list] [next in list] [prev in thread] [next in thread]