Archiving events via BASE

[David Ryan <David.Ryan () Quintiles com>]

All,

I have a question about archiving/deleting events from a mysql database.

At the moment I have snort logging alerts to mysql and I am looking at the data via BASE 1.3.6.  I have BASE configured 
with an archive database and I sometimes use the archive function to move alerts that are no longer interesting.

There seems to be a problem with the archiving function, but I don't know if I am using it incorrectly.  I had one 
particular alert with 15,000+ events, so I went in to the view of unique alerts, selected the relevant icon on the list 
and selected 'archive (move) selected' from the actions.  After a long time the transaction seemed to finish OK, but 
when I went in to look at it again there was still some large number of these events . . . maybe 5,000+.  I checked the 
archive database and many of the entries had been moved.  I repeated the procedure and it came down to 1,000+ events.  
Then I repeated it and it left 1.  No matter how many times I repeat, this 1 event will not move.

So, here's the question - how come when I asked BASE to move all the records of a particular type it only moved part of 
them, and how come it refuses to move the last transaction ?  It makes me a bit wary of the archive funtion if it has 
this type of issue.

Also, is there some other front end that people can recommend for manipulating the data ?  I presume I can do it 
nativley via sql commands, but I'm not up to speed with these commands to be confident of doing it correctly.

Thanks,

David
===========================================
David Ryan
IT Security Engineer, Global IT Security
Quintiles, Global IT - Infrastructure, QDUB

david.ryan () quintiles com
v: +353-1-819-5186, GMT+0
m: +353-87-124-9108
===========================================


**********************  IMPORTANT--PLEASE READ  ************************
This electronic message, including its attachments, is COMPANY CONFIDENTIAL
and may contain PROPRIETARY or LEGALLY PRIVILEGED information.  If you are 
not the intended recipient, you are hereby notified that any use, disclosure,
copying, or distribution of this message or any of the information included
in it is unauthorized and strictly prohibited.  If you have received this
message in error, please immediately notify the sender by reply e-mail and
permanently delete this message and its attachments, along with any copies
thereof. If this electronic message contains a zipped attachment and you do
not have a decompression tool, you may download unZIP (free of cost) from:
http://www.mk-net-work.com/us/uz/unzip.htm. Alternatively, you may request
that the attachment be resent in an uncompressed format.        Thank you. 
************************************************************************

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/

_______________________________________________
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