thanks for your reply but as i posted in my original post i already know about
all the protocol handshakes
i've now gotten far enough to get bad password error
length(buffer) : 76
H�#28000Access denied for user 'root'@'localhost' (using password: YES)
i'm trying to find the hash method from the seed to what hash is used etc (and
the fpc version etc)
On Mon, 31 Jul 2023 10:04:07 +0200
Rik van Kekem <r...@graficalc.nl> wrote:
> 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
