How to load prev captured snort logs into MySQL database?

[BM Hall <hallbm () gmail com>]

I have configured snort to successfully log packets into a MySQL
database as they arrive at eth0.

My problem is that I have some binary log files that I need to load into
 MySQL for analysis by ACID.

I am doing something like this (file names simplified):
snort -r my.snort.log -c snort_dabaseinfo.conf

where snort_dabaseinfo.conf contains 1 line:
output database: log, mysql, dbasename=snort_log_db sensor_name=sensor1

(my.snort.log contains 348,197 packets)

When I do this, only one entry is made in the database: a record is
added to the sensor table for "sensor1". I am guessing here, but it
seems that the -r option switches off packet logging, which is
understandable if the output was to be just another flat file (i.e. a
copy of the input) but it seems to switch off logging to a database as
well.

I have also tried using the -r switch and my "regular" snort.conf (which
performs real-time database logging successfully) with the same lack of
success.

I have tried various switches, e.g. combinations of
-A none -L /dev/null -b -X
but with no success.

So how do I load binary log files into a database?

BM Hall





-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
https://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users