Home page logo
/

snort logo Snort mailing list archives

Re: Barnyard2 issue w/unified2 ?
From: beenph <beenph () gmail com>
Date: Thu, 15 Aug 2013 11:11:25 -0400

As far as i remember you converted with alter table, you didn't used
InnoDB to create a new database as suggested.

Also if your UI does not use sig_reference you can allways use the
"disable_signature_reference_table" option to
prevent population of that table.

-elz


On Tue, Aug 13, 2013 at 2:32 PM, Jeff Kell <jeff-kell () utc edu> wrote:
On 8/9/2013 10:53 PM, beenph wrote:
I would highly suggest you that you
re-create a new DB with InnoDB and restart your barnyard2 sensor.

Worked until today...

Aug 13 09:59:42 snort-campus barnyard2[29878]:
===============================================================================
Aug 13 09:59:43 snort-campus barnyard2[29882]: 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 ('154939','167807','1');]
Aug 13 09:59:43 snort-campus barnyard2[29882]: Barnyard2 exiting
Aug 13 09:59:43 snort-campus barnyard2[29882]: database: Closing
connection to database "snort"

+------------------+--------+
| table_name       | engine |
+------------------+--------+
      ...
| event            | InnoDB |
| icmphdr          | InnoDB |
| iphdr            | InnoDB |
| opt              | InnoDB |
| reference        | InnoDB |
| reference_system | InnoDB |

Jeff


------------------------------------------------------------------------------
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. 
http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk
_______________________________________________
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://sourceforge.net/mailarchive/forum.php?forum_name=snort-users

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 ]
AlienVault