[Snort-users] schema version 104

Hugo Ferr snortgrp at ...125...
Fri May 31 09:00:03 EDT 2002


thanks
----- Original Message -----
From: <roman at ...438...>
To: "Hugo Ferr" <snortgrp at ...125...>
Cc: <snort-users at lists.sourceforge.net>
Sent: Friday, May 31, 2002 11:40 AM
Subject: Re: [Snort-users] schema version 104


> create_mysql is the DDL script that will create the entire database from
scratch.  The
> below SQL statements merely update the schema created by create_mysql.
>
> Roman
>
> > Sorry for dummy question but what is the difference between running
> > create_mysql  and doing:
> > INSERT INTO schema (vseq, ctime) VALUES ('105', now());
> >  DELETE FROM schema WHERE vseq = '104';
> >
> > ?????
> >
> > thx.
> >
> > ----- Original Message -----
> > From: <roman at ...438...>
> > To: "Hugo Ferr" <snortgrp at ...125...>
> > Cc: <snort-users at lists.sourceforge.net>
> > Sent: Friday, May 31, 2002 10:09 AM
> > Subject: Re: [Snort-users] schema version 104
> >
> >
> > > - create_mysql comes from the snort tar ball
> > >
> > > - v105 of the DB schema really only affects Oracle users.  Hence, for
> > MySQL, there is no
> > > difference between 104 and 105.  The warning about the "database is
using
> > an older version
> > > .." message can be safely ignored.
> > >
> > > - In order to upgrade the mysql schema, run the SQL you indicated
below.
> > >
> > > > INSERT INTO schema (vseq, ctime) VALUES ('105', now());
> > > > DELETE FROM schema WHERE vseq = '104';
> > >
> > > cheers,
> > > Roman
> > >
> > > > Upgraded to 1.8.6, when snorts starts it says:
> > > > database: schema version = 104
> > > > database: The database is using an older version of the DB schema
> > > >
> > > > In the snort 1.8.3 distro there was a directory 'scripts' that had a
> > > > mysql_install_db script that was used to initialize mysql databases
and
> > > > probably upgrade the db schema (I may be wrong about that). It is no
> > longer
> > > > in 1.8.6 distro (btw, anyone knows why?)
> > > >
> > > > FAQ says:
> > > > You are using an older database schema, and should update it by
running
> > the
> > > >  create scripts from the /contrib directory of the source tarball.
> > > >
> > > > Should I run ./create_mysql frim here?
> > > >
> > > >
> > > > This the solution to change the vseq number but it looks like a
> > workaround
> > > > for me, not a real thing:
> > > > INSERT INTO schema (vseq, ctime) VALUES ('105', now());
> > > > DELETE FROM schema WHERE vseq = '104';
> > > >
> > > > Pls advise on what should I do, I don't want to scre up production
> > machine
> > > > my doing things I'm not really sure of.
> > > >
> > > > Thanks.
> > >
> > >
> > >
> > > ---------------------------------------------
> > > This message was sent using Voicenet WebMail.
> > >       http://www.voicenet.com/webmail/
> > >
> >
> >
>
>
>
> ---------------------------------------------
> This message was sent using Voicenet WebMail.
>       http://www.voicenet.com/webmail/
>




More information about the Snort-users mailing list