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
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Snort-users mailing list
Snort-users@lists.sourceforge.net
Go to this URL to change user options or unsubscribe:
https://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users
