It is most likely ssl related , or maybe ssl-verify-server. Both of which
used to be off by default, but now on by default.

Some people already complained that switching off SSL helped to speed
server (or client, or both) up <https://jira.mariadb.org/browse/MDEV-36267>
(. We do not know what it is, maybe it is large integer math which is slow,
but maybe the client is trying to read CRL from the internet, while doing
full-blown  certificate validation) But maybe you can help us understand,
since you're affected.

You probably need to restart server with --connect-timeout=1000 or
something like that

Can you run command line client with
a) --ssl=0
b) --ssl=1 --ssl-verify-server-cert=1
c) --ssl=1 --ssl-verify-server-cert=0


Can you report connect time with all these  configurations? Best, you do it
in a bug report  here https://jira.mariadb.org/ ?
HeidiSQL perhaps does not do this auto-SSL, or maybe it just uses an older
client library.

Thank you!


On Fri, Apr 11, 2025 at 8:24 AM gerhard.pauls--- via discuss <
[email protected]> wrote:

> Hi,
>
> I installed MariaDB 11.4.5 on Windows Server 2019.
> The command line client installed together with server can't connect:
>
> C: \Program Files\MariaDB 11.4\bin>mysql -u user -p
> ERROR 2813 (HY000): Lost connection to server at 'sending authentication
> information', system error: 0
>
> In the server err log:
> [Warning] Could not read packet: fd: 1424 state: 1 read length: 4 errno: 0
> vio_errno: 1158 length: -1
>
> Problem does not occur with HeidiSQL.
> Problem does not occur with MariaDB clients version 11.4.0 or lower
> Problem occurs with MariaDB clients version 11.4.1 or higher
>
> Any idea what the problem might be?
>
> Best regards,
> Gerhard
> _______________________________________________
> discuss mailing list -- [email protected]
> To unsubscribe send an email to [email protected]
>
_______________________________________________
discuss mailing list -- [email protected]
To unsubscribe send an email to [email protected]

Reply via email to