Snort mailing list archives

RE: acid-0.9.6b15: phplot graphs and time criteria


From: Steve Halligan <agent33 () geeksquad com>
Date: Mon, 17 Sep 2001 10:52:59 -0500

Roman just fixed this 3 minutes ago in cvs.

-----Original Message-----
From: Andreas Hasenack [mailto:andreas () conectiva com br]
Sent: Monday, September 17, 2001 10:13 AM
To: snort-users () lists sourceforge net
Subject: [Snort-users] acid-0.9.6b15: phplot graphs and time criteria


Whenever I select any of the "chart begin" or "chart end" criterias
in the graph page I get the following errors (debug=1):


Criteria warning: Multiple Time/Date criteria entered without 
a boolean operator (e.g. AND, OR) between them.



Chart criteria
Array
(
    [0] => LEFT JOIN acid_ag_alert ON 
(acid_event.sid=acid_ag_alert.ag_sid AND 
acid_event.cid=acid_ag_alert.ag_cid) 
    [1] => ag_id = 4 AND  AND (  UNIX_TIMESTAMP(timestamp) >= 
 UNIX_TIMESTAMP('2001-09-01 000000')         
UNIX_TIMESTAMP(timestamp) >=  UNIX_TIMESTAMP('2001-09-17 
000000')       ) 
)
chart_type = 2
 data_source = 4
Database ERROR:You have an error in your SQL syntax near 'AND 
( UNIX_TIMESTAMP(timestamp) >= UNIX_TIMESTAMP('2001-09-01 
000000') ' at line 1


SELECT min(timestamp), max(timestamp) FROM acid_event LEFT 
JOIN acid_ag_alert ON (acid_event.sid=acid_ag_alert.ag_sid 
AND acid_event.cid=acid_ag_alert.ag_cid)  WHERE ag_id = 4 AND 
 AND (  UNIX_TIMESTAMP(timestamp) >=  
UNIX_TIMESTAMP('2001-09-01 000000')         
UNIX_TIMESTAMP(timestamp) >=  UNIX_TIMESTAMP('2001-09-17 
000000')       ) 


This is acid-0.9.6b15 (tarball), php-4.0.6, mysql-3.23.33.



_______________________________________________
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: