[Snort-users] acid-0.9.6b15: phplot graphs and time criteria

Andreas Hasenack andreas at ...1574...
Mon Sep 17 08:15:02 EDT 2001


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.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 240 bytes
Desc: not available
URL: <https://lists.snort.org/pipermail/snort-users/attachments/20010917/ebb6d13b/attachment.sig>


More information about the Snort-users mailing list