Re: MySQL

2019-07-02 Thread @lbutlr
On 2 Jul 2019, at 14:21, Kevin A. McGrail wrote: >> I guess the tl;dr version of my question (too late!) is how is the username >> field populated in the database? > > I think you are mixing up the user preference table and the naive bayesian > table. Apologies if the docs aren't clear. Pleas

Re: MySQL

2019-07-02 Thread Kevin A. McGrail
On 7/2/2019 3:45 PM, @lbutlr wrote: > Thanks, should I wait? For the 3.4.3 release? You can use rc3 today if you want.  I have it in production and it works fine. You can find it at http://talon2.pccc.com/~kmcgrail/devel/ > Looking over both the sql/README and the sql/README.bayes > > how does spa

Re: MySQL

2019-07-02 Thread @lbutlr
On 2 Jul 2019, at 09:12, Kevin A. McGrail wrote: > Those are still accurate as not much has changed. The new 3.4.3 rc3 has > some SQL changes for a last updated field which I've added over the > years for a cron job as well to clear out old entries. Thanks, should I wait? Looking over both the

Re: How do I filter emails that have only special characters in them.

2019-07-02 Thread Bill Cole
On 2 Jul 2019, at 8:42, Kevin A. McGrail wrote: Mark, can you put a sample up on pastebin? That looks like ASCII hex but ending up with UTF-8 chars I think. It is QP-encoded UTF-8, with the code points being chosen for visual equivalence to small latin capitals (mostly in the IPA Extensions

Re: How do I filter emails that have only special characters in them.

2019-07-02 Thread Kevin A. McGrail
On 7/2/2019 11:13 AM, Grant Taylor wrote: > On 7/2/19 6:42 AM, Kevin A. McGrail wrote: >> I can't remember an encoding format like that > > That looks like quoted printable at first (undercaffeinated) glance. Yep, definitely QP, thanks.

Re: How do I filter emails that have only special characters in them.

2019-07-02 Thread Grant Taylor
On 7/2/19 6:42 AM, Kevin A. McGrail wrote: I can't remember an encoding format like that That looks like quoted printable at first (undercaffeinated) glance. -- Grant. . . . unix || die smime.p7s Description: S/MIME Cryptographic Signature

Re: MySQL

2019-07-02 Thread Kevin A. McGrail
Those are still accurate as not much has changed.  The new 3.4.3 rc3 has some SQL changes for a last updated field which I've added over the years for a cron job as well to clear out old entries. On 7/2/2019 6:41 AM, @lbutlr wrote: > Is > > bayes_store_module Mail::SpamAssassin::BayesStore::MySQL

Re: How do I filter emails that have only special characters in them.

2019-07-02 Thread Sean Lynch
There's BODY_8BIT IIRC, which is 8 consecutive 8-bit characters. That'll catch sequences of UTF-8 characters outside the ASCII range since they all have the high bit set. On 7/2/19 5:16 AM, Mark London wrote: Hi - I'm trying to filter emails that have only special characters in them.   Like th

Re: How do I filter emails that have only special characters in them.

2019-07-02 Thread Mark London
The header is huge (stupid Microsoft!), but yes, it’s UTF-8 encoding, in order to include special characters that look like normal letters. So I can’t easily do text filtering on it. Below is the whole body of the text, except for a link at the bottom. It is not an html email. Maybe I can t

Re: How do I filter emails that have only special characters in them.

2019-07-02 Thread Kevin A. McGrail
Mark, can you put a sample up on pastebin? That looks like ASCII hex but ending up with UTF-8 chars I think. I can't remember an encoding format like that so hoping the sample gives me a hint. Regards, KAM -- Kevin A. McGrail Member, Apache Software Foundation Chair Emeritus Apache SpamAssassin P

How do I filter emails that have only special characters in them.

2019-07-02 Thread Mark London
Hi - I'm trying to filter emails that have only special characters in them. Like the text of the following email. Thanks. - Mark - =CA=9C=C9=AA=CA=80=E1=B4=87s s=CA=9C=E1=B4=87=E1=B4=8D=E1=B4=80=CA=9F=E1= =B4=87s =E1=B4=9B=E1=B4=8F s=E1=B4=9C=E1=B4=84=E1=B4=8B =E1=B4=9B=CA=9C=E1= =B4=87=C9=AA

MySQL

2019-07-02 Thread @lbutlr
Is bayes_store_module Mail::SpamAssassin::BayesStore::MySQL Still the current best configuration option for implementing bays SQL? I ask because the documentation I found mentions things like MySQL 4.1 so it’s a rather old document. In fact, it is old enough it’s from SA 3.1 days. I tried to s