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

["McPheeters, Scott" <smcpheeters () fnms-indy com>]

When I timeout deleting items, I just run it again.  Because mySql is not transaction based it does still delete some 
of the items.  It is not a "all or none" delete. Sometimes I have had to run it 3 or so times to get all the events.

I guess you could delete your database, create the database again and rerun the create_tables.sql to rebuild them.

Scott

-----Original Message-----
From: Aaron The Young [mailto:acyoung () nysernet org]
Sent: Monday, February 24, 2003 2: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