[Snort-users] mysql_error for Duplicate entry

Henry Chan henrchan at ...3845...
Wed Nov 28 17:35:09 EST 2001


Dear all snort users:

Pls help.... the following is my questions:

When I use two interfaces in the snort for the sensors, I found out 
some error for mysql. The commnad I use for issue the snort senseors as 
follow:
/usr/local/bin/snort -d -h 192.168.7.0/24 -i eth0 -l /var/log/snort -
c /opt/snort.conf

/usr/local/bin/snort -d -h 192,168.8.0/24 -i eth1 -l /var/log/snort -
c /opt/snort.conf

The following is mysql error, pls check and help:

database: mysql_error: Duplicate entry '3-42326' for key 1
SQL=INSERT INTO data (sid,cid,data_payload) VALUES 
('3','42326','474554202F736372697074732F2E2E2535632E2E2F77696E6E742F7379
7374656D33322F636D642E6578653F2F632B64697220485454502F312E300D0A486F7374
3A207777770D0A436F6E6E6E656374696F6E3A20636C6F73650D0A0D0A')
database: mysql_error: Duplicate entry '3-42327' for key 1
SQL=INSERT INTO event (sid,cid,signature,timestamp) VALUES 
('3', '42327', '168', '2001-11-29 09:24:30+08')
database: mysql_error: Duplicate entry '3-42327' for key 1
SQL=INSERT INTO tcphdr (sid, cid, tcp_sport, tcp_dport, tcp_seq, 
tcp_ack, tcp_off, tcp_res, tcp_flags, tcp_win, tcp_csum, tcp_urp) 
VALUES 
('3','42327','1713','80','2777917987','2744005127','5','0','24','17520',
'50346','0')
database: mysql_error: Duplicate entry '3-42327' for key 1
SQL=INSERT INTO iphdr (sid, cid, ip_src, ip_dst, ip_ver,ip_hlen, 
ip_tos, ip_len, ip_id, ip_flags, ip_off,ip_ttl, ip_proto, ip_csum) 
VALUES 
('3','42327','3393234821','3232236048','4','5','0','136','319','0','0','
123','6','51634')









More information about the Snort-users mailing list