dbeaver登录informix报文分析-hex

《dbeaver登录informix报文分析-hex》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、000001B3000001C3000001D3000001E3SelectDebeaver作为客户端一自动下载驱动:•A?H..E.mdbmd41,2,3,9.f.2#...orderby*.•1»•7•c.•b•ISELEnerFROM春•參1«.088oal5004C5O7d08c814ooa8854a9f053c9eo50SQL长度ul-3t>2a6oi1o!:oo1o24r*pCO2Obo8o803084205f281838e2d47398d86o35604011dooo-26••••©#•••rf.

2、••攀088oal5004C500028481400253454c4500OcSQL长度73004c728006co2o-dbo8o8o3od842065d41118cb6edc3o972cc27do6d356fd40001000000001000200030004000500060000000100020003000400050Select语川（六个字节开始）（六/七个字节结束）以00020000开始，紧跟两个字节select语句长度（不包含包头和乜尾），最后以00160031000c—-SQL长度为偶数或0

3、000160031000cSQL长度为奇数保-证报文整体为偶数字节，结束。通过报文尖00020000以及报文尾00160031000c判断报文为select语川报文。（冇的以00020000开头,不以00160031000c结尾的报文不是selcet语句报文）。WinSQL作为客户端一IBMinformixclient4.10驱动:0000015100000161000001710000018100000191000001A1000001B1包头<^0100:736d616c6c666c6f696e666f72

4、6d697865732077686572652031006f003100037572736f72000006000cSQL长度登录第二条报文select标识不为00020003c73656c65637420313a3a…"

5、ursor.-Kt的selei?HiJ规则勹Dbeaver登求一样00020000002d73656c65637420646973-selectdis74696e6374206f776e65722066726f6dtinctownerfrom20696e666f726d69782e737973746162informix.systab6c65730000160031000cles....l..包尾Inser、create、dropDebeaver作为客户端：（An为偶以（六个字节开始，五六位为语句长度n）n个

6、字节语句数/九n为奇数，个字节结朿）。包头SQL长度Drop语句000038A100010000001164726f70207461626c65......droptable000038B12064626d6431380000160007000b000cdbmdl8KInsert语句包尾000004E700010000002c696e7365727420696e74..^insertint000004F76f2064626d6431352076616c75657328odbmdl5values(00000507

7、202027696e666f726d6978272c275427•inforrnix'/T'00000517202900160007000b000c)••••••••Create语句0000038500000395000003A5000003B5000003C5000003D5000003E50001000000596372656174652074656d..…Ycreatetem70207461626c652064626d6431352820ptabledbmdl5(20205441424c455f53434

8、8454d202020TABLESCHEM7661726368617228616274797065202020292077697468200016000700Ob000c3835292c20202074varcharf85),t2063686172283129abtypechar⑴6e6f206c6f673b00)withnolog;.登录Debeaver作为客户端:olJnfohdL