RE: How do I clean up when ACID fails like this?

["Hutchinson, Andrew" <Andrew.Hutchinson () Vanderbilt edu>]

You could just feed a file with SQL commands like this into the
database:

mysql -u <username> -p -D <databasename> < snortdb_deleteall.sql

Where 'snortdb_deleteall.sql' contains:

delete from data;
delete from event;
delete from opt;
delete from icmphdr;
delete from iphdr;
delete from tcphdr;
delete from udphdr;


That should blow away all of the event-specific data.


Andrew Hutchinson - Network Security
Vanderbilt University Medical Center
(615) 936-2856

> -----Original Message-----
> From: Aaron The Young [mailto:acyoung () nysernet org] 
> Sent: Monday, February 24, 2003 1:11 PM
> To: snort-users () lists sourceforge net
> Subject: [Snort-users] How do I clean up when ACID fails like this?
>
>
>
> Hello,
>
> I have way too much in my SQL database at this time and
> trying to delete selected alerts causes the following error:
>
> Fatal error: Maximum execution time of 180 seconds exceeded in 
> /usr/share/acidlab/acid_db.inc on line 260
>
> I'd love to find a simple way to just erase everything
> in my SQL database until I get my rules set in Snort, but ACID
> doesn't seem able to help me out.
>
> Any suggestions?
>
> Thanks,
>
> Aaron
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> 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


-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
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