[Snort-users] database: mysql_error:
deny at ...13381...
Thu Dec 15 08:35:13 EST 2005
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
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
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_postgresql, create_oracle, create_mssql) located in the
See the database documentation for cursory details
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