[Snort-users] snort DB clean
fcarreiro at ...4629...
Fri Mar 15 12:49:02 EST 2002
There should be some cleaner way to do this. I've been looking at the
tables created and believe there must be some day to use the delete
command and delete based on the timestamp. I noticed a "cis" field in
the tablespaces. Looks like some sort of index. Should be able to
build something referencing that.
I'll play with it now and then. It's rather low on my priority list
(for now). Sooner or later I'll have to get serious about it though.
For now I've simply used phpMyadmin to drop certain signatures then
optimize the database. It works but still a dirty way to maintain the
>Date: Fri, 15 Mar 2002 16:25:28 +0200
>From: Claudiu Ionescu <jones at ...3634...>
>To: snort-users at lists.sourceforge.net
>Subject: Re: [Snort-users] snort DB clean
>At the extreme you can drop the database and create it again:).... just add few lines
>at the begining of the create_database script. For mySQL would be something like :
>DROP DATABASE IF EXISTS snort;
>CREATE DATABASE snort;
>GRANT INSERT,SELECT on snort.* to snortuser at ...274...;
> here the original create_mysql
More information about the Snort-users