| blob | 3aedf7b349a73d422e9df36dc1b557b104988c24 |
1 # Test for the MySQL protocol dissector of Wireshark
2 #
3 # SPDX-License-Identifier: GPL-2.0-or-later
4 #
5 # Using PDML instead of JSON as output of tshark works better
6 # as some field names are duplicated, which isn't accepted in JSON
7 #
8 """MySQL tests"""
10 import subprocess
17 """MySQL 8.4.0 with results in binary resultset from prepared statement including the JSON field type"""
19 # MySQL Protocol - row packet
20 # Packet Length: 31
21 # Packet Number: 4
22 # Response Code: OK Packet (0x00)
23 # Row null buffer: 00
24 # Binary Field
25 # Length (JSON): 9
26 # JavaScript Object Notation
27 # Array
28 # [Path with value: /[]:1]
29 # [Member with value: []:1]
30 # Number value: 1
31 # [Path with value: /[]:2]
32 # [Member with value: []:2]
33 # Number value: 2
34 # [Path with value: /[]:3]
35 # [Member with value: []:3]
36 # Number value: 3
37 # Binary Field
38 # Length (JSON): 18
39 # JavaScript Object Notation
40 # Object
41 # Member: a
42 # [Path with value: /a:61]
43 # [Member with value: a:61]
44 # Number value: 61
45 # Key: a
46 # [Path: /a]
47 # Member: b
48 # [Path with value: /b:62]
49 # [Member with value: b:62]
50 # Number value: 62
51 # Key: b
52 # [Path: /b]
55 (
56 cmd_tshark,
65 ),
68 )
72 # There should not be any expert info as that indicates the dissector is incomplete
74 "./proto[@name='mysql']//field[@name='_ws.expert']"
75 ):
77 assert False
81 # Get the packet number
84 )
90 "./proto/field[@show='Binary Field']/proto/field"
91 )
95 """MySQL 8.4.0 with prepared statement and query attributes"""
98 (
99 cmd_tshark,
108 ),
111 )
113 # This is just a copy-paste of the `summary` variable and then formatted with the black formatter for python.
114 expected = {
122 ],
123 }
124 },
132 ],
133 }
134 },
146 ],
147 }
148 },
156 ],
157 }
158 },
170 ],
171 }
172 },
180 ],
181 }
182 },
194 ],
195 }
196 },
204 ],
205 }
206 },
218 ],
219 }
220 },
228 ],
229 }
230 },
241 ],
242 }
243 },
251 ],
252 }
253 },
265 ],
266 },
277 ],
278 },
289 ],
290 },
301 ],
302 },
313 ],
314 },
325 ],
326 },
337 ],
338 },
349 ],
350 },
361 ],
362 },
363 },
371 ],
372 }
373 },
384 ],
385 }
386 },
394 ],
395 }
396 },
404 ],
405 },
416 ],
417 },
428 ],
429 },
440 ],
441 },
452 ],
453 },
464 ],
465 },
476 ],
477 },
488 ],
489 },
497 ],
498 },
509 ],
510 },
511 },
519 ],
520 }
521 },
532 ],
533 }
534 },
542 ],
543 }
544 },
552 ],
553 }
554 },
555 }
557 # Summary should look like this:
558 # {
559 # <int:Packet Number>: {
560 # <int:MySQL Packet Number>: {
561 # "showname": <str>,
562 # "fields": [str, ...]
563 # }
564 # }
565 # }
566 summary = {}
570 # There should not be any expert info as that indicates the dissector is incomplete
572 "./proto[@name='mysql']//field[@name='_ws.expert']"
573 ):
575 assert False
579 # Get the packet number
582 )
589 )
593 }
598 )
607 )
611 )
614 """MySQL 5.7"""
617 (
618 cmd_tshark,
627 ),
630 )
632 # This is just a copy-paste of the `summary` variable and then formatted with the black formatter for python.
633 expected = {
641 ],
642 }
643 },
651 ],
652 }
653 },
664 ],
665 }
666 },
674 ],
675 }
676 },
684 ],
685 },
696 ],
697 },
701 },
712 ],
713 },
714 },
722 ],
723 }
724 },
735 ],
736 }
737 },
745 ],
746 }
747 },
755 ],
756 },
767 ],
768 },
779 ],
780 },
784 },
795 ],
796 },
797 },
805 ],
806 }
807 },
815 ],
816 },
827 ],
828 },
839 ],
840 },
851 ],
852 },
863 ],
864 },
868 },
879 ],
880 },
881 },
889 ],
890 }
891 },
898 "Message: Uptime: 126 Threads: 1 Questions: 18 Slow queries: 0 Opens: 105 Flush tables: 1 Open tables: 98 Queries per second avg: 0.142",
899 ],
900 }
901 },
909 ],
910 }
911 },
912 }
914 # Summary should look like this:
915 # {
916 # <int:Packet Number>: {
917 # <int:MySQL Packet Number>: {
918 # "showname": <str>,
919 # "fields": [str, ...]
920 # }
921 # }
922 # }
923 summary = {}
927 # There should not be any expert info as that indicates the dissector is incomplete
929 "./proto[@name='mysql']//field[@name='_ws.expert']"
930 ):
932 assert False
936 # Get the packet number
939 )
946 )
950 }
955 )
964 )
968 )
971 """MySQL 8.0"""
974 (
975 cmd_tshark,
984 ),
987 )
989 # This is just a copy-paste of the `summary` variable and then formatted with the black formatter for python.
990 expected = {
998 ],
999 }
1000 },
1008 ],
1009 }
1010 },
1021 ],
1022 }
1023 },
1031 ],
1032 }
1033 },
1041 ],
1042 },
1053 ],
1054 },
1058 },
1069 ],
1070 },
1071 },
1079 ],
1080 }
1081 },
1092 ],
1093 }
1094 },
1102 ],
1103 }
1104 },
1112 ],
1113 },
1124 ],
1125 },
1136 ],
1137 },
1141 },
1152 ],
1153 },
1154 },
1162 ],
1163 }
1164 },
1172 ],
1173 },
1184 ],
1185 },
1196 ],
1197 },
1208 ],
1209 },
1220 ],
1221 },
1225 },
1236 ],
1237 },
1238 },
1246 ],
1247 }
1248 },
1255 "Message: Uptime: 30 Threads: 2 Questions: 6 Slow queries: 0 Opens: 119 Flush tables: 3 Open tables: 38 Queries per second avg: 0.200",
1256 ],
1257 }
1258 },
1266 ],
1267 }
1268 },
1269 }
1271 # Summary should look like this:
1272 # {
1273 # <int:Packet Number>: {
1274 # <int:MySQL Packet Number>: {
1275 # "showname": <str>,
1276 # "fields": [str, ...]
1277 # }
1278 # }
1279 # }
1280 summary = {}
1284 # There should not be any expert info as that indicates the dissector is incomplete
1286 "./proto[@name='mysql']//field[@name='_ws.expert']"
1287 ):
1289 assert False
1293 # Get the packet number
1296 )
1303 )
1307 }
1312 )
1321 )
1325 )
1328 """MariaDB 11.4"""
1331 (
1332 cmd_tshark,
1341 ),
1344 )
1346 # This is just a copy-paste of the `summary` variable and then formatted with the black formatter for python.
1347 expected = {
1355 ],
1356 }
1357 },
1365 ],
1366 }
1367 },
1378 ],
1379 }
1380 },
1388 ],
1389 }
1390 },
1398 ],
1399 },
1410 ],
1411 },
1415 },
1426 ],
1427 },
1428 },
1436 ],
1437 }
1438 },
1449 ],
1450 }
1451 },
1459 ],
1460 }
1461 },
1469 ],
1470 },
1481 ],
1482 },
1493 ],
1494 },
1498 },
1509 ],
1510 },
1511 },
1519 ],
1520 }
1521 },
1529 ],
1530 },
1541 ],
1542 },
1553 ],
1554 },
1565 ],
1566 },
1577 ],
1578 },
1582 },
1593 ],
1594 },
1595 },
1603 ],
1604 }
1605 },
1612 "Message: Uptime: 25 Threads: 1 Questions: 5 Slow queries: 0 Opens: 17 Open tables: 10 Queries per second avg: 0.200",
1613 ],
1614 }
1615 },
1623 ],
1624 }
1625 },
1626 }
1628 # Summary should look like this:
1629 # {
1630 # <int:Packet Number>: {
1631 # <int:MySQL Packet Number>: {
1632 # "showname": <str>,
1633 # "fields": [str, ...]
1634 # }
1635 # }
1636 # }
1637 summary = {}
1641 # There should not be any expert info as that indicates the dissector is incomplete
1643 "./proto[@name='mysql']//field[@name='_ws.expert']"
1644 ):
1646 assert False
1650 # Get the packet number
1653 )
1660 )
1664 }
1669 )
1678 )
1682 )
1685 """TiDB 8.1"""
1688 (
1689 cmd_tshark,
1698 ),
1701 )
1703 # This is just a copy-paste of the `summary` variable and then formatted with the black formatter for python.
1704 expected = {
1712 ],
1713 }
1714 },
1722 ],
1723 }
1724 },
1735 ],
1736 }
1737 },
1745 ],
1746 }
1747 },
1755 ],
1756 },
1767 ],
1768 },
1772 },
1783 ],
1784 },
1785 },
1793 ],
1794 }
1795 },
1806 ],
1807 }
1808 },
1816 ],
1817 }
1818 },
1826 ],
1827 },
1838 ],
1839 },
1850 ],
1851 },
1855 },
1866 ],
1867 },
1868 },
1876 ],
1877 }
1878 },
1886 ],
1887 },
1898 ],
1899 },
1910 ],
1911 },
1922 ],
1923 },
1934 ],
1935 },
1939 },
1950 ],
1951 },
1952 },
1960 ],
1961 }
1962 },
1969 "Message: Uptime: 19 Threads: 0 Questions: 0 Slow queries: 0 Opens: 0 Flush tables: 0 Open tables: 0 Queries per second avg: 0.000",
1970 ],
1971 }
1972 },
1980 ],
1981 }
1982 },
1983 }
1985 # Summary should look like this:
1986 # {
1987 # <int:Packet Number>: {
1988 # <int:MySQL Packet Number>: {
1989 # "showname": <str>,
1990 # "fields": [str, ...]
1991 # }
1992 # }
1993 # }
1994 summary = {}
1998 # There should not be any expert info as that indicates the dissector is incomplete
2000 "./proto[@name='mysql']//field[@name='_ws.expert']"
2001 ):
2003 assert False
2007 # Get the packet number
2010 )
2017 )
2021 }
2026 )
2035 )
2039 )