Re: ACID_main.php Timesout w/Snort 1.9.0

["Dhruv Chandra" <dhruvc () hotmail com>]

Hi

I just created the below mentioned indexes on MS-SQL ....and WOW there has 
been a significant improvement in speed.

I am eagerly waiting for Snort 1.9.0 to work with MS-SQL.

Thanks :)

Cheers


> From: "Albert E. Whale" <aewhale () ABS-CompTech com>
> To: joe () onshore com
> CC: snort-users <snort-users () lists sourceforge net>
> Subject: Re: [Snort-users] ACID_main.php Timesout w/Snort 1.9.0
> Date: Mon, 18 Nov 2002 08:46:32 -0500
>
> 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


_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*. 
http://join.msn.com/?page=features/featuredemail



-------------------------------------------------------
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