Snort mailing list archives

msql error


From: Omolayo Salako <OSalako () corp goamerica net>
Date: Mon, 29 Apr 2002 11:30:39 -0400

any getting this error when i try to open events in mysql database, it's
been working up until today. i have seen the solution posted before just
can't find it. i know it has to do with header conversion in mysql. anyhelp
would be appreciated.


Got error 28 from table handler : SELECT
event.*,iphdr.ip_src,iphdr.ip_dst,tcphdr.tcp_sport,
tcphdr.tcp_dport,udphdr.udp_sport,udphdr.udp_dport, sensor.hostname,sig_name
, udphdr.sid AS UDP, icmphdr.sid AS ICMP, tcphdr.sid AS TCP FROM event LEFT
JOIN iphdr ON ((event.cid = iphdr.cid) AND (event.sid = iphdr.sid)) LEFT
JOIN tcphdr ON ((event.cid = tcphdr.cid) AND (event.sid = tcphdr.sid)) LEFT
JOIN udphdr ON ((event.cid = udphdr.cid) AND (event.sid = udphdr.sid)) LEFT
JOIN icmphdr ON ((event.cid = icmphdr.cid) AND (event.sid = icmphdr.sid))
LEFT JOIN sensor ON (event.sid = sensor.sid) LEFT JOIN signature ON
(event.signature = signature.sig_id) WHERE (ip_dst = '3634285923') ORDER BY
timestamp DESC LIMIT 60 




_______________________________________________
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


Current thread: