I have about 4million HMM records, startup was 2-3 minutes, but ASSP is on
Windows, in a VM, on a not so new (but new to the charity) host....
Whatever SQL you simplified has it at a couple seconds now! Terrific.
On the new SSL error/warnings, I'll open a thread to discuss in case it's
something more than just new warnings. I'm seeing bad file descriptor log
lines.
On Tue, Oct 5, 2021 at 2:03 AM Thomas Eckardt <thomas.ecka...@thockar.com>
wrote:
> >my very slow startup with the rebuild spamdb worker
>
> MySQL was blocking for a long time, because of a unnecessary complex
> SQL-statement for hmmdb and spamdb.
>
> In my case the delay was ~25 seconds for ~10 million database records.
>
> >Is that part of the improved error handling for SSL SMTP sessions over
> port 25?
>
> yes.
>
> Thomas
>
>
>
>
>
> Von: "K Post" <nntp.p...@gmail.com>
> An: "ASSP development mailing list" <
> assp-test@lists.sourceforge.net>
> Datum: 05.10.2021 01:27
> Betreff: Re: [Assp-test] fixes in assp 2.6.6 *SPAM-Evaporator*
> build 21277
> ------------------------------
>
>
>
> Thank you Thomas!!!
> This version solved my very slow startup with the rebuild spamdb worker.
>
> I am seeing some entries like:
> got an unexpected TLSv1_2 handshake Client-Helo-Frame of version (3.3)
> from IP '154.21.28.74' at local IP '(my ip here)' and Port '25' - this
> frame is ignored
>
> I don't believe I've seen those before this version. Is that part of the
> improved error handling for SSL SMTP sessions over port 25?
>
>
>
> On Mon, Oct 4, 2021 at 4:21 AM Thomas Eckardt <
> *thomas.ecka...@thockar.com* <thomas.ecka...@thockar.com>> wrote:
> Hi all,
>
> fixed in assp 2.6.6 *SPAM-Evaporator* build 21277:
>
> - If a relational DB engine was used for hmmDB and/or SpamDB, the start of
> the worker 10001 (rebuildspamdb worker) has taken much more time (under
> certain conditions)
> compared to the start time of all other workers
>
> - Improved error handling in case a client or server connects to the
> default SMTP-listener (25) using SSL.
>
> - The 'fakeAUTHsuccess' feature was not working like expected (caused by a
> fix for AUTH-error handling in assp 2.6.4 *SPAM-Evaporator* build 19284).
>
>
> added:
>
> - At the point in time the X-ASSP-.. headers were calculated, assp now
> calls '&CorrectASSPcfg::modMyHeader($Con{fh})' (if this sub is defined).
> This makes it possible to in place modify $Con{fh}->{myheader} to any
> special needs.
> Keep in mind: Modifying SMTP-headers in a wrong manner may prevent mails
> from beeing transported!
>
> Thomas
>
> DISCLAIMER:
> *******************************************************
> This email and any files transmitted with it may be confidential, legally
> privileged and protected in law and are intended solely for the use of the
> individual to whom it is addressed.
> This email was multiple times scanned for viruses. There should be no
> known virus in this email!
> *******************************************************
>
> _______________________________________________
> Assp-test mailing list
> *Assp-test@lists.sourceforge.net* <Assp-test@lists.sourceforge.net>
> *https://lists.sourceforge.net/lists/listinfo/assp-test*
> <https://lists.sourceforge.net/lists/listinfo/assp-test>
> _______________________________________________
> Assp-test mailing list
> Assp-test@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/assp-test
>
>
>
>
> DISCLAIMER:
> *******************************************************
> This email and any files transmitted with it may be confidential, legally
> privileged and protected in law and are intended solely for the use of the
> individual to whom it is addressed.
> This email was multiple times scanned for viruses. There should be no
> known virus in this email!
> *******************************************************
>
> _______________________________________________
> Assp-test mailing list
> Assp-test@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/assp-test
>
_______________________________________________
Assp-test mailing list
Assp-test@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/assp-test
