[Snort-users] error inserting values into mysql DB

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

--------------------- ------------
SQL=3DINSERT 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=3DINSERT 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=3DINSERT 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=...720&dat=121642
_______________________________________________
Snort-users mailing list
Snort-users@lists.sourceforge.net
Go to this URL to change user options or unsubscribe:
https://lists.sourceforge.net/lists/...fo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.p...st=snort-users