RE: msql error

[Omolayo Salako <OSalako () corp goamerica net>]

upon further investigation, i found out that i have no space left on my
machine for sql to write  to. i used this command command: perror 28 and it
confirmed that. seems my mind is working slow today. df -k confirmed the
filesystem was fooled. ignore my earlier post  

-----Original Message-----
From: Omolayo Salako [mailto:OSalako () corp goamerica net]
Sent: Monday, April 29, 2002 10:31 AM
To: snort-users () lists sourceforge net
Subject: [Snort-users] msql error


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

_______________________________________________
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