[Snort-users] schema version 104

Hugo Ferr snortgrp at ...125...
Fri May 31 07:45:04 EDT 2002


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/
>




More information about the Snort-users mailing list