Op 30-07-2023 om 19:51 schreef paste...@gmx.com:output
sock1.lasterror : 0
length(buffer : 86
R
5.5.31-MariaDBs'c@Uh.H��`*O2J[n7eu@{mysql_native_password
length(buffer : 0
length(buffer : 37
!��#08S01Got packets out of order
What do you send to the server after it gives you the "Initial Handshake
Packet" ?
I see that you just send some random strings as username and password.
But where is your response to the initial handshake?
See here for the "Client Handshake Response"
https://mariadb.com/kb/en/connection/#initial-handshake-packet
You should follow the protocol exactly or else you'll get the "Got
packets out of order" message back.
So you need to send a packet back with information like this:
* int<4>
<https://mariadb.com/kb/en/protocol-data-types/#fixed-length-integers>client
capabilities
* int<4>
<https://mariadb.com/kb/en/protocol-data-types/#fixed-length-integers>max
packet size
* int<1>
<https://mariadb.com/kb/en/protocol-data-types/#fixed-length-integers>client
character collation
* string<19>
<https://mariadb.com/kb/en/protocol-data-types/#fixed-length-strings>reserved
* if not (server_capabilities & CLIENT_MYSQL)
o int<4>
<https://mariadb.com/kb/en/protocol-data-types/#fixed-length-integers>extended
client capabilities
* else
o string<4>
<https://mariadb.com/kb/en/protocol-data-types/#fixed-length-strings>reserved
* string<NUL>
<https://mariadb.com/kb/en/protocol-data-types/#null-terminated-strings>username
* etc etc
BTW. I still think you'll get better response on the FPC/Lazarus forum
because I don't look at this list much (If that message was from you?).
But you'll need to specify clearly you want to communicate native with
the MariaDB server without the official client library.
(Now it seems there were some communication issues there)
--
Grtz,
Rik
_______________________________________________
synalist-public mailing list
synalist-public@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/synalist-public
