Re: uridnsbl_skip_domain question

2024-05-18 Thread giovanni

On 5/17/24 3:17 PM, Matus UHLAR - fantomas wrote:

Hi guys,

I have configured exclusion for some common domains e.g. gov.sk in SA:

uridnsbl_skip_domain [...] gov.sk slovensko.sk

However it seems that that domain is still queried:

  9826  68.951573    127.0.0.1 → 127.0.0.1    DNS 104 Standard query 0xbffe A 
mail.gov.sk.multi.uribl.com OPT

in SA 4 docs I see that:

    uridnsbl_skip_domain domain1 domain2 ...
    Specify a domain, or a number of domains, which should be skipped
    for the URIBL checks.  This is very useful to specify very common
    domains which are not going to be listed in URIBLs.

    In addition to trimmed domain, the full hostname is also checked
    from the list.

Do I have to exclude subdomains for each host too?
(this would kind of defeat the directive imho).

This is SA 3.4.6 (debian 11) which does not have the latter paragraph but I 
assume the difference is only in documentation


From a quick look at the code it seems that subdomains check has been added to 
Mail::SpamAssassin::Plugin::URIDNSBL with commit r1889093 ~10 days after 3.4.6 
release.
In addition to that Mail::SpamAssassin::Plugin::DNSEval honor 
uridnsbl_skip_domain preference only in trunk code.

  Giovanni


OpenPGP_signature.asc
Description: OpenPGP digital signature


Re: Difference between spamc -L and sa-learn

2024-05-18 Thread Bill Cole

On 2024-05-18 at 10:26:54 UTC-0400 (Sat, 18 May 2024 16:26:54 +0200)
Francis Augusto Medeiros-Logeay 
is rumored to have said:


Hi,

Is there any difference between using spamc -L and sa-learn ?


Yes. The compiled-C spamc binary loads no Perl, it just talks over a 
socket to spamd, which is always running and so always has the advantage 
of a warmed-up i/o cache and a permanently loaded set of Perl code 
objects pre-compiled and in RAM; sa-learn has to open and compile all of 
the needed SA Perl code on every launch.



I noticed that the later is way slower.


Yes, it is. It is quite expensive to execute perl and have it load the 
many SpamAssassin modules needed to learn a message.




--
Bill Cole
b...@scconsult.com or billc...@apache.org
(AKA @grumpybozo@toad.social and many *@billmail.scconsult.com 
addresses)

Not Currently Available For Hire


Re: Error parsing sql configuration

2024-05-18 Thread Francis Augusto Medeiros-Logeay



> On 18 May 2024, at 17:10, Bill Cole  
> wrote:
> 
> On 2024-05-18 at 10:25:28 UTC-0400 (Sat, 18 May 2024 16:25:28 +0200)
> Francis Augusto Medeiros-Logeay 
> is rumored to have said:
> 
>> Hi,
>> 
>> I use Spamassassin 4 on Ubuntu 24.04.
>> 
>> I have configured SQL for storing user preferences. Things work fine, but I 
>> am getting these errors on my logs:
>> 
>> Sat May 18 16:22:21 2024 [75733] info: config: not parsing, administrator 
>> setting: use_pyzor\t1
>> Sat May 18 16:22:21 2024 [75733] info: config: failed to parse line in (sql 
>> config) (line 23): use_pyzor\t1
>> Sat May 18 16:22:21 2024 [75733] info: config: not parsing, administrator 
>> setting: use_razor2\t1
>> Sat May 18 16:22:21 2024 [75733] info: config: failed to parse line in (sql 
>> config) (line 28): use_razor2\t1
>> 
>> My query is pretty standard:
>> 
>> user_scores_sql_custom_query SELECT preference,value FROM 
>> spam_assassin_userpref WHERE username = _USERNAME_ OR username = '$GLOBAL' 
>> OR username = CONCAT('%',_DOMAIN_) ORDER BY username ASC
>> 
>> Is there a bug when parsing the preferences from sql?
> 
> It's not really a parsing error, it's a configuration error. You cannot set 
> "use_pyzor" or "use_razor" in user preferences, as they are both restricted 
> to system-wide config.


Thank you Bill. I kinda suspected that, but I am using a plugin called 
«sauserpref» on roundcube that actually set these on the database, so I was a 
bit unsure.

Best,
Francis 

Re: Error parsing sql configuration

2024-05-18 Thread Bill Cole

On 2024-05-18 at 10:25:28 UTC-0400 (Sat, 18 May 2024 16:25:28 +0200)
Francis Augusto Medeiros-Logeay 
is rumored to have said:


Hi,

I use Spamassassin 4 on Ubuntu 24.04.

I have configured SQL for storing user preferences. Things work fine, 
but I am getting these errors on my logs:


Sat May 18 16:22:21 2024 [75733] info: config: not parsing, 
administrator setting: use_pyzor\t1
Sat May 18 16:22:21 2024 [75733] info: config: failed to parse line in 
(sql config) (line 23): use_pyzor\t1
Sat May 18 16:22:21 2024 [75733] info: config: not parsing, 
administrator setting: use_razor2\t1
Sat May 18 16:22:21 2024 [75733] info: config: failed to parse line in 
(sql config) (line 28): use_razor2\t1


My query is pretty standard:

user_scores_sql_custom_query SELECT preference,value FROM 
spam_assassin_userpref WHERE username = _USERNAME_ OR username = 
'$GLOBAL' OR username = CONCAT('%',_DOMAIN_) ORDER BY username ASC


Is there a bug when parsing the preferences from sql?


It's not really a parsing error, it's a configuration error. You cannot 
set "use_pyzor" or "use_razor" in user preferences, as they are both 
restricted to system-wide config.





--
Bill Cole
b...@scconsult.com or billc...@apache.org
(AKA @grumpybozo@toad.social and many *@billmail.scconsult.com 
addresses)

Not Currently Available For Hire


Difference between spamc -L and sa-learn

2024-05-18 Thread Francis Augusto Medeiros-Logeay
Hi,

Is there any difference between using spamc -L and sa-learn ? I noticed that 
the later is way slower. I don’t use a journal for local updating, so both 
write directly to the database.

Best,

Francis 

Error parsing sql configuration

2024-05-18 Thread Francis Augusto Medeiros-Logeay
Hi,

I use Spamassassin 4 on Ubuntu 24.04.

I have configured SQL for storing user preferences. Things work fine, but I am 
getting these errors on my logs:

Sat May 18 16:22:21 2024 [75733] info: config: not parsing, administrator 
setting: use_pyzor\t1
Sat May 18 16:22:21 2024 [75733] info: config: failed to parse line in (sql 
config) (line 23): use_pyzor\t1
Sat May 18 16:22:21 2024 [75733] info: config: not parsing, administrator 
setting: use_razor2\t1
Sat May 18 16:22:21 2024 [75733] info: config: failed to parse line in (sql 
config) (line 28): use_razor2\t1

My query is pretty standard: 

user_scores_sql_custom_query SELECT preference,value FROM 
spam_assassin_userpref WHERE username = _USERNAME_ OR username = '$GLOBAL' OR 
username = CONCAT('%',_DOMAIN_) ORDER BY username ASC

Is there a bug when parsing the preferences from sql? 

Best,
Francis