Raw SQL in a packet?
Moderators: Community Managers, Developers
- John Adams
- Retired
- Posts: 4581
- Joined: Wed Aug 28, 2013 9:40 am
- Location: Phoenix, AZ.
- Contact:
Raw SQL in a packet?
Not sure if this is a bug, or some feature I don't know about yet but I just watched Zewtastic make a new toon and this big-azz packet came across, showing SQL query text in it. Is this right?
[quote]
0000: 00 0D 00 19 00 00 03 83 - 02 00 19 00 00 00 79 03 ..............y.
0010: 00 00 7A 00 65 00 77 00 - 74 00 61 00 73 00 74 00 ..z.e.w.t.a.s.t.
0020: 69 00 63 00 00 00 00 00 - 00 00 00 00 00 00 00 00 i.c.............
0030: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0040: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0050: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0060: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0070: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0080: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0090: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
00A0: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
00B0: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
00C0: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
00D0: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
00E0: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
00F0: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0100: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0110: 00 00 4E 00 65 00 77 00 - 20 00 54 00 65 00 6C 00 ..N.e.w. .T.e.l.
0120: 6F 00 6E 00 00 00 00 00 - 00 00 00 00 00 00 00 00 o.n.............
0130: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0140: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0150: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0160: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0170: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0180: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0190: 00 00 04 00 00 00 01 00 - 00 00 FF 00 00 00 FF 00 ................
01A0: 00 00 FF 00 00 00 30 00 - 00 00 0D 00 00 00 03 00 ......0.........
01B0: 00 00 01 00 00 00 E6 FF - FF FF 01 00 00 00 00 00 ................
01C0: 00 00 00 00 00 00 00 00 - 00 32 32 01 01 01 01 01 .........22.....
01D0: 01 01 01 01 01 32 32 32 - 32 32 32 32 32 32 32 32 .....22222222222
01E0: 32 32 32 32 32 32 32 32 - 32 32 32 32 32 32 32 32 2222222222222222
01F0: 32 32 32 32 32 32 32 32 - 32 32 32 32 32 32 89 CD 22222222222222..
20:47:49.612 E UDP Packet to client timeout after 300 milliseconds (3 tries, 100 milliseconds each)
20:47:49.612 E UDP Either there is a lot of packet loss or the client is not acking this packet
0000: 00 0D 00 1A 32 32 32 32 - 32 32 32 32 32 00 00 00 ....222222222...
0010: 00 5F 63 6C 61 73 73 60 - 2C 60 63 68 61 72 5F 67 ._class`,`char_g
0020: 65 6E 64 65 72 60 2C 60 - 61 64 76 65 6E 74 75 72 ender`,`adventur
0030: 65 5F 6C 65 76 65 6C 60 - 0A 46 52 4F 4D 20 60 63 e_level`.FROM `c
0040: 68 61 72 61 63 74 65 72 - 73 60 0A 57 48 45 52 45 haracters`.WHERE
0050: 20 60 61 63 63 6F 75 6E - 74 5F 69 64 60 3D 31 34 `account_id`=14
0060: 34 0A 41 4E 44 20 60 63 - 68 61 72 5F 64 65 6C 65 4.AND `char_dele
0070: 74 65 64 60 3D 30 0A 4C - 49 4D 49 54 20 31 32 00 ted`=0.LIMIT 12.
0080: 00 00 00 00 00 00 51 01 - 00 00 00 00 00 00 20 41 ......Q....... A
0090: 6A 00 00 00 00 00 D8 08 - E6 F6 FF 7F 00 00 00 00 j...............
00A0: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
00B0: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
00C0: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
00D0: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
00E0: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
00F0: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0100: 00 00 00 00 00 00 D1 00 - 00 00 00 00 00 00 98 07 ................
0110: E6 F6 FF 7F 00 00 F0 A4 - 6A 00 00 00 00 00 00 00 ........j.......
0120: 00 00 A9 24 08 00 00 00 - 0A 00 00 00 10 1A 6B 00 ...$..........k.
0130: 00 00 00 00 20 1A 6B 00 - 00 00 00 00 20 1A 6B 00 .... .k..... .k.
0140: 00 00 00 00 00 80 B7 F0 - 00 00 00 00 E9 1D 6B 00 ..............k.
0150: 00 00 00 00 21 03 00 00 - 00 00 00 00 80 20 6B 00 ....!........ k.
0160: 00 00 00 00 98 07 E6 F6 - FF 7F 00 00 20 00 00 00 ............ ...
0170: 00 00 00 00 60 00 00 00 - 00 00 00 00 20 1A 6B 00 ....`....... .k.
0180: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0190: 00 3B 49 .;I
20:48:20.330 I UDP Client from xxx.xxx.xxx.xxx set to disconnect in 60 seconds: Timeout
20:49:20.332 I UDP Client from xxx.xxx.xxx.xxx has been removed[/quote]
[quote]
0000: 00 0D 00 19 00 00 03 83 - 02 00 19 00 00 00 79 03 ..............y.
0010: 00 00 7A 00 65 00 77 00 - 74 00 61 00 73 00 74 00 ..z.e.w.t.a.s.t.
0020: 69 00 63 00 00 00 00 00 - 00 00 00 00 00 00 00 00 i.c.............
0030: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0040: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0050: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0060: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0070: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0080: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0090: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
00A0: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
00B0: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
00C0: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
00D0: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
00E0: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
00F0: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0100: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0110: 00 00 4E 00 65 00 77 00 - 20 00 54 00 65 00 6C 00 ..N.e.w. .T.e.l.
0120: 6F 00 6E 00 00 00 00 00 - 00 00 00 00 00 00 00 00 o.n.............
0130: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0140: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0150: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0160: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0170: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0180: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0190: 00 00 04 00 00 00 01 00 - 00 00 FF 00 00 00 FF 00 ................
01A0: 00 00 FF 00 00 00 30 00 - 00 00 0D 00 00 00 03 00 ......0.........
01B0: 00 00 01 00 00 00 E6 FF - FF FF 01 00 00 00 00 00 ................
01C0: 00 00 00 00 00 00 00 00 - 00 32 32 01 01 01 01 01 .........22.....
01D0: 01 01 01 01 01 32 32 32 - 32 32 32 32 32 32 32 32 .....22222222222
01E0: 32 32 32 32 32 32 32 32 - 32 32 32 32 32 32 32 32 2222222222222222
01F0: 32 32 32 32 32 32 32 32 - 32 32 32 32 32 32 89 CD 22222222222222..
20:47:49.612 E UDP Packet to client timeout after 300 milliseconds (3 tries, 100 milliseconds each)
20:47:49.612 E UDP Either there is a lot of packet loss or the client is not acking this packet
0000: 00 0D 00 1A 32 32 32 32 - 32 32 32 32 32 00 00 00 ....222222222...
0010: 00 5F 63 6C 61 73 73 60 - 2C 60 63 68 61 72 5F 67 ._class`,`char_g
0020: 65 6E 64 65 72 60 2C 60 - 61 64 76 65 6E 74 75 72 ender`,`adventur
0030: 65 5F 6C 65 76 65 6C 60 - 0A 46 52 4F 4D 20 60 63 e_level`.FROM `c
0040: 68 61 72 61 63 74 65 72 - 73 60 0A 57 48 45 52 45 haracters`.WHERE
0050: 20 60 61 63 63 6F 75 6E - 74 5F 69 64 60 3D 31 34 `account_id`=14
0060: 34 0A 41 4E 44 20 60 63 - 68 61 72 5F 64 65 6C 65 4.AND `char_dele
0070: 74 65 64 60 3D 30 0A 4C - 49 4D 49 54 20 31 32 00 ted`=0.LIMIT 12.
0080: 00 00 00 00 00 00 51 01 - 00 00 00 00 00 00 20 41 ......Q....... A
0090: 6A 00 00 00 00 00 D8 08 - E6 F6 FF 7F 00 00 00 00 j...............
00A0: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
00B0: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
00C0: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
00D0: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
00E0: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
00F0: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0100: 00 00 00 00 00 00 D1 00 - 00 00 00 00 00 00 98 07 ................
0110: E6 F6 FF 7F 00 00 F0 A4 - 6A 00 00 00 00 00 00 00 ........j.......
0120: 00 00 A9 24 08 00 00 00 - 0A 00 00 00 10 1A 6B 00 ...$..........k.
0130: 00 00 00 00 20 1A 6B 00 - 00 00 00 00 20 1A 6B 00 .... .k..... .k.
0140: 00 00 00 00 00 80 B7 F0 - 00 00 00 00 E9 1D 6B 00 ..............k.
0150: 00 00 00 00 21 03 00 00 - 00 00 00 00 80 20 6B 00 ....!........ k.
0160: 00 00 00 00 98 07 E6 F6 - FF 7F 00 00 20 00 00 00 ............ ...
0170: 00 00 00 00 60 00 00 00 - 00 00 00 00 20 1A 6B 00 ....`....... .k.
0180: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0190: 00 3B 49 .;I
20:48:20.330 I UDP Client from xxx.xxx.xxx.xxx set to disconnect in 60 seconds: Timeout
20:49:20.332 I UDP Client from xxx.xxx.xxx.xxx has been removed[/quote]
Re: Raw SQL in a packet?
Hehe nice. Your MySQL and servers are on the same box right?
Re: Raw SQL in a packet?
Is this where I was trying to log into the world earlier tonight? I never tried to make a toon, that is my already existing one.
- John Adams
- Retired
- Posts: 4581
- Joined: Wed Aug 28, 2013 9:40 am
- Location: Phoenix, AZ.
- Contact:
Re: Raw SQL in a packet?
[quote="Scatman"]Hehe nice. Your MySQL and servers are on the same box right?[/quote]
Nope, my Game Server mysql is all by itself on a VM.
Nope, my Game Server mysql is all by itself on a VM.
Re: Raw SQL in a packet?
I've seen this happen as well when running my own server. Is the packet data too large and running into the memory space where the sql statement is stored?
Re: Raw SQL in a packet?
Interesting. I wonder if our TCP connection and MySQL's TCP connection somehow got mixed up? Or a buffer wasn't cleared? Has it happened since? I thought your MySQL and game box were the same so I assumed it was just a unix socket.
- John Adams
- Retired
- Posts: 4581
- Joined: Wed Aug 28, 2013 9:40 am
- Location: Phoenix, AZ.
- Contact:
Re: Raw SQL in a packet?
No I haven't seen that again since. But I am seeing other weird packet dumps in Login I haven't seen before. Nothing with blatant MySQL query script in it though.