search

hoterran / tcpcollect

Watch sql base libpcap
141 stars 59 forks source link

multistatement protocol #45

Open hoterran opened 11 years ago

hoterran commented 11 years ago 
T 127.0.0.1:50724 -> 127.0.0.1:3306 [AP]
  19 00 00 00 03 73 65 6c    65 63 74 20 31 3b 73 65    .....select 1;se
  6c 65 63 74 20 2a 20 66    72 6f 6d 20 6e             lect * from n

T 127.0.0.1:3306 -> 127.0.0.1:50724 [AP]
  01 00 00 01 01 17 00 00    02 03 64 65 66 00 00 00    ..........def...
  01 31 00 0c 3f 00 01 00    00 00 08 81 00 00 00 00    .1..?...........
  05 00 00 03 fe 00 00 0a    00 02 00 00 04 01 31 05    ..............1.
  00 00 05 fe 00 00 0a 00                               ........

T 127.0.0.1:3306 -> 127.0.0.1:50724 [AP]
  01 00 00 06 01 1e 00 00    07 03 64 65 66 04 74 65    ..........def.te
  73 74 01 6e 01 6e 01 6e    01 6e 0c 3f 00 0b 00 00    st.n.n.n.n.?....
  00 03 00 00 00 00 00 05    00 00 08 fe 00 00 22 00    ..............".
  02 00 00 09 01 31 02 00    00 0a 01 32 02 00 00 0b    .....1.....2....
  01 32 02 00 00 0c 01 31    02 00 00 0d 01 31 02 00    .2.....1.....1..
  00 0e 01 31 02 00 00 0f    01 31 02 00 00 10 01 31    ...1.....1.....1
  02 00 00 11 01 31 02 00    00 12 01 31 02 00 00 13    .....1.....1....
  01 31 02 00 00 14 01 31    02 00 00 15 01 31 02 00    .1.....1.....1..
  00 16 01 31 05 00 00 17    fe 00 00 22 00             ...1.......".
hoterran commented 11 years ago

record it，take care following resultset packet header detail。