Re: Tweak mysql database

[Dustin Webber <dustin.webber () gmail com>]

Dwane,

|| Also, it appears that my database is still collecting data, but my gui,
SNORBY, only shows the stuff from two weeks ago.  Is there a way to give
this screen a boost?

You need to verify that the Snorby worker and backend jobs are running
properly. On the Snorby administration menu you will see a link called
`Worker & Job Queue`.  If you have any cache jobs that failed you will see
them here. If the status on the worker process is not green you have a job
queue issue. I would delete all jobs from the queue, restart the Snorby
worker and then start each job from the `worker` menu.

Make sure you are using the lastest version of snorby which is 2.1.0 as of
last night.

|| How does one delete events that are over two weeks old?  At that point,
if an action was going to happen, it would be done

You cannot delete events from inside Snorby. Think gmail, you never delete
email you just archive and remove from the inbox. If you wish
to permanently remove the events just use the mysql console.

Let me know if this fixes the issue.

Dustin W. Webber
Dustin.Webber () gmail com


On Tue, Dec 21, 2010 at 12:48 PM, Atkins, Dwane P <ATKINSD () uthscsa edu>wrote:

> How does one delete events that are over two weeks old?  At that point, if
> an action was going to happen, it would be done.  Also, it appears that my
> database is still collecting data, but my gui, SNORBY, only shows the stuff
> from two weeks ago.  Is there a way to give this screen a boost?  Is there a
> web interface that allows me modify database and do reports that can do
> sorts?
>
>
> Dwane
>
>
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> Forrester recently released a report on the Return on Investment (ROI) of
> Google Apps. They found a 300% ROI, 38%-56% cost savings, and break-even
> within 7 months.  Over 3 million businesses have gone Google with Google
> Apps:
> an online email calendar, and document program that's accessible from your
> browser. Read the Forrester report: http://p.sf.net/sfu/googleapps-sfnew
> _______________________________________________
> 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
------------------------------------------------------------------------------
Forrester recently released a report on the Return on Investment (ROI) of
Google Apps. They found a 300% ROI, 38%-56% cost savings, and break-even
within 7 months.  Over 3 million businesses have gone Google with Google Apps:
an online email calendar, and document program that's accessible from your 
browser. Read the Forrester report: http://p.sf.net/sfu/googleapps-sfnew

_______________________________________________
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