Snort mailing list archives
database: mysql_error:
From: deny <deny () monaco net>
Date: Thu, 15 Dec 2005 17:34:22 +0100
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 getdatabase: 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 = 0ERROR: 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
Current thread:
- database: mysql_error: deny (Dec 15)
- Message not available
- Re: database: mysql_error: deny (Dec 15)
- Message not available
- Re: database: mysql_error: deny (Dec 15)
- Re: database: mysql_error: deny (Dec 15)
- Message not available
- <Possible follow-ups>
- RE: database: mysql_error: Briggs, Bruce (Dec 15)