[Snort-users] barnyard to db
jed at ...153...
Wed Oct 3 23:44:03 EDT 2001
On Mon, Oct 01, 2001 at 04:39:57PM -0700, Andrew R. Baker wrote:
> > is there any db support through barnyard? I read the documentation,
> > and other than through the traditional snort output to MYSQL
> > and other unixodbc outputs, there was no mention of
> > db output from barnyard.
> there are not currently any database output plugins available in barnyard.
> I have contemplated porting Jed's database output plugin over to
> barnyard, but there are other things that need to be completed first.
Note that I made an attempt at porting the db plugin over to barnyard
beta2 a couple weeks ago and --- while I was able to get it partially
working there were some problems that do not have obvious solutions
(listed below). If you know of any simple workarounds or if any of
this is addressed in beta3 please let me know.
* The unified log format does not store any information about where
an event originated from (no host, interface, bpf filter string,
etc); thus, the database plugin is not able to determine which
sensor the event data is associated with. There are ways around
this, (eg. adding a new sensor each time barnyard executes, having a
single sensor for barnyard, etc...) but they all involve tossing out
the current notion of a sensor resulting in broken functionality in
one or more of the analysis apps that use the current db format.
* User defined rules don't log any message. This comes from the fact
that barnyard requires the use of the sid-msg.map file and that all
user defined rules actually have a "sid". The obvious workaround is
for users to maintain their rules in two places, but I personally am
not in support of this. Any chance snort could auto-generate this
file and auto-assign sid's for rules that don't have them?
* Alert / Log - I'm not interested in maintaining a separate database
plugin for each logging facility. In beta2 there was no way to
connect an output plugin to more than one input type. As it stands,
I connect only to "log".
> > I noticed that in the lecture you gave at IO Wargames,
> > you were mentioning 20,000 writes per
> > second though barnyard, compared to +-800 with MYSQL output
> > plugin from snort, and was wondering if that was to a
> > database, and if so, which one? Is this something for the future?
> The benchmark mentioned was obtained using a high speed embedded database.
> I will let Marty talk more about that if he wants to.
I've heard others mention these numbers. I am interested in seeing
some supporting data for this. Also, has anyone measured the
performance difference between barnyard and simply replaying pcap
through another instance of snort?
More information about the Snort-users