error inserting values into mysql DB

[devork <devork () gmail com>]

I have mysql database set as output plugin in snort.conf configuration file.
but when any alert is generated it gives following error.

---------------------  ------------
SQL=INSERT INTO event (sid,cid,signature,timestamp) VALUES ('2',
'135', '548', ' 2006-04-10 12:37:51.284+005')
database: mysql_error: Duplicate entry '2' for key 1
SQL=INSERT INTO event (sid,cid,signature,timestamp) VALUES ('2',
'136', '548', ' 2006-04-10 12:37:51.284+005')
database: mysql_error: Duplicate entry '2' for key 1
SQL=INSERT INTO event (sid,cid,signature,timestamp) VALUES ('2',
'137', '548', ' 2006-04-10 12:37:51.284+005')
database: mysql_error: Duplicate entry '2' for key 1
---------------------  ------------
#mysql -V
mysql  Ver 14.7 Distrib 4.1.14, for pc-linux-gnu (i686) using readline 4.3

regards,
dvk


-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642
_______________________________________________
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