Re: ACID_main.php Timesout w/Snort 1.9.0

["Albert E. Whale" <aewhale () ABS-CompTech com>]

Joe,

Unfortunately I am already using the MySQL Database for Web Applications and
would prefer to separate this from the Web Services.

However I have found that creating a New Index on just the cid helps to speed up
processing.  Create it on the event table and on the acid_event tables.

joe () onshore com wrote:

> I had a problem like this as well.  I solved it finally by moving from
> postgresql to mysql due to speed issues.  In this case I would reccomend that
> you backup your productiondb and recreate it blank.
>
> Quoting "Albert E. Whale" <aewhale () ABS-CompTech com>:
>
> > I have acquired a number of packets in the database, over 80,000.
> > This
> > appears to have the effect of having the acid_main.php page time out
> > after 60 seconds.
> >
> > I am using Postgresql and would like to be able to delete some of the
> > unnecessary alerts, but the main pages keeps timing out.
> >
> > Any clues?
> >
> > --
> > Albert E. Whale - CISSP
> > http://www.abs-comptech.com
> > ----------------------------------------------------------------------
> > ABS Computer Technology, Inc. - ESM, Computer & Networking Specialists
> > Sr. Security, Network, and Systems Consultant
> > Board of Directors - InfraGard - Pittsburgh, PA
> >
> >
> >
> >
> > -------------------------------------------------------
> > This sf.net email is sponsored by: To learn the basics of securing
> > your web site with SSL, click here to get a FREE TRIAL of a Thawte
> > Server Certificate: http://www.gothawte.com/rd524.html
> > _______________________________________________
> > 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

--
Albert E. Whale - CISSP
http://www.abs-comptech.com
----------------------------------------------------------------------
ABS Computer Technology, Inc. - ESM, Computer & Networking Specialists
Sr. Security, Network, and Systems Consultant
Board of Directors - InfraGard - Pittsburgh, PA




-------------------------------------------------------
This sf.net email is sponsored by: To learn the basics of securing 
your web site with SSL, click here to get a FREE TRIAL of a Thawte 
Server Certificate: http://www.gothawte.com/rd524.html
_______________________________________________
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