snort: database: mysql_error: Duplicate entry

[Adam Kaufman <adam_kaufman () yahoo com>]

I just updated the rules on one of my sensors and now I am getting the
following errors in syslog:

Jan 20 20:25:14 sensor snort: database: mysql_error: Duplicate entry
'1-1491262' for key 1
Jan 20 20:25:14 sensor SQL=INSERT INTO event
(sid,cid,signature,timestamp) VALUES ('1', '1491262', '14', '2004-01-20
20:25:14+00')
Jan 20 20:25:14 sensor snort: database: mysql_error: Duplicate entry
'1-1491263' for key 1
Jan 20 20:25:14 sensor SQL=INSERT INTO event
(sid,cid,signature,timestamp) VALUES ('1', '1491263', '14', '2004-01-20
20:25:14+00')
Jan 20 20:25:15 sensor snort: database: mysql_error: Duplicate entry
'1-1491264' for key 1
Jan 20 20:25:15 sensor SQL=INSERT INTO event
(sid,cid,signature,timestamp) VALUES ('1', '1491264', '496',
'2004-01-20 20:25:15+00')
Jan 20 20:25:15 sensor snort: database: mysql_error: Duplicate entry
'1-1491265' for key 1
Jan 20 20:25:15 sensor SQL=INSERT INTO event
(sid,cid,signature,timestamp) VALUES ('1', '1491265', '491',
'2004-01-20 20:25:15+00')
Jan 20 20:25:15 sensor snort: database: mysql_error: Duplicate entry
'1-1491266' for key 1
Jan 20 20:25:15 sensor SQL=INSERT INTO event
(sid,cid,signature,timestamp) VALUES ('1', '1491266', '491',
'2004-01-20 20:25:15+00')
Jan 20 20:25:17 sensor snort: database: mysql_error: Duplicate entry
'1-1491267' for key 1
Jan 20 20:25:17 sensor SQL=INSERT INTO event
(sid,cid,signature,timestamp) VALUES ('1', '1491267', '17', '2004-01-20
20:25:17+00')
Jan 20 20:25:17 sensor snort: database: mysql_error: Duplicate entry
'1-1491268' for key 1
Jan 20 20:25:17 sensor SQL=INSERT INTO event
(sid,cid,signature,timestamp) VALUES ('1', '1491268', '13', '2004-01-20
20:25:17+00')
Jan 20 20:25:18 sensor snort: database: mysql_error: Duplicate entry
'1-1491269' for key 1
Jan 20 20:25:18 sensor SQL=INSERT INTO event
(sid,cid,signature,timestamp) VALUES ('1', '1491269', '7', '2004-01-20
20:25:17+00')
Jan 20 20:25:19 sensor snort: database: mysql_error: Duplicate entry
'1-1491270' for key 1
Jan 20 20:25:19 sensor SQL=INSERT INTO event
(sid,cid,signature,timestamp) VALUES ('1', '1491270', '14', '2004-01-20
20:25:19+00')

I've seen some other problems similar to this on the mailing list, but
no  solution.  Can someone please help me fix this.

Thanks,

-Adam


__________________________________
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus


-------------------------------------------------------
The SF.Net email is sponsored by EclipseCon 2004
Premiere Conference on Open Tools Development and Integration
See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
http://www.eclipsecon.org/osdn
_______________________________________________
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://www.geocrawler.com/redir-sf.php3?list=snort-users