RE: Snort with MySQL,ACID

[Elvira_Byrnes () mobileinnovations com au]

Thanks a lot. That sounds like a good idea. I will try it at the end of next
week. What I did so far I deleted all files from /usr/local/mysql/var (they
were huge) except for the databases directories. Than ran mysql ./configure
and things went back to normal. Mysql seems to be archiving things without
deleting them by default.
 
Regards
 
Elvira

-----Original Message-----
From: operator [mailto:operator () email it]
Sent: Friday, 16 May 2003 3:44 PM
To: POST SnortUsers
Subject: Re: [Snort-users] Snort with MySQL,ACID


I completely clean the DB from outside, not from ACID, by using: 
 
# mysql snort < /usr/local/bin/purge_db.mysql 
 
dove:
 
# less /usr/local/bin/purge_db.mysql    
DELETE FROM sensor;
DELETE FROM event;
DELETE FROM iphdr;
DELETE FROM tcphdr;
DELETE FROM udphdr;
DELETE FROM icmphdr;
DELETE FROM data;
DELETE FROM opt;
DELETE FROM signature;
DELETE FROM sig_class;
DELETE FROM sig_reference;
DELETE FROM reference;
DELETE FROM reference_system;
DELETE FROM acid_ag;
DELETE FROM acid_ag_alert;
DELETE FROM acid_event;
DELETE FROM acid_ip_cache;

----- Original Message ----- 
From: Elvira_Byrnes () mobileinnovations com au
<mailto:Elvira_Byrnes () mobileinnovations com au>  
To: Snort-users () lists sourceforge net
<mailto:Snort-users () lists sourceforge net>  
Sent: Friday, May 16, 2003 5:52 AM
Subject: [Snort-users] Snort with MySQL,ACID

Hi Guys
 
I just purged the records from MySQL database through ACID console on Linux
RedHat 8.0. I have 0 disk space now. I am wondering if the deleted records
went somewhere instead of being completely deleted.
 
Thank you very much in advance.
 
Regards
 
Elvira



******************** Confidentiality Statement *************************** 


This message contains privileged and confidential information intended only
for the use of the addressee named above. If you are not the intended
recipient of this message, you must not disseminate, copy or take any action
in reliance on it. If you have received this message in error, please delete
it from your system and notify the sender immediately. Any views expressed
in this message are those of the individual sender, except where the sender
specifically states them to be the view of the company.


----
Email.it, the professional e-mail, gratis per te: clicca qui
<http://www.email.it/cgi-bin/start?sid=3>  

Sponsor:
Il vero Pomodoro San Marzano D.O.P. dell' Agro-Sarnese-Nocerino.
Clicca qui <http://adv.email.it/cgi-bin/foclick.cgi?mid=981&d=16-5>  




******************** Confidentiality Statement *************************** 

This message contains privileged and confidential information intended only
for the use of the addressee named above.  If you are not the intended
recipient of this message, you must not disseminate, copy or take any action
in reliance on it.  If you have received this message in error, please
delete it from your system and notify the sender immediately.  Any views
expressed in this message are those of the individual sender, except where
the sender specifically states them to be the view of the company.