FW: snortdb schema update

["Dan Fiorito" <danf () clearnetwork com>]

This is a previous post!

-----Original Message-----
From: Kreimendahl, Chad J [mailto:Chad.Kreimendahl () umb com] 
Sent: Tuesday, March 19, 2002 10:27 AM
To: 'Poppi, Sandro'; snort-users () lists sourceforge net
Subject: RE: [Snort-users] snortdb schema update



Am I wrong here?:  It looks like the code checks for which schema you're
using before it does any database calls...  

which error did you get?
if you get "database: The database is using an older version of the DB
schema", then it's just a warning, everything should still work.

There was no change in the schema as it relates to MySQL, so you should
be able to:

INSERT INTO schema  (vseq, ctime) VALUES ('105', now());
DELETE FROM schema WHERE vseq = '104';

-----Original Message-----
From: Poppi, Sandro [mailto:Sandro.Poppi () wacker com]
Sent: Tuesday, March 19, 2002 6:37 AM
To: snort-users () lists sourceforge net
Subject: [Snort-users] snortdb schema update


I just installed the snort rpm 1.8.4 of last saturday over my previously
installed 1.8.4beta1 and snort now tells me that the database schema of
my mysql db is not the actual one (I'm still on 1.04). Is there a simple
way to update the db schema without the need of creating a new db in
mysql AND without loosing existing alerts?

If not, did anyone already have a little script to copy the old database
contents to the new db (any RTFM link is also appreciated but I didn't
find it in the FAQ or archives ;) since I'm no sql guru.

TIA,
Sandro


_______________________________________________
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

_______________________________________________
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

_______________________________________________
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