Making Snort Work with MySQL

169

mysql> select * from sig_class;

+              +                          +

| sig_class_id | sig_class_name           |

+              +                          +

|            9 | attempted recon          |

|            8 | misc attack              |

|            7 | bad unknown              |

|            6 | web application activity |

+              +                          +

4 rows in set (0.00 sec)

mysql>

The select command pulls out data from a database and displays it on the screen.

You can use the select command after connecting to database using the mysql client.

For more information on MySQL commands, refer to Appendix B.

The following are some records in reference_system table.

mysql> select * from reference_system;

+               +                 +

| ref_system_id | ref_system_name |

+               +                 +

|             8 | nessus          |

|             7 | cve             |

|             6 | arachnids       |

|             5 | bugtraq         |

+               +                 +

4 rows in set (0.02 sec)

mysql>

The following output of the select command shows records in encoding table.

mysql> select * from encoding;

+               +               +

| encoding_type | encoding_text |

+               +               +

|             0 | hex           |

|             1 | base64        |

|             2 | ascii         |

+               +               +

3 rows in set (0.00 sec)

mysql>

The following output of the select command lists all entries in the services table

for port numbers between 20 and 30.