Snort notes

Reloading Snort rules without stopping the server:
     killall -HUP snort

Whitelisting an IP:
add the following to the /etc/snort/rules/local.rules

     pass udp 134.129.111.111 any -> any any ( sid:1000001 ;)
     pass udp any any -> 134.129.111.111 any ( sid:1000002 ;)

Exporting SQL tables and data

Following are the steps for exporting your database and data view script generation.

• Right click on the database that you would like to export
• Go to Tasks > Generate Scripts...
• A screen will pop up.  Your database should be selected in the list.
• Click Next
• Change the following settings
• General
• ANSI Padding = False
• Include Descriptive Headers = False
• Script Extended Properties = False
• Table/View Options
• Script Data = True
• Click Next
• Choose the Tables checkbox and click next
• Click the Select All button and click Finish
• Click Finish again and your script should be in a new query window.