API tools faq
paste
Advertisement
sergioMITM

snort mysql default tables

sergioMITM
Jan 29th, 2018
314
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.97 KB | None | 0 0
raw download clone embed print report
  1. +------------------+
  2. | Tables_in_snort |
  3. +------------------+
  4. | data |
  5. | detail |
  6. | encoding |
  7. | event |
  8. | icmphdr |
  9. | iphdr |
  10. | opt |
  11. | reference |
  12. | reference_system |
  13. | schema |
  14. | sensor |
  15. | sig_class |
  16. | sig_reference |
  17. | signature |
  18. | tcphdr |
  19. | udphdr |
  20. +------------------+
  21.  
  22. mysql> describe data;
  23. +--------------+------------------+------+-----+---------+-------+
  24. | Field | Type | Null | Key | Default | Extra |
  25. +--------------+------------------+------+-----+---------+-------+
  26. | sid | int(10) unsigned | NO | PRI | NULL | |
  27. | cid | int(10) unsigned | NO | PRI | NULL | |
  28. | data_payload | text | YES | | NULL | |
  29. +--------------+------------------+------+-----+---------+-------+
  30. 3 rows in set (0.06 sec)
  31.  
  32. mysql> describe detail;
  33. +-------------+---------------------+------+-----+---------+-------+
  34. | Field | Type | Null | Key | Default | Extra |
  35. +-------------+---------------------+------+-----+---------+-------+
  36. | detail_type | tinyint(3) unsigned | NO | PRI | NULL | |
  37. | detail_text | text | NO | | NULL | |
  38. +-------------+---------------------+------+-----+---------+-------+
  39. 2 rows in set (0.01 sec)
  40.  
  41. mysql> describe encoding;
  42. +---------------+---------------------+------+-----+---------+-------+
  43. | Field | Type | Null | Key | Default | Extra |
  44. +---------------+---------------------+------+-----+---------+-------+
  45. | encoding_type | tinyint(3) unsigned | NO | PRI | NULL | |
  46. | encoding_text | text | NO | | NULL | |
  47. +---------------+---------------------+------+-----+---------+-------+
  48. 2 rows in set (0.00 sec)
  49.  
  50. mysql> describe event;
  51. +-----------+------------------+------+-----+---------+-------+
  52. | Field | Type | Null | Key | Default | Extra |
  53. +-----------+------------------+------+-----+---------+-------+
  54. | sid | int(10) unsigned | NO | PRI | NULL | |
  55. | cid | int(10) unsigned | NO | PRI | NULL | |
  56. | signature | int(10) unsigned | NO | MUL | NULL | |
  57. | timestamp | datetime | NO | MUL | NULL | |
  58. +-----------+------------------+------+-----+---------+-------+
  59. 4 rows in set (0.00 sec)
  60.  
  61. mysql> describe icmphdr;
  62. +-----------+----------------------+------+-----+---------+-------+
  63. | Field | Type | Null | Key | Default | Extra |
  64. +-----------+----------------------+------+-----+---------+-------+
  65. | sid | int(10) unsigned | NO | PRI | NULL | |
  66. | cid | int(10) unsigned | NO | PRI | NULL | |
  67. | icmp_type | tinyint(3) unsigned | NO | MUL | NULL | |
  68. | icmp_code | tinyint(3) unsigned | NO | | NULL | |
  69. | icmp_csum | smallint(5) unsigned | YES | | NULL | |
  70. | icmp_id | smallint(5) unsigned | YES | | NULL | |
  71. | icmp_seq | smallint(5) unsigned | YES | | NULL | |
  72. +-----------+----------------------+------+-----+---------+-------+
  73. 7 rows in set (0.01 sec)
  74.  
  75. mysql> describe iphdr;
  76. +----------+----------------------+------+-----+---------+-------+
  77. | Field | Type | Null | Key | Default | Extra |
  78. +----------+----------------------+------+-----+---------+-------+
  79. | sid | int(10) unsigned | NO | PRI | NULL | |
  80. | cid | int(10) unsigned | NO | PRI | NULL | |
  81. | ip_src | int(10) unsigned | NO | MUL | NULL | |
  82. | ip_dst | int(10) unsigned | NO | MUL | NULL | |
  83. | ip_ver | tinyint(3) unsigned | YES | | NULL | |
  84. | ip_hlen | tinyint(3) unsigned | YES | | NULL | |
  85. | ip_tos | tinyint(3) unsigned | YES | | NULL | |
  86. | ip_len | smallint(5) unsigned | YES | | NULL | |
  87. | ip_id | smallint(5) unsigned | YES | | NULL | |
  88. | ip_flags | tinyint(3) unsigned | YES | | NULL | |
  89. | ip_off | smallint(5) unsigned | YES | | NULL | |
  90. | ip_ttl | tinyint(3) unsigned | YES | | NULL | |
  91. | ip_proto | tinyint(3) unsigned | NO | | NULL | |
  92. | ip_csum | smallint(5) unsigned | YES | | NULL | |
  93. +----------+----------------------+------+-----+---------+-------+
  94. 14 rows in set (0.00 sec)
  95.  
  96. mysql> describe opt;
  97. +-----------+---------------------+------+-----+---------+-------+
  98. | Field | Type | Null | Key | Default | Extra |
  99. +-----------+---------------------+------+-----+---------+-------+
  100. | sid | int(10) unsigned | NO | PRI | NULL | |
  101. | cid | int(10) unsigned | NO | PRI | NULL | |
  102. | optid | int(10) unsigned | NO | PRI | NULL | |
  103. | opt_proto | tinyint(3) unsigned | NO | | NULL | |
  104. | opt_code | tinyint(3) unsigned | NO | | NULL | |
  105. | opt_len | smallint(6) | YES | | NULL | |
  106. | opt_data | text | YES | | NULL | |
  107. +-----------+---------------------+------+-----+---------+-------+
  108. 7 rows in set (0.00 sec)
  109.  
  110. mysql> describe reference;
  111. +---------------+------------------+------+-----+---------+----------------+
  112. | Field | Type | Null | Key | Default | Extra |
  113. +---------------+------------------+------+-----+---------+----------------+
  114. | ref_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
  115. | ref_system_id | int(10) unsigned | NO | | NULL | |
  116. | ref_tag | text | NO | | NULL | |
  117. +---------------+------------------+------+-----+---------+----------------+
  118. 3 rows in set (0.01 sec)
  119.  
  120. mysql> describe reference_system;
  121. +-----------------+------------------+------+-----+---------+----------------+
  122. | Field | Type | Null | Key | Default | Extra |
  123. +-----------------+------------------+------+-----+---------+----------------+
  124. | ref_system_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
  125. | ref_system_name | varchar(20) | YES | | NULL | |
  126. +-----------------+------------------+------+-----+---------+----------------+
  127. 2 rows in set (0.00 sec)
  128.  
  129. mysql> describe sensor;
  130. +-----------+------------------+------+-----+---------+----------------+
  131. | Field | Type | Null | Key | Default | Extra |
  132. +-----------+------------------+------+-----+---------+----------------+
  133. | sid | int(10) unsigned | NO | PRI | NULL | auto_increment |
  134. | hostname | text | YES | | NULL | |
  135. | interface | text | YES | | NULL | |
  136. | filter | text | YES | | NULL | |
  137. | detail | tinyint(4) | YES | | NULL | |
  138. | encoding | tinyint(4) | YES | | NULL | |
  139. | last_cid | int(10) unsigned | NO | | NULL | |
  140. +-----------+------------------+------+-----+---------+----------------+
  141. 7 rows in set (0.00 sec)
  142.  
  143. mysql> describe sig_class;
  144. +----------------+------------------+------+-----+---------+----------------+
  145. | Field | Type | Null | Key | Default | Extra |
  146. +----------------+------------------+------+-----+---------+----------------+
  147. | sig_class_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
  148. | sig_class_name | varchar(60) | NO | MUL | NULL | |
  149. +----------------+------------------+------+-----+---------+----------------+
  150. 2 rows in set (0.01 sec)
  151.  
  152. mysql> describe sig_reference;
  153. +---------+------------------+------+-----+---------+-------+
  154. | Field | Type | Null | Key | Default | Extra |
  155. +---------+------------------+------+-----+---------+-------+
  156. | sig_id | int(10) unsigned | NO | PRI | NULL | |
  157. | ref_seq | int(10) unsigned | NO | PRI | NULL | |
  158. | ref_id | int(10) unsigned | NO | | NULL | |
  159. +---------+------------------+------+-----+---------+-------+
  160. 3 rows in set (0.00 sec)
  161.  
  162. mysql> describe signature;
  163. +--------------+------------------+------+-----+---------+----------------+
  164. | Field | Type | Null | Key | Default | Extra |
  165. +--------------+------------------+------+-----+---------+----------------+
  166. | sig_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
  167. | sig_name | varchar(255) | NO | MUL | NULL | |
  168. | sig_class_id | int(10) unsigned | NO | MUL | NULL | |
  169. | sig_priority | int(10) unsigned | YES | | NULL | |
  170. | sig_rev | int(10) unsigned | YES | | NULL | |
  171. | sig_sid | int(10) unsigned | YES | | NULL | |
  172. | sig_gid | int(10) unsigned | YES | | NULL | |
  173. +--------------+------------------+------+-----+---------+----------------+
  174. 7 rows in set (0.01 sec)
  175.  
  176. mysql> describe tcphdr;
  177. +-----------+----------------------+------+-----+---------+-------+
  178. | Field | Type | Null | Key | Default | Extra |
  179. +-----------+----------------------+------+-----+---------+-------+
  180. | sid | int(10) unsigned | NO | PRI | NULL | |
  181. | cid | int(10) unsigned | NO | PRI | NULL | |
  182. | tcp_sport | smallint(5) unsigned | NO | MUL | NULL | |
  183. | tcp_dport | smallint(5) unsigned | NO | MUL | NULL | |
  184. | tcp_seq | int(10) unsigned | YES | | NULL | |
  185. | tcp_ack | int(10) unsigned | YES | | NULL | |
  186. | tcp_off | tinyint(3) unsigned | YES | | NULL | |
  187. | tcp_res | tinyint(3) unsigned | YES | | NULL | |
  188. | tcp_flags | tinyint(3) unsigned | NO | MUL | NULL | |
  189. | tcp_win | smallint(5) unsigned | YES | | NULL | |
  190. | tcp_csum | smallint(5) unsigned | YES | | NULL | |
  191. | tcp_urp | smallint(5) unsigned | YES | | NULL | |
  192. +-----------+----------------------+------+-----+---------+-------+
  193. 12 rows in set (0.00 sec)
  194.  
  195. mysql> describe udphdr;
  196. +-----------+----------------------+------+-----+---------+-------+
  197. | Field | Type | Null | Key | Default | Extra |
  198. +-----------+----------------------+------+-----+---------+-------+
  199. | sid | int(10) unsigned | NO | PRI | NULL | |
  200. | cid | int(10) unsigned | NO | PRI | NULL | |
  201. | udp_sport | smallint(5) unsigned | NO | MUL | NULL | |
  202. | udp_dport | smallint(5) unsigned | NO | MUL | NULL | |
  203. | udp_len | smallint(5) unsigned | YES | | NULL | |
  204. | udp_csum | smallint(5) unsigned | YES | | NULL | |
  205. +-----------+----------------------+------+-----+---------+-------+
  206. 6 rows in set (0.01 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!