[Snort-users] mostly an (my)sql question.

i've just started learning sql, and was wondering if
someone could give me a hand. I'm using per-dbi for
queries.

at the moment. this is what my sql statement looks like.

SELECT event.cid,inet_ntoa(ip_src),inet_ntoa(ip_dst)
FROM event,iphdr
WHERE event.cid > 0
AND iphdr.cid = event.cid
LIMIT 500

That much works fine. it prints events 1-500 However i
can't seem to figure out how to link the signature table
into this. I've tried many (bad :) ) things, and the end
result is a query that never ends most of the time or
even.cid goes from 1,6,10,etc,etc

So lets say i also want to print the priority of the
event, how would i add that?


-------------------------------------------------------
SF.Net is sponsored by: Speed Start Your Linux Apps Now.
Build and deploy apps & Web services for Linux with
a free DVD software kit from IBM. Click Now!
http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click
_______________________________________________
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