[Snort-users] database: mysql_error:

deny deny at ...13381...
Thu Dec 15 08:35:13 EST 2005


Good afternoon

i use mysql 5.0 with snort 2.3.3 (installed via rpm urpmi snort-mysql )
when i try to start snort :
# /usr/sbin/snort -c /etc/snort/snort.conf

i get

database: mysql_error: You have an error in your SQL syntax; check the 
manual that corresponds to your MySQL server version for the right 
syntax to use near 'schema' at line 1
database: schema version = 0
ERROR: database: The underlying database has not been initialized 
correctly.  This
          version of Snort requires version 106 of the DB schema.  Your DB
          doesn't appear to have any records in the 'schema' table.
          Please re-run the appropriate DB creation script (e.g. 
create_mysql,
          create_postgresql, create_oracle, create_mssql) located in the
          contrib\ directory.

          See the database documentation for cursory details 
(doc/README.database).
          and the URL to the most recent database plugin documentation.
Fatal Error, Quitting..

of course ,i read google and on my database snort i add

CREATE TABLE `schema` ( vseq INT UNSIGNED NOT NULL,
ctime DATETIME NOT NULL,
PRIMARY KEY (vseq));
INSERT INTO `schema` (vseq, ctime) VALUES ('106', now());


but when i restart snort , the error is the same

thanks for your help





More information about the Snort-users mailing list