RE: Error executing schema

["Jeff Dell" <jdell () activeworx com>]

This is a bug in the schema... The correct schema should look like:

CREATE TABLE read_data ( 
        id              INT          UNSIGNED AUTO_INCREMENT,
        ip_addr INT        UNSIGNED NOT NULL,
        insert_time     TIMESTAMP,
        time            DATETIME   NOT NULL,
        command CHAR(20)   NOT NULL,
        counter INT        UNSIGNED NOT NULL,
        filed           INT        UNSIGNED NOT NULL,
        pid             INT        UNSIGNED NOT NULL,
        uid             INT        UNSIGNED NOT NULL,
        length  INT        UNSIGNED NOT NULL,
        data            BLOB,

        PRIMARY KEY   ( id ),
      INDEX time_idx( time ),
        INDEX ip_idx  ( ip_addr),
        INDEX ip_time_idx(ip_addr, time),
      INDEX ip_pid_idx ( ip_addr, pid)  
); 

The problem is with insert_time, you can't have a default setting of now()
for a timestamp column.

Cheers,
Jeff

-----Original Message-----
From: tebodell () mchsi com [mailto:tebodell () mchsi com] 
Sent: Wednesday, March 24, 2004 12:05 PM
To: ovayohead () email com
Cc: honeypots () securityfocus com
Subject: Error executing schema

Hi all,
Has anyone else got:

ERROR 1064 at line 39: You have an error in your SQL syntax near ')' at line
18

When executing the schema file to buld the databases for sebek server?  I
built
them by hand cause i couldn't get this to work but i'm not sure if they're
working correctly.  I'm getting:

Warning RX 1  Lost 0

A lot too.  What have i failed to setup correctly??
Thanks,
Ty Bodell