database: mysql_error:

[deny <deny () monaco net>]

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