Re: [snort-users] snortdb schema update

["Roman Danyliw" <roman () danyliw com>]

I try to keep the version number of the schema consistent across all databases.
 There was a small change in the Oracle database script hence v105.  However,
for Postgresql and MySQL there were no changes.

Upgrading via the suggested SQL (UPDATE schema SET vseq=105) on these databases
is recommended.

cheers,
Roman

On Tue, 19 Mar 2002 15:36:48 +0000, Mark Vevers <mark () ifl net> wrote :

> (Sorry if this has been answered already - I get this on digest..)
> Sandro,
>
> What db are you using?  As far as I can see from the CVS the only
> change to the MySQL schema from 104 -> 105 was the version change
> which had to change to keep in line with the changes made for other
> db's (Roman please correct me if I am wrong!)
>
> I just did:
>     mysql> UPDATE schema SET vseq=105;
>
> And now my schema matches - ;-)
>
>
> Mark
>
> > 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? 
>
> -- 
> Mark Vevers.    mark () ifl net / mvevers () rm com
> Internet Backbone Engineering Team
> Internet for Learning, Research Machines Plc
>
>
>
>
> _______________________________________________
> 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