Home page logo

snort logo Snort mailing list archives

Re: Barnyard2 issue w/unified2 ?
From: beenph <beenph () gmail com>
Date: Fri, 9 Aug 2013 22:44:38 -0400

On Fri, Aug 9, 2013 at 10:34 PM, Jeff Kell <jeff-kell () utc edu> wrote:
It's a classic BASE MySQL instance.  BASE is using adodb5.  As for the
schema...  umm...  I've slept a few times since creating the DB :)

Execute this query and look if your storage engine is set to InnoDB or MyIASM.

table_schema=DATABASE(); )


On 8/9/2013 10:26 PM, beenph wrote:
On Fri, Aug 9, 2013 at 9:06 PM, Jeff Kell <jeff-kell () utc edu> wrote:
Getting a rash of these recently... causes barnyard2 to abort, and only
way to "obviously" clear is to go to the database and "delete from

Aug  9 20:55:03 snort-dorms barnyard2[11053]: FATAL ERROR: database
mysql_error: Duplicate entry '167807-1' for key
'PRIMARY'#012#011SQL=[INSERT INTO sig_reference
(ref_id,sig_id,ref_seq) VALUES ('132475','167807','1');]
Aug  9 20:55:03 snort-dorms barnyard2[11053]: Barnyard2 exiting
Have also had it recur after the "delete" reset of the table.

We have 8 snort/barnyard2 instances running across multiple sensors, not
sure if that's relevant.

Which version of barnyard2 are you running?
Are you logging to a InnoDB or MyIASM schema?


Get 100% visibility into Java/.NET code with AppDynamics Lite!
It's a free troubleshooting tool designed for production.
Get down to code-level detail for bottlenecks, with <2% overhead. 
Download for free and get started troubleshooting in minutes. 
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
Snort-users list archive:

Please visit http://blog.snort.org to stay current on all the latest Snort news!

  By Date           By Thread  

Current thread:
[ Nmap | Sec Tools | Mailing Lists | Site News | About/Contact | Advertising | Privacy ]