[Snort-users] schema version 104

roman at ...438... roman at ...438...
Fri May 31 08:41:02 EDT 2002


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