[Snort-users] Barnyard2 and dealing with mysql_error
firnsy at ...14568...
Mon Aug 8 06:36:06 EDT 2011
Just to clean up the discussion on this list.
The mysql component of the database does have the option to
automatically reconnect on a dropped connection. It's auto discovered at
compile time and is checked using the mysql version number.
If configured correctly and supported by your mysql server, config.h
#define MYSQL_HAS_OPT_RECONNECT 1
What this is supposed to do is block the barnyard2 spooler until the
connection has re-established and then continue. Thus you would not miss
If your config.h has this option and you are in fact missing alerts then
that is a different story, a bug in fact and we'd be happy to here about
it on our mailing list.
On 08/08/11 06:38, James Lay wrote:
>> Greetings James,
>> is your database having some issue?
>> Where is your database located? On the same system on a remote system?
>> Is there any network quirks that woul tear down your session?
>> Are you using a SSL session?
>> Do you have some timeout values set in your my.conf (server side)?
> DB is peachy
> Oh it's remote (and on a certain PPPoE link you may be familiar with ;))
> Just my ISP 8-|...sometimes my pppoe link bounces..not often, but often
> enough (twice a month?).
> Negative on SSL (I know...I know.. ;))
> Haven't set the server variables yet in my.conf. I've seen some things
> after googling, but I'm hoping to get some recommendations here. Thank
> P.S. Joining the barnyard2 groups today so I don't drive everyone in the
> snort groups crazy ;)
> BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA
> The must-attend event for mobile developers. Connect with experts.
> Get tools for creating Super Apps. See the latest technologies.
> Sessions, hands-on labs, demos& much more. Register early& save!
> Snort-users mailing list
> Snort-users at lists.sourceforge.net
> Go to this URL to change user options or unsubscribe:
> Snort-users list archive:
> Please see http://www.snort.org/docs for documentation
More information about the Snort-users