| blob | 8aab73fd188e260c542311c486ba340c06224d49 |
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 },
147 ],
148 }
149 },
157 ],
158 }
159 },
172 ],
173 }
174 },
182 ],
183 }
184 },
197 ],
198 }
199 },
207 ],
208 }
209 },
222 ],
223 }
224 },
232 ],
233 }
234 },
246 ],
247 }
248 },
256 ],
257 }
258 },
270 ],
271 },
282 ],
283 },
294 ],
295 },
306 ],
307 },
318 ],
319 },
330 ],
331 },
342 ],
343 },
354 ],
355 },
366 ],
367 },
368 },
376 ],
377 }
378 },
390 ],
391 }
392 },
400 ],
401 }
402 },
410 ],
411 },
422 ],
423 },
434 ],
435 },
446 ],
447 },
458 ],
459 },
470 ],
471 },
482 ],
483 },
494 ],
495 },
503 ],
504 },
516 ],
517 },
518 },
526 ],
527 }
528 },
540 ],
541 }
542 },
550 ],
551 }
552 },
560 ],
561 }
562 },
563 }
565 # Summary should look like this:
566 # {
567 # <int:Packet Number>: {
568 # <int:MySQL Packet Number>: {
569 # "showname": <str>,
570 # "fields": [str, ...]
571 # }
572 # }
573 # }
574 summary = {}
578 # There should not be any expert info as that indicates the dissector is incomplete
580 "./proto[@name='mysql']//field[@name='_ws.expert']"
581 ):
583 assert False
587 # Get the packet number
590 )
597 )
601 }
606 )
615 )
619 )
622 """MySQL 5.7"""
625 (
626 cmd_tshark,
635 ),
638 )
640 # This is just a copy-paste of the `summary` variable and then formatted with the black formatter for python.
641 expected = {
649 ],
650 }
651 },
659 ],
660 }
661 },
673 ],
674 }
675 },
683 ],
684 }
685 },
693 ],
694 },
705 ],
706 },
710 },
722 ],
723 },
724 },
732 ],
733 }
734 },
745 ],
746 }
747 },
755 ],
756 }
757 },
765 ],
766 },
777 ],
778 },
789 ],
790 },
794 },
806 ],
807 },
808 },
816 ],
817 }
818 },
826 ],
827 },
838 ],
839 },
850 ],
851 },
862 ],
863 },
874 ],
875 },
879 },
891 ],
892 },
893 },
901 ],
902 }
903 },
910 "Message: Uptime: 126 Threads: 1 Questions: 18 Slow queries: 0 Opens: 105 Flush tables: 1 Open tables: 98 Queries per second avg: 0.142",
911 ],
912 }
913 },
921 ],
922 }
923 },
924 }
926 # Summary should look like this:
927 # {
928 # <int:Packet Number>: {
929 # <int:MySQL Packet Number>: {
930 # "showname": <str>,
931 # "fields": [str, ...]
932 # }
933 # }
934 # }
935 summary = {}
939 # There should not be any expert info as that indicates the dissector is incomplete
941 "./proto[@name='mysql']//field[@name='_ws.expert']"
942 ):
944 assert False
948 # Get the packet number
951 )
958 )
962 }
967 )
976 )
980 )
983 """MySQL 8.0"""
986 (
987 cmd_tshark,
996 ),
999 )
1001 # This is just a copy-paste of the `summary` variable and then formatted with the black formatter for python.
1002 expected = {
1010 ],
1011 }
1012 },
1020 ],
1021 }
1022 },
1034 ],
1035 }
1036 },
1044 ],
1045 }
1046 },
1054 ],
1055 },
1066 ],
1067 },
1071 },
1083 ],
1084 },
1085 },
1093 ],
1094 }
1095 },
1106 ],
1107 }
1108 },
1116 ],
1117 }
1118 },
1126 ],
1127 },
1138 ],
1139 },
1150 ],
1151 },
1155 },
1167 ],
1168 },
1169 },
1177 ],
1178 }
1179 },
1187 ],
1188 },
1199 ],
1200 },
1211 ],
1212 },
1223 ],
1224 },
1235 ],
1236 },
1240 },
1252 ],
1253 },
1254 },
1262 ],
1263 }
1264 },
1271 "Message: Uptime: 30 Threads: 2 Questions: 6 Slow queries: 0 Opens: 119 Flush tables: 3 Open tables: 38 Queries per second avg: 0.200",
1272 ],
1273 }
1274 },
1282 ],
1283 }
1284 },
1285 }
1287 # Summary should look like this:
1288 # {
1289 # <int:Packet Number>: {
1290 # <int:MySQL Packet Number>: {
1291 # "showname": <str>,
1292 # "fields": [str, ...]
1293 # }
1294 # }
1295 # }
1296 summary = {}
1300 # There should not be any expert info as that indicates the dissector is incomplete
1302 "./proto[@name='mysql']//field[@name='_ws.expert']"
1303 ):
1305 assert False
1309 # Get the packet number
1312 )
1319 )
1323 }
1328 )
1337 )
1341 )
1344 """MariaDB 11.4"""
1347 (
1348 cmd_tshark,
1357 ),
1360 )
1362 # This is just a copy-paste of the `summary` variable and then formatted with the black formatter for python.
1363 expected = {
1371 ],
1372 }
1373 },
1381 ],
1382 }
1383 },
1395 ],
1396 }
1397 },
1405 ],
1406 }
1407 },
1415 ],
1416 },
1427 ],
1428 },
1432 },
1444 ],
1445 },
1446 },
1454 ],
1455 }
1456 },
1467 ],
1468 }
1469 },
1477 ],
1478 }
1479 },
1487 ],
1488 },
1499 ],
1500 },
1511 ],
1512 },
1516 },
1528 ],
1529 },
1530 },
1538 ],
1539 }
1540 },
1548 ],
1549 },
1560 ],
1561 },
1572 ],
1573 },
1584 ],
1585 },
1596 ],
1597 },
1601 },
1613 ],
1614 },
1615 },
1623 ],
1624 }
1625 },
1632 "Message: Uptime: 25 Threads: 1 Questions: 5 Slow queries: 0 Opens: 17 Open tables: 10 Queries per second avg: 0.200",
1633 ],
1634 }
1635 },
1643 ],
1644 }
1645 },
1646 }
1648 # Summary should look like this:
1649 # {
1650 # <int:Packet Number>: {
1651 # <int:MySQL Packet Number>: {
1652 # "showname": <str>,
1653 # "fields": [str, ...]
1654 # }
1655 # }
1656 # }
1657 summary = {}
1661 # There should not be any expert info as that indicates the dissector is incomplete
1663 "./proto[@name='mysql']//field[@name='_ws.expert']"
1664 ):
1666 assert False
1670 # Get the packet number
1673 )
1680 )
1684 }
1689 )
1698 )
1702 )
1705 """TiDB 8.1"""
1708 (
1709 cmd_tshark,
1718 ),
1721 )
1723 # This is just a copy-paste of the `summary` variable and then formatted with the black formatter for python.
1724 expected = {
1732 ],
1733 }
1734 },
1742 ],
1743 }
1744 },
1756 ],
1757 }
1758 },
1766 ],
1767 }
1768 },
1776 ],
1777 },
1788 ],
1789 },
1793 },
1805 ],
1806 },
1807 },
1815 ],
1816 }
1817 },
1828 ],
1829 }
1830 },
1838 ],
1839 }
1840 },
1848 ],
1849 },
1860 ],
1861 },
1872 ],
1873 },
1877 },
1889 ],
1890 },
1891 },
1899 ],
1900 }
1901 },
1909 ],
1910 },
1921 ],
1922 },
1933 ],
1934 },
1945 ],
1946 },
1957 ],
1958 },
1962 },
1974 ],
1975 },
1976 },
1984 ],
1985 }
1986 },
1993 "Message: Uptime: 19 Threads: 0 Questions: 0 Slow queries: 0 Opens: 0 Flush tables: 0 Open tables: 0 Queries per second avg: 0.000",
1994 ],
1995 }
1996 },
2004 ],
2005 }
2006 },
2007 }
2009 # Summary should look like this:
2010 # {
2011 # <int:Packet Number>: {
2012 # <int:MySQL Packet Number>: {
2013 # "showname": <str>,
2014 # "fields": [str, ...]
2015 # }
2016 # }
2017 # }
2018 summary = {}
2022 # There should not be any expert info as that indicates the dissector is incomplete
2024 "./proto[@name='mysql']//field[@name='_ws.expert']"
2025 ):
2027 assert False
2031 # Get the packet number
2034 )
2041 )
2045 }
2050 )
2059 )
2063 )