Re: Snort with MySQL,ACID

["operator" <operator () email it>]

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 
  To: 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: http://www.email.it/f

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