Barnyard MySQL DB Reconnection Problem

Howdy,

Maybe someone can help me out with this problem as I am sure it must be a
pretty common one (or so I would think).

Quick info before I start:

Senor: Version 2.4.3 (Build 26)
Sensor: Barnyard Version 0.2.0 (Build 32)
DB Server: MySQL: 5.0.21 with OpenSSL enabled.

I use snort + barnyard to write to my remote MySQL db (remote being on the
same subnet but another machine).  Alerting, logging, and inserting into
the database works fine.  However, after period of inactivity, or if the
database is restarted -- we lose connection at some point.  The next time
a snort alert is triggered and barynard attempts to write to the database
I get this problem:

myhost1 barnyard[71485]: Lost connection to MySQL server.  Reconnecting

It doesn't appear to actually ever try and reconnect or anything.  Short
of restarting barnyard I can't see a way to fix this.  This doesn't seem
like it should be normal behavior.  Is there a way to have barnyard
/actually/ reconnect to the database?  Why must it be restarted in order
to truly reconnect.

Is there a work around or fix for this?  I've found limited responses on
the web, but I would have to think everyone using a remote db + barnyard
has to have this problem.  Besides restarting barnyard every so often or
monitoring /var/log/messages for "Lost connection to MySQL server." and
restarting the process -- is there another way to correct this issue?

Thanks




-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642