Snort mailing list archives
Re: acid_ag_alert empty : can't have a Graph Alert Data in Base
From: chido42 () free fr
Date: Fri, 9 Jul 2010 10:14:49 +0200 (CEST)
Sorry for the flood... Send my previous mail too early After some test and research the problem is not coming from the database. I have the correct data. However my graph is still down and i don't know why. Here is a copy/paste of base in debug_mode = 1 Chart criteria Array ( [0] => [1] => 1 = 1 ) chart_type = 1 data_source = chart_begin_hour = "", hour_start = "20" chart_end_hour = "", hour_end = "10" year_start year_end month_start month_end day_start day_end hour_start hour_end 2010 2010 07 07 08 09 20 23 SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND DAYOFMONTH(timestamp) = 08 AND HOUR(timestamp) = 20 SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND DAYOFMONTH(timestamp) = 08 AND HOUR(timestamp) = 21 SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND DAYOFMONTH(timestamp) = 08 AND HOUR(timestamp) = 22 SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND DAYOFMONTH(timestamp) = 08 AND HOUR(timestamp) = 23 SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 00 SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 01 SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 02 SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 03 SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 04 SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 05 SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 06 SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 07 SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 08 SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 09 SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 10 SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 11 SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 12 SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 13 SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 14 SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 15 SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 16 SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 17 SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 18 SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 19 SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 20 SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 21 SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 22 SELECT count(*) FROM acid_event WHERE 1 = 1 AND YEAR(timestamp) = 2010 AND MONTH(timestamp) = 07 AND DAYOFMONTH(timestamp) = 09 AND HOUR(timestamp) = 23 chart_type = 1 data_source = chart_interval = 0 element_start = 0 count($xdata) = 28 Handling Period if necessary... i = 0 element_start = 0 number_array_elements = 28 count(xdata) = 28 count(xdata) = 28 0 -- 07/08/2010 20:00:00 - 20:59:59 - 151 1 -- 07/08/2010 21:00:00 - 21:59:59 - 0 2 -- 07/08/2010 22:00:00 - 22:59:59 - 10 3 -- 07/08/2010 23:00:00 - 23:59:59 - 0 4 -- 07/09/2010 00:00:00 - 00:59:59 - 0 5 -- 07/09/2010 01:00:00 - 01:59:59 - 0 6 -- 07/09/2010 02:00:00 - 02:59:59 - 2 7 -- 07/09/2010 03:00:00 - 03:59:59 - 0 8 -- 07/09/2010 04:00:00 - 04:59:59 - 4 9 -- 07/09/2010 05:00:00 - 05:59:59 - 0 10 -- 07/09/2010 06:00:00 - 06:59:59 - 0 11 -- 07/09/2010 07:00:00 - 07:59:59 - 3 12 -- 07/09/2010 08:00:00 - 08:59:59 - 0 13 -- 07/09/2010 09:00:00 - 09:59:59 - 16 14 -- 07/09/2010 10:00:00 - 10:59:59 - 15 15 -- 07/09/2010 11:00:00 - 11:59:59 - 0 16 -- 07/09/2010 12:00:00 - 12:59:59 - 0 17 -- 07/09/2010 13:00:00 - 13:59:59 - 0 18 -- 07/09/2010 14:00:00 - 14:59:59 - 0 19 -- 07/09/2010 15:00:00 - 15:59:59 - 0 20 -- 07/09/2010 16:00:00 - 16:59:59 - 0 21 -- 07/09/2010 17:00:00 - 17:59:59 - 0 22 -- 07/09/2010 18:00:00 - 18:59:59 - 0 23 -- 07/09/2010 19:00:00 - 19:59:59 - 0 24 -- 07/09/2010 20:00:00 - 20:59:59 - 0 25 -- 07/09/2010 21:00:00 - 21:59:59 - 0 26 -- 07/09/2010 22:00:00 - 22:59:59 - 0 27 -- 07/09/2010 23:00:00 - 23:59:59 - 0 Drawing graph (600 x 800) And then a picture of a broken image link. If you have an idea how to correct that. ------------------------------------------------------------------------------ This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first _______________________________________________ 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
Current thread:
- Re: acid_ag_alert empty : can't have a Graph Alert Data in Base chido42 (Jul 09)
- <Possible follow-ups>
- Re: acid_ag_alert empty : can't have a Graph Alert Data in Base chido42 (Jul 09)