Re: uridnsbl_skip_domain question
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
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
> 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
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
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
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