Ethical Hacking

Learn to find vulnerabilities before the bad guys do! Gain real world hands on hacking experience in our state of the art hacking lab. Course designed and taught by expert instructors with years of penetration testing experience. 12 student maximum in every class. Certification attempt included in every package.
Computer Forensics Training at InfoSec Institute

Gain the in-demand skills of a certified computer examiner, learn to recover trace data left behind by fraud, theft, and cybercrime perpetrators. Discover the source of computer crime and abuse at your organization so that it never happens again. All of our class sizes are guaranteed to be 12 students or less to facilitate one-on-one interaction with one of our expert instructors.




Network Security Snort-Users
[Top] [All Lists]

[Snort-users] mysql, base, and snort and a plea for tips in general

Subject: [Snort-users] mysql, base, and snort and a plea for tips in general
Date: Fri, 15 Jun 2007 11:36:20 -0400
Hello

I'm a new Network Administrator trying to get a grip on the snort setup 
that I inherited. It sends the output to a LAMP server with base and 
snortreport as the frontends. I noticed a little discussion about this 
over the last few days so I thought that I would ask for a little advice 
on my troubles. It seems to quickly become an unhelpful time sink.

The first big problem I have is the simple maintenance of the database. 
It seems to easily and quickly get out of hand and slow queries waaaaay 
down while using almost all of the CPU.

Are there any specific MYSQL indexes, joins, or maintenance scripts that 
are good for performance?

I noticed somebody say that this setup is just not a good idea. Others 
have noted that barnyard can help.

I understand how barnyard can help snort itself but how can it help the 
MYQL end? And what is a better setup that mysql/base?

And last, I could really use a good guide to interpreting the alerts 
themselves. It sucks up a lot of my time just figuring out whether 
something is important or not. Does anybody have any good suggestions 
for interpretation guides?

Thanks.
-- 
John Baker
Network Systems Administrator
Marlboro College
Phone: 451-7551 off campus; 551 on campus

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
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

<Prev in Thread] Current Thread [Next in Thread>