Hello,
I am using a MySql DB for my Snort Intrusion detection system (Version
3.23.42). Four of my DB tables
mysteriously got corrupted on Saturday evening. So this morning I ran
the following commands to fix the
tables.
./myisamchk --safe-recover /data/mysql/var/snort/event.MYI
./myisamchk --recover /data/mysql/var/snort/icmphdr.MYI
./myisamchk --safe-recover /data/mysql/var/snort/iphdr.MYI
./myisamchk --recover /data/mysql/var/snort/tcphdr.MYI
This seemed to fix them. They completed with no errors. So when I
started to write to the database again,
I started getting the following messages. Can some one help me figure
out what I need to do to fix this
problem? If you coan help please e-mail me directly at [EMAIL PROTECTED]
Thank you for your time.
vjl
Nov 19 13:18:05 srems snort[8134]: [ID 702911 daemon.error] database:
mysql_error: Duplicate entry '4-3354872' for key 1
Nov 19 13:18:05 srems SQL=INSERT INTO data (sid,cid,data_payload) VALUES
('4','3354872','....E..../@..........>j......')
Nov 19 13:18:05 srems snort[8130]: [ID 702911 daemon.error] database:
mysql_error: Duplicate entry '3-4559557-0' for key 1
Nov 19 13:18:05 srems SQL=INSERT INTO opt
(sid,cid,optid,opt_proto,opt_code,opt_len,opt_data) VALUES
('3','4559557','0','6','1','0','')
Nov 19 13:18:05 srems snort[8130]: [ID 702911 daemon.error] database:
mysql_error: Duplicate entry '3-4559557-1' for key 1
Nov 19 13:18:05 srems SQL=INSERT INTO opt
(sid,cid,optid,opt_proto,opt_code,opt_len,opt_data) VALUES
('3','4559557','1','6','1','0','')
Nov 19 13:18:05 srems snort[8130]: [ID 702911 daemon.error] database:
mysql_error: Duplicate entry '3-4559557-2' for key 1
Nov 19 13:18:05 srems SQL=INSERT INTO opt
(sid,cid,optid,opt_proto,opt_code,opt_len,opt_data) VALUES
('3','4559557','2','6','8','10','000320E84DFBD2D1')
Nov 19 13:18:05 srems snort[8130]: [ID 702911 daemon.error] database:
mysql_error: Duplicate entry '3-4559557' for key 1
--
V.Jay LaRosa EMC Corporation
Systems Administrator 171 South Street
(508)435-1000 ext 14957 Hopkinton, MA 01748
(508)497-8082 fax www.emc.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
