Snort mailing list archives
RE: (no subject)
From: "Chris Eidem" <ceidem () Dexma com>
Date: Fri, 9 Aug 2002 09:33:16 -0500
Below is the error I get trying to run snort. database: sensor id = 1 database: mysql_error: You have an error in your SQL syntax near '[schema]' at line 1 database: schema version = 0 database: The underlying database seems to be running an older version of the DB schema. Please re-run the appropriate DB creation script (e.g. create_mysql, create_postgresql, create_oracle) located in the contrib\ directory. Fatal Error, Quitting.. I used the 1.8.7 source to get the create_mysql table entries.
you need to use schema v105. do this: mysql -u root -p use snort; select * from schema; if it doesn't look like this: mysql> select * from schema; +------+---------------------+ | vseq | ctime | +------+---------------------+ | 105 | 2002-07-11 14:41:41 | +------+---------------------+ 1 row in set (0.00 sec) mysql> then do this: mysql> update schema2 set vseq = '105', ctime = now() where vseq = '0'; that should do it, if that is indeed, the problem. - chris ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ 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:
- Re: Snort start up error, (continued)
- Re: Snort start up error Ian Macdonald (Aug 02)
- RE: (no subject) McCammon, Keith (Jul 31)
- RE: (no subject) Moyer, Shawn (Jul 31)
- (no subject) charella constansia (Aug 02)
- RE: (no subject) McCammon, Keith (Aug 02)
- RE: (no subject) Donofrio, Lewis (Aug 02)
- RE: (no subject) Chris Eidem (Aug 02)
- (no subject) herris () somnambulance org (Aug 08)
- Re: (no subject) Ian Macdonald (Aug 08)
- Re: (no subject) Chris Reid (Aug 08)
- RE: (no subject) Chris Eidem (Aug 09)
- (no subject) kohat enclave (Aug 21)
- Re: (no subject) Piotr Pietrowski (Aug 22)
- Re: (no subject) John Sage (Aug 22)
- (no subject) Alvaro Lillo (Aug 25)
- Just one match could cover serious attack Alvaro Lillo (Aug 25)
- Re: Just one match could cover serious attack John Sage (Aug 25)
- Just one match could cover serious attack Alvaro Lillo (Aug 25)
- (no subject) S.M.Karthik (Aug 26)
- (no subject) Lionel Fairon (Aug 28)
- Re: (no subject) Roman Danyliw (Sep 05)
- (no subject) Marc Dreher (Sep 06)
(Thread continues...)