Re: ACID ERROR

[SkatFiend () aol com]

OK, enabled $debug_mode =1 and here are the results:


Session Registered
History depth = 1
Analysis Console for Intrusion Databases    
URL: '/Acid/acid_main.php' (referred by: '')PARAMETERS: ''CLIENT: Mozilla/4.0 
(compatible; MSIE 6.0; Windows NT 5.1)SERVER: Microsoft-IIS/5.0 SERVER HW: 
Windows NT 5.0 build 2195DATABASE TYPE: mssql  DB ABSTRACTION VERSION: PHP 
VERSION: 4.0.6  PHP API: cgiSESSION ID: b8f0a2645bc755b9de4db8ab871724eb( 
18233 bytes )Checking for DB abstraction lib in 
'c:\snort\Adobe\adodb.inc.php'
sensor #1: event.cid = 185886, acid_event.cid = 185886
Added 0 alert(s) to the Alert cacheQueried on : Tue November 20, 2001 
14:39:41
Database: snort@Blackbox    (schema version: 104) 
Time window: [Nov 1 2001 1:20PM] - [Nov 20 2001 12:17PM] 
Database ERROR:Database ERROR:Line 1: Incorrect syntax near ','.SELECT 
COUNT(DISTINCT acid_event.ip_src, acid_event.ip_dst, acid_event.ip_proto) 
FROM acid_eventSELECT COUNT(DISTINCT acid_event.ip_src, acid_event.ip_dst, 
acid_event.ip_proto) FROM acid_event



Cliff Arms

------------------------------------------------------------------------------

--------------------------------------
In a message dated 11/20/2001 2:40:11 PM Eastern Standard Time, 
roman () danyliw com writes:


> Additional details are required to debug this issue.  Enable $debug_mode =
> 1 and reproduce this error with additional information.
>
> However, first try grabbing a fresh copy from CVS.  I believe this may
> already have been fixed.
>
> Roman
>
> On Tue, 20 Nov 2001 SkatFiend () aol com wrote:
>
> > Hellow all,
> >
> > On some of the ACID pages and queries I am getting an error. For the
> most
> > part my ACID console appears to be working. Here is the "acid_main.php"
> page.
> >  Analysis Console for Intrusion Databases
> > Added 0 alert(s) to the Alert cacheQueried on : Tue November 20, 2001
> > 13:40:12
> > Database: snort@Blackbox    (schema version: 104)
> > Time window: [Nov 1 2001 1:20PM] - [Nov 20 2001 12:17PM]
> > Database ERROR:Database ERROR:Line 1: Incorrect syntax near ','.
> >
> >
> > Any ideas how to fix this??
> >
> > I am using a Win32 configuration.
> > Win2K Server
> > Snort 1.8.2
> > IDS 1.09 beta
> > Adobe 140
> > PHP 4.0.6
> > ACID 0.9.6 b18
> > MSSQL 2000
> >
> > Thanks, Cliff Arms